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_11bb_2); 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_11bb_2); 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_11bb_2); 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_11bb_2); 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_11bb_2); waiting for someone to free some space...
