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 ) LEFT JOIN ltgl2ofgdv_postmeta start ON start.post_id=ltgl2ofgdv_posts.ID AND start.meta_key='startdate' LEFT JOIN ltgl2ofgdv_postmeta end ON end.post_id=ltgl2ofgdv_posts.ID AND end.meta_key='enddate' LEFT JOIN ltgl2ofgdv_postmeta dates ON dates.post_id=ltgl2ofgdv_posts.ID AND dates.meta_key='date' LEFT JOIN ltgl2ofgdv_postmeta views ON views.post_id=ltgl2ofgdv_posts.ID AND views.meta_key='views' LEFT JOIN ltgl2ofgdv_postmeta tax_position ON tax_position.post_id=ltgl2ofgdv_posts.ID AND tax_position.meta_key='front_pos' 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
- Аквапарки Москвы
- Московский зоопарк
- Усадьба Коломенское
- Алмазный фонд Кремля
![Сообщество Mos-Holidays.ru в Одноклассниках]](http://mos-holidays.ru/wp-content/themes/holidays2/images/soc5.png)
