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 ('158338','158543','158562','158599','158833','158839','158872','159647','160267','160598','161036','161271','163215','163609','163610','163710','163837','164252','164657','164692','164755','164884','164885','165824','166569','167167','167767','167816','167875','168172','168321','232434','232473','232760','238090','238209','238247','240768','240807','240964','241030','242109','242363','242685','242873','242887','243058','243059','243060','243143','243147','243214','243405','244328','244403','244546','245008','245009','245218','246605','246606','246775','246809','247482','247889','247905','248432','248795','248874','249430','249489','249491','249660','250207','250208','250800','250857','250892','251071','251130','251339','251660','251958','253555','253873','254199','254200','254201','254221','255017','255615','256169','256170','256446','256588','256697','256945','261764','262010','262034','262185','262306','262536','263057','263497','263498','263499','264507','264906','265061','265248','265249','265254','265309','265803','266584','266775','266935','267245','267339','267606','267842','268057','268117','268690','268837','268895','269461','274372','275051','275106','275394','275427','276094','276374','276516','276517','276580','276683','276705','277032','277256','277473','277878','278414','278688','279196','279382','279571','279834','280984','281231','281902','282278','282694','284133','284643','284652','285084','285136','285158','285653','285896','286098','286182','286272','286443','287045','287063','287205','288089','288301','289489','292573','292811','293455','294244','294767','294780','294855','295600','296253','296277','297015','297210','297421','297424','297521','297708','298060','298067','298364','298471','298598','299668','299669','300527','300641','301814','302367','302368','302369','302370','302371','302372','302373','302374','302375','302376','302377','302378','302379','302380','302381','302382','302383','302384','302385','302386','302387','302388','302389','302390','302391','302392','302393','302394','302395','302396','302397','302398','302399','302400','302401','302402','302403','302404','302405','302406','302407','302408','302409','302410','302411','302412','302413','302414','302415','302416','302417','302418','302419','302420','302421','302422','302423','302424','302425','302426','302427','302428','302429','302430','302431','302432','302433','302434','302435','302436','302437','302438','302439','302440','302441','302442','302443','302444','302445','302446','302447','302448','302449','302450','302451','302452','302453','302454','302455','302456','302457','302458','302459','302460','302461','302462','302463','302464','302465','302466','302467','302468','302469','302470','302471','302472','302473','302474','302475','302476','302477','302478','302479','302480','302481','302482','302483','302484','302485','302486','302487','302488','302489','302490','302491','302492','302493','302494','302495','302496','302497','302498','302499','302500','302501','302502','302503','302504','302505','302506','302507','302508','302509','302510','302511','302512','302513','302514','302515','302516','302517','302518','302519','302520','302521','302522','302523','302524','302525','302526','302527','302528','302529','302530','302531','302532','302533','302534','302535','302536','302537','302538','302539','302540','302541','302542','302543','302544','302545','302546','302547','302548','302549','302550','302551','302552','302553','302554','302555','302556','302557','302558','302559','302560','302561','302562','302563','302564','302565','302566','302567','302568','302569','302570','302571','302572','302573','302574','302575','302576','302577','302578','302579','302580','302581','302582','302583','302584','302585','302586','302587','302588','302589','302590','302591','302592','302593','302594','302595','302596','302597','302598','302599','302600','302601','302602','302603','302604','302605','302606','302607','302608','302609','302610','302611','302612','302613','302614','302615','302616','302617','302618','302619','302620','302621','302622','302623','302624','302625','302626','302627','302628','302629','302630','302631','302632','302633','302634','302635','302636','302637','302638','302639','302640','302641','302642','302643','302644','302645','302646','302647','302648','302649','302650','302651','302652','302653','302654','302655','302656','302657','302658','302659','302660','302661','302662','302663','302664','302665','302666','302667','302668','302669','302670','302671','302672','302673','302674','302675','302676','302677','302678','302679','302680','302681','302682','302683','302684','302685','302686','302687','302688','302689','302690','302691','302692','302693','302694','302695','302696','302697','302698','302699','302700','302701','302702','302703','302704','302705','302706','302707','302708','302709','302710','302711','302712','302713','302714','302715','302716','302717','302718','302719','302720','302721','302722','302723','302724','302725','302726','302727','302728','302729','302730','302731','302732','302733','302734','302735','302736','302737','302738','302739','302740','302741','302742','302743','302744','302745','302746','302747','302748','302749','302750','302751','302752','302753','302754','302755','302756','302757','302758','302759','302760','302761','302762','302763','302764','302765','302766','302767','302768','302769','302770','302771','302772','302773','302774','302775','302776','302777','302778','302779','302780','302781','302782','302783','302784','302785','302786','302787','302788','302789','302790','302791','302792','302793','302794','302795','302796','302797','302798','302799','302800','302801','302802','302803','302804','302805','302806','302807','302808','302809','302810','302811','302812','302813','302814','302815','302816','302817','302818','302819','302820','302821','302822','302823','302824','302825','302826','302827','302828','302829','302830','302831','302832','302833','302834','302835','302836','302837','302838','302839','302840','302841','302842','302843','302844','302845','302846','302847','302848','302849','302850','302851','302852','302853','302854','302855','302856','302857','302858','302859','302860','302861','302862','302863','302864','302865','302866','302867','302868','302869','302870','302871','302872','302873','302874','302875','302876','302877','302878','302879','302880','302881','302882','302883','302884','302885','302886','302887','302888','302889','302890','302891','302892','302893','302894','302895','302896','302897','302898','302899','302900','302901','302902','302903','302904','302905','302906','302907','302908','302909','302910','302911','302912','302913','302914','302915','302916','302917','302918','302919','302920','302921','302922','302923','302924','302925','302926','302927','302928','302929','302930','302931','302932','302933','302934','302935','302936','302937','302938','302939','302940','302941','302942','302943','302944','302945','302946','302947','302948','302949','302950','302951','302952','302953','302954','302955','302956','302957','302958','302959','302960','302961','302962','302963','302964','302965','302966','302967','302968','302969','302970','302971','302972','302973','302974','302975','302976','302977','302978','302979','302980','302981','302982','302983','302984','302985','302986','302987','302988','302989','302990','302991','302992','302993','302994','302995','302996','302997','302998','302999','303000','303001','303002','303003','303004','303005','303006','303007','303008','303009','303010','303011','303012','303013','303014','303015','303016','303017','303018','303019','303020','303021','303022','303023','303024','303025','303026','303027','303028','303029','303030','303031','303032','303033','303034','303035','303036','303037','303038','303039','303040','303041','303042','303043','303044','303045','303046','303047','303048','303049','303050','303051','303052','303053','303054','303055','303056','303057','303058','303059','303060','303061','303062','303063','303064','303065','303066','303067','303068','303069','303070','303071','303072','303073','303074','303075','303076','303077','303078','303079','303080','303081','303082','303083','303084','303085','303086','303087','303088','303089','303090','303091','303092','303093','303094','303095','303096','303097','303098','303099','303100','303101','303102','303103','303104','303105','303106','303107','303108','303109','303110','303111','303112','303113','303114','303115','303116','303117','303118','303119','303120','303121','303122','303123','303124','303125','303126','303127','303128','303129','303130','303131','303132','303133','303134','303135','303136','303137','303138','303139','303140','303141','303142','303143','303144','303145','303146','303147','303148','303149','303150','303151','303152','303153','303154','303155','303156','303157','303158','303159','303160','303161','303162','303163','303164','303165','303166','303167','303168','303169','303170','303171','303172','303173','303174','303175','303176','303177','303178','303179','303180','303181','303182','303183','303184','303185','303186','303187','303188','303189','303190','303191','303192','303193','303194','303195','303196','303197','303198','303199','303200','303201','303202','303203','303204','303205','303206','303207','303208','303209','303210','303211','303212','303213','303214','303215','303216','303217','303218','303219','303220','303221','303222','303223','303224','303225','303226','303227','303228','303229','303230','303231','303232','303233','303234','303235','303236','303237','303238','303239','303240','303241','303242','303243','303244','303245','303246','303247','303248','303249','303250','303251','303252','303253','303254','303255','303256','303257','303258','303259','303260','303261','303262','303263','303264','303265','303266','303267','303268','303269','303270','303271','303272','303273','303274','303275','303276','303277','303278','303279','303280','303281','303282','303283','303284','303285','303286','303287','303288','303289','303290','303291','303292','303293','303294','303295','303296','303297','303298','303299','303300','303301','303302','303303','303304','303305','303306','303307','303308','303309','303310','303311','303312','303313','303314','303315','303316','303317','303318','303319','303320','303321','303322','303323','303324','303325','303326','303327','303328','303329','303330','303331','303332','303333','303334','303335','303336','303337','303338','303339','303340','303341','303342','303343','303344','303345','303346','303347','303348','303349','303350','303351','303352','303353','303354','303355','303356','303357','303358','303359','303360','303361','303362','303363','303364','303365','303366','303367','303368','303369','303370','303371','303372','303373','303374','303375','303376','303377','303378','303379','303380','303381','303382','303383','303384','303385','303386','303387','303388','303389','303390','303391','303392','303393','303394','303395','303396','303397','303398','303399','303400','303401','303402','303403','303404','303405','303406','303407','303408','303409','303410','303411','303412','303413','303414','303415','303416','303417','303418','303419','303420','303421','303422','303423','303424','303425','303426','303427','303428','303429','303430','303431','303432','303433','303434','303435','303436','303437','303438','303439','303440','303441','303442','303443','303444','303445','303446','303447','303448','303449','303450','303451','303452','303453','303454','303455','303456','303457','303458','303459','303460','303461','303462','303463','303464','303465','303466','303467','303468','303469','303470','303471','303472','303473','303474','303475','303476','303477','303478','303479','303480','303481','303482','303483','303484','303485','303486','303487','303488','303489','303490','303491','303492','303493','303494','303495','303496','303497','303498','303499','303500','303501','303502','303503','303504','303505','303506','303507','303508','303509','303510','303511','303512','303513','303514','303515','303516','303517','303518','303519','303520','303521','303522','303523','303524','303525','303526','303527','303528','303529','303530','303531','303532','303533','303534','303535','303536','303537','303538','303539','303540','303541','303542','303543','303544','303545','303546','303547','303548','303549','303550','303551','303552','303553','303554','303555','303556','303557','303558','303559','303560','303561','303562','303563','303564','303565','303566','303567','303568','303569','303570','303571','303572','303573','303574','303575','303576','303577','303578','303579','303580','303581','303582','303583','303584','303585','303586','303587','303588','303589','303590','303591','303592','303593','303594','303595','303596','303597','303598','303599','303600','303601','303602','303603','303604','303605','303606','303607','303608','303609','303610','303611','303612','303613','303614','303615','303616','303617','303618','303619','303620','303621','303622','303623','303624','303625','303626','303627','303628','303629','303630','303631','303632','303633','303634','303635','303636','303637','303638','303639','303640','303641','303642','303643','303644','303645','303646','303647','303648','303649','303650','303651','303652','303653','303654','303655','303656','303657','303658','303659','303660','303661','303662','303663','303664','303665','303666','303667','303668','303669','303670','303671','303672','303673','303674','303675','303676','303677','303678','303679','303680','303681','303682','303683','303684','303685','303686','303687','303688','303689','303690','303691','303692','303693','303694','303695','303696','303697','303698','303699','303700','303701','303702','303703','303704','303705','303706','303707','303708','303709','303710','303711','303712','303713','303714','303715','303716','303717','303718','303719','303720','303721','303722','303723','303724','303725','303726','303727','303728','303729','303730','303731','303732','303733','303734','303735','303736','303737','303738','303739','303740','303741','303742','303743','303744','303745','303746','303747','303748','303749','303750','303751','303752','303753','303754','303755','303756','303757','303758','303759','303760','303761','303762','303763','303764','303765','303766','303767','303768','303769','303770','303771','303772','303773','303774','303775','303776','303777','303778','303779','303780','303781','303782','303783','303784','303785','303786','303847','303887') 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 ('158338','158543','158562','158599','158833','158839','158872','159647','160267','160598','161036','161271','163215','163609','163610','163710','163837','164252','164657','164692','164755','164884','164885','165824','166569','167167','167767','167816','167875','168172','168321','232434','232473','232760','238090','238209','238247','240768','240807','240964','241030','242109','242363','242685','242873','242887','243058','243059','243060','243143','243147','243214','243405','244328','244403','244546','245008','245009','245218','246605','246606','246775','246809','247482','247889','247905','248432','248795','248874','249430','249489','249491','249660','250207','250208','250800','250857','250892','251071','251130','251339','251660','251958','253555','253873','254199','254200','254201','254221','255017','255615','256169','256170','256446','256588','256697','256945','261764','262010','262034','262185','262306','262536','263057','263497','263498','263499','264507','264906','265061','265248','265249','265254','265309','265803','266584','266775','266935','267245','267339','267606','267842','268057','268117','268690','268837','268895','269461','274372','275051','275106','275394','275427','276094','276374','276516','276517','276580','276683','276705','277032','277256','277473','277878','278414','278688','279196','279382','279571','279834','280984','281231','281902','282278','282694','284133','284643','284652','285084','285136','285158','285653','285896','286098','286182','286272','286443','287045','287063','287205','288089','288301','289489','292573','292811','293455','294244','294767','294780','294855','295600','296253','296277','297015','297210','297421','297424','297521','297708','298060','298067','298364','298471','298598','299668','299669','300527','300641','301814','302367','302368','302369','302370','302371','302372','302373','302374','302375','302376','302377','302378','302379','302380','302381','302382','302383','302384','302385','302386','302387','302388','302389','302390','302391','302392','302393','302394','302395','302396','302397','302398','302399','302400','302401','302402','302403','302404','302405','302406','302407','302408','302409','302410','302411','302412','302413','302414','302415','302416','302417','302418','302419','302420','302421','302422','302423','302424','302425','302426','302427','302428','302429','302430','302431','302432','302433','302434','302435','302436','302437','302438','302439','302440','302441','302442','302443','302444','302445','302446','302447','302448','302449','302450','302451','302452','302453','302454','302455','302456','302457','302458','302459','302460','302461','302462','302463','302464','302465','302466','302467','302468','302469','302470','302471','302472','302473','302474','302475','302476','302477','302478','302479','302480','302481','302482','302483','302484','302485','302486','302487','302488','302489','302490','302491','302492','302493','302494','302495','302496','302497','302498','302499','302500','302501','302502','302503','302504','302505','302506','302507','302508','302509','302510','302511','302512','302513','302514','302515','302516','302517','302518','302519','302520','302521','302522','302523','302524','302525','302526','302527','302528','302529','302530','302531','302532','302533','302534','302535','302536','302537','302538','302539','302540','302541','302542','302543','302544','302545','302546','302547','302548','302549','302550','302551','302552','302553','302554','302555','302556','302557','302558','302559','302560','302561','302562','302563','302564','302565','302566','302567','302568','302569','302570','302571','302572','302573','302574','302575','302576','302577','302578','302579','302580','302581','302582','302583','302584','302585','302586','302587','302588','302589','302590','302591','302592','302593','302594','302595','302596','302597','302598','302599','302600','302601','302602','302603','302604','302605','302606','302607','302608','302609','302610','302611','302612','302613','302614','302615','302616','302617','302618','302619','302620','302621','302622','302623','302624','302625','302626','302627','302628','302629','302630','302631','302632','302633','302634','302635','302636','302637','302638','302639','302640','302641','302642','302643','302644','302645','302646','302647','302648','302649','302650','302651','302652','302653','302654','302655','302656','302657','302658','302659','302660','302661','302662','302663','302664','302665','302666','302667','302668','302669','302670','302671','302672','302673','302674','302675','302676','302677','302678','302679','302680','302681','302682','302683','302684','302685','302686','302687','302688','302689','302690','302691','302692','302693','302694','302695','302696','302697','302698','302699','302700','302701','302702','302703','302704','302705','302706','302707','302708','302709','302710','302711','302712','302713','302714','302715','302716','302717','302718','302719','302720','302721','302722','302723','302724','302725','302726','302727','302728','302729','302730','302731','302732','302733','302734','302735','302736','302737','302738','302739','302740','302741','302742','302743','302744','302745','302746','302747','302748','302749','302750','302751','302752','302753','302754','302755','302756','302757','302758','302759','302760','302761','302762','302763','302764','302765','302766','302767','302768','302769','302770','302771','302772','302773','302774','302775','302776','302777','302778','302779','302780','302781','302782','302783','302784','302785','302786','302787','302788','302789','302790','302791','302792','302793','302794','302795','302796','302797','302798','302799','302800','302801','302802','302803','302804','302805','302806','302807','302808','302809','302810','302811','302812','302813','302814','302815','302816','302817','302818','302819','302820','302821','302822','302823','302824','302825','302826','302827','302828','302829','302830','302831','302832','302833','302834','302835','302836','302837','302838','302839','302840','302841','302842','302843','302844','302845','302846','302847','302848','302849','302850','302851','302852','302853','302854','302855','302856','302857','302858','302859','302860','302861','302862','302863','302864','302865','302866','302867','302868','302869','302870','302871','302872','302873','302874','302875','302876','302877','302878','302879','302880','302881','302882','302883','302884','302885','302886','302887','302888','302889','302890','302891','302892','302893','302894','302895','302896','302897','302898','302899','302900','302901','302902','302903','302904','302905','302906','302907','302908','302909','302910','302911','302912','302913','302914','302915','302916','302917','302918','302919','302920','302921','302922','302923','302924','302925','302926','302927','302928','302929','302930','302931','302932','302933','302934','302935','302936','302937','302938','302939','302940','302941','302942','302943','302944','302945','302946','302947','302948','302949','302950','302951','302952','302953','302954','302955','302956','302957','302958','302959','302960','302961','302962','302963','302964','302965','302966','302967','302968','302969','302970','302971','302972','302973','302974','302975','302976','302977','302978','302979','302980','302981','302982','302983','302984','302985','302986','302987','302988','302989','302990','302991','302992','302993','302994','302995','302996','302997','302998','302999','303000','303001','303002','303003','303004','303005','303006','303007','303008','303009','303010','303011','303012','303013','303014','303015','303016','303017','303018','303019','303020','303021','303022','303023','303024','303025','303026','303027','303028','303029','303030','303031','303032','303033','303034','303035','303036','303037','303038','303039','303040','303041','303042','303043','303044','303045','303046','303047','303048','303049','303050','303051','303052','303053','303054','303055','303056','303057','303058','303059','303060','303061','303062','303063','303064','303065','303066','303067','303068','303069','303070','303071','303072','303073','303074','303075','303076','303077','303078','303079','303080','303081','303082','303083','303084','303085','303086','303087','303088','303089','303090','303091','303092','303093','303094','303095','303096','303097','303098','303099','303100','303101','303102','303103','303104','303105','303106','303107','303108','303109','303110','303111','303112','303113','303114','303115','303116','303117','303118','303119','303120','303121','303122','303123','303124','303125','303126','303127','303128','303129','303130','303131','303132','303133','303134','303135','303136','303137','303138','303139','303140','303141','303142','303143','303144','303145','303146','303147','303148','303149','303150','303151','303152','303153','303154','303155','303156','303157','303158','303159','303160','303161','303162','303163','303164','303165','303166','303167','303168','303169','303170','303171','303172','303173','303174','303175','303176','303177','303178','303179','303180','303181','303182','303183','303184','303185','303186','303187','303188','303189','303190','303191','303192','303193','303194','303195','303196','303197','303198','303199','303200','303201','303202','303203','303204','303205','303206','303207','303208','303209','303210','303211','303212','303213','303214','303215','303216','303217','303218','303219','303220','303221','303222','303223','303224','303225','303226','303227','303228','303229','303230','303231','303232','303233','303234','303235','303236','303237','303238','303239','303240','303241','303242','303243','303244','303245','303246','303247','303248','303249','303250','303251','303252','303253','303254','303255','303256','303257','303258','303259','303260','303261','303262','303263','303264','303265','303266','303267','303268','303269','303270','303271','303272','303273','303274','303275','303276','303277','303278','303279','303280','303281','303282','303283','303284','303285','303286','303287','303288','303289','303290','303291','303292','303293','303294','303295','303296','303297','303298','303299','303300','303301','303302','303303','303304','303305','303306','303307','303308','303309','303310','303311','303312','303313','303314','303315','303316','303317','303318','303319','303320','303321','303322','303323','303324','303325','303326','303327','303328','303329','303330','303331','303332','303333','303334','303335','303336','303337','303338','303339','303340','303341','303342','303343','303344','303345','303346','303347','303348','303349','303350','303351','303352','303353','303354','303355','303356','303357','303358','303359','303360','303361','303362','303363','303364','303365','303366','303367','303368','303369','303370','303371','303372','303373','303374','303375','303376','303377','303378','303379','303380','303381','303382','303383','303384','303385','303386','303387','303388','303389','303390','303391','303392','303393','303394','303395','303396','303397','303398','303399','303400','303401','303402','303403','303404','303405','303406','303407','303408','303409','303410','303411','303412','303413','303414','303415','303416','303417','303418','303419','303420','303421','303422','303423','303424','303425','303426','303427','303428','303429','303430','303431','303432','303433','303434','303435','303436','303437','303438','303439','303440','303441','303442','303443','303444','303445','303446','303447','303448','303449','303450','303451','303452','303453','303454','303455','303456','303457','303458','303459','303460','303461','303462','303463','303464','303465','303466','303467','303468','303469','303470','303471','303472','303473','303474','303475','303476','303477','303478','303479','303480','303481','303482','303483','303484','303485','303486','303487','303488','303489','303490','303491','303492','303493','303494','303495','303496','303497','303498','303499','303500','303501','303502','303503','303504','303505','303506','303507','303508','303509','303510','303511','303512','303513','303514','303515','303516','303517','303518','303519','303520','303521','303522','303523','303524','303525','303526','303527','303528','303529','303530','303531','303532','303533','303534','303535','303536','303537','303538','303539','303540','303541','303542','303543','303544','303545','303546','303547','303548','303549','303550','303551','303552','303553','303554','303555','303556','303557','303558','303559','303560','303561','303562','303563','303564','303565','303566','303567','303568','303569','303570','303571','303572','303573','303574','303575','303576','303577','303578','303579','303580','303581','303582','303583','303584','303585','303586','303587','303588','303589','303590','303591','303592','303593','303594','303595','303596','303597','303598','303599','303600','303601','303602','303603','303604','303605','303606','303607','303608','303609','303610','303611','303612','303613','303614','303615','303616','303617','303618','303619','303620','303621','303622','303623','303624','303625','303626','303627','303628','303629','303630','303631','303632','303633','303634','303635','303636','303637','303638','303639','303640','303641','303642','303643','303644','303645','303646','303647','303648','303649','303650','303651','303652','303653','303654','303655','303656','303657','303658','303659','303660','303661','303662','303663','303664','303665','303666','303667','303668','303669','303670','303671','303672','303673','303674','303675','303676','303677','303678','303679','303680','303681','303682','303683','303684','303685','303686','303687','303688','303689','303690','303691','303692','303693','303694','303695','303696','303697','303698','303699','303700','303701','303702','303703','303704','303705','303706','303707','303708','303709','303710','303711','303712','303713','303714','303715','303716','303717','303718','303719','303720','303721','303722','303723','303724','303725','303726','303727','303728','303729','303730','303731','303732','303733','303734','303735','303736','303737','303738','303739','303740','303741','303742','303743','303744','303745','303746','303747','303748','303749','303750','303751','303752','303753','303754','303755','303756','303757','303758','303759','303760','303761','303762','303763','303764','303765','303766','303767','303768','303769','303770','303771','303772','303773','303774','303775','303776','303777','303778','303779','303780','303781','303782','303783','303784','303785','303786','303847','303887') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: voltage
SELECT `voltage`,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 `voltage` !='' AND `modx_site_content`.`id` IN ('158338','158543','158562','158599','158833','158839','158872','159647','160267','160598','161036','161271','163215','163609','163610','163710','163837','164252','164657','164692','164755','164884','164885','165824','166569','167167','167767','167816','167875','168172','168321','232434','232473','232760','238090','238209','238247','240768','240807','240964','241030','242109','242363','242685','242873','242887','243058','243059','243060','243143','243147','243214','243405','244328','244403','244546','245008','245009','245218','246605','246606','246775','246809','247482','247889','247905','248432','248795','248874','249430','249489','249491','249660','250207','250208','250800','250857','250892','251071','251130','251339','251660','251958','253555','253873','254199','254200','254201','254221','255017','255615','256169','256170','256446','256588','256697','256945','261764','262010','262034','262185','262306','262536','263057','263497','263498','263499','264507','264906','265061','265248','265249','265254','265309','265803','266584','266775','266935','267245','267339','267606','267842','268057','268117','268690','268837','268895','269461','274372','275051','275106','275394','275427','276094','276374','276516','276517','276580','276683','276705','277032','277256','277473','277878','278414','278688','279196','279382','279571','279834','280984','281231','281902','282278','282694','284133','284643','284652','285084','285136','285158','285653','285896','286098','286182','286272','286443','287045','287063','287205','288089','288301','289489','292573','292811','293455','294244','294767','294780','294855','295600','296253','296277','297015','297210','297421','297424','297521','297708','298060','298067','298364','298471','298598','299668','299669','300527','300641','301814','302367','302368','302369','302370','302371','302372','302373','302374','302375','302376','302377','302378','302379','302380','302381','302382','302383','302384','302385','302386','302387','302388','302389','302390','302391','302392','302393','302394','302395','302396','302397','302398','302399','302400','302401','302402','302403','302404','302405','302406','302407','302408','302409','302410','302411','302412','302413','302414','302415','302416','302417','302418','302419','302420','302421','302422','302423','302424','302425','302426','302427','302428','302429','302430','302431','302432','302433','302434','302435','302436','302437','302438','302439','302440','302441','302442','302443','302444','302445','302446','302447','302448','302449','302450','302451','302452','302453','302454','302455','302456','302457','302458','302459','302460','302461','302462','302463','302464','302465','302466','302467','302468','302469','302470','302471','302472','302473','302474','302475','302476','302477','302478','302479','302480','302481','302482','302483','302484','302485','302486','302487','302488','302489','302490','302491','302492','302493','302494','302495','302496','302497','302498','302499','302500','302501','302502','302503','302504','302505','302506','302507','302508','302509','302510','302511','302512','302513','302514','302515','302516','302517','302518','302519','302520','302521','302522','302523','302524','302525','302526','302527','302528','302529','302530','302531','302532','302533','302534','302535','302536','302537','302538','302539','302540','302541','302542','302543','302544','302545','302546','302547','302548','302549','302550','302551','302552','302553','302554','302555','302556','302557','302558','302559','302560','302561','302562','302563','302564','302565','302566','302567','302568','302569','302570','302571','302572','302573','302574','302575','302576','302577','302578','302579','302580','302581','302582','302583','302584','302585','302586','302587','302588','302589','302590','302591','302592','302593','302594','302595','302596','302597','302598','302599','302600','302601','302602','302603','302604','302605','302606','302607','302608','302609','302610','302611','302612','302613','302614','302615','302616','302617','302618','302619','302620','302621','302622','302623','302624','302625','302626','302627','302628','302629','302630','302631','302632','302633','302634','302635','302636','302637','302638','302639','302640','302641','302642','302643','302644','302645','302646','302647','302648','302649','302650','302651','302652','302653','302654','302655','302656','302657','302658','302659','302660','302661','302662','302663','302664','302665','302666','302667','302668','302669','302670','302671','302672','302673','302674','302675','302676','302677','302678','302679','302680','302681','302682','302683','302684','302685','302686','302687','302688','302689','302690','302691','302692','302693','302694','302695','302696','302697','302698','302699','302700','302701','302702','302703','302704','302705','302706','302707','302708','302709','302710','302711','302712','302713','302714','302715','302716','302717','302718','302719','302720','302721','302722','302723','302724','302725','302726','302727','302728','302729','302730','302731','302732','302733','302734','302735','302736','302737','302738','302739','302740','302741','302742','302743','302744','302745','302746','302747','302748','302749','302750','302751','302752','302753','302754','302755','302756','302757','302758','302759','302760','302761','302762','302763','302764','302765','302766','302767','302768','302769','302770','302771','302772','302773','302774','302775','302776','302777','302778','302779','302780','302781','302782','302783','302784','302785','302786','302787','302788','302789','302790','302791','302792','302793','302794','302795','302796','302797','302798','302799','302800','302801','302802','302803','302804','302805','302806','302807','302808','302809','302810','302811','302812','302813','302814','302815','302816','302817','302818','302819','302820','302821','302822','302823','302824','302825','302826','302827','302828','302829','302830','302831','302832','302833','302834','302835','302836','302837','302838','302839','302840','302841','302842','302843','302844','302845','302846','302847','302848','302849','302850','302851','302852','302853','302854','302855','302856','302857','302858','302859','302860','302861','302862','302863','302864','302865','302866','302867','302868','302869','302870','302871','302872','302873','302874','302875','302876','302877','302878','302879','302880','302881','302882','302883','302884','302885','302886','302887','302888','302889','302890','302891','302892','302893','302894','302895','302896','302897','302898','302899','302900','302901','302902','302903','302904','302905','302906','302907','302908','302909','302910','302911','302912','302913','302914','302915','302916','302917','302918','302919','302920','302921','302922','302923','302924','302925','302926','302927','302928','302929','302930','302931','302932','302933','302934','302935','302936','302937','302938','302939','302940','302941','302942','302943','302944','302945','302946','302947','302948','302949','302950','302951','302952','302953','302954','302955','302956','302957','302958','302959','302960','302961','302962','302963','302964','302965','302966','302967','302968','302969','302970','302971','302972','302973','302974','302975','302976','302977','302978','302979','302980','302981','302982','302983','302984','302985','302986','302987','302988','302989','302990','302991','302992','302993','302994','302995','302996','302997','302998','302999','303000','303001','303002','303003','303004','303005','303006','303007','303008','303009','303010','303011','303012','303013','303014','303015','303016','303017','303018','303019','303020','303021','303022','303023','303024','303025','303026','303027','303028','303029','303030','303031','303032','303033','303034','303035','303036','303037','303038','303039','303040','303041','303042','303043','303044','303045','303046','303047','303048','303049','303050','303051','303052','303053','303054','303055','303056','303057','303058','303059','303060','303061','303062','303063','303064','303065','303066','303067','303068','303069','303070','303071','303072','303073','303074','303075','303076','303077','303078','303079','303080','303081','303082','303083','303084','303085','303086','303087','303088','303089','303090','303091','303092','303093','303094','303095','303096','303097','303098','303099','303100','303101','303102','303103','303104','303105','303106','303107','303108','303109','303110','303111','303112','303113','303114','303115','303116','303117','303118','303119','303120','303121','303122','303123','303124','303125','303126','303127','303128','303129','303130','303131','303132','303133','303134','303135','303136','303137','303138','303139','303140','303141','303142','303143','303144','303145','303146','303147','303148','303149','303150','303151','303152','303153','303154','303155','303156','303157','303158','303159','303160','303161','303162','303163','303164','303165','303166','303167','303168','303169','303170','303171','303172','303173','303174','303175','303176','303177','303178','303179','303180','303181','303182','303183','303184','303185','303186','303187','303188','303189','303190','303191','303192','303193','303194','303195','303196','303197','303198','303199','303200','303201','303202','303203','303204','303205','303206','303207','303208','303209','303210','303211','303212','303213','303214','303215','303216','303217','303218','303219','303220','303221','303222','303223','303224','303225','303226','303227','303228','303229','303230','303231','303232','303233','303234','303235','303236','303237','303238','303239','303240','303241','303242','303243','303244','303245','303246','303247','303248','303249','303250','303251','303252','303253','303254','303255','303256','303257','303258','303259','303260','303261','303262','303263','303264','303265','303266','303267','303268','303269','303270','303271','303272','303273','303274','303275','303276','303277','303278','303279','303280','303281','303282','303283','303284','303285','303286','303287','303288','303289','303290','303291','303292','303293','303294','303295','303296','303297','303298','303299','303300','303301','303302','303303','303304','303305','303306','303307','303308','303309','303310','303311','303312','303313','303314','303315','303316','303317','303318','303319','303320','303321','303322','303323','303324','303325','303326','303327','303328','303329','303330','303331','303332','303333','303334','303335','303336','303337','303338','303339','303340','303341','303342','303343','303344','303345','303346','303347','303348','303349','303350','303351','303352','303353','303354','303355','303356','303357','303358','303359','303360','303361','303362','303363','303364','303365','303366','303367','303368','303369','303370','303371','303372','303373','303374','303375','303376','303377','303378','303379','303380','303381','303382','303383','303384','303385','303386','303387','303388','303389','303390','303391','303392','303393','303394','303395','303396','303397','303398','303399','303400','303401','303402','303403','303404','303405','303406','303407','303408','303409','303410','303411','303412','303413','303414','303415','303416','303417','303418','303419','303420','303421','303422','303423','303424','303425','303426','303427','303428','303429','303430','303431','303432','303433','303434','303435','303436','303437','303438','303439','303440','303441','303442','303443','303444','303445','303446','303447','303448','303449','303450','303451','303452','303453','303454','303455','303456','303457','303458','303459','303460','303461','303462','303463','303464','303465','303466','303467','303468','303469','303470','303471','303472','303473','303474','303475','303476','303477','303478','303479','303480','303481','303482','303483','303484','303485','303486','303487','303488','303489','303490','303491','303492','303493','303494','303495','303496','303497','303498','303499','303500','303501','303502','303503','303504','303505','303506','303507','303508','303509','303510','303511','303512','303513','303514','303515','303516','303517','303518','303519','303520','303521','303522','303523','303524','303525','303526','303527','303528','303529','303530','303531','303532','303533','303534','303535','303536','303537','303538','303539','303540','303541','303542','303543','303544','303545','303546','303547','303548','303549','303550','303551','303552','303553','303554','303555','303556','303557','303558','303559','303560','303561','303562','303563','303564','303565','303566','303567','303568','303569','303570','303571','303572','303573','303574','303575','303576','303577','303578','303579','303580','303581','303582','303583','303584','303585','303586','303587','303588','303589','303590','303591','303592','303593','303594','303595','303596','303597','303598','303599','303600','303601','303602','303603','303604','303605','303606','303607','303608','303609','303610','303611','303612','303613','303614','303615','303616','303617','303618','303619','303620','303621','303622','303623','303624','303625','303626','303627','303628','303629','303630','303631','303632','303633','303634','303635','303636','303637','303638','303639','303640','303641','303642','303643','303644','303645','303646','303647','303648','303649','303650','303651','303652','303653','303654','303655','303656','303657','303658','303659','303660','303661','303662','303663','303664','303665','303666','303667','303668','303669','303670','303671','303672','303673','303674','303675','303676','303677','303678','303679','303680','303681','303682','303683','303684','303685','303686','303687','303688','303689','303690','303691','303692','303693','303694','303695','303696','303697','303698','303699','303700','303701','303702','303703','303704','303705','303706','303707','303708','303709','303710','303711','303712','303713','303714','303715','303716','303717','303718','303719','303720','303721','303722','303723','303724','303725','303726','303727','303728','303729','303730','303731','303732','303733','303734','303735','303736','303737','303738','303739','303740','303741','303742','303743','303744','303745','303746','303747','303748','303749','303750','303751','303752','303753','303754','303755','303756','303757','303758','303759','303760','303761','303762','303763','303764','303765','303766','303767','303768','303769','303770','303771','303772','303773','303774','303775','303776','303777','303778','303779','303780','303781','303782','303783','303784','303785','303786','303847','303887') GROUP BY `voltage` ORDER BY `voltage` ASC
childsstroke1: voltage
SELECT `voltage`,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 `voltage` !='' AND `modx_site_content`.`id` IN ('158338','158543','158562','158599','158833','158839','158872','159647','160267','160598','161036','161271','163215','163609','163610','163710','163837','164252','164657','164692','164755','164884','164885','165824','166569','167167','167767','167816','167875','168172','168321','232434','232473','232760','238090','238209','238247','240768','240807','240964','241030','242109','242363','242685','242873','242887','243058','243059','243060','243143','243147','243214','243405','244328','244403','244546','245008','245009','245218','246605','246606','246775','246809','247482','247889','247905','248432','248795','248874','249430','249489','249491','249660','250207','250208','250800','250857','250892','251071','251130','251339','251660','251958','253555','253873','254199','254200','254201','254221','255017','255615','256169','256170','256446','256588','256697','256945','261764','262010','262034','262185','262306','262536','263057','263497','263498','263499','264507','264906','265061','265248','265249','265254','265309','265803','266584','266775','266935','267245','267339','267606','267842','268057','268117','268690','268837','268895','269461','274372','275051','275106','275394','275427','276094','276374','276516','276517','276580','276683','276705','277032','277256','277473','277878','278414','278688','279196','279382','279571','279834','280984','281231','281902','282278','282694','284133','284643','284652','285084','285136','285158','285653','285896','286098','286182','286272','286443','287045','287063','287205','288089','288301','289489','292573','292811','293455','294244','294767','294780','294855','295600','296253','296277','297015','297210','297421','297424','297521','297708','298060','298067','298364','298471','298598','299668','299669','300527','300641','301814','302367','302368','302369','302370','302371','302372','302373','302374','302375','302376','302377','302378','302379','302380','302381','302382','302383','302384','302385','302386','302387','302388','302389','302390','302391','302392','302393','302394','302395','302396','302397','302398','302399','302400','302401','302402','302403','302404','302405','302406','302407','302408','302409','302410','302411','302412','302413','302414','302415','302416','302417','302418','302419','302420','302421','302422','302423','302424','302425','302426','302427','302428','302429','302430','302431','302432','302433','302434','302435','302436','302437','302438','302439','302440','302441','302442','302443','302444','302445','302446','302447','302448','302449','302450','302451','302452','302453','302454','302455','302456','302457','302458','302459','302460','302461','302462','302463','302464','302465','302466','302467','302468','302469','302470','302471','302472','302473','302474','302475','302476','302477','302478','302479','302480','302481','302482','302483','302484','302485','302486','302487','302488','302489','302490','302491','302492','302493','302494','302495','302496','302497','302498','302499','302500','302501','302502','302503','302504','302505','302506','302507','302508','302509','302510','302511','302512','302513','302514','302515','302516','302517','302518','302519','302520','302521','302522','302523','302524','302525','302526','302527','302528','302529','302530','302531','302532','302533','302534','302535','302536','302537','302538','302539','302540','302541','302542','302543','302544','302545','302546','302547','302548','302549','302550','302551','302552','302553','302554','302555','302556','302557','302558','302559','302560','302561','302562','302563','302564','302565','302566','302567','302568','302569','302570','302571','302572','302573','302574','302575','302576','302577','302578','302579','302580','302581','302582','302583','302584','302585','302586','302587','302588','302589','302590','302591','302592','302593','302594','302595','302596','302597','302598','302599','302600','302601','302602','302603','302604','302605','302606','302607','302608','302609','302610','302611','302612','302613','302614','302615','302616','302617','302618','302619','302620','302621','302622','302623','302624','302625','302626','302627','302628','302629','302630','302631','302632','302633','302634','302635','302636','302637','302638','302639','302640','302641','302642','302643','302644','302645','302646','302647','302648','302649','302650','302651','302652','302653','302654','302655','302656','302657','302658','302659','302660','302661','302662','302663','302664','302665','302666','302667','302668','302669','302670','302671','302672','302673','302674','302675','302676','302677','302678','302679','302680','302681','302682','302683','302684','302685','302686','302687','302688','302689','302690','302691','302692','302693','302694','302695','302696','302697','302698','302699','302700','302701','302702','302703','302704','302705','302706','302707','302708','302709','302710','302711','302712','302713','302714','302715','302716','302717','302718','302719','302720','302721','302722','302723','302724','302725','302726','302727','302728','302729','302730','302731','302732','302733','302734','302735','302736','302737','302738','302739','302740','302741','302742','302743','302744','302745','302746','302747','302748','302749','302750','302751','302752','302753','302754','302755','302756','302757','302758','302759','302760','302761','302762','302763','302764','302765','302766','302767','302768','302769','302770','302771','302772','302773','302774','302775','302776','302777','302778','302779','302780','302781','302782','302783','302784','302785','302786','302787','302788','302789','302790','302791','302792','302793','302794','302795','302796','302797','302798','302799','302800','302801','302802','302803','302804','302805','302806','302807','302808','302809','302810','302811','302812','302813','302814','302815','302816','302817','302818','302819','302820','302821','302822','302823','302824','302825','302826','302827','302828','302829','302830','302831','302832','302833','302834','302835','302836','302837','302838','302839','302840','302841','302842','302843','302844','302845','302846','302847','302848','302849','302850','302851','302852','302853','302854','302855','302856','302857','302858','302859','302860','302861','302862','302863','302864','302865','302866','302867','302868','302869','302870','302871','302872','302873','302874','302875','302876','302877','302878','302879','302880','302881','302882','302883','302884','302885','302886','302887','302888','302889','302890','302891','302892','302893','302894','302895','302896','302897','302898','302899','302900','302901','302902','302903','302904','302905','302906','302907','302908','302909','302910','302911','302912','302913','302914','302915','302916','302917','302918','302919','302920','302921','302922','302923','302924','302925','302926','302927','302928','302929','302930','302931','302932','302933','302934','302935','302936','302937','302938','302939','302940','302941','302942','302943','302944','302945','302946','302947','302948','302949','302950','302951','302952','302953','302954','302955','302956','302957','302958','302959','302960','302961','302962','302963','302964','302965','302966','302967','302968','302969','302970','302971','302972','302973','302974','302975','302976','302977','302978','302979','302980','302981','302982','302983','302984','302985','302986','302987','302988','302989','302990','302991','302992','302993','302994','302995','302996','302997','302998','302999','303000','303001','303002','303003','303004','303005','303006','303007','303008','303009','303010','303011','303012','303013','303014','303015','303016','303017','303018','303019','303020','303021','303022','303023','303024','303025','303026','303027','303028','303029','303030','303031','303032','303033','303034','303035','303036','303037','303038','303039','303040','303041','303042','303043','303044','303045','303046','303047','303048','303049','303050','303051','303052','303053','303054','303055','303056','303057','303058','303059','303060','303061','303062','303063','303064','303065','303066','303067','303068','303069','303070','303071','303072','303073','303074','303075','303076','303077','303078','303079','303080','303081','303082','303083','303084','303085','303086','303087','303088','303089','303090','303091','303092','303093','303094','303095','303096','303097','303098','303099','303100','303101','303102','303103','303104','303105','303106','303107','303108','303109','303110','303111','303112','303113','303114','303115','303116','303117','303118','303119','303120','303121','303122','303123','303124','303125','303126','303127','303128','303129','303130','303131','303132','303133','303134','303135','303136','303137','303138','303139','303140','303141','303142','303143','303144','303145','303146','303147','303148','303149','303150','303151','303152','303153','303154','303155','303156','303157','303158','303159','303160','303161','303162','303163','303164','303165','303166','303167','303168','303169','303170','303171','303172','303173','303174','303175','303176','303177','303178','303179','303180','303181','303182','303183','303184','303185','303186','303187','303188','303189','303190','303191','303192','303193','303194','303195','303196','303197','303198','303199','303200','303201','303202','303203','303204','303205','303206','303207','303208','303209','303210','303211','303212','303213','303214','303215','303216','303217','303218','303219','303220','303221','303222','303223','303224','303225','303226','303227','303228','303229','303230','303231','303232','303233','303234','303235','303236','303237','303238','303239','303240','303241','303242','303243','303244','303245','303246','303247','303248','303249','303250','303251','303252','303253','303254','303255','303256','303257','303258','303259','303260','303261','303262','303263','303264','303265','303266','303267','303268','303269','303270','303271','303272','303273','303274','303275','303276','303277','303278','303279','303280','303281','303282','303283','303284','303285','303286','303287','303288','303289','303290','303291','303292','303293','303294','303295','303296','303297','303298','303299','303300','303301','303302','303303','303304','303305','303306','303307','303308','303309','303310','303311','303312','303313','303314','303315','303316','303317','303318','303319','303320','303321','303322','303323','303324','303325','303326','303327','303328','303329','303330','303331','303332','303333','303334','303335','303336','303337','303338','303339','303340','303341','303342','303343','303344','303345','303346','303347','303348','303349','303350','303351','303352','303353','303354','303355','303356','303357','303358','303359','303360','303361','303362','303363','303364','303365','303366','303367','303368','303369','303370','303371','303372','303373','303374','303375','303376','303377','303378','303379','303380','303381','303382','303383','303384','303385','303386','303387','303388','303389','303390','303391','303392','303393','303394','303395','303396','303397','303398','303399','303400','303401','303402','303403','303404','303405','303406','303407','303408','303409','303410','303411','303412','303413','303414','303415','303416','303417','303418','303419','303420','303421','303422','303423','303424','303425','303426','303427','303428','303429','303430','303431','303432','303433','303434','303435','303436','303437','303438','303439','303440','303441','303442','303443','303444','303445','303446','303447','303448','303449','303450','303451','303452','303453','303454','303455','303456','303457','303458','303459','303460','303461','303462','303463','303464','303465','303466','303467','303468','303469','303470','303471','303472','303473','303474','303475','303476','303477','303478','303479','303480','303481','303482','303483','303484','303485','303486','303487','303488','303489','303490','303491','303492','303493','303494','303495','303496','303497','303498','303499','303500','303501','303502','303503','303504','303505','303506','303507','303508','303509','303510','303511','303512','303513','303514','303515','303516','303517','303518','303519','303520','303521','303522','303523','303524','303525','303526','303527','303528','303529','303530','303531','303532','303533','303534','303535','303536','303537','303538','303539','303540','303541','303542','303543','303544','303545','303546','303547','303548','303549','303550','303551','303552','303553','303554','303555','303556','303557','303558','303559','303560','303561','303562','303563','303564','303565','303566','303567','303568','303569','303570','303571','303572','303573','303574','303575','303576','303577','303578','303579','303580','303581','303582','303583','303584','303585','303586','303587','303588','303589','303590','303591','303592','303593','303594','303595','303596','303597','303598','303599','303600','303601','303602','303603','303604','303605','303606','303607','303608','303609','303610','303611','303612','303613','303614','303615','303616','303617','303618','303619','303620','303621','303622','303623','303624','303625','303626','303627','303628','303629','303630','303631','303632','303633','303634','303635','303636','303637','303638','303639','303640','303641','303642','303643','303644','303645','303646','303647','303648','303649','303650','303651','303652','303653','303654','303655','303656','303657','303658','303659','303660','303661','303662','303663','303664','303665','303666','303667','303668','303669','303670','303671','303672','303673','303674','303675','303676','303677','303678','303679','303680','303681','303682','303683','303684','303685','303686','303687','303688','303689','303690','303691','303692','303693','303694','303695','303696','303697','303698','303699','303700','303701','303702','303703','303704','303705','303706','303707','303708','303709','303710','303711','303712','303713','303714','303715','303716','303717','303718','303719','303720','303721','303722','303723','303724','303725','303726','303727','303728','303729','303730','303731','303732','303733','303734','303735','303736','303737','303738','303739','303740','303741','303742','303743','303744','303745','303746','303747','303748','303749','303750','303751','303752','303753','303754','303755','303756','303757','303758','303759','303760','303761','303762','303763','303764','303765','303766','303767','303768','303769','303770','303771','303772','303773','303774','303775','303776','303777','303778','303779','303780','303781','303782','303783','303784','303785','303786','303847','303887') GROUP BY `voltage` ORDER BY `voltage` ASC
childsstroke: typesize
SELECT `typesize`,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 `typesize` !='' AND `modx_site_content`.`id` IN ('158338','158543','158562','158599','158833','158839','158872','159647','160267','160598','161036','161271','163215','163609','163610','163710','163837','164252','164657','164692','164755','164884','164885','165824','166569','167167','167767','167816','167875','168172','168321','232434','232473','232760','238090','238209','238247','240768','240807','240964','241030','242109','242363','242685','242873','242887','243058','243059','243060','243143','243147','243214','243405','244328','244403','244546','245008','245009','245218','246605','246606','246775','246809','247482','247889','247905','248432','248795','248874','249430','249489','249491','249660','250207','250208','250800','250857','250892','251071','251130','251339','251660','251958','253555','253873','254199','254200','254201','254221','255017','255615','256169','256170','256446','256588','256697','256945','261764','262010','262034','262185','262306','262536','263057','263497','263498','263499','264507','264906','265061','265248','265249','265254','265309','265803','266584','266775','266935','267245','267339','267606','267842','268057','268117','268690','268837','268895','269461','274372','275051','275106','275394','275427','276094','276374','276516','276517','276580','276683','276705','277032','277256','277473','277878','278414','278688','279196','279382','279571','279834','280984','281231','281902','282278','282694','284133','284643','284652','285084','285136','285158','285653','285896','286098','286182','286272','286443','287045','287063','287205','288089','288301','289489','292573','292811','293455','294244','294767','294780','294855','295600','296253','296277','297015','297210','297421','297424','297521','297708','298060','298067','298364','298471','298598','299668','299669','300527','300641','301814','302367','302368','302369','302370','302371','302372','302373','302374','302375','302376','302377','302378','302379','302380','302381','302382','302383','302384','302385','302386','302387','302388','302389','302390','302391','302392','302393','302394','302395','302396','302397','302398','302399','302400','302401','302402','302403','302404','302405','302406','302407','302408','302409','302410','302411','302412','302413','302414','302415','302416','302417','302418','302419','302420','302421','302422','302423','302424','302425','302426','302427','302428','302429','302430','302431','302432','302433','302434','302435','302436','302437','302438','302439','302440','302441','302442','302443','302444','302445','302446','302447','302448','302449','302450','302451','302452','302453','302454','302455','302456','302457','302458','302459','302460','302461','302462','302463','302464','302465','302466','302467','302468','302469','302470','302471','302472','302473','302474','302475','302476','302477','302478','302479','302480','302481','302482','302483','302484','302485','302486','302487','302488','302489','302490','302491','302492','302493','302494','302495','302496','302497','302498','302499','302500','302501','302502','302503','302504','302505','302506','302507','302508','302509','302510','302511','302512','302513','302514','302515','302516','302517','302518','302519','302520','302521','302522','302523','302524','302525','302526','302527','302528','302529','302530','302531','302532','302533','302534','302535','302536','302537','302538','302539','302540','302541','302542','302543','302544','302545','302546','302547','302548','302549','302550','302551','302552','302553','302554','302555','302556','302557','302558','302559','302560','302561','302562','302563','302564','302565','302566','302567','302568','302569','302570','302571','302572','302573','302574','302575','302576','302577','302578','302579','302580','302581','302582','302583','302584','302585','302586','302587','302588','302589','302590','302591','302592','302593','302594','302595','302596','302597','302598','302599','302600','302601','302602','302603','302604','302605','302606','302607','302608','302609','302610','302611','302612','302613','302614','302615','302616','302617','302618','302619','302620','302621','302622','302623','302624','302625','302626','302627','302628','302629','302630','302631','302632','302633','302634','302635','302636','302637','302638','302639','302640','302641','302642','302643','302644','302645','302646','302647','302648','302649','302650','302651','302652','302653','302654','302655','302656','302657','302658','302659','302660','302661','302662','302663','302664','302665','302666','302667','302668','302669','302670','302671','302672','302673','302674','302675','302676','302677','302678','302679','302680','302681','302682','302683','302684','302685','302686','302687','302688','302689','302690','302691','302692','302693','302694','302695','302696','302697','302698','302699','302700','302701','302702','302703','302704','302705','302706','302707','302708','302709','302710','302711','302712','302713','302714','302715','302716','302717','302718','302719','302720','302721','302722','302723','302724','302725','302726','302727','302728','302729','302730','302731','302732','302733','302734','302735','302736','302737','302738','302739','302740','302741','302742','302743','302744','302745','302746','302747','302748','302749','302750','302751','302752','302753','302754','302755','302756','302757','302758','302759','302760','302761','302762','302763','302764','302765','302766','302767','302768','302769','302770','302771','302772','302773','302774','302775','302776','302777','302778','302779','302780','302781','302782','302783','302784','302785','302786','302787','302788','302789','302790','302791','302792','302793','302794','302795','302796','302797','302798','302799','302800','302801','302802','302803','302804','302805','302806','302807','302808','302809','302810','302811','302812','302813','302814','302815','302816','302817','302818','302819','302820','302821','302822','302823','302824','302825','302826','302827','302828','302829','302830','302831','302832','302833','302834','302835','302836','302837','302838','302839','302840','302841','302842','302843','302844','302845','302846','302847','302848','302849','302850','302851','302852','302853','302854','302855','302856','302857','302858','302859','302860','302861','302862','302863','302864','302865','302866','302867','302868','302869','302870','302871','302872','302873','302874','302875','302876','302877','302878','302879','302880','302881','302882','302883','302884','302885','302886','302887','302888','302889','302890','302891','302892','302893','302894','302895','302896','302897','302898','302899','302900','302901','302902','302903','302904','302905','302906','302907','302908','302909','302910','302911','302912','302913','302914','302915','302916','302917','302918','302919','302920','302921','302922','302923','302924','302925','302926','302927','302928','302929','302930','302931','302932','302933','302934','302935','302936','302937','302938','302939','302940','302941','302942','302943','302944','302945','302946','302947','302948','302949','302950','302951','302952','302953','302954','302955','302956','302957','302958','302959','302960','302961','302962','302963','302964','302965','302966','302967','302968','302969','302970','302971','302972','302973','302974','302975','302976','302977','302978','302979','302980','302981','302982','302983','302984','302985','302986','302987','302988','302989','302990','302991','302992','302993','302994','302995','302996','302997','302998','302999','303000','303001','303002','303003','303004','303005','303006','303007','303008','303009','303010','303011','303012','303013','303014','303015','303016','303017','303018','303019','303020','303021','303022','303023','303024','303025','303026','303027','303028','303029','303030','303031','303032','303033','303034','303035','303036','303037','303038','303039','303040','303041','303042','303043','303044','303045','303046','303047','303048','303049','303050','303051','303052','303053','303054','303055','303056','303057','303058','303059','303060','303061','303062','303063','303064','303065','303066','303067','303068','303069','303070','303071','303072','303073','303074','303075','303076','303077','303078','303079','303080','303081','303082','303083','303084','303085','303086','303087','303088','303089','303090','303091','303092','303093','303094','303095','303096','303097','303098','303099','303100','303101','303102','303103','303104','303105','303106','303107','303108','303109','303110','303111','303112','303113','303114','303115','303116','303117','303118','303119','303120','303121','303122','303123','303124','303125','303126','303127','303128','303129','303130','303131','303132','303133','303134','303135','303136','303137','303138','303139','303140','303141','303142','303143','303144','303145','303146','303147','303148','303149','303150','303151','303152','303153','303154','303155','303156','303157','303158','303159','303160','303161','303162','303163','303164','303165','303166','303167','303168','303169','303170','303171','303172','303173','303174','303175','303176','303177','303178','303179','303180','303181','303182','303183','303184','303185','303186','303187','303188','303189','303190','303191','303192','303193','303194','303195','303196','303197','303198','303199','303200','303201','303202','303203','303204','303205','303206','303207','303208','303209','303210','303211','303212','303213','303214','303215','303216','303217','303218','303219','303220','303221','303222','303223','303224','303225','303226','303227','303228','303229','303230','303231','303232','303233','303234','303235','303236','303237','303238','303239','303240','303241','303242','303243','303244','303245','303246','303247','303248','303249','303250','303251','303252','303253','303254','303255','303256','303257','303258','303259','303260','303261','303262','303263','303264','303265','303266','303267','303268','303269','303270','303271','303272','303273','303274','303275','303276','303277','303278','303279','303280','303281','303282','303283','303284','303285','303286','303287','303288','303289','303290','303291','303292','303293','303294','303295','303296','303297','303298','303299','303300','303301','303302','303303','303304','303305','303306','303307','303308','303309','303310','303311','303312','303313','303314','303315','303316','303317','303318','303319','303320','303321','303322','303323','303324','303325','303326','303327','303328','303329','303330','303331','303332','303333','303334','303335','303336','303337','303338','303339','303340','303341','303342','303343','303344','303345','303346','303347','303348','303349','303350','303351','303352','303353','303354','303355','303356','303357','303358','303359','303360','303361','303362','303363','303364','303365','303366','303367','303368','303369','303370','303371','303372','303373','303374','303375','303376','303377','303378','303379','303380','303381','303382','303383','303384','303385','303386','303387','303388','303389','303390','303391','303392','303393','303394','303395','303396','303397','303398','303399','303400','303401','303402','303403','303404','303405','303406','303407','303408','303409','303410','303411','303412','303413','303414','303415','303416','303417','303418','303419','303420','303421','303422','303423','303424','303425','303426','303427','303428','303429','303430','303431','303432','303433','303434','303435','303436','303437','303438','303439','303440','303441','303442','303443','303444','303445','303446','303447','303448','303449','303450','303451','303452','303453','303454','303455','303456','303457','303458','303459','303460','303461','303462','303463','303464','303465','303466','303467','303468','303469','303470','303471','303472','303473','303474','303475','303476','303477','303478','303479','303480','303481','303482','303483','303484','303485','303486','303487','303488','303489','303490','303491','303492','303493','303494','303495','303496','303497','303498','303499','303500','303501','303502','303503','303504','303505','303506','303507','303508','303509','303510','303511','303512','303513','303514','303515','303516','303517','303518','303519','303520','303521','303522','303523','303524','303525','303526','303527','303528','303529','303530','303531','303532','303533','303534','303535','303536','303537','303538','303539','303540','303541','303542','303543','303544','303545','303546','303547','303548','303549','303550','303551','303552','303553','303554','303555','303556','303557','303558','303559','303560','303561','303562','303563','303564','303565','303566','303567','303568','303569','303570','303571','303572','303573','303574','303575','303576','303577','303578','303579','303580','303581','303582','303583','303584','303585','303586','303587','303588','303589','303590','303591','303592','303593','303594','303595','303596','303597','303598','303599','303600','303601','303602','303603','303604','303605','303606','303607','303608','303609','303610','303611','303612','303613','303614','303615','303616','303617','303618','303619','303620','303621','303622','303623','303624','303625','303626','303627','303628','303629','303630','303631','303632','303633','303634','303635','303636','303637','303638','303639','303640','303641','303642','303643','303644','303645','303646','303647','303648','303649','303650','303651','303652','303653','303654','303655','303656','303657','303658','303659','303660','303661','303662','303663','303664','303665','303666','303667','303668','303669','303670','303671','303672','303673','303674','303675','303676','303677','303678','303679','303680','303681','303682','303683','303684','303685','303686','303687','303688','303689','303690','303691','303692','303693','303694','303695','303696','303697','303698','303699','303700','303701','303702','303703','303704','303705','303706','303707','303708','303709','303710','303711','303712','303713','303714','303715','303716','303717','303718','303719','303720','303721','303722','303723','303724','303725','303726','303727','303728','303729','303730','303731','303732','303733','303734','303735','303736','303737','303738','303739','303740','303741','303742','303743','303744','303745','303746','303747','303748','303749','303750','303751','303752','303753','303754','303755','303756','303757','303758','303759','303760','303761','303762','303763','303764','303765','303766','303767','303768','303769','303770','303771','303772','303773','303774','303775','303776','303777','303778','303779','303780','303781','303782','303783','303784','303785','303786','303847','303887') GROUP BY `typesize` ORDER BY `typesize` ASC
childsstroke1: typesize
SELECT `typesize`,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 `typesize` !='' AND `modx_site_content`.`id` IN ('158338','158543','158562','158599','158833','158839','158872','159647','160267','160598','161036','161271','163215','163609','163610','163710','163837','164252','164657','164692','164755','164884','164885','165824','166569','167167','167767','167816','167875','168172','168321','232434','232473','232760','238090','238209','238247','240768','240807','240964','241030','242109','242363','242685','242873','242887','243058','243059','243060','243143','243147','243214','243405','244328','244403','244546','245008','245009','245218','246605','246606','246775','246809','247482','247889','247905','248432','248795','248874','249430','249489','249491','249660','250207','250208','250800','250857','250892','251071','251130','251339','251660','251958','253555','253873','254199','254200','254201','254221','255017','255615','256169','256170','256446','256588','256697','256945','261764','262010','262034','262185','262306','262536','263057','263497','263498','263499','264507','264906','265061','265248','265249','265254','265309','265803','266584','266775','266935','267245','267339','267606','267842','268057','268117','268690','268837','268895','269461','274372','275051','275106','275394','275427','276094','276374','276516','276517','276580','276683','276705','277032','277256','277473','277878','278414','278688','279196','279382','279571','279834','280984','281231','281902','282278','282694','284133','284643','284652','285084','285136','285158','285653','285896','286098','286182','286272','286443','287045','287063','287205','288089','288301','289489','292573','292811','293455','294244','294767','294780','294855','295600','296253','296277','297015','297210','297421','297424','297521','297708','298060','298067','298364','298471','298598','299668','299669','300527','300641','301814','302367','302368','302369','302370','302371','302372','302373','302374','302375','302376','302377','302378','302379','302380','302381','302382','302383','302384','302385','302386','302387','302388','302389','302390','302391','302392','302393','302394','302395','302396','302397','302398','302399','302400','302401','302402','302403','302404','302405','302406','302407','302408','302409','302410','302411','302412','302413','302414','302415','302416','302417','302418','302419','302420','302421','302422','302423','302424','302425','302426','302427','302428','302429','302430','302431','302432','302433','302434','302435','302436','302437','302438','302439','302440','302441','302442','302443','302444','302445','302446','302447','302448','302449','302450','302451','302452','302453','302454','302455','302456','302457','302458','302459','302460','302461','302462','302463','302464','302465','302466','302467','302468','302469','302470','302471','302472','302473','302474','302475','302476','302477','302478','302479','302480','302481','302482','302483','302484','302485','302486','302487','302488','302489','302490','302491','302492','302493','302494','302495','302496','302497','302498','302499','302500','302501','302502','302503','302504','302505','302506','302507','302508','302509','302510','302511','302512','302513','302514','302515','302516','302517','302518','302519','302520','302521','302522','302523','302524','302525','302526','302527','302528','302529','302530','302531','302532','302533','302534','302535','302536','302537','302538','302539','302540','302541','302542','302543','302544','302545','302546','302547','302548','302549','302550','302551','302552','302553','302554','302555','302556','302557','302558','302559','302560','302561','302562','302563','302564','302565','302566','302567','302568','302569','302570','302571','302572','302573','302574','302575','302576','302577','302578','302579','302580','302581','302582','302583','302584','302585','302586','302587','302588','302589','302590','302591','302592','302593','302594','302595','302596','302597','302598','302599','302600','302601','302602','302603','302604','302605','302606','302607','302608','302609','302610','302611','302612','302613','302614','302615','302616','302617','302618','302619','302620','302621','302622','302623','302624','302625','302626','302627','302628','302629','302630','302631','302632','302633','302634','302635','302636','302637','302638','302639','302640','302641','302642','302643','302644','302645','302646','302647','302648','302649','302650','302651','302652','302653','302654','302655','302656','302657','302658','302659','302660','302661','302662','302663','302664','302665','302666','302667','302668','302669','302670','302671','302672','302673','302674','302675','302676','302677','302678','302679','302680','302681','302682','302683','302684','302685','302686','302687','302688','302689','302690','302691','302692','302693','302694','302695','302696','302697','302698','302699','302700','302701','302702','302703','302704','302705','302706','302707','302708','302709','302710','302711','302712','302713','302714','302715','302716','302717','302718','302719','302720','302721','302722','302723','302724','302725','302726','302727','302728','302729','302730','302731','302732','302733','302734','302735','302736','302737','302738','302739','302740','302741','302742','302743','302744','302745','302746','302747','302748','302749','302750','302751','302752','302753','302754','302755','302756','302757','302758','302759','302760','302761','302762','302763','302764','302765','302766','302767','302768','302769','302770','302771','302772','302773','302774','302775','302776','302777','302778','302779','302780','302781','302782','302783','302784','302785','302786','302787','302788','302789','302790','302791','302792','302793','302794','302795','302796','302797','302798','302799','302800','302801','302802','302803','302804','302805','302806','302807','302808','302809','302810','302811','302812','302813','302814','302815','302816','302817','302818','302819','302820','302821','302822','302823','302824','302825','302826','302827','302828','302829','302830','302831','302832','302833','302834','302835','302836','302837','302838','302839','302840','302841','302842','302843','302844','302845','302846','302847','302848','302849','302850','302851','302852','302853','302854','302855','302856','302857','302858','302859','302860','302861','302862','302863','302864','302865','302866','302867','302868','302869','302870','302871','302872','302873','302874','302875','302876','302877','302878','302879','302880','302881','302882','302883','302884','302885','302886','302887','302888','302889','302890','302891','302892','302893','302894','302895','302896','302897','302898','302899','302900','302901','302902','302903','302904','302905','302906','302907','302908','302909','302910','302911','302912','302913','302914','302915','302916','302917','302918','302919','302920','302921','302922','302923','302924','302925','302926','302927','302928','302929','302930','302931','302932','302933','302934','302935','302936','302937','302938','302939','302940','302941','302942','302943','302944','302945','302946','302947','302948','302949','302950','302951','302952','302953','302954','302955','302956','302957','302958','302959','302960','302961','302962','302963','302964','302965','302966','302967','302968','302969','302970','302971','302972','302973','302974','302975','302976','302977','302978','302979','302980','302981','302982','302983','302984','302985','302986','302987','302988','302989','302990','302991','302992','302993','302994','302995','302996','302997','302998','302999','303000','303001','303002','303003','303004','303005','303006','303007','303008','303009','303010','303011','303012','303013','303014','303015','303016','303017','303018','303019','303020','303021','303022','303023','303024','303025','303026','303027','303028','303029','303030','303031','303032','303033','303034','303035','303036','303037','303038','303039','303040','303041','303042','303043','303044','303045','303046','303047','303048','303049','303050','303051','303052','303053','303054','303055','303056','303057','303058','303059','303060','303061','303062','303063','303064','303065','303066','303067','303068','303069','303070','303071','303072','303073','303074','303075','303076','303077','303078','303079','303080','303081','303082','303083','303084','303085','303086','303087','303088','303089','303090','303091','303092','303093','303094','303095','303096','303097','303098','303099','303100','303101','303102','303103','303104','303105','303106','303107','303108','303109','303110','303111','303112','303113','303114','303115','303116','303117','303118','303119','303120','303121','303122','303123','303124','303125','303126','303127','303128','303129','303130','303131','303132','303133','303134','303135','303136','303137','303138','303139','303140','303141','303142','303143','303144','303145','303146','303147','303148','303149','303150','303151','303152','303153','303154','303155','303156','303157','303158','303159','303160','303161','303162','303163','303164','303165','303166','303167','303168','303169','303170','303171','303172','303173','303174','303175','303176','303177','303178','303179','303180','303181','303182','303183','303184','303185','303186','303187','303188','303189','303190','303191','303192','303193','303194','303195','303196','303197','303198','303199','303200','303201','303202','303203','303204','303205','303206','303207','303208','303209','303210','303211','303212','303213','303214','303215','303216','303217','303218','303219','303220','303221','303222','303223','303224','303225','303226','303227','303228','303229','303230','303231','303232','303233','303234','303235','303236','303237','303238','303239','303240','303241','303242','303243','303244','303245','303246','303247','303248','303249','303250','303251','303252','303253','303254','303255','303256','303257','303258','303259','303260','303261','303262','303263','303264','303265','303266','303267','303268','303269','303270','303271','303272','303273','303274','303275','303276','303277','303278','303279','303280','303281','303282','303283','303284','303285','303286','303287','303288','303289','303290','303291','303292','303293','303294','303295','303296','303297','303298','303299','303300','303301','303302','303303','303304','303305','303306','303307','303308','303309','303310','303311','303312','303313','303314','303315','303316','303317','303318','303319','303320','303321','303322','303323','303324','303325','303326','303327','303328','303329','303330','303331','303332','303333','303334','303335','303336','303337','303338','303339','303340','303341','303342','303343','303344','303345','303346','303347','303348','303349','303350','303351','303352','303353','303354','303355','303356','303357','303358','303359','303360','303361','303362','303363','303364','303365','303366','303367','303368','303369','303370','303371','303372','303373','303374','303375','303376','303377','303378','303379','303380','303381','303382','303383','303384','303385','303386','303387','303388','303389','303390','303391','303392','303393','303394','303395','303396','303397','303398','303399','303400','303401','303402','303403','303404','303405','303406','303407','303408','303409','303410','303411','303412','303413','303414','303415','303416','303417','303418','303419','303420','303421','303422','303423','303424','303425','303426','303427','303428','303429','303430','303431','303432','303433','303434','303435','303436','303437','303438','303439','303440','303441','303442','303443','303444','303445','303446','303447','303448','303449','303450','303451','303452','303453','303454','303455','303456','303457','303458','303459','303460','303461','303462','303463','303464','303465','303466','303467','303468','303469','303470','303471','303472','303473','303474','303475','303476','303477','303478','303479','303480','303481','303482','303483','303484','303485','303486','303487','303488','303489','303490','303491','303492','303493','303494','303495','303496','303497','303498','303499','303500','303501','303502','303503','303504','303505','303506','303507','303508','303509','303510','303511','303512','303513','303514','303515','303516','303517','303518','303519','303520','303521','303522','303523','303524','303525','303526','303527','303528','303529','303530','303531','303532','303533','303534','303535','303536','303537','303538','303539','303540','303541','303542','303543','303544','303545','303546','303547','303548','303549','303550','303551','303552','303553','303554','303555','303556','303557','303558','303559','303560','303561','303562','303563','303564','303565','303566','303567','303568','303569','303570','303571','303572','303573','303574','303575','303576','303577','303578','303579','303580','303581','303582','303583','303584','303585','303586','303587','303588','303589','303590','303591','303592','303593','303594','303595','303596','303597','303598','303599','303600','303601','303602','303603','303604','303605','303606','303607','303608','303609','303610','303611','303612','303613','303614','303615','303616','303617','303618','303619','303620','303621','303622','303623','303624','303625','303626','303627','303628','303629','303630','303631','303632','303633','303634','303635','303636','303637','303638','303639','303640','303641','303642','303643','303644','303645','303646','303647','303648','303649','303650','303651','303652','303653','303654','303655','303656','303657','303658','303659','303660','303661','303662','303663','303664','303665','303666','303667','303668','303669','303670','303671','303672','303673','303674','303675','303676','303677','303678','303679','303680','303681','303682','303683','303684','303685','303686','303687','303688','303689','303690','303691','303692','303693','303694','303695','303696','303697','303698','303699','303700','303701','303702','303703','303704','303705','303706','303707','303708','303709','303710','303711','303712','303713','303714','303715','303716','303717','303718','303719','303720','303721','303722','303723','303724','303725','303726','303727','303728','303729','303730','303731','303732','303733','303734','303735','303736','303737','303738','303739','303740','303741','303742','303743','303744','303745','303746','303747','303748','303749','303750','303751','303752','303753','303754','303755','303756','303757','303758','303759','303760','303761','303762','303763','303764','303765','303766','303767','303768','303769','303770','303771','303772','303773','303774','303775','303776','303777','303778','303779','303780','303781','303782','303783','303784','303785','303786','303847','303887') GROUP BY `typesize` ORDER BY `typesize` ASC
childsstroke: capacity
SELECT `capacity`,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 `capacity` !='' AND `modx_site_content`.`id` IN ('158338','158543','158562','158599','158833','158839','158872','159647','160267','160598','161036','161271','163215','163609','163610','163710','163837','164252','164657','164692','164755','164884','164885','165824','166569','167167','167767','167816','167875','168172','168321','232434','232473','232760','238090','238209','238247','240768','240807','240964','241030','242109','242363','242685','242873','242887','243058','243059','243060','243143','243147','243214','243405','244328','244403','244546','245008','245009','245218','246605','246606','246775','246809','247482','247889','247905','248432','248795','248874','249430','249489','249491','249660','250207','250208','250800','250857','250892','251071','251130','251339','251660','251958','253555','253873','254199','254200','254201','254221','255017','255615','256169','256170','256446','256588','256697','256945','261764','262010','262034','262185','262306','262536','263057','263497','263498','263499','264507','264906','265061','265248','265249','265254','265309','265803','266584','266775','266935','267245','267339','267606','267842','268057','268117','268690','268837','268895','269461','274372','275051','275106','275394','275427','276094','276374','276516','276517','276580','276683','276705','277032','277256','277473','277878','278414','278688','279196','279382','279571','279834','280984','281231','281902','282278','282694','284133','284643','284652','285084','285136','285158','285653','285896','286098','286182','286272','286443','287045','287063','287205','288089','288301','289489','292573','292811','293455','294244','294767','294780','294855','295600','296253','296277','297015','297210','297421','297424','297521','297708','298060','298067','298364','298471','298598','299668','299669','300527','300641','301814','302367','302368','302369','302370','302371','302372','302373','302374','302375','302376','302377','302378','302379','302380','302381','302382','302383','302384','302385','302386','302387','302388','302389','302390','302391','302392','302393','302394','302395','302396','302397','302398','302399','302400','302401','302402','302403','302404','302405','302406','302407','302408','302409','302410','302411','302412','302413','302414','302415','302416','302417','302418','302419','302420','302421','302422','302423','302424','302425','302426','302427','302428','302429','302430','302431','302432','302433','302434','302435','302436','302437','302438','302439','302440','302441','302442','302443','302444','302445','302446','302447','302448','302449','302450','302451','302452','302453','302454','302455','302456','302457','302458','302459','302460','302461','302462','302463','302464','302465','302466','302467','302468','302469','302470','302471','302472','302473','302474','302475','302476','302477','302478','302479','302480','302481','302482','302483','302484','302485','302486','302487','302488','302489','302490','302491','302492','302493','302494','302495','302496','302497','302498','302499','302500','302501','302502','302503','302504','302505','302506','302507','302508','302509','302510','302511','302512','302513','302514','302515','302516','302517','302518','302519','302520','302521','302522','302523','302524','302525','302526','302527','302528','302529','302530','302531','302532','302533','302534','302535','302536','302537','302538','302539','302540','302541','302542','302543','302544','302545','302546','302547','302548','302549','302550','302551','302552','302553','302554','302555','302556','302557','302558','302559','302560','302561','302562','302563','302564','302565','302566','302567','302568','302569','302570','302571','302572','302573','302574','302575','302576','302577','302578','302579','302580','302581','302582','302583','302584','302585','302586','302587','302588','302589','302590','302591','302592','302593','302594','302595','302596','302597','302598','302599','302600','302601','302602','302603','302604','302605','302606','302607','302608','302609','302610','302611','302612','302613','302614','302615','302616','302617','302618','302619','302620','302621','302622','302623','302624','302625','302626','302627','302628','302629','302630','302631','302632','302633','302634','302635','302636','302637','302638','302639','302640','302641','302642','302643','302644','302645','302646','302647','302648','302649','302650','302651','302652','302653','302654','302655','302656','302657','302658','302659','302660','302661','302662','302663','302664','302665','302666','302667','302668','302669','302670','302671','302672','302673','302674','302675','302676','302677','302678','302679','302680','302681','302682','302683','302684','302685','302686','302687','302688','302689','302690','302691','302692','302693','302694','302695','302696','302697','302698','302699','302700','302701','302702','302703','302704','302705','302706','302707','302708','302709','302710','302711','302712','302713','302714','302715','302716','302717','302718','302719','302720','302721','302722','302723','302724','302725','302726','302727','302728','302729','302730','302731','302732','302733','302734','302735','302736','302737','302738','302739','302740','302741','302742','302743','302744','302745','302746','302747','302748','302749','302750','302751','302752','302753','302754','302755','302756','302757','302758','302759','302760','302761','302762','302763','302764','302765','302766','302767','302768','302769','302770','302771','302772','302773','302774','302775','302776','302777','302778','302779','302780','302781','302782','302783','302784','302785','302786','302787','302788','302789','302790','302791','302792','302793','302794','302795','302796','302797','302798','302799','302800','302801','302802','302803','302804','302805','302806','302807','302808','302809','302810','302811','302812','302813','302814','302815','302816','302817','302818','302819','302820','302821','302822','302823','302824','302825','302826','302827','302828','302829','302830','302831','302832','302833','302834','302835','302836','302837','302838','302839','302840','302841','302842','302843','302844','302845','302846','302847','302848','302849','302850','302851','302852','302853','302854','302855','302856','302857','302858','302859','302860','302861','302862','302863','302864','302865','302866','302867','302868','302869','302870','302871','302872','302873','302874','302875','302876','302877','302878','302879','302880','302881','302882','302883','302884','302885','302886','302887','302888','302889','302890','302891','302892','302893','302894','302895','302896','302897','302898','302899','302900','302901','302902','302903','302904','302905','302906','302907','302908','302909','302910','302911','302912','302913','302914','302915','302916','302917','302918','302919','302920','302921','302922','302923','302924','302925','302926','302927','302928','302929','302930','302931','302932','302933','302934','302935','302936','302937','302938','302939','302940','302941','302942','302943','302944','302945','302946','302947','302948','302949','302950','302951','302952','302953','302954','302955','302956','302957','302958','302959','302960','302961','302962','302963','302964','302965','302966','302967','302968','302969','302970','302971','302972','302973','302974','302975','302976','302977','302978','302979','302980','302981','302982','302983','302984','302985','302986','302987','302988','302989','302990','302991','302992','302993','302994','302995','302996','302997','302998','302999','303000','303001','303002','303003','303004','303005','303006','303007','303008','303009','303010','303011','303012','303013','303014','303015','303016','303017','303018','303019','303020','303021','303022','303023','303024','303025','303026','303027','303028','303029','303030','303031','303032','303033','303034','303035','303036','303037','303038','303039','303040','303041','303042','303043','303044','303045','303046','303047','303048','303049','303050','303051','303052','303053','303054','303055','303056','303057','303058','303059','303060','303061','303062','303063','303064','303065','303066','303067','303068','303069','303070','303071','303072','303073','303074','303075','303076','303077','303078','303079','303080','303081','303082','303083','303084','303085','303086','303087','303088','303089','303090','303091','303092','303093','303094','303095','303096','303097','303098','303099','303100','303101','303102','303103','303104','303105','303106','303107','303108','303109','303110','303111','303112','303113','303114','303115','303116','303117','303118','303119','303120','303121','303122','303123','303124','303125','303126','303127','303128','303129','303130','303131','303132','303133','303134','303135','303136','303137','303138','303139','303140','303141','303142','303143','303144','303145','303146','303147','303148','303149','303150','303151','303152','303153','303154','303155','303156','303157','303158','303159','303160','303161','303162','303163','303164','303165','303166','303167','303168','303169','303170','303171','303172','303173','303174','303175','303176','303177','303178','303179','303180','303181','303182','303183','303184','303185','303186','303187','303188','303189','303190','303191','303192','303193','303194','303195','303196','303197','303198','303199','303200','303201','303202','303203','303204','303205','303206','303207','303208','303209','303210','303211','303212','303213','303214','303215','303216','303217','303218','303219','303220','303221','303222','303223','303224','303225','303226','303227','303228','303229','303230','303231','303232','303233','303234','303235','303236','303237','303238','303239','303240','303241','303242','303243','303244','303245','303246','303247','303248','303249','303250','303251','303252','303253','303254','303255','303256','303257','303258','303259','303260','303261','303262','303263','303264','303265','303266','303267','303268','303269','303270','303271','303272','303273','303274','303275','303276','303277','303278','303279','303280','303281','303282','303283','303284','303285','303286','303287','303288','303289','303290','303291','303292','303293','303294','303295','303296','303297','303298','303299','303300','303301','303302','303303','303304','303305','303306','303307','303308','303309','303310','303311','303312','303313','303314','303315','303316','303317','303318','303319','303320','303321','303322','303323','303324','303325','303326','303327','303328','303329','303330','303331','303332','303333','303334','303335','303336','303337','303338','303339','303340','303341','303342','303343','303344','303345','303346','303347','303348','303349','303350','303351','303352','303353','303354','303355','303356','303357','303358','303359','303360','303361','303362','303363','303364','303365','303366','303367','303368','303369','303370','303371','303372','303373','303374','303375','303376','303377','303378','303379','303380','303381','303382','303383','303384','303385','303386','303387','303388','303389','303390','303391','303392','303393','303394','303395','303396','303397','303398','303399','303400','303401','303402','303403','303404','303405','303406','303407','303408','303409','303410','303411','303412','303413','303414','303415','303416','303417','303418','303419','303420','303421','303422','303423','303424','303425','303426','303427','303428','303429','303430','303431','303432','303433','303434','303435','303436','303437','303438','303439','303440','303441','303442','303443','303444','303445','303446','303447','303448','303449','303450','303451','303452','303453','303454','303455','303456','303457','303458','303459','303460','303461','303462','303463','303464','303465','303466','303467','303468','303469','303470','303471','303472','303473','303474','303475','303476','303477','303478','303479','303480','303481','303482','303483','303484','303485','303486','303487','303488','303489','303490','303491','303492','303493','303494','303495','303496','303497','303498','303499','303500','303501','303502','303503','303504','303505','303506','303507','303508','303509','303510','303511','303512','303513','303514','303515','303516','303517','303518','303519','303520','303521','303522','303523','303524','303525','303526','303527','303528','303529','303530','303531','303532','303533','303534','303535','303536','303537','303538','303539','303540','303541','303542','303543','303544','303545','303546','303547','303548','303549','303550','303551','303552','303553','303554','303555','303556','303557','303558','303559','303560','303561','303562','303563','303564','303565','303566','303567','303568','303569','303570','303571','303572','303573','303574','303575','303576','303577','303578','303579','303580','303581','303582','303583','303584','303585','303586','303587','303588','303589','303590','303591','303592','303593','303594','303595','303596','303597','303598','303599','303600','303601','303602','303603','303604','303605','303606','303607','303608','303609','303610','303611','303612','303613','303614','303615','303616','303617','303618','303619','303620','303621','303622','303623','303624','303625','303626','303627','303628','303629','303630','303631','303632','303633','303634','303635','303636','303637','303638','303639','303640','303641','303642','303643','303644','303645','303646','303647','303648','303649','303650','303651','303652','303653','303654','303655','303656','303657','303658','303659','303660','303661','303662','303663','303664','303665','303666','303667','303668','303669','303670','303671','303672','303673','303674','303675','303676','303677','303678','303679','303680','303681','303682','303683','303684','303685','303686','303687','303688','303689','303690','303691','303692','303693','303694','303695','303696','303697','303698','303699','303700','303701','303702','303703','303704','303705','303706','303707','303708','303709','303710','303711','303712','303713','303714','303715','303716','303717','303718','303719','303720','303721','303722','303723','303724','303725','303726','303727','303728','303729','303730','303731','303732','303733','303734','303735','303736','303737','303738','303739','303740','303741','303742','303743','303744','303745','303746','303747','303748','303749','303750','303751','303752','303753','303754','303755','303756','303757','303758','303759','303760','303761','303762','303763','303764','303765','303766','303767','303768','303769','303770','303771','303772','303773','303774','303775','303776','303777','303778','303779','303780','303781','303782','303783','303784','303785','303786','303847','303887') GROUP BY `capacity` ORDER BY `capacity` ASC
childsstroke1: capacity
SELECT `capacity`,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 `capacity` !='' AND `modx_site_content`.`id` IN ('158338','158543','158562','158599','158833','158839','158872','159647','160267','160598','161036','161271','163215','163609','163610','163710','163837','164252','164657','164692','164755','164884','164885','165824','166569','167167','167767','167816','167875','168172','168321','232434','232473','232760','238090','238209','238247','240768','240807','240964','241030','242109','242363','242685','242873','242887','243058','243059','243060','243143','243147','243214','243405','244328','244403','244546','245008','245009','245218','246605','246606','246775','246809','247482','247889','247905','248432','248795','248874','249430','249489','249491','249660','250207','250208','250800','250857','250892','251071','251130','251339','251660','251958','253555','253873','254199','254200','254201','254221','255017','255615','256169','256170','256446','256588','256697','256945','261764','262010','262034','262185','262306','262536','263057','263497','263498','263499','264507','264906','265061','265248','265249','265254','265309','265803','266584','266775','266935','267245','267339','267606','267842','268057','268117','268690','268837','268895','269461','274372','275051','275106','275394','275427','276094','276374','276516','276517','276580','276683','276705','277032','277256','277473','277878','278414','278688','279196','279382','279571','279834','280984','281231','281902','282278','282694','284133','284643','284652','285084','285136','285158','285653','285896','286098','286182','286272','286443','287045','287063','287205','288089','288301','289489','292573','292811','293455','294244','294767','294780','294855','295600','296253','296277','297015','297210','297421','297424','297521','297708','298060','298067','298364','298471','298598','299668','299669','300527','300641','301814','302367','302368','302369','302370','302371','302372','302373','302374','302375','302376','302377','302378','302379','302380','302381','302382','302383','302384','302385','302386','302387','302388','302389','302390','302391','302392','302393','302394','302395','302396','302397','302398','302399','302400','302401','302402','302403','302404','302405','302406','302407','302408','302409','302410','302411','302412','302413','302414','302415','302416','302417','302418','302419','302420','302421','302422','302423','302424','302425','302426','302427','302428','302429','302430','302431','302432','302433','302434','302435','302436','302437','302438','302439','302440','302441','302442','302443','302444','302445','302446','302447','302448','302449','302450','302451','302452','302453','302454','302455','302456','302457','302458','302459','302460','302461','302462','302463','302464','302465','302466','302467','302468','302469','302470','302471','302472','302473','302474','302475','302476','302477','302478','302479','302480','302481','302482','302483','302484','302485','302486','302487','302488','302489','302490','302491','302492','302493','302494','302495','302496','302497','302498','302499','302500','302501','302502','302503','302504','302505','302506','302507','302508','302509','302510','302511','302512','302513','302514','302515','302516','302517','302518','302519','302520','302521','302522','302523','302524','302525','302526','302527','302528','302529','302530','302531','302532','302533','302534','302535','302536','302537','302538','302539','302540','302541','302542','302543','302544','302545','302546','302547','302548','302549','302550','302551','302552','302553','302554','302555','302556','302557','302558','302559','302560','302561','302562','302563','302564','302565','302566','302567','302568','302569','302570','302571','302572','302573','302574','302575','302576','302577','302578','302579','302580','302581','302582','302583','302584','302585','302586','302587','302588','302589','302590','302591','302592','302593','302594','302595','302596','302597','302598','302599','302600','302601','302602','302603','302604','302605','302606','302607','302608','302609','302610','302611','302612','302613','302614','302615','302616','302617','302618','302619','302620','302621','302622','302623','302624','302625','302626','302627','302628','302629','302630','302631','302632','302633','302634','302635','302636','302637','302638','302639','302640','302641','302642','302643','302644','302645','302646','302647','302648','302649','302650','302651','302652','302653','302654','302655','302656','302657','302658','302659','302660','302661','302662','302663','302664','302665','302666','302667','302668','302669','302670','302671','302672','302673','302674','302675','302676','302677','302678','302679','302680','302681','302682','302683','302684','302685','302686','302687','302688','302689','302690','302691','302692','302693','302694','302695','302696','302697','302698','302699','302700','302701','302702','302703','302704','302705','302706','302707','302708','302709','302710','302711','302712','302713','302714','302715','302716','302717','302718','302719','302720','302721','302722','302723','302724','302725','302726','302727','302728','302729','302730','302731','302732','302733','302734','302735','302736','302737','302738','302739','302740','302741','302742','302743','302744','302745','302746','302747','302748','302749','302750','302751','302752','302753','302754','302755','302756','302757','302758','302759','302760','302761','302762','302763','302764','302765','302766','302767','302768','302769','302770','302771','302772','302773','302774','302775','302776','302777','302778','302779','302780','302781','302782','302783','302784','302785','302786','302787','302788','302789','302790','302791','302792','302793','302794','302795','302796','302797','302798','302799','302800','302801','302802','302803','302804','302805','302806','302807','302808','302809','302810','302811','302812','302813','302814','302815','302816','302817','302818','302819','302820','302821','302822','302823','302824','302825','302826','302827','302828','302829','302830','302831','302832','302833','302834','302835','302836','302837','302838','302839','302840','302841','302842','302843','302844','302845','302846','302847','302848','302849','302850','302851','302852','302853','302854','302855','302856','302857','302858','302859','302860','302861','302862','302863','302864','302865','302866','302867','302868','302869','302870','302871','302872','302873','302874','302875','302876','302877','302878','302879','302880','302881','302882','302883','302884','302885','302886','302887','302888','302889','302890','302891','302892','302893','302894','302895','302896','302897','302898','302899','302900','302901','302902','302903','302904','302905','302906','302907','302908','302909','302910','302911','302912','302913','302914','302915','302916','302917','302918','302919','302920','302921','302922','302923','302924','302925','302926','302927','302928','302929','302930','302931','302932','302933','302934','302935','302936','302937','302938','302939','302940','302941','302942','302943','302944','302945','302946','302947','302948','302949','302950','302951','302952','302953','302954','302955','302956','302957','302958','302959','302960','302961','302962','302963','302964','302965','302966','302967','302968','302969','302970','302971','302972','302973','302974','302975','302976','302977','302978','302979','302980','302981','302982','302983','302984','302985','302986','302987','302988','302989','302990','302991','302992','302993','302994','302995','302996','302997','302998','302999','303000','303001','303002','303003','303004','303005','303006','303007','303008','303009','303010','303011','303012','303013','303014','303015','303016','303017','303018','303019','303020','303021','303022','303023','303024','303025','303026','303027','303028','303029','303030','303031','303032','303033','303034','303035','303036','303037','303038','303039','303040','303041','303042','303043','303044','303045','303046','303047','303048','303049','303050','303051','303052','303053','303054','303055','303056','303057','303058','303059','303060','303061','303062','303063','303064','303065','303066','303067','303068','303069','303070','303071','303072','303073','303074','303075','303076','303077','303078','303079','303080','303081','303082','303083','303084','303085','303086','303087','303088','303089','303090','303091','303092','303093','303094','303095','303096','303097','303098','303099','303100','303101','303102','303103','303104','303105','303106','303107','303108','303109','303110','303111','303112','303113','303114','303115','303116','303117','303118','303119','303120','303121','303122','303123','303124','303125','303126','303127','303128','303129','303130','303131','303132','303133','303134','303135','303136','303137','303138','303139','303140','303141','303142','303143','303144','303145','303146','303147','303148','303149','303150','303151','303152','303153','303154','303155','303156','303157','303158','303159','303160','303161','303162','303163','303164','303165','303166','303167','303168','303169','303170','303171','303172','303173','303174','303175','303176','303177','303178','303179','303180','303181','303182','303183','303184','303185','303186','303187','303188','303189','303190','303191','303192','303193','303194','303195','303196','303197','303198','303199','303200','303201','303202','303203','303204','303205','303206','303207','303208','303209','303210','303211','303212','303213','303214','303215','303216','303217','303218','303219','303220','303221','303222','303223','303224','303225','303226','303227','303228','303229','303230','303231','303232','303233','303234','303235','303236','303237','303238','303239','303240','303241','303242','303243','303244','303245','303246','303247','303248','303249','303250','303251','303252','303253','303254','303255','303256','303257','303258','303259','303260','303261','303262','303263','303264','303265','303266','303267','303268','303269','303270','303271','303272','303273','303274','303275','303276','303277','303278','303279','303280','303281','303282','303283','303284','303285','303286','303287','303288','303289','303290','303291','303292','303293','303294','303295','303296','303297','303298','303299','303300','303301','303302','303303','303304','303305','303306','303307','303308','303309','303310','303311','303312','303313','303314','303315','303316','303317','303318','303319','303320','303321','303322','303323','303324','303325','303326','303327','303328','303329','303330','303331','303332','303333','303334','303335','303336','303337','303338','303339','303340','303341','303342','303343','303344','303345','303346','303347','303348','303349','303350','303351','303352','303353','303354','303355','303356','303357','303358','303359','303360','303361','303362','303363','303364','303365','303366','303367','303368','303369','303370','303371','303372','303373','303374','303375','303376','303377','303378','303379','303380','303381','303382','303383','303384','303385','303386','303387','303388','303389','303390','303391','303392','303393','303394','303395','303396','303397','303398','303399','303400','303401','303402','303403','303404','303405','303406','303407','303408','303409','303410','303411','303412','303413','303414','303415','303416','303417','303418','303419','303420','303421','303422','303423','303424','303425','303426','303427','303428','303429','303430','303431','303432','303433','303434','303435','303436','303437','303438','303439','303440','303441','303442','303443','303444','303445','303446','303447','303448','303449','303450','303451','303452','303453','303454','303455','303456','303457','303458','303459','303460','303461','303462','303463','303464','303465','303466','303467','303468','303469','303470','303471','303472','303473','303474','303475','303476','303477','303478','303479','303480','303481','303482','303483','303484','303485','303486','303487','303488','303489','303490','303491','303492','303493','303494','303495','303496','303497','303498','303499','303500','303501','303502','303503','303504','303505','303506','303507','303508','303509','303510','303511','303512','303513','303514','303515','303516','303517','303518','303519','303520','303521','303522','303523','303524','303525','303526','303527','303528','303529','303530','303531','303532','303533','303534','303535','303536','303537','303538','303539','303540','303541','303542','303543','303544','303545','303546','303547','303548','303549','303550','303551','303552','303553','303554','303555','303556','303557','303558','303559','303560','303561','303562','303563','303564','303565','303566','303567','303568','303569','303570','303571','303572','303573','303574','303575','303576','303577','303578','303579','303580','303581','303582','303583','303584','303585','303586','303587','303588','303589','303590','303591','303592','303593','303594','303595','303596','303597','303598','303599','303600','303601','303602','303603','303604','303605','303606','303607','303608','303609','303610','303611','303612','303613','303614','303615','303616','303617','303618','303619','303620','303621','303622','303623','303624','303625','303626','303627','303628','303629','303630','303631','303632','303633','303634','303635','303636','303637','303638','303639','303640','303641','303642','303643','303644','303645','303646','303647','303648','303649','303650','303651','303652','303653','303654','303655','303656','303657','303658','303659','303660','303661','303662','303663','303664','303665','303666','303667','303668','303669','303670','303671','303672','303673','303674','303675','303676','303677','303678','303679','303680','303681','303682','303683','303684','303685','303686','303687','303688','303689','303690','303691','303692','303693','303694','303695','303696','303697','303698','303699','303700','303701','303702','303703','303704','303705','303706','303707','303708','303709','303710','303711','303712','303713','303714','303715','303716','303717','303718','303719','303720','303721','303722','303723','303724','303725','303726','303727','303728','303729','303730','303731','303732','303733','303734','303735','303736','303737','303738','303739','303740','303741','303742','303743','303744','303745','303746','303747','303748','303749','303750','303751','303752','303753','303754','303755','303756','303757','303758','303759','303760','303761','303762','303763','303764','303765','303766','303767','303768','303769','303770','303771','303772','303773','303774','303775','303776','303777','303778','303779','303780','303781','303782','303783','303784','303785','303786','303847','303887') GROUP BY `capacity` ORDER BY `capacity` ASC
