Экскурсия по Московскому метро «Подземные дворцы Москвы»

SELECT SQL_CALC_FOUND_ROWS ltgl2ofgdv_posts.ID FROM ltgl2ofgdv_posts LEFT JOIN ltgl2ofgdv_term_relationships ON (ltgl2ofgdv_posts.ID = ltgl2ofgdv_term_relationships.object_id) INNER JOIN ltgl2ofgdv_postmeta ON ( ltgl2ofgdv_posts.ID = ltgl2ofgdv_postmeta.post_id ) WHERE 1=1 AND ( ltgl2ofgdv_term_relationships.term_taxonomy_id IN (370) ) AND ( ( ltgl2ofgdv_postmeta.meta_key = 'views' AND ltgl2ofgdv_postmeta.meta_value >= '0' ) ) AND ltgl2ofgdv_posts.post_type = 'post' AND (ltgl2ofgdv_posts.post_status = 'publish') GROUP BY ltgl2ofgdv_posts.ID ORDER BY ltgl2ofgdv_postmeta.meta_value+0 DESC LIMIT 0, 8