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 ('30','185','211','212','213','214','215','216','217','218','219','220','221','243','141351','141381','141383','141384','141423','141424','141501','141502','141660','141672','141716','141749','141757','141759','141793','141832','141833','141874','141875','141876','141877','141940','142027','142120','142836','142837','142849','142861','142862','142863','142919','142970','143061','143231','143243','143562','143610','143622','143623','143845','144229','146629','146860','146970','147091','147715','148062','148677','148746','149003','149004','149005','149006','149007','149008','149009','149010','149011','149012','149013','149014','149015','149016','149017','149018','149019','149020','149021','149022','149023','149024','149025','149026','149027','149028','149029','149030','149031','149032','149033','149034','149035','149036','149037','149038','149039','149040','149041','149042','149043','149044','149045','149046','149047','149048','149652','149690','149906','150612','150613','150641','150780','150781','150829','150979','151045','151300','151657','151670','151683','151688','151744','151862','151962','152551','152656','152664','153213','153566','153595','153596','153635','153774','153809','153824','153907','153937','154132','154133','154134','154329','154330','154450','154570','154740','154792','154831','154888','155014','155062','155071','155169','155170','155171','155172','155173','155175','155176','155177','155178','155179','155180','155181','155197','155198','155200','155201','155203','155204','155205','155206','155207','155209','155211','155213','155383','155384','155385','155386','155387','155388','155389','155390','155391','155392','155393','155394','155395','155396','155397','155398','155399','155400','155401','155402','155403','155404','155405','155406','155407','155466','155467','155468','155469','155473','155474','155524','155525','155526','155527','155528','155529','155530','155531','155532','155534','155535','155536','155548','155564','155565','155566','155567','155570','155571','155572','155573','155574','155575','155576','155577','155578','155579','155580','155581','155582','155583','155584','155585','155586','155589','155590','155591','155592','155593','155599','155600','155601','155605','155606','155607','155608','155610','155611','155612','155613','155614','155615','155616','155617','155618','155619','155620','155621','155622','155625','155626','155627','155628','155629','155630','155631','155638','155640','155641','155680','155786','155787','155788','155789','155790','155791','155792','155793','155794','155795','155796','155797','155798','155799','155800','155801','155802','155803','155804','155805','155806','155807','155808','155864','155865','155868','155869','155870','155871','156269','156634','157740','157814','157815','157816','157817','157818','158032','158056','158057','158179','158417','158537','158538','158576','158577','158670','158698','158752','158940','159000','159020','159139','159251','159265','159266','159683','159913','159917','160197','160230','160342','160402','160474','160488','160760','160926','161088','161089','161090','161091','161222','161611','161701','161823','161925','162175','162203','162442','162670','162699','162859','163153','163154','163569','163570','163571','163572','163574','163575','163576','163578','163579','163676','163757','163859','163942','163971','163989','163990','164233','164257','164261','164372','164403','164596','164624','164958','165000','165020','165131','165151','165152','165153','165154','165155','165156','165157','165636','165772','165872','165977','166057','166133','166774','166775','166855','166858','166928','167108','167137','167177','167178','167217','167315','167441','167484','167485','167486','167487','167585','167624','167625','167626','167630','167741','168226','168275','169821','170512','170522','170555','170678','170679','170786','170787','201146','201147','201259','201286','202668','202703','202714','202767','202860','206359','206360','206361','206362','206363','206364','206365','206366','206367','206368','206369','206370','206371','206372','206373','206374','206375','206376','206377','206378','206379','206380','206381','206382','206383','206384','206385','206386','206387','206388','206389','206390','206391','206392','206393','206394','206395','206396','206397','206398','206399','206400','206401','206402','206403','206404','206405','206406','206407','206408','206409','206410','206411','206412','206413','206414','206415','206416','206417','206418','206419','206420','206421','206422','206423','206424','206425','206426','206427','206428','206429','206430','206431','206432','206433','206434','206435','206436','206437','206438','206439','206440','206441','206442','206443','206444','206445','206446','206447','206448','206449','206450','206451','206452','206453','206454','206455','206456','206457','206458','206459','206460','206461','206462','206463','206464','206465','206466','206467','206468','206469','206470','206471','206472','206473','206474','206475','206476','206477','206478','206479','206480','206481','206482','206483','206484','206485','206486','206487','206488','206489','206490','206491','206492','206493','206494','206495','206496','206497','206498','206499','206500','206501','206502','206503','206504','206505','206506','206507','206508','206509','206510','206511','206512','206513','206514','206515','206516','206517','206518','206519','206520','206521','206522','206523','206524','206525','206526','206527','206528','206529','206530','206531','206532','206533','206534','206535','206536','206537','206538','206539','206540','206541','206542','206543','206544','206545','206546','206547','206548','206549','206550','206551','206552','206553','206554','206555','206556','206557','206558','206559','206560','206561','206562','206563','206564','206565','206566','206567','206568','206569','206570','206571','206572','206573','206574','206575','206576','206577','206578','206579','206580','206581','206582','206583','206584','206585','206586','206587','206588','206589','206590','206591','206592','206593','206594','206595','206596','206597','206598','206599','206600','206601','206602','206603','206604','206605','206606','206607','206608','206609','206610','206611','206612','206613','206614','206615','206616','206617','206618','206619','206620','206621','206622','206623','206624','206625','206626','206627','206628','206629','206630','206631','206632','206633','206634','206635','206636','206637','206638','206639','215344','215349','215773','215846','215937','219718','232597','232647','232789','232795','238159','238161','238459','238591','238592','238626','238627','238686','238933','239103','239133','239147','239269','239270','239584','239590','239643','239727','239728','239740','239787','239833','239853','239995','240050','240279','240331','240406','240408','240473','240630','240692','240912','240913','241098','241369','241535','241536','241537','241622','241952','242584','242585','242661','242662','242787','243038','243073','243139','243403','243556','243583','243584','243585','243586','243587','243588','243589','243590','244251','244434','244435','244529','245207','245300','245314','245492','245558','245559','245599','245735','245780','245907','246016','246403','246887','246908','246924','246930','246937','246944','246945','246946','247016','247289','247572','247599','247787','248014','248266','248267','248268','248269','248270','248539','248540','248616','248675','248776','248793','248794','248819','249000','249114','249115','249279','249487','249678','249694','249732','249846','249904','250646','250694','250711','250713','250714','250741','250766','250768','250963','251156','251169','251249','251322','251379','251704','251829','252059','252112','252202','253325','254212','254226','254316','254317','254318','254560','254561','254562','254703','254706','254732','254734','254927','254928','254929','254988','255039','255152','255243','255290','255293','255462','255506','255630','255657','255701','255717','256085','256101','256117','256326','256327','256676','256718','257029','257032','257033','257058','257059','261703','261751','262796','262810','262836','262837','262838','262839','262840','262841','262842','262843','262844','262852','262885','262942','263002','263003','263004','263005','263008','263055','263077','263085','263493','263513','263646','264749','264823','264889','265155','265657','265678','265953','266044','266084','266085','266437','266480','266568','266993','267070','267155','267295','267614','268069','268214','268232','268233','268314','268370','268484','268574','268622','268693','268893','268899','269044','269077','269078','269081','269108','269181','269442','269491','269528','269629','273431','273467','273518','273618','273671','273768','273871','273885','273886','274139','274228','274321','274655','274782','274826','274913','275370','275684','276069','276070','276072','276282','276283','276290','276294','276480','276484','276514','276526','276596','276631','276632','276661','276664','276666','276805','276991','277016','277017','277018','277217','277270','277358','277719','277805','277806','277917','278138','278139','278140','278289','278481','278844','278898','279002','279084','279185','279226','279260','279348','279477','279560','279835','280400','280590','280947','280967','281001','281090','281186','281232','281340','281475','281681','281737','281794','281799','281800','281803','281812','282014','282015','282032','282033','282100','282101','282552','282825','282987','283053','283054','283089','283102','283611','283730','283803','283804','284354','284440','284724','284960','285120','285177','285178','285267','285408','285487','285501','285551','285659','285662','285681','285708','285709','285710','285813','285827','285887','285986','286105','286130','286134','286165','286199','286383','286388','286389','286390','286616','286622','286846','286981','287034','287037','287097','287174','288242','288289','288311','288370','288416','288845','288854','288952','291949','291950','292056','292507','292659','293265','293369','293374','293413','293414','293450','293613','293925','293941','294026','294067','294160','294162','294163','294164','294202','294245','294356','294380','294564','294777','294877','294955','295151','295339','295518','295519','295520','295521','295541','295607','295723','295818','295959','295961','295963','295965','296183','296196','297320','297420','297509','297641','297655','297779','297789','297999','298111','298147','298157','298187','298192','299043','299185','299217','299363','299368','299375','299399','299405','299528','299535','299627','299652','299676','299696','299894','299944','300352','300431','300616','300632','300673','301042','301043','301794','301945','302089','302110','302120','303799','303819','303920','303933') 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 ('141351','141381','141383','141384','141423','141424','141501','141502','141660','141672','141716','141749','141757','141759','141793','141832','141833','141874','141875','141876','141877','141940','142027','142120','142836','142837','142849','142861','142862','142863','142919','142970','143061','143231','143243','143562','143610','143622','143623','143845','144229','146629','146860','146970','147091','147715','148062','148677','148746','149003','149004','149005','149006','149007','149008','149009','149010','149011','149012','149013','149014','149015','149016','149017','149018','149019','149020','149021','149022','149023','149024','149025','149026','149027','149028','149029','149030','149031','149032','149033','149034','149035','149036','149037','149038','149039','149040','149041','149042','149043','149044','149045','149046','149047','149048','149652','149690','149906','150612','150613','150641','150780','150781','150829','150979','151045','151300','151657','151670','151683','151688','151744','151862','151962','152551','152656','152664','153213','153566','153595','153596','153635','153774','153809','153824','153907','153937','154132','154133','154134','154329','154330','154450','154570','154740','154792','154831','154888','155014','155062','155071','155169','155170','155171','155172','155173','155175','155176','155177','155178','155179','155180','155181','155197','155198','155200','155201','155203','155204','155205','155206','155207','155209','155211','155213','155383','155384','155385','155386','155387','155388','155389','155390','155391','155392','155393','155394','155395','155396','155397','155398','155399','155400','155401','155402','155403','155404','155405','155406','155407','155466','155467','155468','155469','155473','155474','155524','155525','155526','155527','155528','155529','155530','155531','155532','155534','155535','155536','155548','155564','155565','155566','155567','155570','155571','155572','155573','155574','155575','155576','155577','155578','155579','155580','155581','155582','155583','155584','155585','155586','155589','155590','155591','155592','155593','155599','155600','155601','155605','155606','155607','155608','155610','155611','155612','155613','155614','155615','155616','155617','155618','155619','155620','155621','155622','155625','155626','155627','155628','155629','155630','155631','155638','155640','155641','155680','155786','155787','155788','155789','155790','155791','155792','155793','155794','155795','155796','155797','155798','155799','155800','155801','155802','155803','155804','155805','155806','155807','155808','155864','155865','155868','155869','155870','155871','156269','156634','157740','157814','157815','157816','157817','157818','158032','158056','158057','158179','158417','158537','158538','158576','158577','158670','158698','158752','158940','159000','159020','159139','159251','159265','159266','159683','159913','159917','160197','160230','160342','160402','160474','160488','160760','160926','161088','161089','161090','161091','161222','161611','161701','161823','161925','162175','162203','162442','162670','162699','162859','163153','163154','163569','163570','163571','163572','163574','163575','163576','163578','163579','163676','163757','163859','163942','163971','163989','163990','164233','164257','164261','164372','164403','164596','164624','164958','165000','165020','165131','165151','165152','165153','165154','165155','165156','165157','165636','165772','165872','165977','166057','166133','166774','166775','166855','166858','166928','167108','167137','167177','167178','167217','167315','167441','167484','167485','167486','167487','167585','167624','167625','167626','167630','167741','168226','168275','169821','170512','170522','170555','170678','170679','170786','170787','201146','201147','201259','201286','202668','202703','202714','202767','202860','206359','206360','206361','206362','206363','206364','206365','206366','206367','206368','206369','206370','206371','206372','206373','206374','206375','206376','206377','206378','206379','206380','206381','206382','206383','206384','206385','206386','206387','206388','206389','206390','206391','206392','206393','206394','206395','206396','206397','206398','206399','206400','206401','206402','206403','206404','206405','206406','206407','206408','206409','206410','206411','206412','206413','206414','206415','206416','206417','206418','206419','206420','206421','206422','206423','206424','206425','206426','206427','206428','206429','206430','206431','206432','206433','206434','206435','206436','206437','206438','206439','206440','206441','206442','206443','206444','206445','206446','206447','206448','206449','206450','206451','206452','206453','206454','206455','206456','206457','206458','206459','206460','206461','206462','206463','206464','206465','206466','206467','206468','206469','206470','206471','206472','206473','206474','206475','206476','206477','206478','206479','206480','206481','206482','206483','206484','206485','206486','206487','206488','206489','206490','206491','206492','206493','206494','206495','206496','206497','206498','206499','206500','206501','206502','206503','206504','206505','206506','206507','206508','206509','206510','206511','206512','206513','206514','206515','206516','206517','206518','206519','206520','206521','206522','206523','206524','206525','206526','206527','206528','206529','206530','206531','206532','206533','206534','206535','206536','206537','206538','206539','206540','206541','206542','206543','206544','206545','206546','206547','206548','206549','206550','206551','206552','206553','206554','206555','206556','206557','206558','206559','206560','206561','206562','206563','206564','206565','206566','206567','206568','206569','206570','206571','206572','206573','206574','206575','206576','206577','206578','206579','206580','206581','206582','206583','206584','206585','206586','206587','206588','206589','206590','206591','206592','206593','206594','206595','206596','206597','206598','206599','206600','206601','206602','206603','206604','206605','206606','206607','206608','206609','206610','206611','206612','206613','206614','206615','206616','206617','206618','206619','206620','206621','206622','206623','206624','206625','206626','206627','206628','206629','206630','206631','206632','206633','206634','206635','206636','206637','206638','206639','215344','215349','215773','215846','215937','219718','232597','232647','232789','232795','238159','238161','238459','238591','238592','238626','238627','238686','238933','239103','239133','239147','239269','239270','239584','239590','239643','239727','239728','239740','239787','239833','239853','239995','240050','240279','240331','240406','240408','240473','240630','240692','240912','240913','241098','241369','241535','241536','241537','241622','241952','242584','242585','242661','242662','242787','243038','243073','243139','243403','243556','243583','243584','243585','243586','243587','243588','243589','243590','244251','244434','244435','244529','245207','245300','245314','245492','245558','245559','245599','245735','245780','245907','246016','246403','246887','246908','246924','246930','246937','246944','246945','246946','247016','247289','247572','247599','247787','248014','248266','248267','248268','248269','248270','248539','248540','248616','248675','248776','248793','248794','248819','249000','249114','249115','249279','249487','249678','249694','249732','249846','249904','250646','250694','250711','250713','250714','250741','250766','250768','250963','251156','251169','251249','251322','251379','251704','251829','252059','252112','252202','253325','254212','254226','254316','254317','254318','254560','254561','254562','254703','254706','254732','254734','254927','254928','254929','254988','255039','255152','255243','255290','255293','255462','255506','255630','255657','255701','255717','256085','256101','256117','256326','256327','256676','256718','257029','257032','257033','257058','257059','261703','261751','262796','262810','262836','262837','262838','262839','262840','262841','262842','262843','262844','262852','262885','262942','263002','263003','263004','263005','263008','263055','263077','263085','263493','263513','263646','264749','264823','264889','265155','265657','265678','265953','266044','266084','266085','266437','266480','266568','266993','267070','267155','267295','267614','268069','268214','268232','268233','268314','268370','268484','268574','268622','268693','268893','268899','269044','269077','269078','269081','269108','269181','269442','269491','269528','269629','273431','273467','273518','273618','273671','273768','273871','273885','273886','274139','274228','274321','274655','274782','274826','274913','275370','275684','276069','276070','276072','276282','276283','276290','276294','276480','276484','276514','276526','276596','276631','276632','276661','276664','276666','276805','276991','277016','277017','277018','277217','277270','277358','277719','277805','277806','277917','278138','278139','278140','278289','278481','278844','278898','279002','279084','279185','279226','279260','279348','279477','279560','279835','280400','280590','280947','280967','281001','281090','281186','281232','281340','281475','281681','281737','281794','281799','281800','281803','281812','282014','282015','282032','282033','282100','282101','282552','282825','282987','283053','283054','283089','283102','283611','283730','283803','283804','284354','284440','284724','284960','285120','285177','285178','285267','285408','285487','285501','285551','285659','285662','285681','285708','285709','285710','285813','285827','285887','285986','286105','286130','286134','286165','286199','286383','286388','286389','286390','286616','286622','286846','286981','287034','287037','287097','287174','288242','288289','288311','288370','288416','288845','288854','288952','291949','291950','292056','292507','292659','293265','293369','293374','293413','293414','293450','293613','293925','293941','294026','294067','294160','294162','294163','294164','294202','294245','294356','294380','294564','294777','294877','294955','295151','295339','295518','295519','295520','295521','295541','295607','295723','295818','295959','295961','295963','295965','296183','296196','297320','297420','297509','297641','297655','297779','297789','297999','298111','298147','298157','298187','298192','299043','299185','299217','299363','299368','299375','299399','299405','299528','299535','299627','299652','299676','299696','299894','299944','300352','300431','300616','300632','300673','301042','301043','301794','301945','302089','302110','302120','303799','303819','303920','303933') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: resistance
SELECT `resistance`,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 `resistance` !='' AND `modx_site_content`.`id` IN ('30','185','211','212','213','214','215','216','217','218','219','220','221','243','141351','141381','141383','141384','141423','141424','141501','141502','141660','141672','141716','141749','141757','141759','141793','141832','141833','141874','141875','141876','141877','141940','142027','142120','142836','142837','142849','142861','142862','142863','142919','142970','143061','143231','143243','143562','143610','143622','143623','143845','144229','146629','146860','146970','147091','147715','148062','148677','148746','149003','149004','149005','149006','149007','149008','149009','149010','149011','149012','149013','149014','149015','149016','149017','149018','149019','149020','149021','149022','149023','149024','149025','149026','149027','149028','149029','149030','149031','149032','149033','149034','149035','149036','149037','149038','149039','149040','149041','149042','149043','149044','149045','149046','149047','149048','149652','149690','149906','150612','150613','150641','150780','150781','150829','150979','151045','151300','151657','151670','151683','151688','151744','151862','151962','152551','152656','152664','153213','153566','153595','153596','153635','153774','153809','153824','153907','153937','154132','154133','154134','154329','154330','154450','154570','154740','154792','154831','154888','155014','155062','155071','155169','155170','155171','155172','155173','155175','155176','155177','155178','155179','155180','155181','155197','155198','155200','155201','155203','155204','155205','155206','155207','155209','155211','155213','155383','155384','155385','155386','155387','155388','155389','155390','155391','155392','155393','155394','155395','155396','155397','155398','155399','155400','155401','155402','155403','155404','155405','155406','155407','155466','155467','155468','155469','155473','155474','155524','155525','155526','155527','155528','155529','155530','155531','155532','155534','155535','155536','155548','155564','155565','155566','155567','155570','155571','155572','155573','155574','155575','155576','155577','155578','155579','155580','155581','155582','155583','155584','155585','155586','155589','155590','155591','155592','155593','155599','155600','155601','155605','155606','155607','155608','155610','155611','155612','155613','155614','155615','155616','155617','155618','155619','155620','155621','155622','155625','155626','155627','155628','155629','155630','155631','155638','155640','155641','155680','155786','155787','155788','155789','155790','155791','155792','155793','155794','155795','155796','155797','155798','155799','155800','155801','155802','155803','155804','155805','155806','155807','155808','155864','155865','155868','155869','155870','155871','156269','156634','157740','157814','157815','157816','157817','157818','158032','158056','158057','158179','158417','158537','158538','158576','158577','158670','158698','158752','158940','159000','159020','159139','159251','159265','159266','159683','159913','159917','160197','160230','160342','160402','160474','160488','160760','160926','161088','161089','161090','161091','161222','161611','161701','161823','161925','162175','162203','162442','162670','162699','162859','163153','163154','163569','163570','163571','163572','163574','163575','163576','163578','163579','163676','163757','163859','163942','163971','163989','163990','164233','164257','164261','164372','164403','164596','164624','164958','165000','165020','165131','165151','165152','165153','165154','165155','165156','165157','165636','165772','165872','165977','166057','166133','166774','166775','166855','166858','166928','167108','167137','167177','167178','167217','167315','167441','167484','167485','167486','167487','167585','167624','167625','167626','167630','167741','168226','168275','169821','170512','170522','170555','170678','170679','170786','170787','201146','201147','201259','201286','202668','202703','202714','202767','202860','206359','206360','206361','206362','206363','206364','206365','206366','206367','206368','206369','206370','206371','206372','206373','206374','206375','206376','206377','206378','206379','206380','206381','206382','206383','206384','206385','206386','206387','206388','206389','206390','206391','206392','206393','206394','206395','206396','206397','206398','206399','206400','206401','206402','206403','206404','206405','206406','206407','206408','206409','206410','206411','206412','206413','206414','206415','206416','206417','206418','206419','206420','206421','206422','206423','206424','206425','206426','206427','206428','206429','206430','206431','206432','206433','206434','206435','206436','206437','206438','206439','206440','206441','206442','206443','206444','206445','206446','206447','206448','206449','206450','206451','206452','206453','206454','206455','206456','206457','206458','206459','206460','206461','206462','206463','206464','206465','206466','206467','206468','206469','206470','206471','206472','206473','206474','206475','206476','206477','206478','206479','206480','206481','206482','206483','206484','206485','206486','206487','206488','206489','206490','206491','206492','206493','206494','206495','206496','206497','206498','206499','206500','206501','206502','206503','206504','206505','206506','206507','206508','206509','206510','206511','206512','206513','206514','206515','206516','206517','206518','206519','206520','206521','206522','206523','206524','206525','206526','206527','206528','206529','206530','206531','206532','206533','206534','206535','206536','206537','206538','206539','206540','206541','206542','206543','206544','206545','206546','206547','206548','206549','206550','206551','206552','206553','206554','206555','206556','206557','206558','206559','206560','206561','206562','206563','206564','206565','206566','206567','206568','206569','206570','206571','206572','206573','206574','206575','206576','206577','206578','206579','206580','206581','206582','206583','206584','206585','206586','206587','206588','206589','206590','206591','206592','206593','206594','206595','206596','206597','206598','206599','206600','206601','206602','206603','206604','206605','206606','206607','206608','206609','206610','206611','206612','206613','206614','206615','206616','206617','206618','206619','206620','206621','206622','206623','206624','206625','206626','206627','206628','206629','206630','206631','206632','206633','206634','206635','206636','206637','206638','206639','215344','215349','215773','215846','215937','219718','232597','232647','232789','232795','238159','238161','238459','238591','238592','238626','238627','238686','238933','239103','239133','239147','239269','239270','239584','239590','239643','239727','239728','239740','239787','239833','239853','239995','240050','240279','240331','240406','240408','240473','240630','240692','240912','240913','241098','241369','241535','241536','241537','241622','241952','242584','242585','242661','242662','242787','243038','243073','243139','243403','243556','243583','243584','243585','243586','243587','243588','243589','243590','244251','244434','244435','244529','245207','245300','245314','245492','245558','245559','245599','245735','245780','245907','246016','246403','246887','246908','246924','246930','246937','246944','246945','246946','247016','247289','247572','247599','247787','248014','248266','248267','248268','248269','248270','248539','248540','248616','248675','248776','248793','248794','248819','249000','249114','249115','249279','249487','249678','249694','249732','249846','249904','250646','250694','250711','250713','250714','250741','250766','250768','250963','251156','251169','251249','251322','251379','251704','251829','252059','252112','252202','253325','254212','254226','254316','254317','254318','254560','254561','254562','254703','254706','254732','254734','254927','254928','254929','254988','255039','255152','255243','255290','255293','255462','255506','255630','255657','255701','255717','256085','256101','256117','256326','256327','256676','256718','257029','257032','257033','257058','257059','261703','261751','262796','262810','262836','262837','262838','262839','262840','262841','262842','262843','262844','262852','262885','262942','263002','263003','263004','263005','263008','263055','263077','263085','263493','263513','263646','264749','264823','264889','265155','265657','265678','265953','266044','266084','266085','266437','266480','266568','266993','267070','267155','267295','267614','268069','268214','268232','268233','268314','268370','268484','268574','268622','268693','268893','268899','269044','269077','269078','269081','269108','269181','269442','269491','269528','269629','273431','273467','273518','273618','273671','273768','273871','273885','273886','274139','274228','274321','274655','274782','274826','274913','275370','275684','276069','276070','276072','276282','276283','276290','276294','276480','276484','276514','276526','276596','276631','276632','276661','276664','276666','276805','276991','277016','277017','277018','277217','277270','277358','277719','277805','277806','277917','278138','278139','278140','278289','278481','278844','278898','279002','279084','279185','279226','279260','279348','279477','279560','279835','280400','280590','280947','280967','281001','281090','281186','281232','281340','281475','281681','281737','281794','281799','281800','281803','281812','282014','282015','282032','282033','282100','282101','282552','282825','282987','283053','283054','283089','283102','283611','283730','283803','283804','284354','284440','284724','284960','285120','285177','285178','285267','285408','285487','285501','285551','285659','285662','285681','285708','285709','285710','285813','285827','285887','285986','286105','286130','286134','286165','286199','286383','286388','286389','286390','286616','286622','286846','286981','287034','287037','287097','287174','288242','288289','288311','288370','288416','288845','288854','288952','291949','291950','292056','292507','292659','293265','293369','293374','293413','293414','293450','293613','293925','293941','294026','294067','294160','294162','294163','294164','294202','294245','294356','294380','294564','294777','294877','294955','295151','295339','295518','295519','295520','295521','295541','295607','295723','295818','295959','295961','295963','295965','296183','296196','297320','297420','297509','297641','297655','297779','297789','297999','298111','298147','298157','298187','298192','299043','299185','299217','299363','299368','299375','299399','299405','299528','299535','299627','299652','299676','299696','299894','299944','300352','300431','300616','300632','300673','301042','301043','301794','301945','302089','302110','302120','303799','303819','303920','303933') GROUP BY `resistance` ORDER BY `resistance` ASC
childsstroke1: resistance
SELECT `resistance`,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 `resistance` !='' AND `modx_site_content`.`id` IN ('141351','141381','141383','141384','141423','141424','141501','141502','141660','141672','141716','141749','141757','141759','141793','141832','141833','141874','141875','141876','141877','141940','142027','142120','142836','142837','142849','142861','142862','142863','142919','142970','143061','143231','143243','143562','143610','143622','143623','143845','144229','146629','146860','146970','147091','147715','148062','148677','148746','149003','149004','149005','149006','149007','149008','149009','149010','149011','149012','149013','149014','149015','149016','149017','149018','149019','149020','149021','149022','149023','149024','149025','149026','149027','149028','149029','149030','149031','149032','149033','149034','149035','149036','149037','149038','149039','149040','149041','149042','149043','149044','149045','149046','149047','149048','149652','149690','149906','150612','150613','150641','150780','150781','150829','150979','151045','151300','151657','151670','151683','151688','151744','151862','151962','152551','152656','152664','153213','153566','153595','153596','153635','153774','153809','153824','153907','153937','154132','154133','154134','154329','154330','154450','154570','154740','154792','154831','154888','155014','155062','155071','155169','155170','155171','155172','155173','155175','155176','155177','155178','155179','155180','155181','155197','155198','155200','155201','155203','155204','155205','155206','155207','155209','155211','155213','155383','155384','155385','155386','155387','155388','155389','155390','155391','155392','155393','155394','155395','155396','155397','155398','155399','155400','155401','155402','155403','155404','155405','155406','155407','155466','155467','155468','155469','155473','155474','155524','155525','155526','155527','155528','155529','155530','155531','155532','155534','155535','155536','155548','155564','155565','155566','155567','155570','155571','155572','155573','155574','155575','155576','155577','155578','155579','155580','155581','155582','155583','155584','155585','155586','155589','155590','155591','155592','155593','155599','155600','155601','155605','155606','155607','155608','155610','155611','155612','155613','155614','155615','155616','155617','155618','155619','155620','155621','155622','155625','155626','155627','155628','155629','155630','155631','155638','155640','155641','155680','155786','155787','155788','155789','155790','155791','155792','155793','155794','155795','155796','155797','155798','155799','155800','155801','155802','155803','155804','155805','155806','155807','155808','155864','155865','155868','155869','155870','155871','156269','156634','157740','157814','157815','157816','157817','157818','158032','158056','158057','158179','158417','158537','158538','158576','158577','158670','158698','158752','158940','159000','159020','159139','159251','159265','159266','159683','159913','159917','160197','160230','160342','160402','160474','160488','160760','160926','161088','161089','161090','161091','161222','161611','161701','161823','161925','162175','162203','162442','162670','162699','162859','163153','163154','163569','163570','163571','163572','163574','163575','163576','163578','163579','163676','163757','163859','163942','163971','163989','163990','164233','164257','164261','164372','164403','164596','164624','164958','165000','165020','165131','165151','165152','165153','165154','165155','165156','165157','165636','165772','165872','165977','166057','166133','166774','166775','166855','166858','166928','167108','167137','167177','167178','167217','167315','167441','167484','167485','167486','167487','167585','167624','167625','167626','167630','167741','168226','168275','169821','170512','170522','170555','170678','170679','170786','170787','201146','201147','201259','201286','202668','202703','202714','202767','202860','206359','206360','206361','206362','206363','206364','206365','206366','206367','206368','206369','206370','206371','206372','206373','206374','206375','206376','206377','206378','206379','206380','206381','206382','206383','206384','206385','206386','206387','206388','206389','206390','206391','206392','206393','206394','206395','206396','206397','206398','206399','206400','206401','206402','206403','206404','206405','206406','206407','206408','206409','206410','206411','206412','206413','206414','206415','206416','206417','206418','206419','206420','206421','206422','206423','206424','206425','206426','206427','206428','206429','206430','206431','206432','206433','206434','206435','206436','206437','206438','206439','206440','206441','206442','206443','206444','206445','206446','206447','206448','206449','206450','206451','206452','206453','206454','206455','206456','206457','206458','206459','206460','206461','206462','206463','206464','206465','206466','206467','206468','206469','206470','206471','206472','206473','206474','206475','206476','206477','206478','206479','206480','206481','206482','206483','206484','206485','206486','206487','206488','206489','206490','206491','206492','206493','206494','206495','206496','206497','206498','206499','206500','206501','206502','206503','206504','206505','206506','206507','206508','206509','206510','206511','206512','206513','206514','206515','206516','206517','206518','206519','206520','206521','206522','206523','206524','206525','206526','206527','206528','206529','206530','206531','206532','206533','206534','206535','206536','206537','206538','206539','206540','206541','206542','206543','206544','206545','206546','206547','206548','206549','206550','206551','206552','206553','206554','206555','206556','206557','206558','206559','206560','206561','206562','206563','206564','206565','206566','206567','206568','206569','206570','206571','206572','206573','206574','206575','206576','206577','206578','206579','206580','206581','206582','206583','206584','206585','206586','206587','206588','206589','206590','206591','206592','206593','206594','206595','206596','206597','206598','206599','206600','206601','206602','206603','206604','206605','206606','206607','206608','206609','206610','206611','206612','206613','206614','206615','206616','206617','206618','206619','206620','206621','206622','206623','206624','206625','206626','206627','206628','206629','206630','206631','206632','206633','206634','206635','206636','206637','206638','206639','215344','215349','215773','215846','215937','219718','232597','232647','232789','232795','238159','238161','238459','238591','238592','238626','238627','238686','238933','239103','239133','239147','239269','239270','239584','239590','239643','239727','239728','239740','239787','239833','239853','239995','240050','240279','240331','240406','240408','240473','240630','240692','240912','240913','241098','241369','241535','241536','241537','241622','241952','242584','242585','242661','242662','242787','243038','243073','243139','243403','243556','243583','243584','243585','243586','243587','243588','243589','243590','244251','244434','244435','244529','245207','245300','245314','245492','245558','245559','245599','245735','245780','245907','246016','246403','246887','246908','246924','246930','246937','246944','246945','246946','247016','247289','247572','247599','247787','248014','248266','248267','248268','248269','248270','248539','248540','248616','248675','248776','248793','248794','248819','249000','249114','249115','249279','249487','249678','249694','249732','249846','249904','250646','250694','250711','250713','250714','250741','250766','250768','250963','251156','251169','251249','251322','251379','251704','251829','252059','252112','252202','253325','254212','254226','254316','254317','254318','254560','254561','254562','254703','254706','254732','254734','254927','254928','254929','254988','255039','255152','255243','255290','255293','255462','255506','255630','255657','255701','255717','256085','256101','256117','256326','256327','256676','256718','257029','257032','257033','257058','257059','261703','261751','262796','262810','262836','262837','262838','262839','262840','262841','262842','262843','262844','262852','262885','262942','263002','263003','263004','263005','263008','263055','263077','263085','263493','263513','263646','264749','264823','264889','265155','265657','265678','265953','266044','266084','266085','266437','266480','266568','266993','267070','267155','267295','267614','268069','268214','268232','268233','268314','268370','268484','268574','268622','268693','268893','268899','269044','269077','269078','269081','269108','269181','269442','269491','269528','269629','273431','273467','273518','273618','273671','273768','273871','273885','273886','274139','274228','274321','274655','274782','274826','274913','275370','275684','276069','276070','276072','276282','276283','276290','276294','276480','276484','276514','276526','276596','276631','276632','276661','276664','276666','276805','276991','277016','277017','277018','277217','277270','277358','277719','277805','277806','277917','278138','278139','278140','278289','278481','278844','278898','279002','279084','279185','279226','279260','279348','279477','279560','279835','280400','280590','280947','280967','281001','281090','281186','281232','281340','281475','281681','281737','281794','281799','281800','281803','281812','282014','282015','282032','282033','282100','282101','282552','282825','282987','283053','283054','283089','283102','283611','283730','283803','283804','284354','284440','284724','284960','285120','285177','285178','285267','285408','285487','285501','285551','285659','285662','285681','285708','285709','285710','285813','285827','285887','285986','286105','286130','286134','286165','286199','286383','286388','286389','286390','286616','286622','286846','286981','287034','287037','287097','287174','288242','288289','288311','288370','288416','288845','288854','288952','291949','291950','292056','292507','292659','293265','293369','293374','293413','293414','293450','293613','293925','293941','294026','294067','294160','294162','294163','294164','294202','294245','294356','294380','294564','294777','294877','294955','295151','295339','295518','295519','295520','295521','295541','295607','295723','295818','295959','295961','295963','295965','296183','296196','297320','297420','297509','297641','297655','297779','297789','297999','298111','298147','298157','298187','298192','299043','299185','299217','299363','299368','299375','299399','299405','299528','299535','299627','299652','299676','299696','299894','299944','300352','300431','300616','300632','300673','301042','301043','301794','301945','302089','302110','302120','303799','303819','303920','303933') GROUP BY `resistance` ORDER BY `resistance` ASC
childsstroke: resistance_unit
SELECT `resistance_unit`,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 `resistance_unit` !='' AND `modx_site_content`.`id` IN ('30','185','211','212','213','214','215','216','217','218','219','220','221','243','141351','141381','141383','141384','141423','141424','141501','141502','141660','141672','141716','141749','141757','141759','141793','141832','141833','141874','141875','141876','141877','141940','142027','142120','142836','142837','142849','142861','142862','142863','142919','142970','143061','143231','143243','143562','143610','143622','143623','143845','144229','146629','146860','146970','147091','147715','148062','148677','148746','149003','149004','149005','149006','149007','149008','149009','149010','149011','149012','149013','149014','149015','149016','149017','149018','149019','149020','149021','149022','149023','149024','149025','149026','149027','149028','149029','149030','149031','149032','149033','149034','149035','149036','149037','149038','149039','149040','149041','149042','149043','149044','149045','149046','149047','149048','149652','149690','149906','150612','150613','150641','150780','150781','150829','150979','151045','151300','151657','151670','151683','151688','151744','151862','151962','152551','152656','152664','153213','153566','153595','153596','153635','153774','153809','153824','153907','153937','154132','154133','154134','154329','154330','154450','154570','154740','154792','154831','154888','155014','155062','155071','155169','155170','155171','155172','155173','155175','155176','155177','155178','155179','155180','155181','155197','155198','155200','155201','155203','155204','155205','155206','155207','155209','155211','155213','155383','155384','155385','155386','155387','155388','155389','155390','155391','155392','155393','155394','155395','155396','155397','155398','155399','155400','155401','155402','155403','155404','155405','155406','155407','155466','155467','155468','155469','155473','155474','155524','155525','155526','155527','155528','155529','155530','155531','155532','155534','155535','155536','155548','155564','155565','155566','155567','155570','155571','155572','155573','155574','155575','155576','155577','155578','155579','155580','155581','155582','155583','155584','155585','155586','155589','155590','155591','155592','155593','155599','155600','155601','155605','155606','155607','155608','155610','155611','155612','155613','155614','155615','155616','155617','155618','155619','155620','155621','155622','155625','155626','155627','155628','155629','155630','155631','155638','155640','155641','155680','155786','155787','155788','155789','155790','155791','155792','155793','155794','155795','155796','155797','155798','155799','155800','155801','155802','155803','155804','155805','155806','155807','155808','155864','155865','155868','155869','155870','155871','156269','156634','157740','157814','157815','157816','157817','157818','158032','158056','158057','158179','158417','158537','158538','158576','158577','158670','158698','158752','158940','159000','159020','159139','159251','159265','159266','159683','159913','159917','160197','160230','160342','160402','160474','160488','160760','160926','161088','161089','161090','161091','161222','161611','161701','161823','161925','162175','162203','162442','162670','162699','162859','163153','163154','163569','163570','163571','163572','163574','163575','163576','163578','163579','163676','163757','163859','163942','163971','163989','163990','164233','164257','164261','164372','164403','164596','164624','164958','165000','165020','165131','165151','165152','165153','165154','165155','165156','165157','165636','165772','165872','165977','166057','166133','166774','166775','166855','166858','166928','167108','167137','167177','167178','167217','167315','167441','167484','167485','167486','167487','167585','167624','167625','167626','167630','167741','168226','168275','169821','170512','170522','170555','170678','170679','170786','170787','201146','201147','201259','201286','202668','202703','202714','202767','202860','206359','206360','206361','206362','206363','206364','206365','206366','206367','206368','206369','206370','206371','206372','206373','206374','206375','206376','206377','206378','206379','206380','206381','206382','206383','206384','206385','206386','206387','206388','206389','206390','206391','206392','206393','206394','206395','206396','206397','206398','206399','206400','206401','206402','206403','206404','206405','206406','206407','206408','206409','206410','206411','206412','206413','206414','206415','206416','206417','206418','206419','206420','206421','206422','206423','206424','206425','206426','206427','206428','206429','206430','206431','206432','206433','206434','206435','206436','206437','206438','206439','206440','206441','206442','206443','206444','206445','206446','206447','206448','206449','206450','206451','206452','206453','206454','206455','206456','206457','206458','206459','206460','206461','206462','206463','206464','206465','206466','206467','206468','206469','206470','206471','206472','206473','206474','206475','206476','206477','206478','206479','206480','206481','206482','206483','206484','206485','206486','206487','206488','206489','206490','206491','206492','206493','206494','206495','206496','206497','206498','206499','206500','206501','206502','206503','206504','206505','206506','206507','206508','206509','206510','206511','206512','206513','206514','206515','206516','206517','206518','206519','206520','206521','206522','206523','206524','206525','206526','206527','206528','206529','206530','206531','206532','206533','206534','206535','206536','206537','206538','206539','206540','206541','206542','206543','206544','206545','206546','206547','206548','206549','206550','206551','206552','206553','206554','206555','206556','206557','206558','206559','206560','206561','206562','206563','206564','206565','206566','206567','206568','206569','206570','206571','206572','206573','206574','206575','206576','206577','206578','206579','206580','206581','206582','206583','206584','206585','206586','206587','206588','206589','206590','206591','206592','206593','206594','206595','206596','206597','206598','206599','206600','206601','206602','206603','206604','206605','206606','206607','206608','206609','206610','206611','206612','206613','206614','206615','206616','206617','206618','206619','206620','206621','206622','206623','206624','206625','206626','206627','206628','206629','206630','206631','206632','206633','206634','206635','206636','206637','206638','206639','215344','215349','215773','215846','215937','219718','232597','232647','232789','232795','238159','238161','238459','238591','238592','238626','238627','238686','238933','239103','239133','239147','239269','239270','239584','239590','239643','239727','239728','239740','239787','239833','239853','239995','240050','240279','240331','240406','240408','240473','240630','240692','240912','240913','241098','241369','241535','241536','241537','241622','241952','242584','242585','242661','242662','242787','243038','243073','243139','243403','243556','243583','243584','243585','243586','243587','243588','243589','243590','244251','244434','244435','244529','245207','245300','245314','245492','245558','245559','245599','245735','245780','245907','246016','246403','246887','246908','246924','246930','246937','246944','246945','246946','247016','247289','247572','247599','247787','248014','248266','248267','248268','248269','248270','248539','248540','248616','248675','248776','248793','248794','248819','249000','249114','249115','249279','249487','249678','249694','249732','249846','249904','250646','250694','250711','250713','250714','250741','250766','250768','250963','251156','251169','251249','251322','251379','251704','251829','252059','252112','252202','253325','254212','254226','254316','254317','254318','254560','254561','254562','254703','254706','254732','254734','254927','254928','254929','254988','255039','255152','255243','255290','255293','255462','255506','255630','255657','255701','255717','256085','256101','256117','256326','256327','256676','256718','257029','257032','257033','257058','257059','261703','261751','262796','262810','262836','262837','262838','262839','262840','262841','262842','262843','262844','262852','262885','262942','263002','263003','263004','263005','263008','263055','263077','263085','263493','263513','263646','264749','264823','264889','265155','265657','265678','265953','266044','266084','266085','266437','266480','266568','266993','267070','267155','267295','267614','268069','268214','268232','268233','268314','268370','268484','268574','268622','268693','268893','268899','269044','269077','269078','269081','269108','269181','269442','269491','269528','269629','273431','273467','273518','273618','273671','273768','273871','273885','273886','274139','274228','274321','274655','274782','274826','274913','275370','275684','276069','276070','276072','276282','276283','276290','276294','276480','276484','276514','276526','276596','276631','276632','276661','276664','276666','276805','276991','277016','277017','277018','277217','277270','277358','277719','277805','277806','277917','278138','278139','278140','278289','278481','278844','278898','279002','279084','279185','279226','279260','279348','279477','279560','279835','280400','280590','280947','280967','281001','281090','281186','281232','281340','281475','281681','281737','281794','281799','281800','281803','281812','282014','282015','282032','282033','282100','282101','282552','282825','282987','283053','283054','283089','283102','283611','283730','283803','283804','284354','284440','284724','284960','285120','285177','285178','285267','285408','285487','285501','285551','285659','285662','285681','285708','285709','285710','285813','285827','285887','285986','286105','286130','286134','286165','286199','286383','286388','286389','286390','286616','286622','286846','286981','287034','287037','287097','287174','288242','288289','288311','288370','288416','288845','288854','288952','291949','291950','292056','292507','292659','293265','293369','293374','293413','293414','293450','293613','293925','293941','294026','294067','294160','294162','294163','294164','294202','294245','294356','294380','294564','294777','294877','294955','295151','295339','295518','295519','295520','295521','295541','295607','295723','295818','295959','295961','295963','295965','296183','296196','297320','297420','297509','297641','297655','297779','297789','297999','298111','298147','298157','298187','298192','299043','299185','299217','299363','299368','299375','299399','299405','299528','299535','299627','299652','299676','299696','299894','299944','300352','300431','300616','300632','300673','301042','301043','301794','301945','302089','302110','302120','303799','303819','303920','303933') GROUP BY `resistance_unit` ORDER BY `resistance_unit` ASC
childsstroke1: resistance_unit
SELECT `resistance_unit`,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 `resistance_unit` !='' AND `modx_site_content`.`id` IN ('141351','141381','141383','141384','141423','141424','141501','141502','141660','141672','141716','141749','141757','141759','141793','141832','141833','141874','141875','141876','141877','141940','142027','142120','142836','142837','142849','142861','142862','142863','142919','142970','143061','143231','143243','143562','143610','143622','143623','143845','144229','146629','146860','146970','147091','147715','148062','148677','148746','149003','149004','149005','149006','149007','149008','149009','149010','149011','149012','149013','149014','149015','149016','149017','149018','149019','149020','149021','149022','149023','149024','149025','149026','149027','149028','149029','149030','149031','149032','149033','149034','149035','149036','149037','149038','149039','149040','149041','149042','149043','149044','149045','149046','149047','149048','149652','149690','149906','150612','150613','150641','150780','150781','150829','150979','151045','151300','151657','151670','151683','151688','151744','151862','151962','152551','152656','152664','153213','153566','153595','153596','153635','153774','153809','153824','153907','153937','154132','154133','154134','154329','154330','154450','154570','154740','154792','154831','154888','155014','155062','155071','155169','155170','155171','155172','155173','155175','155176','155177','155178','155179','155180','155181','155197','155198','155200','155201','155203','155204','155205','155206','155207','155209','155211','155213','155383','155384','155385','155386','155387','155388','155389','155390','155391','155392','155393','155394','155395','155396','155397','155398','155399','155400','155401','155402','155403','155404','155405','155406','155407','155466','155467','155468','155469','155473','155474','155524','155525','155526','155527','155528','155529','155530','155531','155532','155534','155535','155536','155548','155564','155565','155566','155567','155570','155571','155572','155573','155574','155575','155576','155577','155578','155579','155580','155581','155582','155583','155584','155585','155586','155589','155590','155591','155592','155593','155599','155600','155601','155605','155606','155607','155608','155610','155611','155612','155613','155614','155615','155616','155617','155618','155619','155620','155621','155622','155625','155626','155627','155628','155629','155630','155631','155638','155640','155641','155680','155786','155787','155788','155789','155790','155791','155792','155793','155794','155795','155796','155797','155798','155799','155800','155801','155802','155803','155804','155805','155806','155807','155808','155864','155865','155868','155869','155870','155871','156269','156634','157740','157814','157815','157816','157817','157818','158032','158056','158057','158179','158417','158537','158538','158576','158577','158670','158698','158752','158940','159000','159020','159139','159251','159265','159266','159683','159913','159917','160197','160230','160342','160402','160474','160488','160760','160926','161088','161089','161090','161091','161222','161611','161701','161823','161925','162175','162203','162442','162670','162699','162859','163153','163154','163569','163570','163571','163572','163574','163575','163576','163578','163579','163676','163757','163859','163942','163971','163989','163990','164233','164257','164261','164372','164403','164596','164624','164958','165000','165020','165131','165151','165152','165153','165154','165155','165156','165157','165636','165772','165872','165977','166057','166133','166774','166775','166855','166858','166928','167108','167137','167177','167178','167217','167315','167441','167484','167485','167486','167487','167585','167624','167625','167626','167630','167741','168226','168275','169821','170512','170522','170555','170678','170679','170786','170787','201146','201147','201259','201286','202668','202703','202714','202767','202860','206359','206360','206361','206362','206363','206364','206365','206366','206367','206368','206369','206370','206371','206372','206373','206374','206375','206376','206377','206378','206379','206380','206381','206382','206383','206384','206385','206386','206387','206388','206389','206390','206391','206392','206393','206394','206395','206396','206397','206398','206399','206400','206401','206402','206403','206404','206405','206406','206407','206408','206409','206410','206411','206412','206413','206414','206415','206416','206417','206418','206419','206420','206421','206422','206423','206424','206425','206426','206427','206428','206429','206430','206431','206432','206433','206434','206435','206436','206437','206438','206439','206440','206441','206442','206443','206444','206445','206446','206447','206448','206449','206450','206451','206452','206453','206454','206455','206456','206457','206458','206459','206460','206461','206462','206463','206464','206465','206466','206467','206468','206469','206470','206471','206472','206473','206474','206475','206476','206477','206478','206479','206480','206481','206482','206483','206484','206485','206486','206487','206488','206489','206490','206491','206492','206493','206494','206495','206496','206497','206498','206499','206500','206501','206502','206503','206504','206505','206506','206507','206508','206509','206510','206511','206512','206513','206514','206515','206516','206517','206518','206519','206520','206521','206522','206523','206524','206525','206526','206527','206528','206529','206530','206531','206532','206533','206534','206535','206536','206537','206538','206539','206540','206541','206542','206543','206544','206545','206546','206547','206548','206549','206550','206551','206552','206553','206554','206555','206556','206557','206558','206559','206560','206561','206562','206563','206564','206565','206566','206567','206568','206569','206570','206571','206572','206573','206574','206575','206576','206577','206578','206579','206580','206581','206582','206583','206584','206585','206586','206587','206588','206589','206590','206591','206592','206593','206594','206595','206596','206597','206598','206599','206600','206601','206602','206603','206604','206605','206606','206607','206608','206609','206610','206611','206612','206613','206614','206615','206616','206617','206618','206619','206620','206621','206622','206623','206624','206625','206626','206627','206628','206629','206630','206631','206632','206633','206634','206635','206636','206637','206638','206639','215344','215349','215773','215846','215937','219718','232597','232647','232789','232795','238159','238161','238459','238591','238592','238626','238627','238686','238933','239103','239133','239147','239269','239270','239584','239590','239643','239727','239728','239740','239787','239833','239853','239995','240050','240279','240331','240406','240408','240473','240630','240692','240912','240913','241098','241369','241535','241536','241537','241622','241952','242584','242585','242661','242662','242787','243038','243073','243139','243403','243556','243583','243584','243585','243586','243587','243588','243589','243590','244251','244434','244435','244529','245207','245300','245314','245492','245558','245559','245599','245735','245780','245907','246016','246403','246887','246908','246924','246930','246937','246944','246945','246946','247016','247289','247572','247599','247787','248014','248266','248267','248268','248269','248270','248539','248540','248616','248675','248776','248793','248794','248819','249000','249114','249115','249279','249487','249678','249694','249732','249846','249904','250646','250694','250711','250713','250714','250741','250766','250768','250963','251156','251169','251249','251322','251379','251704','251829','252059','252112','252202','253325','254212','254226','254316','254317','254318','254560','254561','254562','254703','254706','254732','254734','254927','254928','254929','254988','255039','255152','255243','255290','255293','255462','255506','255630','255657','255701','255717','256085','256101','256117','256326','256327','256676','256718','257029','257032','257033','257058','257059','261703','261751','262796','262810','262836','262837','262838','262839','262840','262841','262842','262843','262844','262852','262885','262942','263002','263003','263004','263005','263008','263055','263077','263085','263493','263513','263646','264749','264823','264889','265155','265657','265678','265953','266044','266084','266085','266437','266480','266568','266993','267070','267155','267295','267614','268069','268214','268232','268233','268314','268370','268484','268574','268622','268693','268893','268899','269044','269077','269078','269081','269108','269181','269442','269491','269528','269629','273431','273467','273518','273618','273671','273768','273871','273885','273886','274139','274228','274321','274655','274782','274826','274913','275370','275684','276069','276070','276072','276282','276283','276290','276294','276480','276484','276514','276526','276596','276631','276632','276661','276664','276666','276805','276991','277016','277017','277018','277217','277270','277358','277719','277805','277806','277917','278138','278139','278140','278289','278481','278844','278898','279002','279084','279185','279226','279260','279348','279477','279560','279835','280400','280590','280947','280967','281001','281090','281186','281232','281340','281475','281681','281737','281794','281799','281800','281803','281812','282014','282015','282032','282033','282100','282101','282552','282825','282987','283053','283054','283089','283102','283611','283730','283803','283804','284354','284440','284724','284960','285120','285177','285178','285267','285408','285487','285501','285551','285659','285662','285681','285708','285709','285710','285813','285827','285887','285986','286105','286130','286134','286165','286199','286383','286388','286389','286390','286616','286622','286846','286981','287034','287037','287097','287174','288242','288289','288311','288370','288416','288845','288854','288952','291949','291950','292056','292507','292659','293265','293369','293374','293413','293414','293450','293613','293925','293941','294026','294067','294160','294162','294163','294164','294202','294245','294356','294380','294564','294777','294877','294955','295151','295339','295518','295519','295520','295521','295541','295607','295723','295818','295959','295961','295963','295965','296183','296196','297320','297420','297509','297641','297655','297779','297789','297999','298111','298147','298157','298187','298192','299043','299185','299217','299363','299368','299375','299399','299405','299528','299535','299627','299652','299676','299696','299894','299944','300352','300431','300616','300632','300673','301042','301043','301794','301945','302089','302110','302120','303799','303819','303920','303933') GROUP BY `resistance_unit` ORDER BY `resistance_unit` ASC