データベースエラー:/home/opencork/princegroup.jp/public_html/contents/gp2016summer/header.php:153: 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_sales2016s AS ps LEFT JOIN p1_casts2016s 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_sales2016s WHERE filedate='2016-07-14') AS yr ON yr.p1id=ps.p1id WHERE (yr.rank-ps.rank)>=10 AND ps.rank0 AND ps.filedate='2016-07-15' ORDER BY rise DESC LIMIT 0,5