SELECT c1.*, c2.name, c2.name_dop, c2.descr, c2.descr0, c2.meta_title, c2.meta_keyw, c2.meta_descr, cp1.id as pid, cp1.url as purl
FROM dst_cat_section c1
INNER JOIN dst_cat_section_lang c2 ON c1.id=c2.sect_id AND c2.lang_id='2'
LEFT JOIN dst_cat_section cp1 ON c1.parent_id=cp1.id
WHERE c1.id='1' MySQL server has gone awaySELECT c1.id, c1.parent_id, c1.url, c2.name
FROM dst_cat_section c1, dst_cat_section_lang c2
WHERE c1.id='1' AND c1.id=c2.sect_id AND c2.lang_id='2'MySQL server has gone awaySELECT c1.*, c2.name, c2.descr, cp1.id as pid, cp1.url as purl
FROM dst_cat_section c1
INNER JOIN dst_cat_section_lang c2 ON c1.id=c2.sect_id AND c2.lang_id='2'
LEFT JOIN dst_cat_section cp1 ON c1.parent_id=cp1.id
WHERE c1.parent_id='1' AND c1.visible=1
ORDER BY c1.sort_num
MySQL server has gone away Notice: Undefined index: name in /var/www/district/data/www/district.ua/catalog.php on line 450
Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 451
Notice: Undefined index: pid in /var/www/district/data/www/district.ua/catalog.php on line 452
Notice: Undefined index: descr0 in /var/www/district/data/www/district.ua/catalog.php on line 457
SELECT * FROM dst_contact_options WHERE lang_id=2 ORDER BY idMySQL server has gone away Notice: Undefined index: phone1 in /var/www/district/data/www/district.ua/catalog.php on line 579
SELECT * FROM dst_cat_section_title WHERE lang_id='2' AND sect_id=1 AND make_id=0 AND sortmode_id=0 AND filter_id='0' AND filter_val='0' AND carb_id='0' AND carm_id='0' AND comb_filters = '' MySQL server has gone away Notice: Undefined index: name in /var/www/district/data/www/district.ua/catalog.php on line 673
Notice: Undefined index: descr in /var/www/district/data/www/district.ua/catalog.php on line 723
Notice: Undefined index: name in /var/www/district/data/www/district.ua/catalog.php on line 732
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='1'
ORDER BY m2.make_name MySQL server has gone away Notice: Undefined index: showmakefilt in /var/www/district/data/www/district.ua/catalog.php on line 752
SELECT count(*) as totalitems
FROM dst_cat_item i1
INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1'
INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id AND i1.make_id IN (5,2,31,10,18,7,8)
INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id
WHERE i1.id<>0 AND i1.archive=0 MySQL server has gone awaySELECT 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='1'
INNER JOIN dst_cat_producer_lang m1 ON ( (i1.make_id=5) OR (i1.make_id=2) OR (i1.make_id=31) OR (i1.make_id=10) OR (i1.make_id=18) OR (i1.make_id=7) OR (i1.make_id=8) ) 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 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 away Notice: Undefined index: phone1 in /var/www/district/data/www/district.ua/inc/header-inc.php on line 43
Notice: Undefined index: phone2 in /var/www/district/data/www/district.ua/inc/header-inc.php on line 46
Notice: Undefined index: phone1 in /var/www/district/data/www/district.ua/inc/header-inc.php on line 54
Notice: Undefined index: phone2 in /var/www/district/data/www/district.ua/inc/header-inc.php on line 55
Notice: Undefined index: phone3 in /var/www/district/data/www/district.ua/inc/header-inc.php on line 56
Notice: Undefined index: phone4 in /var/www/district/data/www/district.ua/inc/header-inc.php on line 57
SELECT 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
Dr. Martens, Nike, The North Face, Native, Skechers, New Balance, Vans – інтернет магазин District
SELECT i1.id as id, c.id as cart_id, i1.model, pr.price, c.oborud_id, c.oborud_num, c.submod_id
FROM dst_cat_cart c
INNER JOIN dst_cat_item i1 ON c.oborud_id=i1.id
INNER JOIN dst_cat_price pr ON i1.id=pr.item_id AND c.submod_id=pr.subm_id
WHERE c.ses_id='16ddd42c2220f4607cdfceb17dfb7f62'MySQL server has gone away
SELECT m1.*, m2.make_name, m2.descr, count(i1.id) as totprods
FROM dst_cat_producer m1
INNER JOIN dst_cat_producer_lang m2 ON m1.id=m2.make_id AND m2.lang_id='2'
LEFT JOIN dst_cat_item i1 ON m1.id=i1.make_id AND i1.archive=0
WHERE true
GROUP BY m1.id
ORDER BY m2.make_name MySQL server has gone awaySELECT c1.*, c2.name, c2.descr, cp1.id as pid, cp1.url as purl
FROM dst_cat_section c1
INNER JOIN dst_cat_section_lang c2 ON c1.id=c2.sect_id AND c2.lang_id='2'
LEFT JOIN dst_cat_section cp1 ON c1.parent_id=cp1.id
WHERE c1.parent_id='0' AND c1.visible=1
ORDER BY c1.sort_num
MySQL server has gone away
SELECT * FROM dst_html_cache WHERE lang_id='2' AND cache_key='main_menu'MySQL server has gone awayINSERT INTO dst_html_cache (lang_id, cache_key, add_date, htmldata) VALUES ('2', 'main_menu', NOW(), '
Dr. Martens, Nike, The North Face, Native, Skechers, New Balance, Vans
Notice: Undefined index: pid in /var/www/district/data/www/district.ua/catalog.php on line 2505
Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 2837
Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 2837
Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 2837
Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 2837
Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 2853
Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 2853
SELECT count(*) as totalitems
FROM dst_cat_item i1
INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1'
INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id
INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id
WHERE i1.id<>0 AND i1.status='0' AND i1.archive=0 MySQL server has gone away Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 2879
SELECT count(*) as totalitems
FROM dst_cat_item i1
INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1'
INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id
INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id
WHERE i1.id<>0 AND i1.status='1' AND i1.archive=0 MySQL server has gone away Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 2879
SELECT count(*) as totalitems
FROM dst_cat_item i1
INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1'
INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id
INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id
WHERE i1.id<>0 AND i1.status='2' AND i1.archive=0 MySQL server has gone away Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 2879
SELECT count(*) as totalitems
FROM dst_cat_item i1
INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1'
INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id
INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id
WHERE i1.id<>0 AND i1.status='3' AND i1.archive=0 MySQL server has gone away Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 2879
SELECT count(*) as totalitems
FROM dst_cat_item i1
INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1'
INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id
INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id
WHERE i1.id<>0 AND i1.status='4' AND i1.archive=0 MySQL server has gone away Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 2879
SELECT count(*) as totalitems
FROM dst_cat_item i1
INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1'
INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id
INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id
INNER JOIN dst_cat_action_items ai1 ON i1.id=ai1.prod_id
INNER JOIN dst_cat_actions a1 ON ai1.act_id=a1.id AND a1.active=1
WHERE i1.id<>0 AND i1.status='0' AND i1.archive=0 MySQL server has gone away Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 2879
SELECT count(*) as totalitems
FROM dst_cat_item i1
INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1'
INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id
INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id
WHERE i1.id<>0 AND i1.status='1' AND i1.archive=0 MySQL server has gone away Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 3179
SELECT count(*) as totalitems
FROM dst_cat_item i1
INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1'
INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id
INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id
WHERE i1.id<>0 AND i1.status='2' AND i1.archive=0 MySQL server has gone away Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 3179
SELECT count(*) as totalitems
FROM dst_cat_item i1
INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1'
INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id
INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id
WHERE i1.id<>0 AND i1.status='3' AND i1.archive=0 MySQL server has gone away Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 3179
SELECT count(*) as totalitems
FROM dst_cat_item i1
INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1'
INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id
INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id
WHERE i1.id<>0 AND i1.status='4' AND i1.archive=0 MySQL server has gone away Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 3179
SELECT count(*) as totalitems
FROM dst_cat_item i1
INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1'
INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id
INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id
INNER JOIN dst_cat_action_items ai1 ON i1.id=ai1.prod_id
INNER JOIN dst_cat_actions a1 ON ai1.act_id=a1.id AND a1.active=1
WHERE i1.id<>0 AND i1.status='0' AND i1.archive=0 MySQL server has gone away Notice: Undefined index: url in /var/www/district/data/www/district.ua/catalog.php on line 3179
Каталог
SELECT c1.parent_id, c1.id, c1.url, c1.filename, c1.is_link, c2.name, c2.descr, c1.menu_group_id, cp1.id as pid, cp1.url as purl,
g2.title as grouptitle, g1.id as groupid,
case when g1.sort_num IS NOT NULL then g1.sort_num else 1000 end as groupsort
FROM dst_cat_section c1
INNER JOIN dst_cat_section_lang c2 ON c1.id=c2.sect_id AND c2.lang_id='2'
LEFT JOIN dst_cat_section cp1 ON c1.parent_id=cp1.id
LEFT JOIN dst_cat_section_groups g1 ON c1.menu_group_id=g1.id
LEFT JOIN dst_cat_section_groups_lang g2 ON c1.menu_group_id=g2.sect_group_id AND g2.lang_id='2'
WHERE c1.parent_id='1' AND c1.visible=1
ORDER BY groupsort,c1.sort_numMySQL server has gone away
SELECT 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=0 AND b1.page_url LIKE 'https://district.ua/sect/men-shoes/drmartens,nike,thenorthface,nativeshoes,skechers,newbalance,vans/index.html%' AND b1.disppos='0'
ORDER BY b1.sort_numMySQL server has gone away