データベースエラー:/home/opencork/princegroup.jp/public_html/contents/gp2013winter/header.php:151: SELECT pc.id, pc.cast_id, c.main_photo, pc.cast_name, s.shop_name, s.shop_path, mb.area_path, ps.rank, yr.rank AS yesterday, yr.rank-ps.rank AS rise FROM p1_sales AS ps LEFT JOIN p1_casts AS pc ON pc.id=ps.p1id LEFT JOIN cast AS c ON c.id=pc.cast_id LEFT JOIN shop AS s ON s.id=pc.shop_id LEFT JOIN m_tabarea AS mt ON mt.id=s.area_id LEFT JOIN m_bigarea AS mb ON mb.id=mt.pid LEFT JOIN ( SELECT p1id,rank FROM p1_sales WHERE filedate='2013-12-13') AS yr ON yr.p1id=ps.p1id WHERE (yr.rank-ps.rank)>=10 AND ps.rank0 AND ps.filedate='2013-12-14' ORDER BY rise DESC LIMIT 0,5