AiSHi

SELECT `capacity`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `capacity` !='' AND `modx_site_content`.`id` IN ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','216079','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `capacity` ORDER BY `capacity` ASC

SELECT `capacity`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `capacity` !='' AND `modx_site_content`.`id` IN ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `capacity` ORDER BY `capacity` ASC

SELECT `capacity_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 `capacity_unit` !='' AND `modx_site_content`.`id` IN ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','216079','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `capacity_unit` ORDER BY `capacity_unit` ASC

SELECT `capacity_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 `capacity_unit` !='' AND `modx_site_content`.`id` IN ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `capacity_unit` ORDER BY `capacity_unit` ASC

SELECT `voltage`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `voltage` !='' AND `modx_site_content`.`id` IN ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','216079','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `voltage` ORDER BY `voltage` ASC

SELECT `voltage`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `voltage` !='' AND `modx_site_content`.`id` IN ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `voltage` ORDER BY `voltage` ASC

SELECT `montage`,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 `montage` !='' AND `modx_site_content`.`id` IN ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','216079','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `montage` ORDER BY `montage` ASC

SELECT `montage`,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 `montage` !='' AND `modx_site_content`.`id` IN ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `montage` ORDER BY `montage` ASC

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 ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','216079','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `deviation` ORDER BY `deviation` ASC

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 ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `deviation` ORDER BY `deviation` ASC

SELECT `gabarity`,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 `gabarity` !='' AND `modx_site_content`.`id` IN ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','216079','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `gabarity` ORDER BY `gabarity` ASC

SELECT `gabarity`,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 `gabarity` !='' AND `modx_site_content`.`id` IN ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `gabarity` ORDER BY `gabarity` ASC

SELECT `work_temp`,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 `work_temp` !='' AND `modx_site_content`.`id` IN ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','216079','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `work_temp` ORDER BY `work_temp` ASC

SELECT `work_temp`,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 `work_temp` !='' AND `modx_site_content`.`id` IN ('141561','141562','141563','141618','141675','141676','141677','141678','141679','141680','141681','141682','141683','141730','141753','141965','142115','142116','142165','142319','142757','142810','143222','143252','143253','143254','143255','143256','143257','143258','143259','143260','143261','143262','143296','143297','143576','144213','147206','147225','148026','148582','148606','151034','151329','151423','151425','151623','151867','152000','152001','153091','153092','153099','153102','153137','153593','153594','153818','153819','154158','154489','154492','154646','154654','154681','154684','154746','154766','154821','154822','154823','154824','154826','154858','154859','154955','154956','155032','155033','155034','155035','155036','155037','155106','155214','155215','155216','155217','155218','155237','155238','155239','155241','155242','155243','155244','155248','155249','155250','155251','155253','155254','155255','155256','155257','155258','155259','155260','155261','155262','155263','155295','155296','155297','155298','155299','155300','155332','155497','156635','156652','156653','156654','156655','156656','156657','156658','156659','156660','156661','156662','156663','156664','156665','156666','156667','156668','156669','156670','156671','156672','156673','156674','156675','156676','156677','156678','156679','156680','156681','156682','156683','156684','156685','156686','156687','156688','156689','156690','156691','156692','156693','156694','156695','156696','156697','156698','156699','156700','156701','156702','156703','156704','156705','156706','156707','156708','156709','156710','156711','156712','156713','156714','156715','156716','156717','156718','156719','156720','156721','156722','156723','156724','156725','156726','156727','156728','156729','156730','156731','156732','156733','156734','156735','156736','156737','156738','156739','156740','156741','156742','156743','156744','156745','156746','156747','156748','156749','156750','156751','156752','156753','156754','156755','156756','156757','156758','156759','156760','156761','156762','156763','156764','156765','156766','156767','156768','156769','156770','156771','156772','156773','156774','156775','156776','156777','156778','158201','158626','158796','159160','159195','159196','159197','159198','159199','159200','159201','159202','159203','159204','159593','159715','159730','159784','159864','159865','160362','160423','160433','160472','160512','160724','160879','160880','160889','160890','160891','160892','161130','161156','162184','162264','163029','163030','163099','164635','164829','164830','165525','165686','166489','166888','167090','167420','167864','169110','169116','169140','169141','169142','169166','169167','169173','169193','169194','169195','169196','169197','169198','169199','169282','169283','169284','169294','169327','169338','169802','169803','169804','169860','169861','169987','170014','170127','170128','170164','170284','170322','170323','170383','202713','202792','215272','215315','215362','215736','215828','232433','232777','238024','238202','238548','238552','238553','238554','238555','238560','238561','238562','238563','238670','238730','238731','238732','238733','239221','240420','241466','241467','242257','245888','245889','245890','245891','245892','248871','248911','250805','251196','253562','253818','255367','255633','255634','256128','256268','256947','256956','256957','256958','256959','256960','256985','256986','256987','256988','256989','256990','256991','256992','256993','256994','256995','256996','256997','256998','256999','257000','257001','257002','257003','257004','257005','257006','257007','257008','257009','257010','257011','262047','262048','262049','262050','262051','262052','262053','262054','262055','262091','262092','262093','262094','262095','262096','262098','262126','262127','262129','262130','262131','262132','262133','262134','262135','262136','262137','262138','262139','262140','262141','262142','262143','262144','262145','262146','262147','262148','262149','262150','262151','262152','262153','262154','262209','262210','262211','262212','262213','262214','262215','262216','262217','262218','262219','262220','262221','262222','262223','262224','262225','262226','262227','262228','262229','262230','262269','262271','262273','263015','263017','265323','265684','266191','267587','267727','267728','269471','269472','269473','269481','273533','273697','274370','275568','277736','277737','277739','277740','277741','277742','277743','277744','277745','277756','277910','278697','278698','278699','280429','280732','281708','281766','285577','288434','291896','292502','293370','294393','295979','299574','300217','300218','300920','301994') GROUP BY `work_temp` ORDER BY `work_temp` ASC