SELECT name, value FROM constants
SELECT mess_id, message FROM messages WHERE (lang_id='1')
SELECT * FROM images WHERE (lang_id='1')
SELECT * FROM cities WHERE (lang_id='1') AND (in_list='1') ORDER BY city_id
SELECT * FROM ru_news a,ru_news_city_link b WHERE (a.category_id='0') AND (a.is_enable='1') AND (a.path='specoffer') AND (a.id = b.news_id) AND (b.city_id='2') LIMIT 1
SELECT *,DATE_FORMAT(date,'%d.%m.%Y') as dater FROM ru_news WHERE (category_id='95') AND (is_enable='1') AND (path='arkadsvad') LIMIT 1
SELECT a.* FROM ru_left_menu a, ru_left_menu_city_link b WHERE (a.is_enable='1') AND (a.link_id=b.link_id) AND (b.city_id='2') ORDER BY a._order
SELECT a.item_id, a.title, a.path FROM ru_params_lists a,ru_params_lists_city_link b WHERE (a.param_id='4') AND (a.item_id=b.item_id) AND (b.city_id='2') AND (is_enable='1') order by a.title
SELECT a.item_id, a.title, a.path FROM ru_params_lists a,ru_params_lists_city_link b WHERE (a.param_id='5') AND (a.item_id=b.item_id) AND (b.city_id='2') AND (is_enable='1') order by a.title
SELECT a.item_id, a.title, a.path FROM ru_params_lists a,ru_params_lists_city_link b WHERE (a.param_id='7') AND (a.item_id=b.item_id) AND (b.city_id='2') AND (is_enable='1') order by a.title
SELECT a.item_id, a.title, a.path FROM ru_params_lists a,ru_params_lists_city_link b WHERE (a.param_id='15') AND (a.item_id=b.item_id) AND (b.city_id='2') AND (is_enable='1') order by a.title
SELECT * FROM ru_pages_counter
SELECT a.* FROM ru_banners a,ru_banners_city_link b WHERE (a.is_enable='1') AND (a.category_id > 0) AND (a.date_view_from <= NOW()) AND (a.date_view_to >= NOW()) AND (a.id=b.banner_id) AND (b.city_id='2')
SELECT * FROM ru_meta WHERE (path='/spb/news/specoffer/arkadsvad') AND (is_enable='1') LIMIT 1
|
Скидка на размещение в отеле - 10%