childsstroke: manuf
SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('292','160752','161544','239577','240859','240860','242699','242795','243317','243502','247625','247973','286417','288019','288020','288021','293936','293937','293938','158213','164466','165949','166666','244211','244212','245715','249581','253126','253578','253809','267712','274137','274138','275249','276396','279636','285307','286004','286121','292088','294266','285258','295152','288834','303895','293862','293863','293864','293865','293866','293867','293868','293869') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke1: manuf
SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('158213','160752','161544','164466','165949','166666','239577','240859','240860','242699','242795','243317','243502','244211','244212','245715','247625','247973','249581','253126','253578','253809','267712','274137','274138','275249','276396','279636','285258','285307','286004','286121','286417','288019','288020','288021','288834','292088','293862','293863','293864','293865','293866','293867','293868','293869','294266','295152','303895') GROUP BY `manuf` ORDER BY `manuf` ASC
