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_9); 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_9); waiting for someone to free some space...
Мужская обувь Vans, Dr.Martens, Nike, Converse, Skechers – интернет магазин 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_9); 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_9); 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_9); 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_9); 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_9); 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_9); 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_9); waiting for someone to free some space...
