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_catalog WHERE (tid='0') AND (path='hotels') AND (is_enable='1') LIMIT 1
SELECT * FROM ru_items a, ru_items_catalog_link b WHERE (a.city_id='2') AND (a.enable_opinions='1') AND (a.is_enable='1') AND (a.item_id=b.item_id) AND (b.category_id='1')
SELECT a.*, b.value FROM ru_items a,ru_items_values b WHERE (a.path='grandhotel') AND (a.is_enable='1') AND (b.item_id = a.item_id) AND (b.category_id='0') AND (b.param_id='1') AND (b._primary='1') LIMIT 1
SELECT *,DATE_FORMAT(date,'%d.%m.%Y') as dater FROM ru_items_opinions WHERE (is_enable='1') AND (item_id in (1,2,44,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,115,116,19,20,21,22,23,24,66,67,68,25,26,27,28,29,30,31,32,303,304,33,297,298,34,294,296,291,292,293,37,38,39,40,42,299,300,43,45,46,47,49,50,51,52,53,55,56,57,58,59,60,61,62,63,64,69,71,72,73,74,75,76,77,78,79,80,81,82,83,85,86,87,90,89,92,93,94,95,96,97,98,99,100,101,102,310,311,312,313,314,316,317,324,325,326,320,108,109,114,111,113,118,119,120,121,122,123,124,125,126,127,128,129,131,133,135,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,156,157,158,159,160,161,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,198,199,200,201,202,206,207,208,209,210,211,212,213,214,216,217,218,219,220,221,222,223,224,225,226,227,228,229,290,230,231,232,233,236,238,239,240,241,242,243,244,245,246,247,248,249,250,289,251,252,253,254,255,256,257,258,259,260,261,305,306,309,308,262,263,264,265,266,267,269,270,322,323,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288)) AND (item_id='166') ORDER by date DESC LIMIT 10 OFFSET 0
SELECT COUNT(*) FROM ru_items_opinions WHERE (is_enable='1') AND (item_id in (1,2,44,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,115,116,19,20,21,22,23,24,66,67,68,25,26,27,28,29,30,31,32,303,304,33,297,298,34,294,296,291,292,293,37,38,39,40,42,299,300,43,45,46,47,49,50,51,52,53,55,56,57,58,59,60,61,62,63,64,69,71,72,73,74,75,76,77,78,79,80,81,82,83,85,86,87,90,89,92,93,94,95,96,97,98,99,100,101,102,310,311,312,313,314,316,317,324,325,326,320,108,109,114,111,113,118,119,120,121,122,123,124,125,126,127,128,129,131,133,135,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,156,157,158,159,160,161,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,198,199,200,201,202,206,207,208,209,210,211,212,213,214,216,217,218,219,220,221,222,223,224,225,226,227,228,229,290,230,231,232,233,236,238,239,240,241,242,243,244,245,246,247,248,249,250,289,251,252,253,254,255,256,257,258,259,260,261,305,306,309,308,262,263,264,265,266,267,269,270,322,323,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288)) AND (item_id='166') 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/opinions/hotels/grandhotel') AND (is_enable='1') LIMIT 1
|