SELECT r.restaurant_id FROM (
SELECT ifp.restaurant_id,ifp.recommend_count
FROM index_for_area_pages ifp
WHERE ifp.area_id = 94
) tmp JOIN restaurant r USING(restaurant_id)
JOIN area a ON r.area_id = a.area_id
JOIN sub_area_translation sa USING(sub_area_id) JOIN index_for_large_category_pages rlc USING(restaurant_id) LEFT JOIN restaurant_popular_score rpos USING(restaurant_id) WHERE (1 = 1) AND sa.lang = 'ja' AND r.sub_area_id = 62310 AND rlc.large_category_type = 5 AND r.restaurant_status IN (1,7) ORDER BY tmp.recommend_count <> 0 DESC , rpos.score DESC , tmp.recommend_count DESC , r.restaurant_id LIMIT 0,20
