childsstroke: manuf
SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('57','80','100','150','184','297','153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155312','155313','155314','155561','155650','155818','155819','155820','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160616','160623','160664','160665','160715','160721','160729','160909','161002','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161258','161276','161281','161320','161325','161328','161343','161345','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162077','162078','162119','162250','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163550','163558','163615','163670','163764','163773','163839','163881','164186','164187','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166901','166925','166935','166936','167146','167228','167229','167230','167238','167264','167370','167431','167460','167576','167695','167781','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240198','240219','240220','240391','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241888','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242965','242979','242988','242991','243024','243227','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244627','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248058','248113','248457','248531','248812','248872','248929','249053','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250147','250249','250294','250301','250664','250774','250829','250933','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252054','252055','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253785','253835','253894','253897','254237','254354','254403','254413','254464','254581','254716','254764','254831','255167','255328','255374','255482','255619','255620','255660','255716','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265978','265979','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268274','268616','268740','268812','268879','269076','269098','269101','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273882','273923','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276115','276391','276444','276543','276605','276606','276971','277280','277312','277332','277375','277480','277802','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280982','281007','281024','281116','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286968','286983','287211','288017','288076','288087','288164','288211','288645','288699','288736','288745','288957','288967','289072','289092','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295799','295808','295839','295980','295991','295992','295993','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298221','298228','298401','298564','299074','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300687','300930','301032','301944','302079','302198','302304','303922','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244699','248026','248138','249058','250047','250131','250453','250641','251037','252046','254364','255722','261776','268225','268800','269476','273856','273947','276548','277366','281134','281135','281136','281137','281138','281139','285975','286358','286823','288478','293209','293601','295591','297028','298152','298211','299206','300665','300907','155728','157528','158403','163645','238666','238672','241065','244540','249112','250500','252075','253696','254570','254946','255279','262554','263602','268675','274898','276108','276249','276989','277821','280968','282776','283209','288356','288503','288647','289108','300590','300592','301974','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','240190','266128','240415','240416','160902','160903','160904','265949') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke1: manuf
SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153569','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155212','155312','155313','155314','155561','155650','155728','155812','155813','155814','155815','155816','155817','155818','155819','155820','155821','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157528','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157805','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158403','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160573','160616','160623','160664','160665','160715','160721','160729','160902','160903','160904','160909','161002','161056','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161218','161258','161276','161281','161320','161325','161328','161343','161345','161359','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162049','162077','162078','162119','162250','162278','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163521','163550','163558','163615','163645','163670','163764','163773','163839','163855','163881','164186','164187','164237','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166896','166901','166925','166935','166936','167046','167146','167228','167229','167230','167238','167264','167292','167370','167431','167460','167576','167695','167781','167784','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238666','238672','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239311','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240190','240198','240219','240220','240391','240415','240416','240469','240579','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241065','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241881','241888','241896','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242586','242620','242666','242705','242708','242717','242794','242855','242882','242965','242979','242986','242988','242991','243019','243024','243192','243227','243308','243346','243557','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244540','244627','244699','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248026','248058','248113','248138','248457','248531','248812','248872','248929','249053','249058','249112','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250047','250131','250147','250249','250294','250301','250453','250500','250641','250664','250774','250829','250933','251037','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252046','252054','252055','252075','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253696','253785','253835','253894','253897','254237','254354','254364','254403','254413','254464','254570','254581','254716','254764','254831','254946','255167','255279','255328','255374','255482','255619','255620','255660','255716','255722','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261776','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262554','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263602','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265949','265978','265979','266128','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268225','268274','268616','268675','268740','268800','268812','268879','269076','269098','269101','269476','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273856','273882','273923','273947','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274898','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276108','276115','276249','276391','276444','276543','276548','276605','276606','276971','276989','277280','277312','277332','277366','277375','277480','277802','277821','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280968','280982','281007','281024','281116','281134','281135','281136','281137','281138','281139','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','282776','283209','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','285975','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286358','286823','286968','286983','287211','288017','288076','288087','288164','288211','288356','288478','288503','288645','288647','288699','288736','288745','288957','288967','289072','289092','289108','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293209','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293601','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295591','295799','295808','295839','295980','295991','295992','295993','297028','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298152','298211','298221','298228','298401','298515','298564','299074','299206','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300590','300592','300665','300687','300907','300930','301032','301944','301974','302079','302198','302304','303922') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke1: SELECT `candell`,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 `candell` !='' AND `modx_site_content`.`id` IN ('153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153569','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155212','155312','155313','155314','155561','155650','155728','155812','155813','155814','155815','155816','155817','155818','155819','155820','155821','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157528','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157805','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158403','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160573','160616','160623','160664','160665','160715','160721','160729','160902','160903','160904','160909','161002','161056','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161218','161258','161276','161281','161320','161325','161328','161343','161345','161359','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162049','162077','162078','162119','162250','162278','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163521','163550','163558','163615','163645','163670','163764','163773','163839','163855','163881','164186','164187','164237','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166896','166901','166925','166935','166936','167046','167146','167228','167229','167230','167238','167264','167292','167370','167431','167460','167576','167695','167781','167784','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238666','238672','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239311','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240190','240198','240219','240220','240391','240415','240416','240469','240579','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241065','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241881','241888','241896','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242586','242620','242666','242705','242708','242717','242794','242855','242882','242965','242979','242986','242988','242991','243019','243024','243192','243227','243308','243346','243557','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244540','244627','244699','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248026','248058','248113','248138','248457','248531','248812','248872','248929','249053','249058','249112','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250047','250131','250147','250249','250294','250301','250453','250500','250641','250664','250774','250829','250933','251037','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252046','252054','252055','252075','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253696','253785','253835','253894','253897','254237','254354','254364','254403','254413','254464','254570','254581','254716','254764','254831','254946','255167','255279','255328','255374','255482','255619','255620','255660','255716','255722','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261776','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262554','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263602','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265949','265978','265979','266128','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268225','268274','268616','268675','268740','268800','268812','268879','269076','269098','269101','269476','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273856','273882','273923','273947','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274898','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276108','276115','276249','276391','276444','276543','276548','276605','276606','276971','276989','277280','277312','277332','277366','277375','277480','277802','277821','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280968','280982','281007','281024','281116','281134','281135','281136','281137','281138','281139','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','282776','283209','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','285975','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286358','286823','286968','286983','287211','288017','288076','288087','288164','288211','288356','288478','288503','288645','288647','288699','288736','288745','288957','288967','289072','289092','289108','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293209','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293601','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295591','295799','295808','295839','295980','295991','295992','295993','297028','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298152','298211','298221','298228','298401','298515','298564','299074','299206','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300590','300592','300665','300687','300907','300930','301032','301944','301974','302079','302198','302304','303922') GROUP BY `candell` ORDER BY `candell` ASC
childsstroke: lens_color
SELECT `lens_color`,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 `lens_color` !='' AND `modx_site_content`.`id` IN ('57','80','100','150','184','297','153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155312','155313','155314','155561','155650','155818','155819','155820','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160616','160623','160664','160665','160715','160721','160729','160909','161002','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161258','161276','161281','161320','161325','161328','161343','161345','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162077','162078','162119','162250','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163550','163558','163615','163670','163764','163773','163839','163881','164186','164187','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166901','166925','166935','166936','167146','167228','167229','167230','167238','167264','167370','167431','167460','167576','167695','167781','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240198','240219','240220','240391','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241888','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242965','242979','242988','242991','243024','243227','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244627','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248058','248113','248457','248531','248812','248872','248929','249053','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250147','250249','250294','250301','250664','250774','250829','250933','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252054','252055','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253785','253835','253894','253897','254237','254354','254403','254413','254464','254581','254716','254764','254831','255167','255328','255374','255482','255619','255620','255660','255716','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265978','265979','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268274','268616','268740','268812','268879','269076','269098','269101','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273882','273923','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276115','276391','276444','276543','276605','276606','276971','277280','277312','277332','277375','277480','277802','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280982','281007','281024','281116','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286968','286983','287211','288017','288076','288087','288164','288211','288645','288699','288736','288745','288957','288967','289072','289092','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295799','295808','295839','295980','295991','295992','295993','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298221','298228','298401','298564','299074','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300687','300930','301032','301944','302079','302198','302304','303922','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244699','248026','248138','249058','250047','250131','250453','250641','251037','252046','254364','255722','261776','268225','268800','269476','273856','273947','276548','277366','281134','281135','281136','281137','281138','281139','285975','286358','286823','288478','293209','293601','295591','297028','298152','298211','299206','300665','300907','155728','157528','158403','163645','238666','238672','241065','244540','249112','250500','252075','253696','254570','254946','255279','262554','263602','268675','274898','276108','276249','276989','277821','280968','282776','283209','288356','288503','288647','289108','300590','300592','301974','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','240190','266128','240415','240416','160902','160903','160904','265949') GROUP BY `lens_color` ORDER BY `lens_color` ASC
childsstroke1: lens_color
SELECT `lens_color`,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 `lens_color` !='' AND `modx_site_content`.`id` IN ('153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153569','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155212','155312','155313','155314','155561','155650','155728','155812','155813','155814','155815','155816','155817','155818','155819','155820','155821','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157528','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157805','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158403','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160573','160616','160623','160664','160665','160715','160721','160729','160902','160903','160904','160909','161002','161056','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161218','161258','161276','161281','161320','161325','161328','161343','161345','161359','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162049','162077','162078','162119','162250','162278','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163521','163550','163558','163615','163645','163670','163764','163773','163839','163855','163881','164186','164187','164237','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166896','166901','166925','166935','166936','167046','167146','167228','167229','167230','167238','167264','167292','167370','167431','167460','167576','167695','167781','167784','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238666','238672','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239311','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240190','240198','240219','240220','240391','240415','240416','240469','240579','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241065','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241881','241888','241896','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242586','242620','242666','242705','242708','242717','242794','242855','242882','242965','242979','242986','242988','242991','243019','243024','243192','243227','243308','243346','243557','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244540','244627','244699','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248026','248058','248113','248138','248457','248531','248812','248872','248929','249053','249058','249112','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250047','250131','250147','250249','250294','250301','250453','250500','250641','250664','250774','250829','250933','251037','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252046','252054','252055','252075','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253696','253785','253835','253894','253897','254237','254354','254364','254403','254413','254464','254570','254581','254716','254764','254831','254946','255167','255279','255328','255374','255482','255619','255620','255660','255716','255722','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261776','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262554','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263602','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265949','265978','265979','266128','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268225','268274','268616','268675','268740','268800','268812','268879','269076','269098','269101','269476','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273856','273882','273923','273947','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274898','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276108','276115','276249','276391','276444','276543','276548','276605','276606','276971','276989','277280','277312','277332','277366','277375','277480','277802','277821','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280968','280982','281007','281024','281116','281134','281135','281136','281137','281138','281139','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','282776','283209','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','285975','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286358','286823','286968','286983','287211','288017','288076','288087','288164','288211','288356','288478','288503','288645','288647','288699','288736','288745','288957','288967','289072','289092','289108','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293209','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293601','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295591','295799','295808','295839','295980','295991','295992','295993','297028','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298152','298211','298221','298228','298401','298515','298564','299074','299206','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300590','300592','300665','300687','300907','300930','301032','301944','301974','302079','302198','302304','303922') GROUP BY `lens_color` ORDER BY `lens_color` ASC
childsstroke: leddiam
SELECT `leddiam`,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 `leddiam` !='' AND `modx_site_content`.`id` IN ('57','80','100','150','184','297','153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155312','155313','155314','155561','155650','155818','155819','155820','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160616','160623','160664','160665','160715','160721','160729','160909','161002','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161258','161276','161281','161320','161325','161328','161343','161345','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162077','162078','162119','162250','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163550','163558','163615','163670','163764','163773','163839','163881','164186','164187','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166901','166925','166935','166936','167146','167228','167229','167230','167238','167264','167370','167431','167460','167576','167695','167781','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240198','240219','240220','240391','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241888','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242965','242979','242988','242991','243024','243227','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244627','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248058','248113','248457','248531','248812','248872','248929','249053','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250147','250249','250294','250301','250664','250774','250829','250933','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252054','252055','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253785','253835','253894','253897','254237','254354','254403','254413','254464','254581','254716','254764','254831','255167','255328','255374','255482','255619','255620','255660','255716','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265978','265979','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268274','268616','268740','268812','268879','269076','269098','269101','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273882','273923','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276115','276391','276444','276543','276605','276606','276971','277280','277312','277332','277375','277480','277802','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280982','281007','281024','281116','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286968','286983','287211','288017','288076','288087','288164','288211','288645','288699','288736','288745','288957','288967','289072','289092','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295799','295808','295839','295980','295991','295992','295993','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298221','298228','298401','298564','299074','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300687','300930','301032','301944','302079','302198','302304','303922','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244699','248026','248138','249058','250047','250131','250453','250641','251037','252046','254364','255722','261776','268225','268800','269476','273856','273947','276548','277366','281134','281135','281136','281137','281138','281139','285975','286358','286823','288478','293209','293601','295591','297028','298152','298211','299206','300665','300907','155728','157528','158403','163645','238666','238672','241065','244540','249112','250500','252075','253696','254570','254946','255279','262554','263602','268675','274898','276108','276249','276989','277821','280968','282776','283209','288356','288503','288647','289108','300590','300592','301974','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','240190','266128','240415','240416','160902','160903','160904','265949') GROUP BY `leddiam` ORDER BY `leddiam` ASC
childsstroke1: leddiam
SELECT `leddiam`,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 `leddiam` !='' AND `modx_site_content`.`id` IN ('153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153569','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155212','155312','155313','155314','155561','155650','155728','155812','155813','155814','155815','155816','155817','155818','155819','155820','155821','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157528','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157805','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158403','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160573','160616','160623','160664','160665','160715','160721','160729','160902','160903','160904','160909','161002','161056','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161218','161258','161276','161281','161320','161325','161328','161343','161345','161359','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162049','162077','162078','162119','162250','162278','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163521','163550','163558','163615','163645','163670','163764','163773','163839','163855','163881','164186','164187','164237','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166896','166901','166925','166935','166936','167046','167146','167228','167229','167230','167238','167264','167292','167370','167431','167460','167576','167695','167781','167784','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238666','238672','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239311','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240190','240198','240219','240220','240391','240415','240416','240469','240579','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241065','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241881','241888','241896','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242586','242620','242666','242705','242708','242717','242794','242855','242882','242965','242979','242986','242988','242991','243019','243024','243192','243227','243308','243346','243557','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244540','244627','244699','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248026','248058','248113','248138','248457','248531','248812','248872','248929','249053','249058','249112','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250047','250131','250147','250249','250294','250301','250453','250500','250641','250664','250774','250829','250933','251037','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252046','252054','252055','252075','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253696','253785','253835','253894','253897','254237','254354','254364','254403','254413','254464','254570','254581','254716','254764','254831','254946','255167','255279','255328','255374','255482','255619','255620','255660','255716','255722','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261776','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262554','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263602','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265949','265978','265979','266128','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268225','268274','268616','268675','268740','268800','268812','268879','269076','269098','269101','269476','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273856','273882','273923','273947','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274898','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276108','276115','276249','276391','276444','276543','276548','276605','276606','276971','276989','277280','277312','277332','277366','277375','277480','277802','277821','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280968','280982','281007','281024','281116','281134','281135','281136','281137','281138','281139','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','282776','283209','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','285975','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286358','286823','286968','286983','287211','288017','288076','288087','288164','288211','288356','288478','288503','288645','288647','288699','288736','288745','288957','288967','289072','289092','289108','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293209','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293601','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295591','295799','295808','295839','295980','295991','295992','295993','297028','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298152','298211','298221','298228','298401','298515','298564','299074','299206','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300590','300592','300665','300687','300907','300930','301032','301944','301974','302079','302198','302304','303922') GROUP BY `leddiam` ORDER BY `leddiam` ASC
childsstroke: wavelength
SELECT `wavelength`,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 `wavelength` !='' AND `modx_site_content`.`id` IN ('57','80','100','150','184','297','153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155312','155313','155314','155561','155650','155818','155819','155820','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160616','160623','160664','160665','160715','160721','160729','160909','161002','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161258','161276','161281','161320','161325','161328','161343','161345','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162077','162078','162119','162250','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163550','163558','163615','163670','163764','163773','163839','163881','164186','164187','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166901','166925','166935','166936','167146','167228','167229','167230','167238','167264','167370','167431','167460','167576','167695','167781','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240198','240219','240220','240391','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241888','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242965','242979','242988','242991','243024','243227','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244627','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248058','248113','248457','248531','248812','248872','248929','249053','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250147','250249','250294','250301','250664','250774','250829','250933','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252054','252055','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253785','253835','253894','253897','254237','254354','254403','254413','254464','254581','254716','254764','254831','255167','255328','255374','255482','255619','255620','255660','255716','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265978','265979','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268274','268616','268740','268812','268879','269076','269098','269101','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273882','273923','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276115','276391','276444','276543','276605','276606','276971','277280','277312','277332','277375','277480','277802','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280982','281007','281024','281116','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286968','286983','287211','288017','288076','288087','288164','288211','288645','288699','288736','288745','288957','288967','289072','289092','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295799','295808','295839','295980','295991','295992','295993','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298221','298228','298401','298564','299074','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300687','300930','301032','301944','302079','302198','302304','303922','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244699','248026','248138','249058','250047','250131','250453','250641','251037','252046','254364','255722','261776','268225','268800','269476','273856','273947','276548','277366','281134','281135','281136','281137','281138','281139','285975','286358','286823','288478','293209','293601','295591','297028','298152','298211','299206','300665','300907','155728','157528','158403','163645','238666','238672','241065','244540','249112','250500','252075','253696','254570','254946','255279','262554','263602','268675','274898','276108','276249','276989','277821','280968','282776','283209','288356','288503','288647','289108','300590','300592','301974','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','240190','266128','240415','240416','160902','160903','160904','265949') GROUP BY `wavelength` ORDER BY `wavelength` ASC
childsstroke1: wavelength
SELECT `wavelength`,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 `wavelength` !='' AND `modx_site_content`.`id` IN ('153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153569','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155212','155312','155313','155314','155561','155650','155728','155812','155813','155814','155815','155816','155817','155818','155819','155820','155821','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157528','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157805','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158403','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160573','160616','160623','160664','160665','160715','160721','160729','160902','160903','160904','160909','161002','161056','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161218','161258','161276','161281','161320','161325','161328','161343','161345','161359','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162049','162077','162078','162119','162250','162278','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163521','163550','163558','163615','163645','163670','163764','163773','163839','163855','163881','164186','164187','164237','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166896','166901','166925','166935','166936','167046','167146','167228','167229','167230','167238','167264','167292','167370','167431','167460','167576','167695','167781','167784','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238666','238672','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239311','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240190','240198','240219','240220','240391','240415','240416','240469','240579','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241065','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241881','241888','241896','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242586','242620','242666','242705','242708','242717','242794','242855','242882','242965','242979','242986','242988','242991','243019','243024','243192','243227','243308','243346','243557','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244540','244627','244699','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248026','248058','248113','248138','248457','248531','248812','248872','248929','249053','249058','249112','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250047','250131','250147','250249','250294','250301','250453','250500','250641','250664','250774','250829','250933','251037','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252046','252054','252055','252075','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253696','253785','253835','253894','253897','254237','254354','254364','254403','254413','254464','254570','254581','254716','254764','254831','254946','255167','255279','255328','255374','255482','255619','255620','255660','255716','255722','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261776','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262554','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263602','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265949','265978','265979','266128','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268225','268274','268616','268675','268740','268800','268812','268879','269076','269098','269101','269476','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273856','273882','273923','273947','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274898','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276108','276115','276249','276391','276444','276543','276548','276605','276606','276971','276989','277280','277312','277332','277366','277375','277480','277802','277821','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280968','280982','281007','281024','281116','281134','281135','281136','281137','281138','281139','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','282776','283209','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','285975','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286358','286823','286968','286983','287211','288017','288076','288087','288164','288211','288356','288478','288503','288645','288647','288699','288736','288745','288957','288967','289072','289092','289108','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293209','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293601','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295591','295799','295808','295839','295980','295991','295992','295993','297028','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298152','298211','298221','298228','298401','298515','298564','299074','299206','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300590','300592','300665','300687','300907','300930','301032','301944','301974','302079','302198','302304','303922') GROUP BY `wavelength` ORDER BY `wavelength` ASC
childsstroke: montage
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 ('57','80','100','150','184','297','153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155312','155313','155314','155561','155650','155818','155819','155820','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160616','160623','160664','160665','160715','160721','160729','160909','161002','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161258','161276','161281','161320','161325','161328','161343','161345','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162077','162078','162119','162250','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163550','163558','163615','163670','163764','163773','163839','163881','164186','164187','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166901','166925','166935','166936','167146','167228','167229','167230','167238','167264','167370','167431','167460','167576','167695','167781','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240198','240219','240220','240391','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241888','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242965','242979','242988','242991','243024','243227','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244627','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248058','248113','248457','248531','248812','248872','248929','249053','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250147','250249','250294','250301','250664','250774','250829','250933','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252054','252055','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253785','253835','253894','253897','254237','254354','254403','254413','254464','254581','254716','254764','254831','255167','255328','255374','255482','255619','255620','255660','255716','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265978','265979','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268274','268616','268740','268812','268879','269076','269098','269101','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273882','273923','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276115','276391','276444','276543','276605','276606','276971','277280','277312','277332','277375','277480','277802','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280982','281007','281024','281116','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286968','286983','287211','288017','288076','288087','288164','288211','288645','288699','288736','288745','288957','288967','289072','289092','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295799','295808','295839','295980','295991','295992','295993','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298221','298228','298401','298564','299074','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300687','300930','301032','301944','302079','302198','302304','303922','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244699','248026','248138','249058','250047','250131','250453','250641','251037','252046','254364','255722','261776','268225','268800','269476','273856','273947','276548','277366','281134','281135','281136','281137','281138','281139','285975','286358','286823','288478','293209','293601','295591','297028','298152','298211','299206','300665','300907','155728','157528','158403','163645','238666','238672','241065','244540','249112','250500','252075','253696','254570','254946','255279','262554','263602','268675','274898','276108','276249','276989','277821','280968','282776','283209','288356','288503','288647','289108','300590','300592','301974','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','240190','266128','240415','240416','160902','160903','160904','265949') GROUP BY `montage` ORDER BY `montage` ASC
childsstroke1: montage
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 ('153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153569','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155212','155312','155313','155314','155561','155650','155728','155812','155813','155814','155815','155816','155817','155818','155819','155820','155821','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157528','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157805','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158403','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160573','160616','160623','160664','160665','160715','160721','160729','160902','160903','160904','160909','161002','161056','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161218','161258','161276','161281','161320','161325','161328','161343','161345','161359','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162049','162077','162078','162119','162250','162278','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163521','163550','163558','163615','163645','163670','163764','163773','163839','163855','163881','164186','164187','164237','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166896','166901','166925','166935','166936','167046','167146','167228','167229','167230','167238','167264','167292','167370','167431','167460','167576','167695','167781','167784','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238666','238672','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239311','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240190','240198','240219','240220','240391','240415','240416','240469','240579','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241065','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241881','241888','241896','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242586','242620','242666','242705','242708','242717','242794','242855','242882','242965','242979','242986','242988','242991','243019','243024','243192','243227','243308','243346','243557','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244540','244627','244699','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248026','248058','248113','248138','248457','248531','248812','248872','248929','249053','249058','249112','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250047','250131','250147','250249','250294','250301','250453','250500','250641','250664','250774','250829','250933','251037','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252046','252054','252055','252075','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253696','253785','253835','253894','253897','254237','254354','254364','254403','254413','254464','254570','254581','254716','254764','254831','254946','255167','255279','255328','255374','255482','255619','255620','255660','255716','255722','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261776','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262554','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263602','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265949','265978','265979','266128','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268225','268274','268616','268675','268740','268800','268812','268879','269076','269098','269101','269476','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273856','273882','273923','273947','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274898','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276108','276115','276249','276391','276444','276543','276548','276605','276606','276971','276989','277280','277312','277332','277366','277375','277480','277802','277821','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280968','280982','281007','281024','281116','281134','281135','281136','281137','281138','281139','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','282776','283209','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','285975','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286358','286823','286968','286983','287211','288017','288076','288087','288164','288211','288356','288478','288503','288645','288647','288699','288736','288745','288957','288967','289072','289092','289108','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293209','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293601','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295591','295799','295808','295839','295980','295991','295992','295993','297028','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298152','298211','298221','298228','298401','298515','298564','299074','299206','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300590','300592','300665','300687','300907','300930','301032','301944','301974','302079','302198','302304','303922') GROUP BY `montage` ORDER BY `montage` ASC
childsstroke: color
SELECT `color`,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 `color` !='' AND `modx_site_content`.`id` IN ('57','80','100','150','184','297','153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155312','155313','155314','155561','155650','155818','155819','155820','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160616','160623','160664','160665','160715','160721','160729','160909','161002','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161258','161276','161281','161320','161325','161328','161343','161345','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162077','162078','162119','162250','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163550','163558','163615','163670','163764','163773','163839','163881','164186','164187','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166901','166925','166935','166936','167146','167228','167229','167230','167238','167264','167370','167431','167460','167576','167695','167781','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240198','240219','240220','240391','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241888','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242965','242979','242988','242991','243024','243227','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244627','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248058','248113','248457','248531','248812','248872','248929','249053','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250147','250249','250294','250301','250664','250774','250829','250933','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252054','252055','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253785','253835','253894','253897','254237','254354','254403','254413','254464','254581','254716','254764','254831','255167','255328','255374','255482','255619','255620','255660','255716','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265978','265979','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268274','268616','268740','268812','268879','269076','269098','269101','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273882','273923','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276115','276391','276444','276543','276605','276606','276971','277280','277312','277332','277375','277480','277802','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280982','281007','281024','281116','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286968','286983','287211','288017','288076','288087','288164','288211','288645','288699','288736','288745','288957','288967','289072','289092','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295799','295808','295839','295980','295991','295992','295993','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298221','298228','298401','298564','299074','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300687','300930','301032','301944','302079','302198','302304','303922','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244699','248026','248138','249058','250047','250131','250453','250641','251037','252046','254364','255722','261776','268225','268800','269476','273856','273947','276548','277366','281134','281135','281136','281137','281138','281139','285975','286358','286823','288478','293209','293601','295591','297028','298152','298211','299206','300665','300907','155728','157528','158403','163645','238666','238672','241065','244540','249112','250500','252075','253696','254570','254946','255279','262554','263602','268675','274898','276108','276249','276989','277821','280968','282776','283209','288356','288503','288647','289108','300590','300592','301974','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','240190','266128','240415','240416','160902','160903','160904','265949') GROUP BY `color` ORDER BY `color` ASC
childsstroke1: color
SELECT `color`,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 `color` !='' AND `modx_site_content`.`id` IN ('153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153569','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155212','155312','155313','155314','155561','155650','155728','155812','155813','155814','155815','155816','155817','155818','155819','155820','155821','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157528','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157805','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158403','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160573','160616','160623','160664','160665','160715','160721','160729','160902','160903','160904','160909','161002','161056','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161218','161258','161276','161281','161320','161325','161328','161343','161345','161359','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162049','162077','162078','162119','162250','162278','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163521','163550','163558','163615','163645','163670','163764','163773','163839','163855','163881','164186','164187','164237','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166896','166901','166925','166935','166936','167046','167146','167228','167229','167230','167238','167264','167292','167370','167431','167460','167576','167695','167781','167784','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238666','238672','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239311','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240190','240198','240219','240220','240391','240415','240416','240469','240579','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241065','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241881','241888','241896','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242586','242620','242666','242705','242708','242717','242794','242855','242882','242965','242979','242986','242988','242991','243019','243024','243192','243227','243308','243346','243557','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244540','244627','244699','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248026','248058','248113','248138','248457','248531','248812','248872','248929','249053','249058','249112','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250047','250131','250147','250249','250294','250301','250453','250500','250641','250664','250774','250829','250933','251037','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252046','252054','252055','252075','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253696','253785','253835','253894','253897','254237','254354','254364','254403','254413','254464','254570','254581','254716','254764','254831','254946','255167','255279','255328','255374','255482','255619','255620','255660','255716','255722','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261776','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262554','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263602','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265949','265978','265979','266128','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268225','268274','268616','268675','268740','268800','268812','268879','269076','269098','269101','269476','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273856','273882','273923','273947','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274898','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276108','276115','276249','276391','276444','276543','276548','276605','276606','276971','276989','277280','277312','277332','277366','277375','277480','277802','277821','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280968','280982','281007','281024','281116','281134','281135','281136','281137','281138','281139','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','282776','283209','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','285975','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286358','286823','286968','286983','287211','288017','288076','288087','288164','288211','288356','288478','288503','288645','288647','288699','288736','288745','288957','288967','289072','289092','289108','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293209','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293601','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295591','295799','295808','295839','295980','295991','295992','295993','297028','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298152','298211','298221','298228','298401','298515','298564','299074','299206','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300590','300592','300665','300687','300907','300930','301032','301944','301974','302079','302198','302304','303922') GROUP BY `color` ORDER BY `color` 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 ('57','80','100','150','184','297','153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155312','155313','155314','155561','155650','155818','155819','155820','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160616','160623','160664','160665','160715','160721','160729','160909','161002','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161258','161276','161281','161320','161325','161328','161343','161345','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162077','162078','162119','162250','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163550','163558','163615','163670','163764','163773','163839','163881','164186','164187','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166901','166925','166935','166936','167146','167228','167229','167230','167238','167264','167370','167431','167460','167576','167695','167781','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240198','240219','240220','240391','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241888','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242965','242979','242988','242991','243024','243227','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244627','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248058','248113','248457','248531','248812','248872','248929','249053','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250147','250249','250294','250301','250664','250774','250829','250933','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252054','252055','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253785','253835','253894','253897','254237','254354','254403','254413','254464','254581','254716','254764','254831','255167','255328','255374','255482','255619','255620','255660','255716','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265978','265979','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268274','268616','268740','268812','268879','269076','269098','269101','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273882','273923','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276115','276391','276444','276543','276605','276606','276971','277280','277312','277332','277375','277480','277802','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280982','281007','281024','281116','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286968','286983','287211','288017','288076','288087','288164','288211','288645','288699','288736','288745','288957','288967','289072','289092','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295799','295808','295839','295980','295991','295992','295993','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298221','298228','298401','298564','299074','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300687','300930','301032','301944','302079','302198','302304','303922','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244699','248026','248138','249058','250047','250131','250453','250641','251037','252046','254364','255722','261776','268225','268800','269476','273856','273947','276548','277366','281134','281135','281136','281137','281138','281139','285975','286358','286823','288478','293209','293601','295591','297028','298152','298211','299206','300665','300907','155728','157528','158403','163645','238666','238672','241065','244540','249112','250500','252075','253696','254570','254946','255279','262554','263602','268675','274898','276108','276249','276989','277821','280968','282776','283209','288356','288503','288647','289108','300590','300592','301974','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','240190','266128','240415','240416','160902','160903','160904','265949') 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 ('153068','153081','153088','153089','153095','153123','153124','153125','153126','153136','153140','153141','153142','153143','153144','153145','153146','153376','153377','153378','153383','153540','153541','153561','153567','153568','153569','153581','153643','153771','153772','153879','153928','153929','154135','154160','154250','154269','154273','154324','154410','154469','154516','154592','154621','154643','154647','154648','154649','154682','154688','154714','154741','154742','154743','154784','154846','154847','154848','154849','154850','154851','154852','154856','154857','154860','154861','154865','154878','154879','154891','154945','154960','154961','154962','154963','154971','154975','154976','154993','155001','155002','155003','155004','155026','155027','155028','155039','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155076','155092','155093','155094','155095','155096','155097','155098','155108','155117','155118','155119','155120','155142','155212','155312','155313','155314','155561','155650','155728','155812','155813','155814','155815','155816','155817','155818','155819','155820','155821','155924','155925','155926','155927','155928','155929','155930','155931','155932','155933','155934','155935','155936','155937','155938','155939','155940','155941','155942','155943','155944','155945','155946','155947','155948','155949','155950','155951','155952','155953','155954','155955','155956','155957','155958','155959','155960','155961','155962','155963','155964','155965','155966','155967','155968','155969','155970','155971','155972','155973','155974','155975','155976','155977','155978','155979','155980','155981','155982','155983','155984','155985','155986','155987','155988','155989','155990','155991','155992','155993','155994','155995','155996','155997','155998','155999','156000','156001','156002','156003','156004','156005','156006','156007','156008','156009','156010','156011','156012','156013','156014','156015','156016','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','156227','156228','156236','156237','156238','156239','156240','156241','156242','156243','156252','156253','156254','156255','156256','156257','157528','157537','157538','157539','157540','157541','157542','157543','157545','157687','157756','157781','157805','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158403','158447','158477','158525','158578','158643','158644','158676','158677','158678','158699','158739','158770','158793','158918','158968','159001','159042','159120','159159','159224','159226','159260','159326','159368','159441','159442','159524','159526','159542','159557','159565','159642','159671','159720','159726','159806','159807','159808','159809','159863','159884','159885','159920','159948','159978','160043','160071','160386','160407','160429','160434','160479','160480','160481','160496','160573','160616','160623','160664','160665','160715','160721','160729','160902','160903','160904','160909','161002','161056','161060','161061','161069','161070','161071','161072','161073','161118','161196','161214','161218','161258','161276','161281','161320','161325','161328','161343','161345','161359','161373','161384','161385','161386','161420','161553','161623','161624','161770','161821','161929','161963','161981','161996','162001','162002','162017','162026','162027','162049','162077','162078','162119','162250','162278','162293','162318','162336','162356','162357','162358','162381','162431','162550','162612','162620','162645','162646','162697','162704','162721','162780','162795','162848','162849','162862','162893','162901','162979','162993','163085','163089','163090','163219','163303','163347','163348','163349','163350','163361','163382','163383','163384','163385','163416','163439','163463','163521','163550','163558','163615','163645','163670','163764','163773','163839','163855','163881','164186','164187','164237','164343','164344','164373','164374','164404','164670','164752','164825','164848','164850','164901','164934','164974','165014','165056','165106','165114','165115','165116','165117','165248','165377','165382','165457','165506','165507','165508','165509','165510','165511','165512','165513','165610','165650','165692','165693','165706','165740','165778','165854','165883','166090','166126','166254','166272','166310','166311','166540','166545','166594','166607','166754','166773','166781','166799','166896','166901','166925','166935','166936','167046','167146','167228','167229','167230','167238','167264','167292','167370','167431','167460','167576','167695','167781','167784','167832','167865','167866','167867','167911','167928','167953','167986','167987','168238','168263','168287','168290','168331','168390','232458','232719','232746','238116','238117','238165','238274','238283','238290','238408','238527','238570','238652','238663','238666','238672','238688','238689','238690','238691','238692','238693','238694','238695','238696','238697','238710','238711','238822','238873','238885','238968','238969','239034','239035','239036','239037','239041','239296','239311','239355','239374','239396','239399','239408','239451','239492','239513','239525','239558','239561','239762','239763','239764','239765','239766','239820','239823','239830','239831','239836','239927','239931','239932','239961','240169','240190','240198','240219','240220','240391','240415','240416','240469','240579','240619','240685','240727','240918','240999','241000','241001','241002','241003','241004','241005','241014','241065','241139','241148','241158','241464','241710','241711','241712','241713','241714','241715','241718','241793','241827','241861','241881','241888','241896','241913','241914','241915','242009','242023','242042','242209','242237','242254','242333','242568','242586','242620','242666','242705','242708','242717','242794','242855','242882','242965','242979','242986','242988','242991','243019','243024','243192','243227','243308','243346','243557','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244517','244540','244627','244699','244866','244903','244910','244911','244965','244966','244988','244989','244993','245010','245082','245197','245222','245298','245569','245570','245725','246051','246098','246199','246200','246250','246324','246325','246339','246361','246364','246503','246644','246795','246810','246820','246860','246950','247095','247141','247193','247203','247246','247311','247321','247341','247461','247462','247510','247574','247670','247687','247688','247689','247770','247820','247894','247916','247984','248026','248058','248113','248138','248457','248531','248812','248872','248929','249053','249058','249112','249222','249290','249291','249303','249364','249380','249527','249552','249620','249684','249813','250047','250131','250147','250249','250294','250301','250453','250500','250641','250664','250774','250829','250933','251037','251083','251084','251174','251229','251309','251310','251311','251383','251415','251465','251473','251502','251587','251644','251712','251735','251736','251737','251754','251888','251932','251938','251954','251956','251965','252014','252025','252046','252054','252055','252075','252101','252163','252179','253037','253384','253395','253498','253510','253591','253644','253689','253695','253696','253785','253835','253894','253897','254237','254354','254364','254403','254413','254464','254570','254581','254716','254764','254831','254946','255167','255279','255328','255374','255482','255619','255620','255660','255716','255722','255765','255786','255879','255998','256063','256069','256118','256240','256319','256333','256495','256667','256681','256837','256852','256858','256909','256910','256925','257097','257098','257099','257134','257135','257159','257160','257185','261747','261776','261981','261996','262088','262159','262160','262335','262342','262351','262417','262437','262554','262603','262618','262727','263049','263056','263063','263068','263076','263099','263129','263181','263182','263602','263677','263742','263743','264362','264392','264396','264512','264710','264805','264812','264908','265000','265008','265244','265261','265774','265832','265949','265978','265979','266128','266232','266263','266457','266458','266583','266633','266654','266748','266788','266939','267056','267074','267077','267078','267079','267080','267081','267082','267083','267154','267433','267679','267760','267768','267776','267834','267925','267926','268003','268060','268074','268094','268225','268274','268616','268675','268740','268800','268812','268879','269076','269098','269101','269476','269502','269510','269539','269559','269626','273376','273386','273446','273447','273448','273477','273744','273856','273882','273923','273947','273968','274134','274236','274237','274283','274362','274376','274563','274595','274646','274683','274723','274874','274898','274929','275091','275110','275430','275431','275481','275627','275628','275629','275630','275741','275742','275755','275951','276108','276115','276249','276391','276444','276543','276548','276605','276606','276971','276989','277280','277312','277332','277366','277375','277480','277802','277821','277877','277997','278099','278137','278323','278324','278325','278326','278327','278440','278443','278444','278462','278554','278577','278722','278730','278731','278999','279003','279018','279019','279020','279022','279066','279199','279335','279340','279383','279447','279473','279483','279532','279722','279836','280329','280330','280346','280387','280390','280845','280868','280968','280982','281007','281024','281116','281134','281135','281136','281137','281138','281139','281227','281250','281419','281428','281453','281479','281583','281614','281615','281802','282138','282245','282343','282393','282394','282548','282776','283209','283328','283503','283530','283555','283558','283569','283727','284265','284426','284429','284467','284607','284635','284649','284822','284956','284965','285023','285079','285080','285226','285263','285264','285363','285552','285603','285655','285683','285743','285975','286072','286076','286078','286100','286153','286166','286180','286207','286212','286248','286358','286823','286968','286983','287211','288017','288076','288087','288164','288211','288356','288478','288503','288645','288647','288699','288736','288745','288957','288967','289072','289092','289108','289436','289492','291642','292015','292053','292213','292251','292252','292253','292317','292378','292412','292414','292542','292604','292606','292651','292676','292690','292691','292754','292799','292827','293209','293215','293226','293232','293467','293483','293503','293504','293505','293516','293520','293601','293889','294012','294019','294234','294253','294254','294255','294260','294263','294274','294275','294278','294573','294574','294598','294608','294667','294751','294760','294872','294951','294977','295275','295286','295349','295369','295389','295493','295501','295583','295591','295799','295808','295839','295980','295991','295992','295993','297028','297086','297087','297089','297093','297178','297313','297345','297348','297349','297440','297580','297583','297584','297603','297604','297727','297728','297737','297764','297805','297814','298027','298031','298089','298092','298152','298211','298221','298228','298401','298515','298564','299074','299206','299229','299256','299290','299293','299297','299298','299299','299300','299301','299302','299303','299304','299305','299306','299307','299308','299309','299310','299311','299312','299313','299314','299315','299316','299317','299318','299319','299320','299321','299322','299323','299324','299325','299326','299327','299328','299329','299330','299331','299332','299333','299334','299335','299336','299337','299338','299339','299340','299341','299342','299343','299344','299345','299346','299347','299361','299369','299434','299444','299476','299551','299631','299638','299790','299791','299792','299793','299801','300018','300054','300176','300177','300178','300179','300180','300181','300229','300278','300501','300590','300592','300665','300687','300907','300930','301032','301944','301974','302079','302198','302304','303922') GROUP BY `packages` ORDER BY `packages` ASC
