SELECT p1.*, p2.title, p2.descr, YEAR(p1.add_date) as dy, MONTH (p1.add_date) as dm, DAYOFMONTH(p1.add_date) as dd
FROM dst_pages_photo p1
INNER JOIN dst_pages_photo_langs p2 ON p1.id=p2.item_id AND p2.lang_id='1'
WHERE p1.item_id=1
ORDER BY p1.sort_num,p1.add_dateDisk full (/var/tmp/#sql_112e_3); waiting for someone to free some space...SELECT p1.*, p2.title, p2.descr, YEAR(p1.add_date) as dy, MONTH (p1.add_date) as dm, DAYOFMONTH(p1.add_date) as dd
FROM dst_page_video p1
INNER JOIN dst_page_video_lang p2 ON p1.id=p2.item_id AND p2.lang_id='1'
WHERE p1.item_id=1
ORDER BY p1.sort_num,p1.add_dateDisk full (/var/tmp/#sql_112e_3); waiting for someone to free some space...
Мужская обувь Vans, Dr.Martens, Nike – интернет магазин District
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='1'
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 Disk full (/var/tmp/#sql_112e_3); waiting for someone to free some space...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='1'
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='1'
WHERE c1.parent_id='1' AND c1.visible=1
ORDER BY groupsort,c1.sort_numDisk full (/var/tmp/#sql_112e_3); waiting for someone to free some space...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='1'
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='1'
WHERE c1.parent_id='5' AND c1.visible=1
ORDER BY groupsort,c1.sort_numDisk full (/var/tmp/#sql_112e_3); waiting for someone to free some space...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='1'
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='1'
WHERE c1.parent_id='2' AND c1.visible=1
ORDER BY groupsort,c1.sort_numDisk full (/var/tmp/#sql_112e_3); waiting for someone to free some space...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='1'
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='1'
WHERE c1.parent_id='6' AND c1.visible=1
ORDER BY groupsort,c1.sort_numDisk full (/var/tmp/#sql_112e_0); waiting for someone to free some space...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='1'
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='1'
WHERE c1.parent_id='3' AND c1.visible=1
ORDER BY groupsort,c1.sort_numDisk full (/var/tmp/#sql_112e_0); waiting for someone to free some space...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='1'
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='1'
WHERE c1.parent_id='4' AND c1.visible=1
ORDER BY groupsort,c1.sort_numDisk full (/var/tmp/#sql_112e_0); waiting for someone to free some space...
SELECT * FROM dst_html_cache WHERE lang_id='1' AND cache_key='main_menu'MySQL server has gone awayINSERT INTO dst_html_cache (lang_id, cache_key, add_date, htmldata) VALUES ('1', 'main_menu', NOW(), '
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 awaySELECT 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 awaySELECT 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 awaySELECT 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 awaySELECT 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 awaySELECT 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
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='243' AND visible=1 MySQL server has gone awaySELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='243' AND visible=1 MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1579' AND visible=1 MySQL server has gone awaySELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1579' AND visible=1 MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1578' AND visible=1 MySQL server has gone awaySELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1578' AND visible=1 MySQL server has gone away
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 awaySELECT 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 awaySELECT 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 awaySELECT 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 awaySELECT 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
SELECT b1.*, bl1.alttext FROM dst_banners b1
INNER JOIN dst_banners_lang bl1 ON b1.id=bl1.banner_id AND bl1.lang_id='1'
WHERE b1.managetype=0 AND b1.page_url LIKE 'https://district.ua/ru/sect/men-shoes/vans,drmartens,nike/f-8_51_40-6_22_kedy-6_23_boots/index.html%' AND b1.disppos='0'
ORDER BY b1.sort_numMySQL server has gone away
