childsstroke: parent
SELECT `parent`,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 `parent` !='' AND `modx_site_content`.`id` IN ('60','157','163','195','316','249298','262035','287783','287784','287785','141687','142855','142856','148048','148747','148748','148749','148750','148751','148752','148753','148754','148755','148756','151237','153309','153454','153504','154863','154898','155063','155121','156873','156874','156875','156876','156877','157736','157737','157751','158478','158969','158998','160181','161283','161405','161406','161407','161408','161409','161410','161411','161412','161612','162619','165844','165845','165846','165847','167800','170034','170160','170180','202873','202874','202875','202876','202877','202878','202879','202880','202881','202882','202883','202884','202885','202886','202887','202888','202889','202890','202891','202892','202893','202894','202895','202896','202897','202898','202899','202900','202901','202902','202903','202904','202905','202906','202907','202908','202909','202910','202911','202912','202913','202914','202915','202916','202917','202918','202919','202920','202921','202922','202923','202924','202925','202926','202927','202928','202929','202930','202931','202932','202933','202934','202935','202936','202937','202938','202939','202940','202941','202942','202943','202944','202945','202946','202947','202948','202949','202950','202951','202952','202953','202954','202955','202956','202957','202958','202959','202960','202961','202962','202963','202964','202965','202966','202967','202968','202969','202970','202971','202972','202973','202974','202975','202976','202977','202978','202979','202980','202981','202982','202983','202984','202985','202986','202987','202988','202989','202990','215286','215692','215903','219772','232410','238431','238438','238443','238528','238743','238744','240707','241621','242211','242671','243181','244941','244942','247665','248975','249916','251151','253135','254207','256801','256802','262639','265917','267931','268452','274337','274338','275454','275455','275456','275457','275459','275460','275461','275462','275463','275464','275465','275466','275467','276573','277347','277764','280347','280377','280438','281153','282375','282554','282556','283426','285154','285475','287221','287222','287255','287256','287257','287258','287259','287260','287261','287262','287263','287264','287265','287266','287267','287268','287269','287270','287271','287272','287273','287274','287275','287276','287277','287278','287279','287280','287281','287282','287283','287284','287285','287286','287287','287288','287289','287290','287291','287292','287293','287294','287295','287296','287297','287298','287299','287300','287301','287302','287303','287304','287305','287306','287307','287308','287309','287310','287311','287312','287313','287314','287315','287316','287317','287318','287319','287320','287321','287322','287323','287324','287325','287326','287327','287328','287329','287330','287331','287332','287333','287334','287335','287336','287337','287338','287339','287340','287341','287342','287343','287344','287345','287346','287347','287348','287349','287350','287351','287352','287353','287354','287355','287356','287357','287358','287359','287360','287361','287362','287363','287364','287365','287366','287367','287368','287369','287370','287371','287372','287373','287374','287375','287376','287377','287378','287379','287380','287381','287382','287383','287404','287405','287406','287407','287408','287409','287410','287411','287412','287413','287414','287415','287416','287417','291993','294247','295395','295402','297613','297614','297756','298311','298374','298375','298376','298397','299564','299843','300490','300491','300492','300493','302348','149908','151606','151690','153214','153215','153455','153456','153469','157700','157702','157825','158146','158216','158754','158755','159967','159983','159985','161216','161463','162350','162622','163358','163359','163360','163672','164157','164549','164550','165161','165767','166058','166672','167153','168339','239956','240312','240409','242294','243423','243939','245947','246740','246866','249142','251439','255665','255711','262489','262490','262491','262492','264445','267907','273932','277906','278331','280850','283234','283682','283684','283686','283689','300184','141641','141932','143306','147045','150152','150153','150154','150155','150156','150157','150158','153274','153459','155064','158154','158320','158322','160351','160956','161315','162269','162270','162271','163310','163568','167586','170179','202626','211959','211960','211961','211962','211963','211964','211965','211966','211967','211968','211969','211970','211971','211972','211973','215688','240153','241326','242506','242775','242777','242945','243997','248942','251399','253419','253424','255690','262486','262497','262498','262499','287234','287235','287236','287237','287238','287239','287469','287470','287471','287472','287473','287474','287475','287476','287477','287478','287479','287480','287481','287482','287483','287484','287485','287486','287487','287488','287489','287490','287491','287492','287493','288009','288284','294793','300472','300473','300474','300475','300479','300487','300488','300489','300622','300623','300624','141369','142055','142527','142711','142744','143057','143348','144295','146706','146968','146969','147862','150893','151193','151215','151634','152621','152649','153119','153120','153942','153948','154418','154594','155340','155437','157008','157009','157010','157011','157012','157013','157014','157015','157016','157017','157018','157019','157020','157021','158225','158226','158531','158563','158736','158764','158975','159216','159662','159735','159810','160009','160215','160720','161101','161200','161422','161532','161533','162218','162272','162415','162416','162426','162427','162621','162791','162792','163357','163671','163826','165380','165385','165458','165459','165749','166474','166526','166862','167305','167758','170181','170585','201193','201194','201196','215857','215910','215941','232718','238048','238221','238293','238769','238874','239164','239902','240084','240104','240105','240287','240403','240917','241081','241082','241083','241532','241763','242907','242924','242992','242993','242994','242995','243025','243078','243527','243781','244081','244243','244284','244680','245020','245159','245283','245294','245295','245527','246244','246905','246906','247109','247432','248498','248999','249072','249215','249229','249280','249445','249549','250673','251225','251230','251499','251550','251863','253234','253589','253794','254456','254763','254905','254999','255372','256545','256570','256713','261765','262483','262484','262485','262493','262494','262495','262496','263547','263716','263717','264383','265240','265771','266035','266158','267360','268145','269307','273904','274049','274050','275555','275605','275984','276152','277922','279212','279469','279565','279726','280431','280925','281243','283632','284409','284583','285303','285380','285693','285846','287390','287391','287392','287393','287394','287395','287396','287397','287398','287399','287400','287401','287402','287403','287439','287440','287441','287442','287443','287444','287445','287446','287447','287448','287449','287450','287451','287452','287453','287454','287455','287456','287457','287458','287459','287460','287461','287462','287463','287464','287465','287466','287467','287468','289019','291810','293521','295618','297640','297740','299896','300059','303891','303928','303929','142090','143223','150639','151704','153313','154264','155290','156633','159279','160019','161915','162413','162730','163289','163979','167113','167147','238558','240888','242450','245286','247010','247763','253397','253398','253586','256344','256537','256674','256675','262487','262488','262520','264352','264469','275013','276430','277196','280839','285516','285572','287418','287419','287420','287421','287422','287423','287424','287425','287426','287427','287428','287429','287430','287431','287432','287433','287434','287435','287436','287437','287438','288861','295390','295403','295404','298589','300439','300440','300441','300442','300443','300444','300445','300446','300447','300448','300449','300450','300451','300452','300453','300454','300455','300456','300457','300458','300459','300460','300461','300462','300463','300464','300465','300466','300467','300468','300469','300470','300471','300476','300477','300478','300480','300481','300482','300483','300484','300485','300486','301013','287240','287241','287242','287243','287494','287495','287496','287497','287498','287499','287500','287501','287502','287503','287246','287247','287248','287249','287250','287251','287252','287253','287254','287244','287245') GROUP BY `parent` ORDER BY `parent` ASC
childsstroke1: parent
SELECT `parent`,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 `parent` !='' AND `modx_site_content`.`id` IN ('141369','141641','141687','141932','142055','142090','142527','142711','142744','142855','142856','143057','143223','143306','143348','144295','146706','146968','146969','147045','147862','148048','148747','148748','148749','148750','148751','148752','148753','148754','148755','148756','149908','150152','150153','150154','150155','150156','150157','150158','150639','150893','151193','151215','151237','151606','151634','151690','152621','152649','153119','153120','153214','153215','153274','153309','153313','153454','153455','153456','153459','153469','153504','153942','153948','154264','154418','154594','154863','154898','155063','155064','155121','155290','155340','155437','156633','156873','156874','156875','156876','156877','157008','157009','157010','157011','157012','157013','157014','157015','157016','157017','157018','157019','157020','157021','157700','157702','157736','157737','157751','157825','158146','158154','158216','158225','158226','158320','158322','158478','158531','158563','158736','158754','158755','158764','158969','158975','158998','159216','159279','159662','159735','159810','159967','159983','159985','160009','160019','160181','160215','160351','160720','160956','161101','161200','161216','161283','161315','161405','161406','161407','161408','161409','161410','161411','161412','161422','161463','161532','161533','161612','161915','162218','162269','162270','162271','162272','162350','162413','162415','162416','162426','162427','162619','162621','162622','162730','162791','162792','163289','163310','163357','163358','163359','163360','163568','163671','163672','163826','163979','164157','164549','164550','165161','165380','165385','165458','165459','165749','165767','165844','165845','165846','165847','166058','166474','166526','166672','166862','167113','167147','167153','167305','167586','167758','167800','168339','170034','170160','170179','170180','170181','170585','201193','201194','201196','202626','202873','202874','202875','202876','202877','202878','202879','202880','202881','202882','202883','202884','202885','202886','202887','202888','202889','202890','202891','202892','202893','202894','202895','202896','202897','202898','202899','202900','202901','202902','202903','202904','202905','202906','202907','202908','202909','202910','202911','202912','202913','202914','202915','202916','202917','202918','202919','202920','202921','202922','202923','202924','202925','202926','202927','202928','202929','202930','202931','202932','202933','202934','202935','202936','202937','202938','202939','202940','202941','202942','202943','202944','202945','202946','202947','202948','202949','202950','202951','202952','202953','202954','202955','202956','202957','202958','202959','202960','202961','202962','202963','202964','202965','202966','202967','202968','202969','202970','202971','202972','202973','202974','202975','202976','202977','202978','202979','202980','202981','202982','202983','202984','202985','202986','202987','202988','202989','202990','211959','211960','211961','211962','211963','211964','211965','211966','211967','211968','211969','211970','211971','211972','211973','215286','215688','215692','215857','215903','215910','215941','219772','232410','232718','238048','238221','238293','238431','238438','238443','238528','238558','238743','238744','238769','238874','239164','239902','239956','240084','240104','240105','240153','240287','240312','240403','240409','240707','240888','240917','241081','241082','241083','241326','241532','241621','241763','242211','242294','242450','242506','242671','242775','242777','242907','242924','242945','242992','242993','242994','242995','243025','243078','243181','243423','243527','243781','243939','243997','244081','244243','244284','244680','244941','244942','245020','245159','245283','245286','245294','245295','245527','245947','246244','246740','246866','246905','246906','247010','247109','247432','247665','247763','248498','248942','248975','249072','249142','249215','249229','249280','249298','249445','249549','249916','250673','251151','251225','251230','251399','251439','251499','251550','251863','253135','253234','253397','253398','253419','253424','253586','253589','253794','254207','254456','254763','254905','254999','255372','255665','255690','255711','256344','256537','256545','256570','256674','256675','256713','256801','256802','261765','262035','262483','262484','262485','262486','262487','262488','262489','262490','262491','262492','262493','262494','262495','262496','262497','262498','262499','262520','262639','263547','263716','263717','264352','264383','264445','264469','265240','265771','265917','266035','266158','267360','267907','267931','268145','268452','269307','273904','273932','274049','274050','274337','274338','275013','275454','275455','275456','275457','275459','275460','275461','275462','275463','275464','275465','275466','275467','275555','275605','275984','276152','276430','276573','277196','277347','277764','277906','277922','278331','279212','279469','279565','279726','280347','280377','280431','280438','280839','280850','280925','281153','281243','282375','282554','282556','283234','283426','283632','283682','283684','283686','283689','284409','284583','285154','285303','285380','285475','285516','285572','285693','285846','287221','287222','287234','287235','287236','287237','287238','287239','287240','287241','287242','287243','287244','287245','287246','287247','287248','287249','287250','287251','287252','287253','287254','287255','287256','287257','287258','287259','287260','287261','287262','287263','287264','287265','287266','287267','287268','287269','287270','287271','287272','287273','287274','287275','287276','287277','287278','287279','287280','287281','287282','287283','287284','287285','287286','287287','287288','287289','287290','287291','287292','287293','287294','287295','287296','287297','287298','287299','287300','287301','287302','287303','287304','287305','287306','287307','287308','287309','287310','287311','287312','287313','287314','287315','287316','287317','287318','287319','287320','287321','287322','287323','287324','287325','287326','287327','287328','287329','287330','287331','287332','287333','287334','287335','287336','287337','287338','287339','287340','287341','287342','287343','287344','287345','287346','287347','287348','287349','287350','287351','287352','287353','287354','287355','287356','287357','287358','287359','287360','287361','287362','287363','287364','287365','287366','287367','287368','287369','287370','287371','287372','287373','287374','287375','287376','287377','287378','287379','287380','287381','287382','287383','287390','287391','287392','287393','287394','287395','287396','287397','287398','287399','287400','287401','287402','287403','287404','287405','287406','287407','287408','287409','287410','287411','287412','287413','287414','287415','287416','287417','287418','287419','287420','287421','287422','287423','287424','287425','287426','287427','287428','287429','287430','287431','287432','287433','287434','287435','287436','287437','287438','287439','287440','287441','287442','287443','287444','287445','287446','287447','287448','287449','287450','287451','287452','287453','287454','287455','287456','287457','287458','287459','287460','287461','287462','287463','287464','287465','287466','287467','287468','287469','287470','287471','287472','287473','287474','287475','287476','287477','287478','287479','287480','287481','287482','287483','287484','287485','287486','287487','287488','287489','287490','287491','287492','287493','287494','287495','287496','287497','287498','287499','287500','287501','287502','287503','288009','288284','288861','289019','291810','291993','293521','294247','294793','295390','295395','295402','295403','295404','295618','297613','297614','297640','297740','297756','298311','298374','298375','298376','298397','298589','299564','299843','299896','300059','300184','300439','300440','300441','300442','300443','300444','300445','300446','300447','300448','300449','300450','300451','300452','300453','300454','300455','300456','300457','300458','300459','300460','300461','300462','300463','300464','300465','300466','300467','300468','300469','300470','300471','300472','300473','300474','300475','300476','300477','300478','300479','300480','300481','300482','300483','300484','300485','300486','300487','300488','300489','300490','300491','300492','300493','300622','300623','300624','301013','302348','303891','303928','303929') GROUP BY `parent` ORDER BY `parent` ASC
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 ('60','157','163','195','316','249298','262035','287783','287784','287785','141687','142855','142856','148048','148747','148748','148749','148750','148751','148752','148753','148754','148755','148756','151237','153309','153454','153504','154863','154898','155063','155121','156873','156874','156875','156876','156877','157736','157737','157751','158478','158969','158998','160181','161283','161405','161406','161407','161408','161409','161410','161411','161412','161612','162619','165844','165845','165846','165847','167800','170034','170160','170180','202873','202874','202875','202876','202877','202878','202879','202880','202881','202882','202883','202884','202885','202886','202887','202888','202889','202890','202891','202892','202893','202894','202895','202896','202897','202898','202899','202900','202901','202902','202903','202904','202905','202906','202907','202908','202909','202910','202911','202912','202913','202914','202915','202916','202917','202918','202919','202920','202921','202922','202923','202924','202925','202926','202927','202928','202929','202930','202931','202932','202933','202934','202935','202936','202937','202938','202939','202940','202941','202942','202943','202944','202945','202946','202947','202948','202949','202950','202951','202952','202953','202954','202955','202956','202957','202958','202959','202960','202961','202962','202963','202964','202965','202966','202967','202968','202969','202970','202971','202972','202973','202974','202975','202976','202977','202978','202979','202980','202981','202982','202983','202984','202985','202986','202987','202988','202989','202990','215286','215692','215903','219772','232410','238431','238438','238443','238528','238743','238744','240707','241621','242211','242671','243181','244941','244942','247665','248975','249916','251151','253135','254207','256801','256802','262639','265917','267931','268452','274337','274338','275454','275455','275456','275457','275459','275460','275461','275462','275463','275464','275465','275466','275467','276573','277347','277764','280347','280377','280438','281153','282375','282554','282556','283426','285154','285475','287221','287222','287255','287256','287257','287258','287259','287260','287261','287262','287263','287264','287265','287266','287267','287268','287269','287270','287271','287272','287273','287274','287275','287276','287277','287278','287279','287280','287281','287282','287283','287284','287285','287286','287287','287288','287289','287290','287291','287292','287293','287294','287295','287296','287297','287298','287299','287300','287301','287302','287303','287304','287305','287306','287307','287308','287309','287310','287311','287312','287313','287314','287315','287316','287317','287318','287319','287320','287321','287322','287323','287324','287325','287326','287327','287328','287329','287330','287331','287332','287333','287334','287335','287336','287337','287338','287339','287340','287341','287342','287343','287344','287345','287346','287347','287348','287349','287350','287351','287352','287353','287354','287355','287356','287357','287358','287359','287360','287361','287362','287363','287364','287365','287366','287367','287368','287369','287370','287371','287372','287373','287374','287375','287376','287377','287378','287379','287380','287381','287382','287383','287404','287405','287406','287407','287408','287409','287410','287411','287412','287413','287414','287415','287416','287417','291993','294247','295395','295402','297613','297614','297756','298311','298374','298375','298376','298397','299564','299843','300490','300491','300492','300493','302348','149908','151606','151690','153214','153215','153455','153456','153469','157700','157702','157825','158146','158216','158754','158755','159967','159983','159985','161216','161463','162350','162622','163358','163359','163360','163672','164157','164549','164550','165161','165767','166058','166672','167153','168339','239956','240312','240409','242294','243423','243939','245947','246740','246866','249142','251439','255665','255711','262489','262490','262491','262492','264445','267907','273932','277906','278331','280850','283234','283682','283684','283686','283689','300184','141641','141932','143306','147045','150152','150153','150154','150155','150156','150157','150158','153274','153459','155064','158154','158320','158322','160351','160956','161315','162269','162270','162271','163310','163568','167586','170179','202626','211959','211960','211961','211962','211963','211964','211965','211966','211967','211968','211969','211970','211971','211972','211973','215688','240153','241326','242506','242775','242777','242945','243997','248942','251399','253419','253424','255690','262486','262497','262498','262499','287234','287235','287236','287237','287238','287239','287469','287470','287471','287472','287473','287474','287475','287476','287477','287478','287479','287480','287481','287482','287483','287484','287485','287486','287487','287488','287489','287490','287491','287492','287493','288009','288284','294793','300472','300473','300474','300475','300479','300487','300488','300489','300622','300623','300624','141369','142055','142527','142711','142744','143057','143348','144295','146706','146968','146969','147862','150893','151193','151215','151634','152621','152649','153119','153120','153942','153948','154418','154594','155340','155437','157008','157009','157010','157011','157012','157013','157014','157015','157016','157017','157018','157019','157020','157021','158225','158226','158531','158563','158736','158764','158975','159216','159662','159735','159810','160009','160215','160720','161101','161200','161422','161532','161533','162218','162272','162415','162416','162426','162427','162621','162791','162792','163357','163671','163826','165380','165385','165458','165459','165749','166474','166526','166862','167305','167758','170181','170585','201193','201194','201196','215857','215910','215941','232718','238048','238221','238293','238769','238874','239164','239902','240084','240104','240105','240287','240403','240917','241081','241082','241083','241532','241763','242907','242924','242992','242993','242994','242995','243025','243078','243527','243781','244081','244243','244284','244680','245020','245159','245283','245294','245295','245527','246244','246905','246906','247109','247432','248498','248999','249072','249215','249229','249280','249445','249549','250673','251225','251230','251499','251550','251863','253234','253589','253794','254456','254763','254905','254999','255372','256545','256570','256713','261765','262483','262484','262485','262493','262494','262495','262496','263547','263716','263717','264383','265240','265771','266035','266158','267360','268145','269307','273904','274049','274050','275555','275605','275984','276152','277922','279212','279469','279565','279726','280431','280925','281243','283632','284409','284583','285303','285380','285693','285846','287390','287391','287392','287393','287394','287395','287396','287397','287398','287399','287400','287401','287402','287403','287439','287440','287441','287442','287443','287444','287445','287446','287447','287448','287449','287450','287451','287452','287453','287454','287455','287456','287457','287458','287459','287460','287461','287462','287463','287464','287465','287466','287467','287468','289019','291810','293521','295618','297640','297740','299896','300059','303891','303928','303929','142090','143223','150639','151704','153313','154264','155290','156633','159279','160019','161915','162413','162730','163289','163979','167113','167147','238558','240888','242450','245286','247010','247763','253397','253398','253586','256344','256537','256674','256675','262487','262488','262520','264352','264469','275013','276430','277196','280839','285516','285572','287418','287419','287420','287421','287422','287423','287424','287425','287426','287427','287428','287429','287430','287431','287432','287433','287434','287435','287436','287437','287438','288861','295390','295403','295404','298589','300439','300440','300441','300442','300443','300444','300445','300446','300447','300448','300449','300450','300451','300452','300453','300454','300455','300456','300457','300458','300459','300460','300461','300462','300463','300464','300465','300466','300467','300468','300469','300470','300471','300476','300477','300478','300480','300481','300482','300483','300484','300485','300486','301013','287240','287241','287242','287243','287494','287495','287496','287497','287498','287499','287500','287501','287502','287503','287246','287247','287248','287249','287250','287251','287252','287253','287254','287244','287245') 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 ('141369','141641','141687','141932','142055','142090','142527','142711','142744','142855','142856','143057','143223','143306','143348','144295','146706','146968','146969','147045','147862','148048','148747','148748','148749','148750','148751','148752','148753','148754','148755','148756','149908','150152','150153','150154','150155','150156','150157','150158','150639','150893','151193','151215','151237','151606','151634','151690','152621','152649','153119','153120','153214','153215','153274','153309','153313','153454','153455','153456','153459','153469','153504','153942','153948','154264','154418','154594','154863','154898','155063','155064','155121','155290','155340','155437','156633','156873','156874','156875','156876','156877','157008','157009','157010','157011','157012','157013','157014','157015','157016','157017','157018','157019','157020','157021','157700','157702','157736','157737','157751','157825','158146','158154','158216','158225','158226','158320','158322','158478','158531','158563','158736','158754','158755','158764','158969','158975','158998','159216','159279','159662','159735','159810','159967','159983','159985','160009','160019','160181','160215','160351','160720','160956','161101','161200','161216','161283','161315','161405','161406','161407','161408','161409','161410','161411','161412','161422','161463','161532','161533','161612','161915','162218','162269','162270','162271','162272','162350','162413','162415','162416','162426','162427','162619','162621','162622','162730','162791','162792','163289','163310','163357','163358','163359','163360','163568','163671','163672','163826','163979','164157','164549','164550','165161','165380','165385','165458','165459','165749','165767','165844','165845','165846','165847','166058','166474','166526','166672','166862','167113','167147','167153','167305','167586','167758','167800','168339','170034','170160','170179','170180','170181','170585','201193','201194','201196','202626','202873','202874','202875','202876','202877','202878','202879','202880','202881','202882','202883','202884','202885','202886','202887','202888','202889','202890','202891','202892','202893','202894','202895','202896','202897','202898','202899','202900','202901','202902','202903','202904','202905','202906','202907','202908','202909','202910','202911','202912','202913','202914','202915','202916','202917','202918','202919','202920','202921','202922','202923','202924','202925','202926','202927','202928','202929','202930','202931','202932','202933','202934','202935','202936','202937','202938','202939','202940','202941','202942','202943','202944','202945','202946','202947','202948','202949','202950','202951','202952','202953','202954','202955','202956','202957','202958','202959','202960','202961','202962','202963','202964','202965','202966','202967','202968','202969','202970','202971','202972','202973','202974','202975','202976','202977','202978','202979','202980','202981','202982','202983','202984','202985','202986','202987','202988','202989','202990','211959','211960','211961','211962','211963','211964','211965','211966','211967','211968','211969','211970','211971','211972','211973','215286','215688','215692','215857','215903','215910','215941','219772','232410','232718','238048','238221','238293','238431','238438','238443','238528','238558','238743','238744','238769','238874','239164','239902','239956','240084','240104','240105','240153','240287','240312','240403','240409','240707','240888','240917','241081','241082','241083','241326','241532','241621','241763','242211','242294','242450','242506','242671','242775','242777','242907','242924','242945','242992','242993','242994','242995','243025','243078','243181','243423','243527','243781','243939','243997','244081','244243','244284','244680','244941','244942','245020','245159','245283','245286','245294','245295','245527','245947','246244','246740','246866','246905','246906','247010','247109','247432','247665','247763','248498','248942','248975','249072','249142','249215','249229','249280','249298','249445','249549','249916','250673','251151','251225','251230','251399','251439','251499','251550','251863','253135','253234','253397','253398','253419','253424','253586','253589','253794','254207','254456','254763','254905','254999','255372','255665','255690','255711','256344','256537','256545','256570','256674','256675','256713','256801','256802','261765','262035','262483','262484','262485','262486','262487','262488','262489','262490','262491','262492','262493','262494','262495','262496','262497','262498','262499','262520','262639','263547','263716','263717','264352','264383','264445','264469','265240','265771','265917','266035','266158','267360','267907','267931','268145','268452','269307','273904','273932','274049','274050','274337','274338','275013','275454','275455','275456','275457','275459','275460','275461','275462','275463','275464','275465','275466','275467','275555','275605','275984','276152','276430','276573','277196','277347','277764','277906','277922','278331','279212','279469','279565','279726','280347','280377','280431','280438','280839','280850','280925','281153','281243','282375','282554','282556','283234','283426','283632','283682','283684','283686','283689','284409','284583','285154','285303','285380','285475','285516','285572','285693','285846','287221','287222','287234','287235','287236','287237','287238','287239','287240','287241','287242','287243','287244','287245','287246','287247','287248','287249','287250','287251','287252','287253','287254','287255','287256','287257','287258','287259','287260','287261','287262','287263','287264','287265','287266','287267','287268','287269','287270','287271','287272','287273','287274','287275','287276','287277','287278','287279','287280','287281','287282','287283','287284','287285','287286','287287','287288','287289','287290','287291','287292','287293','287294','287295','287296','287297','287298','287299','287300','287301','287302','287303','287304','287305','287306','287307','287308','287309','287310','287311','287312','287313','287314','287315','287316','287317','287318','287319','287320','287321','287322','287323','287324','287325','287326','287327','287328','287329','287330','287331','287332','287333','287334','287335','287336','287337','287338','287339','287340','287341','287342','287343','287344','287345','287346','287347','287348','287349','287350','287351','287352','287353','287354','287355','287356','287357','287358','287359','287360','287361','287362','287363','287364','287365','287366','287367','287368','287369','287370','287371','287372','287373','287374','287375','287376','287377','287378','287379','287380','287381','287382','287383','287390','287391','287392','287393','287394','287395','287396','287397','287398','287399','287400','287401','287402','287403','287404','287405','287406','287407','287408','287409','287410','287411','287412','287413','287414','287415','287416','287417','287418','287419','287420','287421','287422','287423','287424','287425','287426','287427','287428','287429','287430','287431','287432','287433','287434','287435','287436','287437','287438','287439','287440','287441','287442','287443','287444','287445','287446','287447','287448','287449','287450','287451','287452','287453','287454','287455','287456','287457','287458','287459','287460','287461','287462','287463','287464','287465','287466','287467','287468','287469','287470','287471','287472','287473','287474','287475','287476','287477','287478','287479','287480','287481','287482','287483','287484','287485','287486','287487','287488','287489','287490','287491','287492','287493','287494','287495','287496','287497','287498','287499','287500','287501','287502','287503','288009','288284','288861','289019','291810','291993','293521','294247','294793','295390','295395','295402','295403','295404','295618','297613','297614','297640','297740','297756','298311','298374','298375','298376','298397','298589','299564','299843','299896','300059','300184','300439','300440','300441','300442','300443','300444','300445','300446','300447','300448','300449','300450','300451','300452','300453','300454','300455','300456','300457','300458','300459','300460','300461','300462','300463','300464','300465','300466','300467','300468','300469','300470','300471','300472','300473','300474','300475','300476','300477','300478','300479','300480','300481','300482','300483','300484','300485','300486','300487','300488','300489','300490','300491','300492','300493','300622','300623','300624','301013','302348','303891','303928','303929') GROUP BY `manuf` ORDER BY `manuf` ASC