childsstroke: stock_status
SELECT `stock_status`,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 `stock_status` !='' AND `modx_site_content`.`id` IN ('152874','153196','153197','153583','153589','153626','153664','153826','153867','154159','154191','154473','154521','154534','154535','154536','154578','154668','154728','154729','154808','154820','154896','154897','154914','154915','154916','154917','154918','154919','154920','154921','154922','154923','154924','154925','154926','154927','154942','154974','154977','154982','154983','154984','154985','154986','154994','154995','154996','154997','155072','155185','155229','155232','155234','155236','155245','155252','155276','155306','155307','155318','155319','155320','155321','155322','155323','155324','155325','155350','155495','155684','155711','155712','155713','155714','155715','155760','156632','157515','157517','157593','157820','157821','157836','158025','158229','158273','158274','158348','158349','158368','158369','158370','158456','158457','158458','158466','158467','158468','158469','158686','158687','158695','158696','158697','158726','158727','158728','158729','158730','158731','158863','158933','158934','158935','158978','158980','158982','158997','159091','159100','159109','159157','159170','159275','159319','159320','159321','159324','159325','159372','159425','159426','159427','159428','159438','159473','159531','159532','159533','159535','159536','159537','159550','159555','159556','159614','159615','159616','159617','159618','159619','159631','159665','159699','159700','159701','159702','159703','159753','159775','159776','159832','159922','159923','159925','159926','159927','159928','159931','159932','159933','159936','159937','159938','159939','159940','159941','159942','159943','159944','160010','160011','160012','160013','160014','160015','160039','160040','160041','160042','160060','160172','160182','160308','160309','160376','160405','160406','160428','160511','160555','160855','160916','160968','160989','160990','161039','161402','161672','161729','161795','161838','161896','162120','162150','162151','162171','162198','162234','162275','162303','162376','162377','162489','162533','162546','162594','162604','162663','162694','162710','162711','162750','162813','162878','162879','162881','162903','163106','163107','163236','163264','163265','163266','163267','163268','163269','163270','163271','163272','163273','163274','163275','163276','163318','163325','163364','163460','163461','163462','163500','163589','163647','163649','163808','163809','163810','163811','163812','163829','163830','163984','164030','164031','164032','164033','164034','164043','164068','164122','164123','164125','164218','164219','164220','164221','164222','164223','164224','164226','164232','164500','164597','164602','164603','164604','164605','164606','164607','164608','164609','164610','164611','164612','164613','164614','164615','164616','164617','164618','164619','164620','164621','164622','164623','164640','164641','165308','165309','165310','165311','165312','165313','165314','165315','165316','165317','165318','165319','165320','165321','165322','165323','165330','165339','165340','165341','165349','165350','165606','165651','165664','165705','165752','165753','165756','165757','165758','165759','165760','165761','166074','166088','166089','166289','166327','166457','166458','166459','166460','166461','166462','166463','166464','166465','166466','166467','166468','166469','166470','166537','166541','166608','166616','166621','166703','166704','166709','166716','166859','166956','166974','166986','166987','166996','167074','167145','167159','167165','167176','167209','167242','167243','167261','167299','167302','167317','167345','167364','167369','167407','167410','167411','167563','167890','167891','167892','167929','167965','168170','168222','168223','168224','168265','168273','168274','168314','232558','232610','232624','232625','232626','232627','232628','232730','238389','238466','238484','238495','238510','238564','238565','238649','238651','239249','239716','239890','239891','240211','240310','240311','240437','240486','240624','240745','240753','240764','240765','240889','240938','240939','240983','240984','240987','241461','241497','241554','241590','241591','241593','241719','241766','241911','241941','241973','241976','241977','242054','242055','242184','242185','242186','242187','242188','242189','242190','242191','242192','242193','242194','242195','242196','242197','242327','242328','242541','242542','242543','242647','242731','242732','242733','242734','243300','243314','243374','243616','243956','244107','244298','244312','244315','244320','244445','244447','244448','244452','245092','245317','245319','245321','245385','245473','245626','245951','245958','245979','246035','246038','246039','246040','246226','246255','246256','246342','246414','246607','246651','246745','246755','246793','246794','246875','246991','247258','247266','247593','247699','247743','247765','247917','247977','248396','248427','248582','248621','248935','248936','248937','248938','248961','249022','249023','249148','249230','249361','249362','249414','249475','249506','249565','249582','249628','249735','249910','250160','250206','250217','250255','250273','250689','250691','250709','250731','250732','250733','250895','250928','250929','251164','251165','251166','251167','251168','251245','251246','251256','251426','251491','251492','251563','251564','251565','251566','251578','251621','251622','251642','251656','251667','251680','251748','251749','251750','251751','251808','251809','251810','251811','251988','252069','252097','252113','252114','252115','252116','252117','252194','252195','253168','253169','253170','253171','253172','253173','253174','253175','253176','253177','253178','253264','253462','253502','253508','253563','253620','253652','253712','253744','253746','253769','253819','253820','253844','253912','254325','254401','254414','254422','254476','254484','254520','254621','254622','254728','254729','254743','254785','254786','254787','254788','254789','254888','255019','255125','255316','255333','255750','255778','255784','255785','255794','256000','256072','256073','256257','256320','256460','256513','256514','256568','256733','261722','261742','262180','262558','262610','262920','264680','264913','265049','265765','265769','265781','265909','266039','266340','266341','266342','266390','266492','266539','266702','266774','267100','267390','267953','268318','268356','268468','268728','268767','268811','269162','269509','269756','273480','273568','273635','273810','273865','273866','273874','273875','273876','273878','273880','273881','274461','274462','274463','274464','274465','274466','274467','274893','275035','275036','275192','275360','275418','275550','275831','278643','280900','280903','281188','281341','281787','281788','282823','284218','284324','284462','284825','284861','284882','285236','286074','286075','286838','286944','286976','287134','287135','288075','288386','288488','288491','288716','291836','291837','292619','294285','298212','299818') GROUP BY `stock_status` ORDER BY `stock_status` ASC
childsstroke1: stock_status
SELECT `stock_status`,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 `stock_status` !='' AND `modx_site_content`.`id` IN ('152874','153196','153197','153583','153589','153626','153664','153826','153867','154159','154191','154473','154521','154534','154535','154536','154578','154668','154728','154729','154808','154820','154896','154897','154914','154915','154916','154917','154918','154919','154920','154921','154922','154923','154924','154925','154926','154927','154942','154974','154977','154982','154983','154984','154985','154986','154994','154995','154996','154997','155072','155185','155229','155232','155234','155236','155245','155252','155276','155306','155307','155318','155319','155320','155321','155322','155323','155324','155325','155350','155495','155684','155711','155712','155713','155714','155715','155760','156632','157515','157517','157593','157820','157821','157836','158025','158229','158273','158274','158348','158349','158368','158369','158370','158456','158457','158458','158466','158467','158468','158469','158686','158687','158695','158696','158697','158726','158727','158728','158729','158730','158731','158863','158933','158934','158935','158978','158980','158982','158997','159091','159100','159109','159157','159170','159275','159319','159320','159321','159324','159325','159372','159425','159426','159427','159428','159438','159473','159531','159532','159533','159535','159536','159537','159550','159555','159556','159614','159615','159616','159617','159618','159619','159631','159665','159699','159700','159701','159702','159703','159753','159775','159776','159832','159922','159923','159925','159926','159927','159928','159931','159932','159933','159936','159937','159938','159939','159940','159941','159942','159943','159944','160010','160011','160012','160013','160014','160015','160039','160040','160041','160042','160060','160172','160182','160308','160309','160376','160405','160406','160428','160511','160555','160855','160916','160968','160989','160990','161039','161402','161672','161729','161795','161838','161896','162120','162150','162151','162171','162198','162234','162275','162303','162376','162377','162489','162533','162546','162594','162604','162663','162694','162710','162711','162750','162813','162878','162879','162881','162903','163106','163107','163236','163264','163265','163266','163267','163268','163269','163270','163271','163272','163273','163274','163275','163276','163318','163325','163364','163460','163461','163462','163500','163589','163647','163649','163808','163809','163810','163811','163812','163829','163830','163984','164030','164031','164032','164033','164034','164043','164068','164122','164123','164125','164218','164219','164220','164221','164222','164223','164224','164226','164232','164500','164597','164602','164603','164604','164605','164606','164607','164608','164609','164610','164611','164612','164613','164614','164615','164616','164617','164618','164619','164620','164621','164622','164623','164640','164641','165308','165309','165310','165311','165312','165313','165314','165315','165316','165317','165318','165319','165320','165321','165322','165323','165330','165339','165340','165341','165349','165350','165606','165651','165664','165705','165752','165753','165756','165757','165758','165759','165760','165761','166074','166088','166089','166289','166327','166457','166458','166459','166460','166461','166462','166463','166464','166465','166466','166467','166468','166469','166470','166537','166541','166608','166616','166621','166703','166704','166709','166716','166859','166956','166974','166986','166987','166996','167074','167145','167159','167165','167176','167209','167242','167243','167261','167299','167302','167317','167345','167364','167369','167407','167410','167411','167563','167890','167891','167892','167929','167965','168170','168222','168223','168224','168265','168273','168274','168314','232558','232610','232624','232625','232626','232627','232628','232730','238389','238466','238484','238495','238510','238564','238565','238649','238651','239249','239716','239890','239891','240211','240310','240311','240437','240486','240624','240745','240753','240764','240765','240889','240938','240939','240983','240984','240987','241461','241497','241554','241590','241591','241593','241719','241766','241911','241941','241973','241976','241977','242054','242055','242184','242185','242186','242187','242188','242189','242190','242191','242192','242193','242194','242195','242196','242197','242327','242328','242541','242542','242543','242647','242731','242732','242733','242734','243300','243314','243374','243616','243956','244107','244298','244312','244315','244320','244445','244447','244448','244452','245092','245317','245319','245321','245385','245473','245626','245951','245958','245979','246035','246038','246039','246040','246226','246255','246256','246342','246414','246607','246651','246745','246755','246793','246794','246875','246991','247258','247266','247593','247699','247743','247765','247917','247977','248396','248427','248582','248621','248935','248936','248937','248938','248961','249022','249023','249148','249230','249361','249362','249414','249475','249506','249565','249582','249628','249735','249910','250160','250206','250217','250255','250273','250689','250691','250709','250731','250732','250733','250895','250928','250929','251164','251165','251166','251167','251168','251245','251246','251256','251426','251491','251492','251563','251564','251565','251566','251578','251621','251622','251642','251656','251667','251680','251748','251749','251750','251751','251808','251809','251810','251811','251988','252069','252097','252113','252114','252115','252116','252117','252194','252195','253168','253169','253170','253171','253172','253173','253174','253175','253176','253177','253178','253264','253462','253502','253508','253563','253620','253652','253712','253744','253746','253769','253819','253820','253844','253912','254325','254401','254414','254422','254476','254484','254520','254621','254622','254728','254729','254743','254785','254786','254787','254788','254789','254888','255019','255125','255316','255333','255750','255778','255784','255785','255794','256000','256072','256073','256257','256320','256460','256513','256514','256568','256733','261722','261742','262180','262558','262610','262920','264680','264913','265049','265765','265769','265781','265909','266039','266340','266341','266342','266390','266492','266539','266702','266774','267100','267390','267953','268318','268356','268468','268728','268767','268811','269162','269509','269756','273480','273568','273635','273810','273865','273866','273874','273875','273876','273878','273880','273881','274461','274462','274463','274464','274465','274466','274467','274893','275035','275036','275192','275360','275418','275550','275831','278643','280900','280903','281188','281341','281787','281788','282823','284218','284324','284462','284825','284861','284882','285236','286074','286075','286838','286944','286976','287134','287135','288075','288386','288488','288491','288716','291836','291837','292619','294285','298212','299818') GROUP BY `stock_status` ORDER BY `stock_status` ASC
childsstroke: parent
SELECT `parent`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `parent` !='' AND `modx_site_content`.`id` IN ('152874','153196','153197','153583','153589','153626','153664','153826','153867','154159','154191','154473','154521','154534','154535','154536','154578','154668','154728','154729','154808','154820','154896','154897','154914','154915','154916','154917','154918','154919','154920','154921','154922','154923','154924','154925','154926','154927','154942','154974','154977','154982','154983','154984','154985','154986','154994','154995','154996','154997','155072','155185','155229','155232','155234','155236','155245','155252','155276','155306','155307','155318','155319','155320','155321','155322','155323','155324','155325','155350','155495','155684','155711','155712','155713','155714','155715','155760','156632','157515','157517','157593','157820','157821','157836','158025','158229','158273','158274','158348','158349','158368','158369','158370','158456','158457','158458','158466','158467','158468','158469','158686','158687','158695','158696','158697','158726','158727','158728','158729','158730','158731','158863','158933','158934','158935','158978','158980','158982','158997','159091','159100','159109','159157','159170','159275','159319','159320','159321','159324','159325','159372','159425','159426','159427','159428','159438','159473','159531','159532','159533','159535','159536','159537','159550','159555','159556','159614','159615','159616','159617','159618','159619','159631','159665','159699','159700','159701','159702','159703','159753','159775','159776','159832','159922','159923','159925','159926','159927','159928','159931','159932','159933','159936','159937','159938','159939','159940','159941','159942','159943','159944','160010','160011','160012','160013','160014','160015','160039','160040','160041','160042','160060','160172','160182','160308','160309','160376','160405','160406','160428','160511','160555','160855','160916','160968','160989','160990','161039','161402','161672','161729','161795','161838','161896','162120','162150','162151','162171','162198','162234','162275','162303','162376','162377','162489','162533','162546','162594','162604','162663','162694','162710','162711','162750','162813','162878','162879','162881','162903','163106','163107','163236','163264','163265','163266','163267','163268','163269','163270','163271','163272','163273','163274','163275','163276','163318','163325','163364','163460','163461','163462','163500','163589','163647','163649','163808','163809','163810','163811','163812','163829','163830','163984','164030','164031','164032','164033','164034','164043','164068','164122','164123','164125','164218','164219','164220','164221','164222','164223','164224','164226','164232','164500','164597','164602','164603','164604','164605','164606','164607','164608','164609','164610','164611','164612','164613','164614','164615','164616','164617','164618','164619','164620','164621','164622','164623','164640','164641','165308','165309','165310','165311','165312','165313','165314','165315','165316','165317','165318','165319','165320','165321','165322','165323','165330','165339','165340','165341','165349','165350','165606','165651','165664','165705','165752','165753','165756','165757','165758','165759','165760','165761','166074','166088','166089','166289','166327','166457','166458','166459','166460','166461','166462','166463','166464','166465','166466','166467','166468','166469','166470','166537','166541','166608','166616','166621','166703','166704','166709','166716','166859','166956','166974','166986','166987','166996','167074','167145','167159','167165','167176','167209','167242','167243','167261','167299','167302','167317','167345','167364','167369','167407','167410','167411','167563','167890','167891','167892','167929','167965','168170','168222','168223','168224','168265','168273','168274','168314','232558','232610','232624','232625','232626','232627','232628','232730','238389','238466','238484','238495','238510','238564','238565','238649','238651','239249','239716','239890','239891','240211','240310','240311','240437','240486','240624','240745','240753','240764','240765','240889','240938','240939','240983','240984','240987','241461','241497','241554','241590','241591','241593','241719','241766','241911','241941','241973','241976','241977','242054','242055','242184','242185','242186','242187','242188','242189','242190','242191','242192','242193','242194','242195','242196','242197','242327','242328','242541','242542','242543','242647','242731','242732','242733','242734','243300','243314','243374','243616','243956','244107','244298','244312','244315','244320','244445','244447','244448','244452','245092','245317','245319','245321','245385','245473','245626','245951','245958','245979','246035','246038','246039','246040','246226','246255','246256','246342','246414','246607','246651','246745','246755','246793','246794','246875','246991','247258','247266','247593','247699','247743','247765','247917','247977','248396','248427','248582','248621','248935','248936','248937','248938','248961','249022','249023','249148','249230','249361','249362','249414','249475','249506','249565','249582','249628','249735','249910','250160','250206','250217','250255','250273','250689','250691','250709','250731','250732','250733','250895','250928','250929','251164','251165','251166','251167','251168','251245','251246','251256','251426','251491','251492','251563','251564','251565','251566','251578','251621','251622','251642','251656','251667','251680','251748','251749','251750','251751','251808','251809','251810','251811','251988','252069','252097','252113','252114','252115','252116','252117','252194','252195','253168','253169','253170','253171','253172','253173','253174','253175','253176','253177','253178','253264','253462','253502','253508','253563','253620','253652','253712','253744','253746','253769','253819','253820','253844','253912','254325','254401','254414','254422','254476','254484','254520','254621','254622','254728','254729','254743','254785','254786','254787','254788','254789','254888','255019','255125','255316','255333','255750','255778','255784','255785','255794','256000','256072','256073','256257','256320','256460','256513','256514','256568','256733','261722','261742','262180','262558','262610','262920','264680','264913','265049','265765','265769','265781','265909','266039','266340','266341','266342','266390','266492','266539','266702','266774','267100','267390','267953','268318','268356','268468','268728','268767','268811','269162','269509','269756','273480','273568','273635','273810','273865','273866','273874','273875','273876','273878','273880','273881','274461','274462','274463','274464','274465','274466','274467','274893','275035','275036','275192','275360','275418','275550','275831','278643','280900','280903','281188','281341','281787','281788','282823','284218','284324','284462','284825','284861','284882','285236','286074','286075','286838','286944','286976','287134','287135','288075','288386','288488','288491','288716','291836','291837','292619','294285','298212','299818') GROUP BY `parent` ORDER BY `parent` ASC
childsstroke1: parent
SELECT `parent`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `parent` !='' AND `modx_site_content`.`id` IN ('152874','153196','153197','153583','153589','153626','153664','153826','153867','154159','154191','154473','154521','154534','154535','154536','154578','154668','154728','154729','154808','154820','154896','154897','154914','154915','154916','154917','154918','154919','154920','154921','154922','154923','154924','154925','154926','154927','154942','154974','154977','154982','154983','154984','154985','154986','154994','154995','154996','154997','155072','155185','155229','155232','155234','155236','155245','155252','155276','155306','155307','155318','155319','155320','155321','155322','155323','155324','155325','155350','155495','155684','155711','155712','155713','155714','155715','155760','156632','157515','157517','157593','157820','157821','157836','158025','158229','158273','158274','158348','158349','158368','158369','158370','158456','158457','158458','158466','158467','158468','158469','158686','158687','158695','158696','158697','158726','158727','158728','158729','158730','158731','158863','158933','158934','158935','158978','158980','158982','158997','159091','159100','159109','159157','159170','159275','159319','159320','159321','159324','159325','159372','159425','159426','159427','159428','159438','159473','159531','159532','159533','159535','159536','159537','159550','159555','159556','159614','159615','159616','159617','159618','159619','159631','159665','159699','159700','159701','159702','159703','159753','159775','159776','159832','159922','159923','159925','159926','159927','159928','159931','159932','159933','159936','159937','159938','159939','159940','159941','159942','159943','159944','160010','160011','160012','160013','160014','160015','160039','160040','160041','160042','160060','160172','160182','160308','160309','160376','160405','160406','160428','160511','160555','160855','160916','160968','160989','160990','161039','161402','161672','161729','161795','161838','161896','162120','162150','162151','162171','162198','162234','162275','162303','162376','162377','162489','162533','162546','162594','162604','162663','162694','162710','162711','162750','162813','162878','162879','162881','162903','163106','163107','163236','163264','163265','163266','163267','163268','163269','163270','163271','163272','163273','163274','163275','163276','163318','163325','163364','163460','163461','163462','163500','163589','163647','163649','163808','163809','163810','163811','163812','163829','163830','163984','164030','164031','164032','164033','164034','164043','164068','164122','164123','164125','164218','164219','164220','164221','164222','164223','164224','164226','164232','164500','164597','164602','164603','164604','164605','164606','164607','164608','164609','164610','164611','164612','164613','164614','164615','164616','164617','164618','164619','164620','164621','164622','164623','164640','164641','165308','165309','165310','165311','165312','165313','165314','165315','165316','165317','165318','165319','165320','165321','165322','165323','165330','165339','165340','165341','165349','165350','165606','165651','165664','165705','165752','165753','165756','165757','165758','165759','165760','165761','166074','166088','166089','166289','166327','166457','166458','166459','166460','166461','166462','166463','166464','166465','166466','166467','166468','166469','166470','166537','166541','166608','166616','166621','166703','166704','166709','166716','166859','166956','166974','166986','166987','166996','167074','167145','167159','167165','167176','167209','167242','167243','167261','167299','167302','167317','167345','167364','167369','167407','167410','167411','167563','167890','167891','167892','167929','167965','168170','168222','168223','168224','168265','168273','168274','168314','232558','232610','232624','232625','232626','232627','232628','232730','238389','238466','238484','238495','238510','238564','238565','238649','238651','239249','239716','239890','239891','240211','240310','240311','240437','240486','240624','240745','240753','240764','240765','240889','240938','240939','240983','240984','240987','241461','241497','241554','241590','241591','241593','241719','241766','241911','241941','241973','241976','241977','242054','242055','242184','242185','242186','242187','242188','242189','242190','242191','242192','242193','242194','242195','242196','242197','242327','242328','242541','242542','242543','242647','242731','242732','242733','242734','243300','243314','243374','243616','243956','244107','244298','244312','244315','244320','244445','244447','244448','244452','245092','245317','245319','245321','245385','245473','245626','245951','245958','245979','246035','246038','246039','246040','246226','246255','246256','246342','246414','246607','246651','246745','246755','246793','246794','246875','246991','247258','247266','247593','247699','247743','247765','247917','247977','248396','248427','248582','248621','248935','248936','248937','248938','248961','249022','249023','249148','249230','249361','249362','249414','249475','249506','249565','249582','249628','249735','249910','250160','250206','250217','250255','250273','250689','250691','250709','250731','250732','250733','250895','250928','250929','251164','251165','251166','251167','251168','251245','251246','251256','251426','251491','251492','251563','251564','251565','251566','251578','251621','251622','251642','251656','251667','251680','251748','251749','251750','251751','251808','251809','251810','251811','251988','252069','252097','252113','252114','252115','252116','252117','252194','252195','253168','253169','253170','253171','253172','253173','253174','253175','253176','253177','253178','253264','253462','253502','253508','253563','253620','253652','253712','253744','253746','253769','253819','253820','253844','253912','254325','254401','254414','254422','254476','254484','254520','254621','254622','254728','254729','254743','254785','254786','254787','254788','254789','254888','255019','255125','255316','255333','255750','255778','255784','255785','255794','256000','256072','256073','256257','256320','256460','256513','256514','256568','256733','261722','261742','262180','262558','262610','262920','264680','264913','265049','265765','265769','265781','265909','266039','266340','266341','266342','266390','266492','266539','266702','266774','267100','267390','267953','268318','268356','268468','268728','268767','268811','269162','269509','269756','273480','273568','273635','273810','273865','273866','273874','273875','273876','273878','273880','273881','274461','274462','274463','274464','274465','274466','274467','274893','275035','275036','275192','275360','275418','275550','275831','278643','280900','280903','281188','281341','281787','281788','282823','284218','284324','284462','284825','284861','284882','285236','286074','286075','286838','286944','286976','287134','287135','288075','288386','288488','288491','288716','291836','291837','292619','294285','298212','299818') GROUP BY `parent` ORDER BY `parent` ASC
childsstroke: packages
SELECT `packages`,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 `packages` !='' AND `modx_site_content`.`id` IN ('152874','153196','153197','153583','153589','153626','153664','153826','153867','154159','154191','154473','154521','154534','154535','154536','154578','154668','154728','154729','154808','154820','154896','154897','154914','154915','154916','154917','154918','154919','154920','154921','154922','154923','154924','154925','154926','154927','154942','154974','154977','154982','154983','154984','154985','154986','154994','154995','154996','154997','155072','155185','155229','155232','155234','155236','155245','155252','155276','155306','155307','155318','155319','155320','155321','155322','155323','155324','155325','155350','155495','155684','155711','155712','155713','155714','155715','155760','156632','157515','157517','157593','157820','157821','157836','158025','158229','158273','158274','158348','158349','158368','158369','158370','158456','158457','158458','158466','158467','158468','158469','158686','158687','158695','158696','158697','158726','158727','158728','158729','158730','158731','158863','158933','158934','158935','158978','158980','158982','158997','159091','159100','159109','159157','159170','159275','159319','159320','159321','159324','159325','159372','159425','159426','159427','159428','159438','159473','159531','159532','159533','159535','159536','159537','159550','159555','159556','159614','159615','159616','159617','159618','159619','159631','159665','159699','159700','159701','159702','159703','159753','159775','159776','159832','159922','159923','159925','159926','159927','159928','159931','159932','159933','159936','159937','159938','159939','159940','159941','159942','159943','159944','160010','160011','160012','160013','160014','160015','160039','160040','160041','160042','160060','160172','160182','160308','160309','160376','160405','160406','160428','160511','160555','160855','160916','160968','160989','160990','161039','161402','161672','161729','161795','161838','161896','162120','162150','162151','162171','162198','162234','162275','162303','162376','162377','162489','162533','162546','162594','162604','162663','162694','162710','162711','162750','162813','162878','162879','162881','162903','163106','163107','163236','163264','163265','163266','163267','163268','163269','163270','163271','163272','163273','163274','163275','163276','163318','163325','163364','163460','163461','163462','163500','163589','163647','163649','163808','163809','163810','163811','163812','163829','163830','163984','164030','164031','164032','164033','164034','164043','164068','164122','164123','164125','164218','164219','164220','164221','164222','164223','164224','164226','164232','164500','164597','164602','164603','164604','164605','164606','164607','164608','164609','164610','164611','164612','164613','164614','164615','164616','164617','164618','164619','164620','164621','164622','164623','164640','164641','165308','165309','165310','165311','165312','165313','165314','165315','165316','165317','165318','165319','165320','165321','165322','165323','165330','165339','165340','165341','165349','165350','165606','165651','165664','165705','165752','165753','165756','165757','165758','165759','165760','165761','166074','166088','166089','166289','166327','166457','166458','166459','166460','166461','166462','166463','166464','166465','166466','166467','166468','166469','166470','166537','166541','166608','166616','166621','166703','166704','166709','166716','166859','166956','166974','166986','166987','166996','167074','167145','167159','167165','167176','167209','167242','167243','167261','167299','167302','167317','167345','167364','167369','167407','167410','167411','167563','167890','167891','167892','167929','167965','168170','168222','168223','168224','168265','168273','168274','168314','232558','232610','232624','232625','232626','232627','232628','232730','238389','238466','238484','238495','238510','238564','238565','238649','238651','239249','239716','239890','239891','240211','240310','240311','240437','240486','240624','240745','240753','240764','240765','240889','240938','240939','240983','240984','240987','241461','241497','241554','241590','241591','241593','241719','241766','241911','241941','241973','241976','241977','242054','242055','242184','242185','242186','242187','242188','242189','242190','242191','242192','242193','242194','242195','242196','242197','242327','242328','242541','242542','242543','242647','242731','242732','242733','242734','243300','243314','243374','243616','243956','244107','244298','244312','244315','244320','244445','244447','244448','244452','245092','245317','245319','245321','245385','245473','245626','245951','245958','245979','246035','246038','246039','246040','246226','246255','246256','246342','246414','246607','246651','246745','246755','246793','246794','246875','246991','247258','247266','247593','247699','247743','247765','247917','247977','248396','248427','248582','248621','248935','248936','248937','248938','248961','249022','249023','249148','249230','249361','249362','249414','249475','249506','249565','249582','249628','249735','249910','250160','250206','250217','250255','250273','250689','250691','250709','250731','250732','250733','250895','250928','250929','251164','251165','251166','251167','251168','251245','251246','251256','251426','251491','251492','251563','251564','251565','251566','251578','251621','251622','251642','251656','251667','251680','251748','251749','251750','251751','251808','251809','251810','251811','251988','252069','252097','252113','252114','252115','252116','252117','252194','252195','253168','253169','253170','253171','253172','253173','253174','253175','253176','253177','253178','253264','253462','253502','253508','253563','253620','253652','253712','253744','253746','253769','253819','253820','253844','253912','254325','254401','254414','254422','254476','254484','254520','254621','254622','254728','254729','254743','254785','254786','254787','254788','254789','254888','255019','255125','255316','255333','255750','255778','255784','255785','255794','256000','256072','256073','256257','256320','256460','256513','256514','256568','256733','261722','261742','262180','262558','262610','262920','264680','264913','265049','265765','265769','265781','265909','266039','266340','266341','266342','266390','266492','266539','266702','266774','267100','267390','267953','268318','268356','268468','268728','268767','268811','269162','269509','269756','273480','273568','273635','273810','273865','273866','273874','273875','273876','273878','273880','273881','274461','274462','274463','274464','274465','274466','274467','274893','275035','275036','275192','275360','275418','275550','275831','278643','280900','280903','281188','281341','281787','281788','282823','284218','284324','284462','284825','284861','284882','285236','286074','286075','286838','286944','286976','287134','287135','288075','288386','288488','288491','288716','291836','291837','292619','294285','298212','299818') GROUP BY `packages` ORDER BY `packages` ASC
childsstroke1: packages
SELECT `packages`,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 `packages` !='' AND `modx_site_content`.`id` IN ('152874','153196','153197','153583','153589','153626','153664','153826','153867','154159','154191','154473','154521','154534','154535','154536','154578','154668','154728','154729','154808','154820','154896','154897','154914','154915','154916','154917','154918','154919','154920','154921','154922','154923','154924','154925','154926','154927','154942','154974','154977','154982','154983','154984','154985','154986','154994','154995','154996','154997','155072','155185','155229','155232','155234','155236','155245','155252','155276','155306','155307','155318','155319','155320','155321','155322','155323','155324','155325','155350','155495','155684','155711','155712','155713','155714','155715','155760','156632','157515','157517','157593','157820','157821','157836','158025','158229','158273','158274','158348','158349','158368','158369','158370','158456','158457','158458','158466','158467','158468','158469','158686','158687','158695','158696','158697','158726','158727','158728','158729','158730','158731','158863','158933','158934','158935','158978','158980','158982','158997','159091','159100','159109','159157','159170','159275','159319','159320','159321','159324','159325','159372','159425','159426','159427','159428','159438','159473','159531','159532','159533','159535','159536','159537','159550','159555','159556','159614','159615','159616','159617','159618','159619','159631','159665','159699','159700','159701','159702','159703','159753','159775','159776','159832','159922','159923','159925','159926','159927','159928','159931','159932','159933','159936','159937','159938','159939','159940','159941','159942','159943','159944','160010','160011','160012','160013','160014','160015','160039','160040','160041','160042','160060','160172','160182','160308','160309','160376','160405','160406','160428','160511','160555','160855','160916','160968','160989','160990','161039','161402','161672','161729','161795','161838','161896','162120','162150','162151','162171','162198','162234','162275','162303','162376','162377','162489','162533','162546','162594','162604','162663','162694','162710','162711','162750','162813','162878','162879','162881','162903','163106','163107','163236','163264','163265','163266','163267','163268','163269','163270','163271','163272','163273','163274','163275','163276','163318','163325','163364','163460','163461','163462','163500','163589','163647','163649','163808','163809','163810','163811','163812','163829','163830','163984','164030','164031','164032','164033','164034','164043','164068','164122','164123','164125','164218','164219','164220','164221','164222','164223','164224','164226','164232','164500','164597','164602','164603','164604','164605','164606','164607','164608','164609','164610','164611','164612','164613','164614','164615','164616','164617','164618','164619','164620','164621','164622','164623','164640','164641','165308','165309','165310','165311','165312','165313','165314','165315','165316','165317','165318','165319','165320','165321','165322','165323','165330','165339','165340','165341','165349','165350','165606','165651','165664','165705','165752','165753','165756','165757','165758','165759','165760','165761','166074','166088','166089','166289','166327','166457','166458','166459','166460','166461','166462','166463','166464','166465','166466','166467','166468','166469','166470','166537','166541','166608','166616','166621','166703','166704','166709','166716','166859','166956','166974','166986','166987','166996','167074','167145','167159','167165','167176','167209','167242','167243','167261','167299','167302','167317','167345','167364','167369','167407','167410','167411','167563','167890','167891','167892','167929','167965','168170','168222','168223','168224','168265','168273','168274','168314','232558','232610','232624','232625','232626','232627','232628','232730','238389','238466','238484','238495','238510','238564','238565','238649','238651','239249','239716','239890','239891','240211','240310','240311','240437','240486','240624','240745','240753','240764','240765','240889','240938','240939','240983','240984','240987','241461','241497','241554','241590','241591','241593','241719','241766','241911','241941','241973','241976','241977','242054','242055','242184','242185','242186','242187','242188','242189','242190','242191','242192','242193','242194','242195','242196','242197','242327','242328','242541','242542','242543','242647','242731','242732','242733','242734','243300','243314','243374','243616','243956','244107','244298','244312','244315','244320','244445','244447','244448','244452','245092','245317','245319','245321','245385','245473','245626','245951','245958','245979','246035','246038','246039','246040','246226','246255','246256','246342','246414','246607','246651','246745','246755','246793','246794','246875','246991','247258','247266','247593','247699','247743','247765','247917','247977','248396','248427','248582','248621','248935','248936','248937','248938','248961','249022','249023','249148','249230','249361','249362','249414','249475','249506','249565','249582','249628','249735','249910','250160','250206','250217','250255','250273','250689','250691','250709','250731','250732','250733','250895','250928','250929','251164','251165','251166','251167','251168','251245','251246','251256','251426','251491','251492','251563','251564','251565','251566','251578','251621','251622','251642','251656','251667','251680','251748','251749','251750','251751','251808','251809','251810','251811','251988','252069','252097','252113','252114','252115','252116','252117','252194','252195','253168','253169','253170','253171','253172','253173','253174','253175','253176','253177','253178','253264','253462','253502','253508','253563','253620','253652','253712','253744','253746','253769','253819','253820','253844','253912','254325','254401','254414','254422','254476','254484','254520','254621','254622','254728','254729','254743','254785','254786','254787','254788','254789','254888','255019','255125','255316','255333','255750','255778','255784','255785','255794','256000','256072','256073','256257','256320','256460','256513','256514','256568','256733','261722','261742','262180','262558','262610','262920','264680','264913','265049','265765','265769','265781','265909','266039','266340','266341','266342','266390','266492','266539','266702','266774','267100','267390','267953','268318','268356','268468','268728','268767','268811','269162','269509','269756','273480','273568','273635','273810','273865','273866','273874','273875','273876','273878','273880','273881','274461','274462','274463','274464','274465','274466','274467','274893','275035','275036','275192','275360','275418','275550','275831','278643','280900','280903','281188','281341','281787','281788','282823','284218','284324','284462','284825','284861','284882','285236','286074','286075','286838','286944','286976','287134','287135','288075','288386','288488','288491','288716','291836','291837','292619','294285','298212','299818') GROUP BY `packages` ORDER BY `packages` ASC
childsstroke: deviation
SELECT `deviation`,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 `deviation` !='' AND `modx_site_content`.`id` IN ('152874','153196','153197','153583','153589','153626','153664','153826','153867','154159','154191','154473','154521','154534','154535','154536','154578','154668','154728','154729','154808','154820','154896','154897','154914','154915','154916','154917','154918','154919','154920','154921','154922','154923','154924','154925','154926','154927','154942','154974','154977','154982','154983','154984','154985','154986','154994','154995','154996','154997','155072','155185','155229','155232','155234','155236','155245','155252','155276','155306','155307','155318','155319','155320','155321','155322','155323','155324','155325','155350','155495','155684','155711','155712','155713','155714','155715','155760','156632','157515','157517','157593','157820','157821','157836','158025','158229','158273','158274','158348','158349','158368','158369','158370','158456','158457','158458','158466','158467','158468','158469','158686','158687','158695','158696','158697','158726','158727','158728','158729','158730','158731','158863','158933','158934','158935','158978','158980','158982','158997','159091','159100','159109','159157','159170','159275','159319','159320','159321','159324','159325','159372','159425','159426','159427','159428','159438','159473','159531','159532','159533','159535','159536','159537','159550','159555','159556','159614','159615','159616','159617','159618','159619','159631','159665','159699','159700','159701','159702','159703','159753','159775','159776','159832','159922','159923','159925','159926','159927','159928','159931','159932','159933','159936','159937','159938','159939','159940','159941','159942','159943','159944','160010','160011','160012','160013','160014','160015','160039','160040','160041','160042','160060','160172','160182','160308','160309','160376','160405','160406','160428','160511','160555','160855','160916','160968','160989','160990','161039','161402','161672','161729','161795','161838','161896','162120','162150','162151','162171','162198','162234','162275','162303','162376','162377','162489','162533','162546','162594','162604','162663','162694','162710','162711','162750','162813','162878','162879','162881','162903','163106','163107','163236','163264','163265','163266','163267','163268','163269','163270','163271','163272','163273','163274','163275','163276','163318','163325','163364','163460','163461','163462','163500','163589','163647','163649','163808','163809','163810','163811','163812','163829','163830','163984','164030','164031','164032','164033','164034','164043','164068','164122','164123','164125','164218','164219','164220','164221','164222','164223','164224','164226','164232','164500','164597','164602','164603','164604','164605','164606','164607','164608','164609','164610','164611','164612','164613','164614','164615','164616','164617','164618','164619','164620','164621','164622','164623','164640','164641','165308','165309','165310','165311','165312','165313','165314','165315','165316','165317','165318','165319','165320','165321','165322','165323','165330','165339','165340','165341','165349','165350','165606','165651','165664','165705','165752','165753','165756','165757','165758','165759','165760','165761','166074','166088','166089','166289','166327','166457','166458','166459','166460','166461','166462','166463','166464','166465','166466','166467','166468','166469','166470','166537','166541','166608','166616','166621','166703','166704','166709','166716','166859','166956','166974','166986','166987','166996','167074','167145','167159','167165','167176','167209','167242','167243','167261','167299','167302','167317','167345','167364','167369','167407','167410','167411','167563','167890','167891','167892','167929','167965','168170','168222','168223','168224','168265','168273','168274','168314','232558','232610','232624','232625','232626','232627','232628','232730','238389','238466','238484','238495','238510','238564','238565','238649','238651','239249','239716','239890','239891','240211','240310','240311','240437','240486','240624','240745','240753','240764','240765','240889','240938','240939','240983','240984','240987','241461','241497','241554','241590','241591','241593','241719','241766','241911','241941','241973','241976','241977','242054','242055','242184','242185','242186','242187','242188','242189','242190','242191','242192','242193','242194','242195','242196','242197','242327','242328','242541','242542','242543','242647','242731','242732','242733','242734','243300','243314','243374','243616','243956','244107','244298','244312','244315','244320','244445','244447','244448','244452','245092','245317','245319','245321','245385','245473','245626','245951','245958','245979','246035','246038','246039','246040','246226','246255','246256','246342','246414','246607','246651','246745','246755','246793','246794','246875','246991','247258','247266','247593','247699','247743','247765','247917','247977','248396','248427','248582','248621','248935','248936','248937','248938','248961','249022','249023','249148','249230','249361','249362','249414','249475','249506','249565','249582','249628','249735','249910','250160','250206','250217','250255','250273','250689','250691','250709','250731','250732','250733','250895','250928','250929','251164','251165','251166','251167','251168','251245','251246','251256','251426','251491','251492','251563','251564','251565','251566','251578','251621','251622','251642','251656','251667','251680','251748','251749','251750','251751','251808','251809','251810','251811','251988','252069','252097','252113','252114','252115','252116','252117','252194','252195','253168','253169','253170','253171','253172','253173','253174','253175','253176','253177','253178','253264','253462','253502','253508','253563','253620','253652','253712','253744','253746','253769','253819','253820','253844','253912','254325','254401','254414','254422','254476','254484','254520','254621','254622','254728','254729','254743','254785','254786','254787','254788','254789','254888','255019','255125','255316','255333','255750','255778','255784','255785','255794','256000','256072','256073','256257','256320','256460','256513','256514','256568','256733','261722','261742','262180','262558','262610','262920','264680','264913','265049','265765','265769','265781','265909','266039','266340','266341','266342','266390','266492','266539','266702','266774','267100','267390','267953','268318','268356','268468','268728','268767','268811','269162','269509','269756','273480','273568','273635','273810','273865','273866','273874','273875','273876','273878','273880','273881','274461','274462','274463','274464','274465','274466','274467','274893','275035','275036','275192','275360','275418','275550','275831','278643','280900','280903','281188','281341','281787','281788','282823','284218','284324','284462','284825','284861','284882','285236','286074','286075','286838','286944','286976','287134','287135','288075','288386','288488','288491','288716','291836','291837','292619','294285','298212','299818') GROUP BY `deviation` ORDER BY `deviation` ASC
childsstroke1: deviation
SELECT `deviation`,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 `deviation` !='' AND `modx_site_content`.`id` IN ('152874','153196','153197','153583','153589','153626','153664','153826','153867','154159','154191','154473','154521','154534','154535','154536','154578','154668','154728','154729','154808','154820','154896','154897','154914','154915','154916','154917','154918','154919','154920','154921','154922','154923','154924','154925','154926','154927','154942','154974','154977','154982','154983','154984','154985','154986','154994','154995','154996','154997','155072','155185','155229','155232','155234','155236','155245','155252','155276','155306','155307','155318','155319','155320','155321','155322','155323','155324','155325','155350','155495','155684','155711','155712','155713','155714','155715','155760','156632','157515','157517','157593','157820','157821','157836','158025','158229','158273','158274','158348','158349','158368','158369','158370','158456','158457','158458','158466','158467','158468','158469','158686','158687','158695','158696','158697','158726','158727','158728','158729','158730','158731','158863','158933','158934','158935','158978','158980','158982','158997','159091','159100','159109','159157','159170','159275','159319','159320','159321','159324','159325','159372','159425','159426','159427','159428','159438','159473','159531','159532','159533','159535','159536','159537','159550','159555','159556','159614','159615','159616','159617','159618','159619','159631','159665','159699','159700','159701','159702','159703','159753','159775','159776','159832','159922','159923','159925','159926','159927','159928','159931','159932','159933','159936','159937','159938','159939','159940','159941','159942','159943','159944','160010','160011','160012','160013','160014','160015','160039','160040','160041','160042','160060','160172','160182','160308','160309','160376','160405','160406','160428','160511','160555','160855','160916','160968','160989','160990','161039','161402','161672','161729','161795','161838','161896','162120','162150','162151','162171','162198','162234','162275','162303','162376','162377','162489','162533','162546','162594','162604','162663','162694','162710','162711','162750','162813','162878','162879','162881','162903','163106','163107','163236','163264','163265','163266','163267','163268','163269','163270','163271','163272','163273','163274','163275','163276','163318','163325','163364','163460','163461','163462','163500','163589','163647','163649','163808','163809','163810','163811','163812','163829','163830','163984','164030','164031','164032','164033','164034','164043','164068','164122','164123','164125','164218','164219','164220','164221','164222','164223','164224','164226','164232','164500','164597','164602','164603','164604','164605','164606','164607','164608','164609','164610','164611','164612','164613','164614','164615','164616','164617','164618','164619','164620','164621','164622','164623','164640','164641','165308','165309','165310','165311','165312','165313','165314','165315','165316','165317','165318','165319','165320','165321','165322','165323','165330','165339','165340','165341','165349','165350','165606','165651','165664','165705','165752','165753','165756','165757','165758','165759','165760','165761','166074','166088','166089','166289','166327','166457','166458','166459','166460','166461','166462','166463','166464','166465','166466','166467','166468','166469','166470','166537','166541','166608','166616','166621','166703','166704','166709','166716','166859','166956','166974','166986','166987','166996','167074','167145','167159','167165','167176','167209','167242','167243','167261','167299','167302','167317','167345','167364','167369','167407','167410','167411','167563','167890','167891','167892','167929','167965','168170','168222','168223','168224','168265','168273','168274','168314','232558','232610','232624','232625','232626','232627','232628','232730','238389','238466','238484','238495','238510','238564','238565','238649','238651','239249','239716','239890','239891','240211','240310','240311','240437','240486','240624','240745','240753','240764','240765','240889','240938','240939','240983','240984','240987','241461','241497','241554','241590','241591','241593','241719','241766','241911','241941','241973','241976','241977','242054','242055','242184','242185','242186','242187','242188','242189','242190','242191','242192','242193','242194','242195','242196','242197','242327','242328','242541','242542','242543','242647','242731','242732','242733','242734','243300','243314','243374','243616','243956','244107','244298','244312','244315','244320','244445','244447','244448','244452','245092','245317','245319','245321','245385','245473','245626','245951','245958','245979','246035','246038','246039','246040','246226','246255','246256','246342','246414','246607','246651','246745','246755','246793','246794','246875','246991','247258','247266','247593','247699','247743','247765','247917','247977','248396','248427','248582','248621','248935','248936','248937','248938','248961','249022','249023','249148','249230','249361','249362','249414','249475','249506','249565','249582','249628','249735','249910','250160','250206','250217','250255','250273','250689','250691','250709','250731','250732','250733','250895','250928','250929','251164','251165','251166','251167','251168','251245','251246','251256','251426','251491','251492','251563','251564','251565','251566','251578','251621','251622','251642','251656','251667','251680','251748','251749','251750','251751','251808','251809','251810','251811','251988','252069','252097','252113','252114','252115','252116','252117','252194','252195','253168','253169','253170','253171','253172','253173','253174','253175','253176','253177','253178','253264','253462','253502','253508','253563','253620','253652','253712','253744','253746','253769','253819','253820','253844','253912','254325','254401','254414','254422','254476','254484','254520','254621','254622','254728','254729','254743','254785','254786','254787','254788','254789','254888','255019','255125','255316','255333','255750','255778','255784','255785','255794','256000','256072','256073','256257','256320','256460','256513','256514','256568','256733','261722','261742','262180','262558','262610','262920','264680','264913','265049','265765','265769','265781','265909','266039','266340','266341','266342','266390','266492','266539','266702','266774','267100','267390','267953','268318','268356','268468','268728','268767','268811','269162','269509','269756','273480','273568','273635','273810','273865','273866','273874','273875','273876','273878','273880','273881','274461','274462','274463','274464','274465','274466','274467','274893','275035','275036','275192','275360','275418','275550','275831','278643','280900','280903','281188','281341','281787','281788','282823','284218','284324','284462','284825','284861','284882','285236','286074','286075','286838','286944','286976','287134','287135','288075','288386','288488','288491','288716','291836','291837','292619','294285','298212','299818') GROUP BY `deviation` ORDER BY `deviation` ASC
childsstroke: rezpower
SELECT `rezpower`,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 `rezpower` !='' AND `modx_site_content`.`id` IN ('152874','153196','153197','153583','153589','153626','153664','153826','153867','154159','154191','154473','154521','154534','154535','154536','154578','154668','154728','154729','154808','154820','154896','154897','154914','154915','154916','154917','154918','154919','154920','154921','154922','154923','154924','154925','154926','154927','154942','154974','154977','154982','154983','154984','154985','154986','154994','154995','154996','154997','155072','155185','155229','155232','155234','155236','155245','155252','155276','155306','155307','155318','155319','155320','155321','155322','155323','155324','155325','155350','155495','155684','155711','155712','155713','155714','155715','155760','156632','157515','157517','157593','157820','157821','157836','158025','158229','158273','158274','158348','158349','158368','158369','158370','158456','158457','158458','158466','158467','158468','158469','158686','158687','158695','158696','158697','158726','158727','158728','158729','158730','158731','158863','158933','158934','158935','158978','158980','158982','158997','159091','159100','159109','159157','159170','159275','159319','159320','159321','159324','159325','159372','159425','159426','159427','159428','159438','159473','159531','159532','159533','159535','159536','159537','159550','159555','159556','159614','159615','159616','159617','159618','159619','159631','159665','159699','159700','159701','159702','159703','159753','159775','159776','159832','159922','159923','159925','159926','159927','159928','159931','159932','159933','159936','159937','159938','159939','159940','159941','159942','159943','159944','160010','160011','160012','160013','160014','160015','160039','160040','160041','160042','160060','160172','160182','160308','160309','160376','160405','160406','160428','160511','160555','160855','160916','160968','160989','160990','161039','161402','161672','161729','161795','161838','161896','162120','162150','162151','162171','162198','162234','162275','162303','162376','162377','162489','162533','162546','162594','162604','162663','162694','162710','162711','162750','162813','162878','162879','162881','162903','163106','163107','163236','163264','163265','163266','163267','163268','163269','163270','163271','163272','163273','163274','163275','163276','163318','163325','163364','163460','163461','163462','163500','163589','163647','163649','163808','163809','163810','163811','163812','163829','163830','163984','164030','164031','164032','164033','164034','164043','164068','164122','164123','164125','164218','164219','164220','164221','164222','164223','164224','164226','164232','164500','164597','164602','164603','164604','164605','164606','164607','164608','164609','164610','164611','164612','164613','164614','164615','164616','164617','164618','164619','164620','164621','164622','164623','164640','164641','165308','165309','165310','165311','165312','165313','165314','165315','165316','165317','165318','165319','165320','165321','165322','165323','165330','165339','165340','165341','165349','165350','165606','165651','165664','165705','165752','165753','165756','165757','165758','165759','165760','165761','166074','166088','166089','166289','166327','166457','166458','166459','166460','166461','166462','166463','166464','166465','166466','166467','166468','166469','166470','166537','166541','166608','166616','166621','166703','166704','166709','166716','166859','166956','166974','166986','166987','166996','167074','167145','167159','167165','167176','167209','167242','167243','167261','167299','167302','167317','167345','167364','167369','167407','167410','167411','167563','167890','167891','167892','167929','167965','168170','168222','168223','168224','168265','168273','168274','168314','232558','232610','232624','232625','232626','232627','232628','232730','238389','238466','238484','238495','238510','238564','238565','238649','238651','239249','239716','239890','239891','240211','240310','240311','240437','240486','240624','240745','240753','240764','240765','240889','240938','240939','240983','240984','240987','241461','241497','241554','241590','241591','241593','241719','241766','241911','241941','241973','241976','241977','242054','242055','242184','242185','242186','242187','242188','242189','242190','242191','242192','242193','242194','242195','242196','242197','242327','242328','242541','242542','242543','242647','242731','242732','242733','242734','243300','243314','243374','243616','243956','244107','244298','244312','244315','244320','244445','244447','244448','244452','245092','245317','245319','245321','245385','245473','245626','245951','245958','245979','246035','246038','246039','246040','246226','246255','246256','246342','246414','246607','246651','246745','246755','246793','246794','246875','246991','247258','247266','247593','247699','247743','247765','247917','247977','248396','248427','248582','248621','248935','248936','248937','248938','248961','249022','249023','249148','249230','249361','249362','249414','249475','249506','249565','249582','249628','249735','249910','250160','250206','250217','250255','250273','250689','250691','250709','250731','250732','250733','250895','250928','250929','251164','251165','251166','251167','251168','251245','251246','251256','251426','251491','251492','251563','251564','251565','251566','251578','251621','251622','251642','251656','251667','251680','251748','251749','251750','251751','251808','251809','251810','251811','251988','252069','252097','252113','252114','252115','252116','252117','252194','252195','253168','253169','253170','253171','253172','253173','253174','253175','253176','253177','253178','253264','253462','253502','253508','253563','253620','253652','253712','253744','253746','253769','253819','253820','253844','253912','254325','254401','254414','254422','254476','254484','254520','254621','254622','254728','254729','254743','254785','254786','254787','254788','254789','254888','255019','255125','255316','255333','255750','255778','255784','255785','255794','256000','256072','256073','256257','256320','256460','256513','256514','256568','256733','261722','261742','262180','262558','262610','262920','264680','264913','265049','265765','265769','265781','265909','266039','266340','266341','266342','266390','266492','266539','266702','266774','267100','267390','267953','268318','268356','268468','268728','268767','268811','269162','269509','269756','273480','273568','273635','273810','273865','273866','273874','273875','273876','273878','273880','273881','274461','274462','274463','274464','274465','274466','274467','274893','275035','275036','275192','275360','275418','275550','275831','278643','280900','280903','281188','281341','281787','281788','282823','284218','284324','284462','284825','284861','284882','285236','286074','286075','286838','286944','286976','287134','287135','288075','288386','288488','288491','288716','291836','291837','292619','294285','298212','299818') GROUP BY `rezpower` ORDER BY `rezpower` ASC
childsstroke1: rezpower
SELECT `rezpower`,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 `rezpower` !='' AND `modx_site_content`.`id` IN ('152874','153196','153197','153583','153589','153626','153664','153826','153867','154159','154191','154473','154521','154534','154535','154536','154578','154668','154728','154729','154808','154820','154896','154897','154914','154915','154916','154917','154918','154919','154920','154921','154922','154923','154924','154925','154926','154927','154942','154974','154977','154982','154983','154984','154985','154986','154994','154995','154996','154997','155072','155185','155229','155232','155234','155236','155245','155252','155276','155306','155307','155318','155319','155320','155321','155322','155323','155324','155325','155350','155495','155684','155711','155712','155713','155714','155715','155760','156632','157515','157517','157593','157820','157821','157836','158025','158229','158273','158274','158348','158349','158368','158369','158370','158456','158457','158458','158466','158467','158468','158469','158686','158687','158695','158696','158697','158726','158727','158728','158729','158730','158731','158863','158933','158934','158935','158978','158980','158982','158997','159091','159100','159109','159157','159170','159275','159319','159320','159321','159324','159325','159372','159425','159426','159427','159428','159438','159473','159531','159532','159533','159535','159536','159537','159550','159555','159556','159614','159615','159616','159617','159618','159619','159631','159665','159699','159700','159701','159702','159703','159753','159775','159776','159832','159922','159923','159925','159926','159927','159928','159931','159932','159933','159936','159937','159938','159939','159940','159941','159942','159943','159944','160010','160011','160012','160013','160014','160015','160039','160040','160041','160042','160060','160172','160182','160308','160309','160376','160405','160406','160428','160511','160555','160855','160916','160968','160989','160990','161039','161402','161672','161729','161795','161838','161896','162120','162150','162151','162171','162198','162234','162275','162303','162376','162377','162489','162533','162546','162594','162604','162663','162694','162710','162711','162750','162813','162878','162879','162881','162903','163106','163107','163236','163264','163265','163266','163267','163268','163269','163270','163271','163272','163273','163274','163275','163276','163318','163325','163364','163460','163461','163462','163500','163589','163647','163649','163808','163809','163810','163811','163812','163829','163830','163984','164030','164031','164032','164033','164034','164043','164068','164122','164123','164125','164218','164219','164220','164221','164222','164223','164224','164226','164232','164500','164597','164602','164603','164604','164605','164606','164607','164608','164609','164610','164611','164612','164613','164614','164615','164616','164617','164618','164619','164620','164621','164622','164623','164640','164641','165308','165309','165310','165311','165312','165313','165314','165315','165316','165317','165318','165319','165320','165321','165322','165323','165330','165339','165340','165341','165349','165350','165606','165651','165664','165705','165752','165753','165756','165757','165758','165759','165760','165761','166074','166088','166089','166289','166327','166457','166458','166459','166460','166461','166462','166463','166464','166465','166466','166467','166468','166469','166470','166537','166541','166608','166616','166621','166703','166704','166709','166716','166859','166956','166974','166986','166987','166996','167074','167145','167159','167165','167176','167209','167242','167243','167261','167299','167302','167317','167345','167364','167369','167407','167410','167411','167563','167890','167891','167892','167929','167965','168170','168222','168223','168224','168265','168273','168274','168314','232558','232610','232624','232625','232626','232627','232628','232730','238389','238466','238484','238495','238510','238564','238565','238649','238651','239249','239716','239890','239891','240211','240310','240311','240437','240486','240624','240745','240753','240764','240765','240889','240938','240939','240983','240984','240987','241461','241497','241554','241590','241591','241593','241719','241766','241911','241941','241973','241976','241977','242054','242055','242184','242185','242186','242187','242188','242189','242190','242191','242192','242193','242194','242195','242196','242197','242327','242328','242541','242542','242543','242647','242731','242732','242733','242734','243300','243314','243374','243616','243956','244107','244298','244312','244315','244320','244445','244447','244448','244452','245092','245317','245319','245321','245385','245473','245626','245951','245958','245979','246035','246038','246039','246040','246226','246255','246256','246342','246414','246607','246651','246745','246755','246793','246794','246875','246991','247258','247266','247593','247699','247743','247765','247917','247977','248396','248427','248582','248621','248935','248936','248937','248938','248961','249022','249023','249148','249230','249361','249362','249414','249475','249506','249565','249582','249628','249735','249910','250160','250206','250217','250255','250273','250689','250691','250709','250731','250732','250733','250895','250928','250929','251164','251165','251166','251167','251168','251245','251246','251256','251426','251491','251492','251563','251564','251565','251566','251578','251621','251622','251642','251656','251667','251680','251748','251749','251750','251751','251808','251809','251810','251811','251988','252069','252097','252113','252114','252115','252116','252117','252194','252195','253168','253169','253170','253171','253172','253173','253174','253175','253176','253177','253178','253264','253462','253502','253508','253563','253620','253652','253712','253744','253746','253769','253819','253820','253844','253912','254325','254401','254414','254422','254476','254484','254520','254621','254622','254728','254729','254743','254785','254786','254787','254788','254789','254888','255019','255125','255316','255333','255750','255778','255784','255785','255794','256000','256072','256073','256257','256320','256460','256513','256514','256568','256733','261722','261742','262180','262558','262610','262920','264680','264913','265049','265765','265769','265781','265909','266039','266340','266341','266342','266390','266492','266539','266702','266774','267100','267390','267953','268318','268356','268468','268728','268767','268811','269162','269509','269756','273480','273568','273635','273810','273865','273866','273874','273875','273876','273878','273880','273881','274461','274462','274463','274464','274465','274466','274467','274893','275035','275036','275192','275360','275418','275550','275831','278643','280900','280903','281188','281341','281787','281788','282823','284218','284324','284462','284825','284861','284882','285236','286074','286075','286838','286944','286976','287134','287135','288075','288386','288488','288491','288716','291836','291837','292619','294285','298212','299818') GROUP BY `rezpower` ORDER BY `rezpower` ASC
На рынке представлено множество производителей резисторов, поэтому выбор надежного партнера является непростой задачей. Компания RoyalOhm; занимается производством и продажей резисторов с 1978 года.
Документация по резисторам общего назначения RoyalOhm
