SELECT DISTINCT m1.id, m1.url, m1.first_page, m2.make_name, m2.descr, ic.cnt as totprods FROM dst_cat_sectitem c1 INNER JOIN dst_cat_item i1 ON c1.item_id=i1.id AND i1.archive=0 INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id INNER JOIN dst_cat_producer_lang m2 ON m1.id=m2.make_id AND m2.lang_id='2' LEFT JOIN dst_cat_item_count_cache ic ON ic.sect_id = c1.sect_id AND ic.make_id = m1.id AND ic.car_id = 0 WHERE c1.sect_id='5' ORDER BY m2.make_name MySQL server has gone awaySELECT p2.*, p3.name FROM dst_cat_filters p2 INNER JOIN dst_cat_filters_lang p3 ON p3.param_id=p2.id AND p3.lang_id='2' WHERE p2.id='7'MySQL server has gone awaySELECT p2.*, p3.name FROM dst_cat_filters p2 INNER JOIN dst_cat_filters_lang p3 ON p3.param_id=p2.id AND p3.lang_id='2' WHERE p2.id='7'MySQL server has gone awaySELECT p2.*, p3.name FROM dst_cat_filters p2 INNER JOIN dst_cat_filters_lang p3 ON p3.param_id=p2.id AND p3.lang_id='2' WHERE p2.id='7'MySQL server has gone awaySELECT p2.*, p3.name FROM dst_cat_filters p2 INNER JOIN dst_cat_filters_lang p3 ON p3.param_id=p2.id AND p3.lang_id='2' WHERE p2.id='7'MySQL server has gone awaySELECT count( i1.id) as totalitems FROM dst_cat_item i1 INNER JOIN dst_cat_sectitem c1 ON i1.id=c1.item_id AND c1.sect_id='5' INNER JOIN dst_cat_producer_lang m1 ON ( (i1.make_id=18) OR (i1.make_id=15) ) AND i1.make_id=m1.make_id AND m1.lang_id='2' INNER JOIN dst_cat_section_lang cc1 ON c1.sect_id=cc1.sect_id AND cc1.lang_id='2' WHERE i1.archive=0 MySQL server has gone awaySELECT DISTINCT p1.url as make_url, i1.*, i2.model2, i2.descr, i2.descr0, m1.make_name as producer, cc1.name as section, max(pr1.price) as maxcost, min(pr1.price) as mincost, max(pr1.availiable_now) as sortexist, case when max(pr1.price)=0 then 1 else 0 end as sortcost, cc1.sect_id as sectid FROM dst_cat_item i1 INNER JOIN dst_cat_item_lang i2 ON i1.id=i2.item_id AND i2.lang_id='2' INNER JOIN dst_cat_sectitem c1 ON i1.id=c1.item_id AND c1.sect_id='5' INNER JOIN dst_cat_producer_lang m1 ON ( (i1.make_id=18) OR (i1.make_id=15) ) AND i1.make_id=m1.make_id AND m1.lang_id='2' INNER JOIN dst_cat_producer p1 ON p1.id=m1.make_id INNER JOIN dst_cat_section_lang cc1 ON c1.sect_id=cc1.sect_id AND cc1.lang_id='2' LEFT JOIN dst_cat_price pr1 ON i1.id=pr1.item_id WHERE i1.archive=0 GROUP BY i1.id ORDER BY sortexist DESC, sortcost, item_rate DESC LIMIT 0,24MySQL server has gone awaySELECT i1.* FROM dst_cat_item i1 INNER JOIN dst_cat_item_lang i2 ON i1.id=i2.item_id AND i2.lang_id='2' INNER JOIN dst_cat_sectitem c1 ON i1.id=c1.item_id AND c1.sect_id='5' INNER JOIN dst_cat_section_lang cc1 ON c1.sect_id=cc1.sect_id AND cc1.lang_id='2' LIMIT 0,1MySQL server has gone awaySELECT p1.*, p2.page_mean, p2.page_title, p2.page_keywords, p2.page_descr, p2.title, p2.header, p2.content FROM dst_pages p1 INNER JOIN dst_pages_lang p2 ON p1.id=p2.item_id AND p2.lang_id='2' WHERE p1.page_name='catalog'MySQL server has gone awaySELECT s1.*, s2.title, s2.url, s2.filename, s2.btntext, s2.comment FROM dst_slides s1 INNER JOIN dst_slides_lang s2 ON s1.id=s2.item_id AND s2.lang_id='2' WHERE s1.visible=1 AND s1.place_type=0 ORDER BY s1.sort_numMySQL server has gone awaySELECT r1.*, r2.content FROM dst_resource r1 INNER JOIN dst_resource_lang r2 ON r1.id=r2.item_id AND r2.lang_id='2'MySQL server has gone awaySELECT b1.*, bl1.alttext FROM dst_banners b1 INNER JOIN dst_banners_lang bl1 ON b1.id=bl1.banner_id AND bl1.lang_id='2' WHERE b1.managetype=1 ORDER BY b1.idMySQL server has gone awaySELECT p1.*, p2.page_mean, p2.title FROM dst_pages p1 INNER JOIN dst_pages_lang p2 ON p1.id=p2.item_id AND p2.lang_id='2' WHERE p1.parent_id=0 AND p1.show_in_menu=1 ORDER BY p1.sort_num,p1.idMySQL server has gone away