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','141319','141321','141322','141325','141326','141327','141340','141343','141344','141345','141360','141361','141362','141363','141364','141365','141366','141367','141368','141386','141387','141388','141389','141390','141391','141392','141393','141394','141395','141396','141417','141418','141467','141468','141469','141475','141476','141477','141478','141479','141480','141481','141482','141483','141484','141485','141486','141487','141488','141489','141490','141491','141492','141493','141494','141495','141505','141507','141512','141516','141517','141518','141519','141520','141521','141533','141543','141564','141565','141566','141567','141570','141571','141596','141597','141598','141620','141621','141622','141623','141624','141626','141628','141630','141631','141633','141634','141635','141648','141649','141650','141651','141652','141653','141654','141661','141662','141663','141664','141668','141673','141688','141689','141690','141693','141708','141711','141712','141713','141714','141715','141718','141719','141720','141721','141722','141723','141724','141726','141736','141737','141738','141739','141740','141741','141742','141743','141744','141761','141799','141800','141801','141802','141803','141804','141805','141855','141856','141857','141858','141859','141860','141863','141864','141867','141885','141907','141908','141909','141910','141913','141916','141917','141918','141948','141949','141950','141951','141952','141953','141954','141955','141961','141962','141963','141967','141981','141982','141994','141996','141997','141998','142004','142005','142031','142032','142036','142037','142038','142039','142053','142063','142119','142121','142122','142123','142124','142125','142126','142130','142141','142146','142147','142148','142166','142168','142177','142178','142179','142180','142181','142183','142201','142216','142218','142221','142236','142237','142238','142239','142240','142241','142242','142243','142244','142245','142246','142247','142248','142249','142250','142251','142252','142253','142254','142255','142256','142257','142258','142259','142260','142261','142262','142263','142264','142265','142266','142267','142268','142269','142270','142271','142272','142273','142274','142275','142276','142277','142278','142279','142280','142281','142282','142283','142284','142285','142286','142287','142288','142289','142290','142291','142292','142293','142294','142295','142296','142297','142298','142299','142300','142301','142302','142303','142304','142305','142306','142307','142308','142309','142313','142314','142315','142316','142317','142320','142321','142322','142323','142325','142326','142327','142328','142329','142330','142331','142332','142333','142334','142335','142336','142337','142338','142339','142340','142341','142342','142343','142344','142345','142346','142347','142348','142349','142350','142351','142352','142353','142354','142355','142356','142357','142358','142359','142360','142361','142362','142363','142364','142365','142366','142367','142368','142369','142370','142371','142372','142373','142374','142375','142376','142377','142378','142379','142380','142381','142382','142383','142384','142385','142386','142387','142388','142389','142390','142391','142392','142394','142395','142396','142397','142398','142399','142400','142401','142402','142403','142404','142405','142406','142407','142408','142409','142410','142411','142412','142413','142414','142415','142416','142417','142418','142419','142420','142421','142422','142423','142424','142425','142426','142427','142428','142429','142430','142431','142432','142433','142434','142435','142436','142437','142438','142439','142440','142441','142442','142443','142444','142445','142446','142447','142448','142449','142450','142451','142452','142453','142454','142455','142456','142457','142458','142459','142460','142461','142462','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142490','142491','142492','142493','142494','142495','142496','142499','142500','142501','142502','142503','142504','142505','142506','142507','142508','142509','142510','142511','142512','142513','142514','142515','142516','142517','142518','142519','142520','142521','142522','142528','142529','142530','142531','142532','142533','142534','142535','142536','142537','142538','142539','142540','142541','142542','142543','142544','142545','142546','142547','142548','142549','142550','142551','142552','142553','142554','142555','142556','142557','142558','142559','142560','142561','142562','142563','142564','142565','142566','142567','142568','142569','142570','142571','142572','142573','142574','142575','142576','142577','142578','142579','142580','142581','142582','142583','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142609','142610','142611','142612','142613','142614','142615','142616','142617','142618','142619','142620','142621','142622','142623','142624','142625','142626','142627','142628','142629','142630','142631','142632','142633','142634','142635','142636','142688','142712','142713','142714','142716','142726','142727','142736','142770','142771','142772','142773','142825','142864','142865','143082','143212','143244','143268','143417','143458','143459','143460','143504','143600','143654','143662','143721','143736','143737','144195','144196','146542','146568','146583','146722','146921','146945','146947','147003','147046','147172','147716','148049','148144','148406','148737','148738','149121','149655','149905','150282','150546','150597','150830','150831','150832','150845','150847','151014','151026','151032','151033','151078','151130','151198','151213','151247','151253','151280','151281','151325','151424','151430','151448','151449','151450','151451','151452','151453','151454','151455','151633','151687','151700','151724','151854','151886','151960','151976','151977','151991','152502','152503','152504','152505','152506','152519','152552','152561','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','156218','156219','156220','156221','156222','156223','156224','156225','156226','156227','156228','156229','156230','156231','156232','156233','156234','156235','156236','156237','156238','156239','156240','156241','156242','156243','156244','156245','156246','156247','156248','156249','156250','156251','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157713','157714','157715','157716','157717','157718','157719','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158604','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','164704','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','169093','169112','169145','169146','169158','169168','169169','169172','169180','169181','169182','169235','169290','169291','169300','169302','169303','169314','169329','169335','169354','169355','169356','169357','169358','169359','169360','169361','169362','169363','169364','169365','169366','169367','169368','169369','169370','169371','169372','169373','169374','169375','169376','169377','169378','169379','169380','169381','169382','169383','169384','169385','169386','169388','169389','169390','169391','169392','169393','169394','169395','169396','169397','169398','169399','169400','169401','169402','169403','169404','169405','169406','169407','169409','169410','169411','169412','169413','169414','169415','169416','169417','169418','169419','169420','169421','169422','169423','169424','169425','169426','169427','169428','169429','169430','169431','169432','169433','169434','169435','169436','169437','169438','169439','169440','169441','169442','169443','169444','169445','169446','169447','169448','169449','169450','169451','169452','169453','169454','169455','169456','169457','169458','169459','169460','169461','169462','169463','169464','169465','169466','169467','169468','169469','169470','169471','169472','169473','169474','169475','169476','169477','169478','169479','169480','169481','169482','169483','169484','169485','169486','169487','169488','169489','169490','169491','169492','169493','169494','169495','169496','169497','169498','169499','169500','169501','169502','169503','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169514','169515','169516','169517','169518','169519','169520','169521','169522','169523','169524','169525','169526','169527','169528','169529','169530','169531','169532','169533','169534','169535','169536','169537','169538','169539','169540','169541','169542','169543','169544','169545','169546','169547','169548','169549','169550','169551','169552','169553','169554','169555','169556','169557','169558','169559','169560','169561','169562','169563','169564','169565','169566','169567','169568','169569','169570','169571','169572','169573','169574','169575','169576','169577','169578','169579','169580','169581','169582','169583','169584','169585','169586','169587','169588','169589','169590','169591','169592','169593','169787','169973','169974','169992','170306','170579','170580','170590','170646','170666','170667','170668','201199','201200','201201','215414','215464','215612','215654','215655','215778','215793','215794','215848','216023','216024','216025','216026','216027','216028','216029','216030','216031','216032','216033','216034','216035','216036','216037','216055','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','238824','238873','238885','238967','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','242064','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242964','242965','242979','242988','242991','243024','243227','243236','243237','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244321','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','248619','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','254285','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','280359','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','141559','141591','141964','142689','142853','143994','148408','148617','150063','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','169348','169859','170147','211148','211149','211150','211151','211152','211153','211154','211155','211156','211157','211158','211159','215909','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244061','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','143217','148143','148710','151725','155728','157528','158403','163645','169993','170114','170290','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','144163','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','216053','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 ('141326','141340','141343','141344','141364','141390','141391','141392','141393','141481','141482','141483','141512','141571','141598','141631','141714','141715','141718','141740','141741','141742','141743','141801','141802','141803','141907','141918','141961','141962','141967','141994','142036','142037','142038','142039','142063','142119','142125','142126','142168','142177','142181','142183','142216','142218','142422','142423','142424','142425','142426','142427','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142492','142493','142494','142495','142496','142499','142500','142501','142502','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142622','142623','142624','142625','142626','142628','142629','142630','142727','142736','143212','143721','144195','144196','151976','151977','151991','152552','153123','153124','153125','153126','154963','154971','155044','155818','155819','155820','155981','156036','156037','156038','156039','156040','156041','156042','156043','157537','158643','158644','159159','159442','160407','160434','162862','166310','167228','167832','169093','169112','169145','169181','169182','169235','169314','169329','169335','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169517','169518','169519','169520','169521','169522','169526','169573','169574','169575','238689','238690','238691','238692','238822','239355','240219','240220','242620','245082','246098','253037','256118','256837','262603','264362','264710','265000','267077','267078','267079','267080','267081','268879','274929','281007','285080','292754','292827','293467','293889','299341') 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 ('141326','141340','141343','141344','141364','141390','141391','141392','141393','141481','141482','141483','141512','141571','141598','141631','141714','141715','141718','141740','141741','141742','141743','141801','141802','141803','141907','141918','141961','141962','141967','141994','142036','142037','142038','142039','142063','142119','142125','142126','142168','142177','142181','142183','142216','142218','142422','142423','142424','142425','142426','142427','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142492','142493','142494','142495','142496','142499','142500','142501','142502','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142622','142623','142624','142625','142626','142628','142629','142630','142727','142736','143212','143721','144195','144196','151976','151977','151991','152552','153123','153124','153125','153126','154963','154971','155044','155818','155819','155820','155981','156036','156037','156038','156039','156040','156041','156042','156043','157537','158643','158644','159159','159442','160407','160434','162862','166310','167228','167832','169093','169112','169145','169181','169182','169235','169314','169329','169335','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169517','169518','169519','169520','169521','169522','169526','169573','169574','169575','238689','238690','238691','238692','238822','239355','240219','240220','242620','245082','246098','253037','256118','256837','262603','264362','264710','265000','267077','267078','267079','267080','267081','268879','274929','281007','285080','292754','292827','293467','293889','299341') 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','141319','141321','141322','141325','141326','141327','141340','141343','141344','141345','141360','141361','141362','141363','141364','141365','141366','141367','141368','141386','141387','141388','141389','141390','141391','141392','141393','141394','141395','141396','141417','141418','141467','141468','141469','141475','141476','141477','141478','141479','141480','141481','141482','141483','141484','141485','141486','141487','141488','141489','141490','141491','141492','141493','141494','141495','141505','141507','141512','141516','141517','141518','141519','141520','141521','141533','141543','141564','141565','141566','141567','141570','141571','141596','141597','141598','141620','141621','141622','141623','141624','141626','141628','141630','141631','141633','141634','141635','141648','141649','141650','141651','141652','141653','141654','141661','141662','141663','141664','141668','141673','141688','141689','141690','141693','141708','141711','141712','141713','141714','141715','141718','141719','141720','141721','141722','141723','141724','141726','141736','141737','141738','141739','141740','141741','141742','141743','141744','141761','141799','141800','141801','141802','141803','141804','141805','141855','141856','141857','141858','141859','141860','141863','141864','141867','141885','141907','141908','141909','141910','141913','141916','141917','141918','141948','141949','141950','141951','141952','141953','141954','141955','141961','141962','141963','141967','141981','141982','141994','141996','141997','141998','142004','142005','142031','142032','142036','142037','142038','142039','142053','142063','142119','142121','142122','142123','142124','142125','142126','142130','142141','142146','142147','142148','142166','142168','142177','142178','142179','142180','142181','142183','142201','142216','142218','142221','142236','142237','142238','142239','142240','142241','142242','142243','142244','142245','142246','142247','142248','142249','142250','142251','142252','142253','142254','142255','142256','142257','142258','142259','142260','142261','142262','142263','142264','142265','142266','142267','142268','142269','142270','142271','142272','142273','142274','142275','142276','142277','142278','142279','142280','142281','142282','142283','142284','142285','142286','142287','142288','142289','142290','142291','142292','142293','142294','142295','142296','142297','142298','142299','142300','142301','142302','142303','142304','142305','142306','142307','142308','142309','142313','142314','142315','142316','142317','142320','142321','142322','142323','142325','142326','142327','142328','142329','142330','142331','142332','142333','142334','142335','142336','142337','142338','142339','142340','142341','142342','142343','142344','142345','142346','142347','142348','142349','142350','142351','142352','142353','142354','142355','142356','142357','142358','142359','142360','142361','142362','142363','142364','142365','142366','142367','142368','142369','142370','142371','142372','142373','142374','142375','142376','142377','142378','142379','142380','142381','142382','142383','142384','142385','142386','142387','142388','142389','142390','142391','142392','142394','142395','142396','142397','142398','142399','142400','142401','142402','142403','142404','142405','142406','142407','142408','142409','142410','142411','142412','142413','142414','142415','142416','142417','142418','142419','142420','142421','142422','142423','142424','142425','142426','142427','142428','142429','142430','142431','142432','142433','142434','142435','142436','142437','142438','142439','142440','142441','142442','142443','142444','142445','142446','142447','142448','142449','142450','142451','142452','142453','142454','142455','142456','142457','142458','142459','142460','142461','142462','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142490','142491','142492','142493','142494','142495','142496','142499','142500','142501','142502','142503','142504','142505','142506','142507','142508','142509','142510','142511','142512','142513','142514','142515','142516','142517','142518','142519','142520','142521','142522','142528','142529','142530','142531','142532','142533','142534','142535','142536','142537','142538','142539','142540','142541','142542','142543','142544','142545','142546','142547','142548','142549','142550','142551','142552','142553','142554','142555','142556','142557','142558','142559','142560','142561','142562','142563','142564','142565','142566','142567','142568','142569','142570','142571','142572','142573','142574','142575','142576','142577','142578','142579','142580','142581','142582','142583','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142609','142610','142611','142612','142613','142614','142615','142616','142617','142618','142619','142620','142621','142622','142623','142624','142625','142626','142627','142628','142629','142630','142631','142632','142633','142634','142635','142636','142688','142712','142713','142714','142716','142726','142727','142736','142770','142771','142772','142773','142825','142864','142865','143082','143212','143244','143268','143417','143458','143459','143460','143504','143600','143654','143662','143721','143736','143737','144195','144196','146542','146568','146583','146722','146921','146945','146947','147003','147046','147172','147716','148049','148144','148406','148737','148738','149121','149655','149905','150282','150546','150597','150830','150831','150832','150845','150847','151014','151026','151032','151033','151078','151130','151198','151213','151247','151253','151280','151281','151325','151424','151430','151448','151449','151450','151451','151452','151453','151454','151455','151633','151687','151700','151724','151854','151886','151960','151976','151977','151991','152502','152503','152504','152505','152506','152519','152552','152561','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','156218','156219','156220','156221','156222','156223','156224','156225','156226','156227','156228','156229','156230','156231','156232','156233','156234','156235','156236','156237','156238','156239','156240','156241','156242','156243','156244','156245','156246','156247','156248','156249','156250','156251','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157713','157714','157715','157716','157717','157718','157719','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158604','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','164704','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','169093','169112','169145','169146','169158','169168','169169','169172','169180','169181','169182','169235','169290','169291','169300','169302','169303','169314','169329','169335','169354','169355','169356','169357','169358','169359','169360','169361','169362','169363','169364','169365','169366','169367','169368','169369','169370','169371','169372','169373','169374','169375','169376','169377','169378','169379','169380','169381','169382','169383','169384','169385','169386','169388','169389','169390','169391','169392','169393','169394','169395','169396','169397','169398','169399','169400','169401','169402','169403','169404','169405','169406','169407','169409','169410','169411','169412','169413','169414','169415','169416','169417','169418','169419','169420','169421','169422','169423','169424','169425','169426','169427','169428','169429','169430','169431','169432','169433','169434','169435','169436','169437','169438','169439','169440','169441','169442','169443','169444','169445','169446','169447','169448','169449','169450','169451','169452','169453','169454','169455','169456','169457','169458','169459','169460','169461','169462','169463','169464','169465','169466','169467','169468','169469','169470','169471','169472','169473','169474','169475','169476','169477','169478','169479','169480','169481','169482','169483','169484','169485','169486','169487','169488','169489','169490','169491','169492','169493','169494','169495','169496','169497','169498','169499','169500','169501','169502','169503','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169514','169515','169516','169517','169518','169519','169520','169521','169522','169523','169524','169525','169526','169527','169528','169529','169530','169531','169532','169533','169534','169535','169536','169537','169538','169539','169540','169541','169542','169543','169544','169545','169546','169547','169548','169549','169550','169551','169552','169553','169554','169555','169556','169557','169558','169559','169560','169561','169562','169563','169564','169565','169566','169567','169568','169569','169570','169571','169572','169573','169574','169575','169576','169577','169578','169579','169580','169581','169582','169583','169584','169585','169586','169587','169588','169589','169590','169591','169592','169593','169787','169973','169974','169992','170306','170579','170580','170590','170646','170666','170667','170668','201199','201200','201201','215414','215464','215612','215654','215655','215778','215793','215794','215848','216023','216024','216025','216026','216027','216028','216029','216030','216031','216032','216033','216034','216035','216036','216037','216055','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','238824','238873','238885','238967','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','242064','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242964','242965','242979','242988','242991','243024','243227','243236','243237','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244321','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','248619','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','254285','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','280359','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','141559','141591','141964','142689','142853','143994','148408','148617','150063','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','169348','169859','170147','211148','211149','211150','211151','211152','211153','211154','211155','211156','211157','211158','211159','215909','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244061','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','143217','148143','148710','151725','155728','157528','158403','163645','169993','170114','170290','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','144163','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','216053','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 ('141326','141340','141343','141344','141364','141390','141391','141392','141393','141481','141482','141483','141512','141571','141598','141631','141714','141715','141718','141740','141741','141742','141743','141801','141802','141803','141907','141918','141961','141962','141967','141994','142036','142037','142038','142039','142063','142119','142125','142126','142168','142177','142181','142183','142216','142218','142422','142423','142424','142425','142426','142427','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142492','142493','142494','142495','142496','142499','142500','142501','142502','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142622','142623','142624','142625','142626','142628','142629','142630','142727','142736','143212','143721','144195','144196','151976','151977','151991','152552','153123','153124','153125','153126','154963','154971','155044','155818','155819','155820','155981','156036','156037','156038','156039','156040','156041','156042','156043','157537','158643','158644','159159','159442','160407','160434','162862','166310','167228','167832','169093','169112','169145','169181','169182','169235','169314','169329','169335','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169517','169518','169519','169520','169521','169522','169526','169573','169574','169575','238689','238690','238691','238692','238822','239355','240219','240220','242620','245082','246098','253037','256118','256837','262603','264362','264710','265000','267077','267078','267079','267080','267081','268879','274929','281007','285080','292754','292827','293467','293889','299341') 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','141319','141321','141322','141325','141326','141327','141340','141343','141344','141345','141360','141361','141362','141363','141364','141365','141366','141367','141368','141386','141387','141388','141389','141390','141391','141392','141393','141394','141395','141396','141417','141418','141467','141468','141469','141475','141476','141477','141478','141479','141480','141481','141482','141483','141484','141485','141486','141487','141488','141489','141490','141491','141492','141493','141494','141495','141505','141507','141512','141516','141517','141518','141519','141520','141521','141533','141543','141564','141565','141566','141567','141570','141571','141596','141597','141598','141620','141621','141622','141623','141624','141626','141628','141630','141631','141633','141634','141635','141648','141649','141650','141651','141652','141653','141654','141661','141662','141663','141664','141668','141673','141688','141689','141690','141693','141708','141711','141712','141713','141714','141715','141718','141719','141720','141721','141722','141723','141724','141726','141736','141737','141738','141739','141740','141741','141742','141743','141744','141761','141799','141800','141801','141802','141803','141804','141805','141855','141856','141857','141858','141859','141860','141863','141864','141867','141885','141907','141908','141909','141910','141913','141916','141917','141918','141948','141949','141950','141951','141952','141953','141954','141955','141961','141962','141963','141967','141981','141982','141994','141996','141997','141998','142004','142005','142031','142032','142036','142037','142038','142039','142053','142063','142119','142121','142122','142123','142124','142125','142126','142130','142141','142146','142147','142148','142166','142168','142177','142178','142179','142180','142181','142183','142201','142216','142218','142221','142236','142237','142238','142239','142240','142241','142242','142243','142244','142245','142246','142247','142248','142249','142250','142251','142252','142253','142254','142255','142256','142257','142258','142259','142260','142261','142262','142263','142264','142265','142266','142267','142268','142269','142270','142271','142272','142273','142274','142275','142276','142277','142278','142279','142280','142281','142282','142283','142284','142285','142286','142287','142288','142289','142290','142291','142292','142293','142294','142295','142296','142297','142298','142299','142300','142301','142302','142303','142304','142305','142306','142307','142308','142309','142313','142314','142315','142316','142317','142320','142321','142322','142323','142325','142326','142327','142328','142329','142330','142331','142332','142333','142334','142335','142336','142337','142338','142339','142340','142341','142342','142343','142344','142345','142346','142347','142348','142349','142350','142351','142352','142353','142354','142355','142356','142357','142358','142359','142360','142361','142362','142363','142364','142365','142366','142367','142368','142369','142370','142371','142372','142373','142374','142375','142376','142377','142378','142379','142380','142381','142382','142383','142384','142385','142386','142387','142388','142389','142390','142391','142392','142394','142395','142396','142397','142398','142399','142400','142401','142402','142403','142404','142405','142406','142407','142408','142409','142410','142411','142412','142413','142414','142415','142416','142417','142418','142419','142420','142421','142422','142423','142424','142425','142426','142427','142428','142429','142430','142431','142432','142433','142434','142435','142436','142437','142438','142439','142440','142441','142442','142443','142444','142445','142446','142447','142448','142449','142450','142451','142452','142453','142454','142455','142456','142457','142458','142459','142460','142461','142462','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142490','142491','142492','142493','142494','142495','142496','142499','142500','142501','142502','142503','142504','142505','142506','142507','142508','142509','142510','142511','142512','142513','142514','142515','142516','142517','142518','142519','142520','142521','142522','142528','142529','142530','142531','142532','142533','142534','142535','142536','142537','142538','142539','142540','142541','142542','142543','142544','142545','142546','142547','142548','142549','142550','142551','142552','142553','142554','142555','142556','142557','142558','142559','142560','142561','142562','142563','142564','142565','142566','142567','142568','142569','142570','142571','142572','142573','142574','142575','142576','142577','142578','142579','142580','142581','142582','142583','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142609','142610','142611','142612','142613','142614','142615','142616','142617','142618','142619','142620','142621','142622','142623','142624','142625','142626','142627','142628','142629','142630','142631','142632','142633','142634','142635','142636','142688','142712','142713','142714','142716','142726','142727','142736','142770','142771','142772','142773','142825','142864','142865','143082','143212','143244','143268','143417','143458','143459','143460','143504','143600','143654','143662','143721','143736','143737','144195','144196','146542','146568','146583','146722','146921','146945','146947','147003','147046','147172','147716','148049','148144','148406','148737','148738','149121','149655','149905','150282','150546','150597','150830','150831','150832','150845','150847','151014','151026','151032','151033','151078','151130','151198','151213','151247','151253','151280','151281','151325','151424','151430','151448','151449','151450','151451','151452','151453','151454','151455','151633','151687','151700','151724','151854','151886','151960','151976','151977','151991','152502','152503','152504','152505','152506','152519','152552','152561','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','156218','156219','156220','156221','156222','156223','156224','156225','156226','156227','156228','156229','156230','156231','156232','156233','156234','156235','156236','156237','156238','156239','156240','156241','156242','156243','156244','156245','156246','156247','156248','156249','156250','156251','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157713','157714','157715','157716','157717','157718','157719','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158604','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','164704','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','169093','169112','169145','169146','169158','169168','169169','169172','169180','169181','169182','169235','169290','169291','169300','169302','169303','169314','169329','169335','169354','169355','169356','169357','169358','169359','169360','169361','169362','169363','169364','169365','169366','169367','169368','169369','169370','169371','169372','169373','169374','169375','169376','169377','169378','169379','169380','169381','169382','169383','169384','169385','169386','169388','169389','169390','169391','169392','169393','169394','169395','169396','169397','169398','169399','169400','169401','169402','169403','169404','169405','169406','169407','169409','169410','169411','169412','169413','169414','169415','169416','169417','169418','169419','169420','169421','169422','169423','169424','169425','169426','169427','169428','169429','169430','169431','169432','169433','169434','169435','169436','169437','169438','169439','169440','169441','169442','169443','169444','169445','169446','169447','169448','169449','169450','169451','169452','169453','169454','169455','169456','169457','169458','169459','169460','169461','169462','169463','169464','169465','169466','169467','169468','169469','169470','169471','169472','169473','169474','169475','169476','169477','169478','169479','169480','169481','169482','169483','169484','169485','169486','169487','169488','169489','169490','169491','169492','169493','169494','169495','169496','169497','169498','169499','169500','169501','169502','169503','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169514','169515','169516','169517','169518','169519','169520','169521','169522','169523','169524','169525','169526','169527','169528','169529','169530','169531','169532','169533','169534','169535','169536','169537','169538','169539','169540','169541','169542','169543','169544','169545','169546','169547','169548','169549','169550','169551','169552','169553','169554','169555','169556','169557','169558','169559','169560','169561','169562','169563','169564','169565','169566','169567','169568','169569','169570','169571','169572','169573','169574','169575','169576','169577','169578','169579','169580','169581','169582','169583','169584','169585','169586','169587','169588','169589','169590','169591','169592','169593','169787','169973','169974','169992','170306','170579','170580','170590','170646','170666','170667','170668','201199','201200','201201','215414','215464','215612','215654','215655','215778','215793','215794','215848','216023','216024','216025','216026','216027','216028','216029','216030','216031','216032','216033','216034','216035','216036','216037','216055','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','238824','238873','238885','238967','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','242064','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242964','242965','242979','242988','242991','243024','243227','243236','243237','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244321','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','248619','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','254285','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','280359','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','141559','141591','141964','142689','142853','143994','148408','148617','150063','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','169348','169859','170147','211148','211149','211150','211151','211152','211153','211154','211155','211156','211157','211158','211159','215909','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244061','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','143217','148143','148710','151725','155728','157528','158403','163645','169993','170114','170290','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','144163','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','216053','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 ('141326','141340','141343','141344','141364','141390','141391','141392','141393','141481','141482','141483','141512','141571','141598','141631','141714','141715','141718','141740','141741','141742','141743','141801','141802','141803','141907','141918','141961','141962','141967','141994','142036','142037','142038','142039','142063','142119','142125','142126','142168','142177','142181','142183','142216','142218','142422','142423','142424','142425','142426','142427','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142492','142493','142494','142495','142496','142499','142500','142501','142502','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142622','142623','142624','142625','142626','142628','142629','142630','142727','142736','143212','143721','144195','144196','151976','151977','151991','152552','153123','153124','153125','153126','154963','154971','155044','155818','155819','155820','155981','156036','156037','156038','156039','156040','156041','156042','156043','157537','158643','158644','159159','159442','160407','160434','162862','166310','167228','167832','169093','169112','169145','169181','169182','169235','169314','169329','169335','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169517','169518','169519','169520','169521','169522','169526','169573','169574','169575','238689','238690','238691','238692','238822','239355','240219','240220','242620','245082','246098','253037','256118','256837','262603','264362','264710','265000','267077','267078','267079','267080','267081','268879','274929','281007','285080','292754','292827','293467','293889','299341') 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','141319','141321','141322','141325','141326','141327','141340','141343','141344','141345','141360','141361','141362','141363','141364','141365','141366','141367','141368','141386','141387','141388','141389','141390','141391','141392','141393','141394','141395','141396','141417','141418','141467','141468','141469','141475','141476','141477','141478','141479','141480','141481','141482','141483','141484','141485','141486','141487','141488','141489','141490','141491','141492','141493','141494','141495','141505','141507','141512','141516','141517','141518','141519','141520','141521','141533','141543','141564','141565','141566','141567','141570','141571','141596','141597','141598','141620','141621','141622','141623','141624','141626','141628','141630','141631','141633','141634','141635','141648','141649','141650','141651','141652','141653','141654','141661','141662','141663','141664','141668','141673','141688','141689','141690','141693','141708','141711','141712','141713','141714','141715','141718','141719','141720','141721','141722','141723','141724','141726','141736','141737','141738','141739','141740','141741','141742','141743','141744','141761','141799','141800','141801','141802','141803','141804','141805','141855','141856','141857','141858','141859','141860','141863','141864','141867','141885','141907','141908','141909','141910','141913','141916','141917','141918','141948','141949','141950','141951','141952','141953','141954','141955','141961','141962','141963','141967','141981','141982','141994','141996','141997','141998','142004','142005','142031','142032','142036','142037','142038','142039','142053','142063','142119','142121','142122','142123','142124','142125','142126','142130','142141','142146','142147','142148','142166','142168','142177','142178','142179','142180','142181','142183','142201','142216','142218','142221','142236','142237','142238','142239','142240','142241','142242','142243','142244','142245','142246','142247','142248','142249','142250','142251','142252','142253','142254','142255','142256','142257','142258','142259','142260','142261','142262','142263','142264','142265','142266','142267','142268','142269','142270','142271','142272','142273','142274','142275','142276','142277','142278','142279','142280','142281','142282','142283','142284','142285','142286','142287','142288','142289','142290','142291','142292','142293','142294','142295','142296','142297','142298','142299','142300','142301','142302','142303','142304','142305','142306','142307','142308','142309','142313','142314','142315','142316','142317','142320','142321','142322','142323','142325','142326','142327','142328','142329','142330','142331','142332','142333','142334','142335','142336','142337','142338','142339','142340','142341','142342','142343','142344','142345','142346','142347','142348','142349','142350','142351','142352','142353','142354','142355','142356','142357','142358','142359','142360','142361','142362','142363','142364','142365','142366','142367','142368','142369','142370','142371','142372','142373','142374','142375','142376','142377','142378','142379','142380','142381','142382','142383','142384','142385','142386','142387','142388','142389','142390','142391','142392','142394','142395','142396','142397','142398','142399','142400','142401','142402','142403','142404','142405','142406','142407','142408','142409','142410','142411','142412','142413','142414','142415','142416','142417','142418','142419','142420','142421','142422','142423','142424','142425','142426','142427','142428','142429','142430','142431','142432','142433','142434','142435','142436','142437','142438','142439','142440','142441','142442','142443','142444','142445','142446','142447','142448','142449','142450','142451','142452','142453','142454','142455','142456','142457','142458','142459','142460','142461','142462','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142490','142491','142492','142493','142494','142495','142496','142499','142500','142501','142502','142503','142504','142505','142506','142507','142508','142509','142510','142511','142512','142513','142514','142515','142516','142517','142518','142519','142520','142521','142522','142528','142529','142530','142531','142532','142533','142534','142535','142536','142537','142538','142539','142540','142541','142542','142543','142544','142545','142546','142547','142548','142549','142550','142551','142552','142553','142554','142555','142556','142557','142558','142559','142560','142561','142562','142563','142564','142565','142566','142567','142568','142569','142570','142571','142572','142573','142574','142575','142576','142577','142578','142579','142580','142581','142582','142583','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142609','142610','142611','142612','142613','142614','142615','142616','142617','142618','142619','142620','142621','142622','142623','142624','142625','142626','142627','142628','142629','142630','142631','142632','142633','142634','142635','142636','142688','142712','142713','142714','142716','142726','142727','142736','142770','142771','142772','142773','142825','142864','142865','143082','143212','143244','143268','143417','143458','143459','143460','143504','143600','143654','143662','143721','143736','143737','144195','144196','146542','146568','146583','146722','146921','146945','146947','147003','147046','147172','147716','148049','148144','148406','148737','148738','149121','149655','149905','150282','150546','150597','150830','150831','150832','150845','150847','151014','151026','151032','151033','151078','151130','151198','151213','151247','151253','151280','151281','151325','151424','151430','151448','151449','151450','151451','151452','151453','151454','151455','151633','151687','151700','151724','151854','151886','151960','151976','151977','151991','152502','152503','152504','152505','152506','152519','152552','152561','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','156218','156219','156220','156221','156222','156223','156224','156225','156226','156227','156228','156229','156230','156231','156232','156233','156234','156235','156236','156237','156238','156239','156240','156241','156242','156243','156244','156245','156246','156247','156248','156249','156250','156251','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157713','157714','157715','157716','157717','157718','157719','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158604','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','164704','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','169093','169112','169145','169146','169158','169168','169169','169172','169180','169181','169182','169235','169290','169291','169300','169302','169303','169314','169329','169335','169354','169355','169356','169357','169358','169359','169360','169361','169362','169363','169364','169365','169366','169367','169368','169369','169370','169371','169372','169373','169374','169375','169376','169377','169378','169379','169380','169381','169382','169383','169384','169385','169386','169388','169389','169390','169391','169392','169393','169394','169395','169396','169397','169398','169399','169400','169401','169402','169403','169404','169405','169406','169407','169409','169410','169411','169412','169413','169414','169415','169416','169417','169418','169419','169420','169421','169422','169423','169424','169425','169426','169427','169428','169429','169430','169431','169432','169433','169434','169435','169436','169437','169438','169439','169440','169441','169442','169443','169444','169445','169446','169447','169448','169449','169450','169451','169452','169453','169454','169455','169456','169457','169458','169459','169460','169461','169462','169463','169464','169465','169466','169467','169468','169469','169470','169471','169472','169473','169474','169475','169476','169477','169478','169479','169480','169481','169482','169483','169484','169485','169486','169487','169488','169489','169490','169491','169492','169493','169494','169495','169496','169497','169498','169499','169500','169501','169502','169503','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169514','169515','169516','169517','169518','169519','169520','169521','169522','169523','169524','169525','169526','169527','169528','169529','169530','169531','169532','169533','169534','169535','169536','169537','169538','169539','169540','169541','169542','169543','169544','169545','169546','169547','169548','169549','169550','169551','169552','169553','169554','169555','169556','169557','169558','169559','169560','169561','169562','169563','169564','169565','169566','169567','169568','169569','169570','169571','169572','169573','169574','169575','169576','169577','169578','169579','169580','169581','169582','169583','169584','169585','169586','169587','169588','169589','169590','169591','169592','169593','169787','169973','169974','169992','170306','170579','170580','170590','170646','170666','170667','170668','201199','201200','201201','215414','215464','215612','215654','215655','215778','215793','215794','215848','216023','216024','216025','216026','216027','216028','216029','216030','216031','216032','216033','216034','216035','216036','216037','216055','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','238824','238873','238885','238967','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','242064','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242964','242965','242979','242988','242991','243024','243227','243236','243237','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244321','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','248619','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','254285','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','280359','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','141559','141591','141964','142689','142853','143994','148408','148617','150063','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','169348','169859','170147','211148','211149','211150','211151','211152','211153','211154','211155','211156','211157','211158','211159','215909','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244061','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','143217','148143','148710','151725','155728','157528','158403','163645','169993','170114','170290','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','144163','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','216053','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 ('141326','141340','141343','141344','141364','141390','141391','141392','141393','141481','141482','141483','141512','141571','141598','141631','141714','141715','141718','141740','141741','141742','141743','141801','141802','141803','141907','141918','141961','141962','141967','141994','142036','142037','142038','142039','142063','142119','142125','142126','142168','142177','142181','142183','142216','142218','142422','142423','142424','142425','142426','142427','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142492','142493','142494','142495','142496','142499','142500','142501','142502','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142622','142623','142624','142625','142626','142628','142629','142630','142727','142736','143212','143721','144195','144196','151976','151977','151991','152552','153123','153124','153125','153126','154963','154971','155044','155818','155819','155820','155981','156036','156037','156038','156039','156040','156041','156042','156043','157537','158643','158644','159159','159442','160407','160434','162862','166310','167228','167832','169093','169112','169145','169181','169182','169235','169314','169329','169335','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169517','169518','169519','169520','169521','169522','169526','169573','169574','169575','238689','238690','238691','238692','238822','239355','240219','240220','242620','245082','246098','253037','256118','256837','262603','264362','264710','265000','267077','267078','267079','267080','267081','268879','274929','281007','285080','292754','292827','293467','293889','299341') 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','141319','141321','141322','141325','141326','141327','141340','141343','141344','141345','141360','141361','141362','141363','141364','141365','141366','141367','141368','141386','141387','141388','141389','141390','141391','141392','141393','141394','141395','141396','141417','141418','141467','141468','141469','141475','141476','141477','141478','141479','141480','141481','141482','141483','141484','141485','141486','141487','141488','141489','141490','141491','141492','141493','141494','141495','141505','141507','141512','141516','141517','141518','141519','141520','141521','141533','141543','141564','141565','141566','141567','141570','141571','141596','141597','141598','141620','141621','141622','141623','141624','141626','141628','141630','141631','141633','141634','141635','141648','141649','141650','141651','141652','141653','141654','141661','141662','141663','141664','141668','141673','141688','141689','141690','141693','141708','141711','141712','141713','141714','141715','141718','141719','141720','141721','141722','141723','141724','141726','141736','141737','141738','141739','141740','141741','141742','141743','141744','141761','141799','141800','141801','141802','141803','141804','141805','141855','141856','141857','141858','141859','141860','141863','141864','141867','141885','141907','141908','141909','141910','141913','141916','141917','141918','141948','141949','141950','141951','141952','141953','141954','141955','141961','141962','141963','141967','141981','141982','141994','141996','141997','141998','142004','142005','142031','142032','142036','142037','142038','142039','142053','142063','142119','142121','142122','142123','142124','142125','142126','142130','142141','142146','142147','142148','142166','142168','142177','142178','142179','142180','142181','142183','142201','142216','142218','142221','142236','142237','142238','142239','142240','142241','142242','142243','142244','142245','142246','142247','142248','142249','142250','142251','142252','142253','142254','142255','142256','142257','142258','142259','142260','142261','142262','142263','142264','142265','142266','142267','142268','142269','142270','142271','142272','142273','142274','142275','142276','142277','142278','142279','142280','142281','142282','142283','142284','142285','142286','142287','142288','142289','142290','142291','142292','142293','142294','142295','142296','142297','142298','142299','142300','142301','142302','142303','142304','142305','142306','142307','142308','142309','142313','142314','142315','142316','142317','142320','142321','142322','142323','142325','142326','142327','142328','142329','142330','142331','142332','142333','142334','142335','142336','142337','142338','142339','142340','142341','142342','142343','142344','142345','142346','142347','142348','142349','142350','142351','142352','142353','142354','142355','142356','142357','142358','142359','142360','142361','142362','142363','142364','142365','142366','142367','142368','142369','142370','142371','142372','142373','142374','142375','142376','142377','142378','142379','142380','142381','142382','142383','142384','142385','142386','142387','142388','142389','142390','142391','142392','142394','142395','142396','142397','142398','142399','142400','142401','142402','142403','142404','142405','142406','142407','142408','142409','142410','142411','142412','142413','142414','142415','142416','142417','142418','142419','142420','142421','142422','142423','142424','142425','142426','142427','142428','142429','142430','142431','142432','142433','142434','142435','142436','142437','142438','142439','142440','142441','142442','142443','142444','142445','142446','142447','142448','142449','142450','142451','142452','142453','142454','142455','142456','142457','142458','142459','142460','142461','142462','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142490','142491','142492','142493','142494','142495','142496','142499','142500','142501','142502','142503','142504','142505','142506','142507','142508','142509','142510','142511','142512','142513','142514','142515','142516','142517','142518','142519','142520','142521','142522','142528','142529','142530','142531','142532','142533','142534','142535','142536','142537','142538','142539','142540','142541','142542','142543','142544','142545','142546','142547','142548','142549','142550','142551','142552','142553','142554','142555','142556','142557','142558','142559','142560','142561','142562','142563','142564','142565','142566','142567','142568','142569','142570','142571','142572','142573','142574','142575','142576','142577','142578','142579','142580','142581','142582','142583','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142609','142610','142611','142612','142613','142614','142615','142616','142617','142618','142619','142620','142621','142622','142623','142624','142625','142626','142627','142628','142629','142630','142631','142632','142633','142634','142635','142636','142688','142712','142713','142714','142716','142726','142727','142736','142770','142771','142772','142773','142825','142864','142865','143082','143212','143244','143268','143417','143458','143459','143460','143504','143600','143654','143662','143721','143736','143737','144195','144196','146542','146568','146583','146722','146921','146945','146947','147003','147046','147172','147716','148049','148144','148406','148737','148738','149121','149655','149905','150282','150546','150597','150830','150831','150832','150845','150847','151014','151026','151032','151033','151078','151130','151198','151213','151247','151253','151280','151281','151325','151424','151430','151448','151449','151450','151451','151452','151453','151454','151455','151633','151687','151700','151724','151854','151886','151960','151976','151977','151991','152502','152503','152504','152505','152506','152519','152552','152561','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','156218','156219','156220','156221','156222','156223','156224','156225','156226','156227','156228','156229','156230','156231','156232','156233','156234','156235','156236','156237','156238','156239','156240','156241','156242','156243','156244','156245','156246','156247','156248','156249','156250','156251','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157713','157714','157715','157716','157717','157718','157719','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158604','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','164704','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','169093','169112','169145','169146','169158','169168','169169','169172','169180','169181','169182','169235','169290','169291','169300','169302','169303','169314','169329','169335','169354','169355','169356','169357','169358','169359','169360','169361','169362','169363','169364','169365','169366','169367','169368','169369','169370','169371','169372','169373','169374','169375','169376','169377','169378','169379','169380','169381','169382','169383','169384','169385','169386','169388','169389','169390','169391','169392','169393','169394','169395','169396','169397','169398','169399','169400','169401','169402','169403','169404','169405','169406','169407','169409','169410','169411','169412','169413','169414','169415','169416','169417','169418','169419','169420','169421','169422','169423','169424','169425','169426','169427','169428','169429','169430','169431','169432','169433','169434','169435','169436','169437','169438','169439','169440','169441','169442','169443','169444','169445','169446','169447','169448','169449','169450','169451','169452','169453','169454','169455','169456','169457','169458','169459','169460','169461','169462','169463','169464','169465','169466','169467','169468','169469','169470','169471','169472','169473','169474','169475','169476','169477','169478','169479','169480','169481','169482','169483','169484','169485','169486','169487','169488','169489','169490','169491','169492','169493','169494','169495','169496','169497','169498','169499','169500','169501','169502','169503','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169514','169515','169516','169517','169518','169519','169520','169521','169522','169523','169524','169525','169526','169527','169528','169529','169530','169531','169532','169533','169534','169535','169536','169537','169538','169539','169540','169541','169542','169543','169544','169545','169546','169547','169548','169549','169550','169551','169552','169553','169554','169555','169556','169557','169558','169559','169560','169561','169562','169563','169564','169565','169566','169567','169568','169569','169570','169571','169572','169573','169574','169575','169576','169577','169578','169579','169580','169581','169582','169583','169584','169585','169586','169587','169588','169589','169590','169591','169592','169593','169787','169973','169974','169992','170306','170579','170580','170590','170646','170666','170667','170668','201199','201200','201201','215414','215464','215612','215654','215655','215778','215793','215794','215848','216023','216024','216025','216026','216027','216028','216029','216030','216031','216032','216033','216034','216035','216036','216037','216055','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','238824','238873','238885','238967','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','242064','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242964','242965','242979','242988','242991','243024','243227','243236','243237','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244321','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','248619','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','254285','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','280359','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','141559','141591','141964','142689','142853','143994','148408','148617','150063','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','169348','169859','170147','211148','211149','211150','211151','211152','211153','211154','211155','211156','211157','211158','211159','215909','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244061','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','143217','148143','148710','151725','155728','157528','158403','163645','169993','170114','170290','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','144163','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','216053','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 ('141326','141340','141343','141344','141364','141390','141391','141392','141393','141481','141482','141483','141512','141571','141598','141631','141714','141715','141718','141740','141741','141742','141743','141801','141802','141803','141907','141918','141961','141962','141967','141994','142036','142037','142038','142039','142063','142119','142125','142126','142168','142177','142181','142183','142216','142218','142422','142423','142424','142425','142426','142427','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142492','142493','142494','142495','142496','142499','142500','142501','142502','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142622','142623','142624','142625','142626','142628','142629','142630','142727','142736','143212','143721','144195','144196','151976','151977','151991','152552','153123','153124','153125','153126','154963','154971','155044','155818','155819','155820','155981','156036','156037','156038','156039','156040','156041','156042','156043','157537','158643','158644','159159','159442','160407','160434','162862','166310','167228','167832','169093','169112','169145','169181','169182','169235','169314','169329','169335','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169517','169518','169519','169520','169521','169522','169526','169573','169574','169575','238689','238690','238691','238692','238822','239355','240219','240220','242620','245082','246098','253037','256118','256837','262603','264362','264710','265000','267077','267078','267079','267080','267081','268879','274929','281007','285080','292754','292827','293467','293889','299341') 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','141319','141321','141322','141325','141326','141327','141340','141343','141344','141345','141360','141361','141362','141363','141364','141365','141366','141367','141368','141386','141387','141388','141389','141390','141391','141392','141393','141394','141395','141396','141417','141418','141467','141468','141469','141475','141476','141477','141478','141479','141480','141481','141482','141483','141484','141485','141486','141487','141488','141489','141490','141491','141492','141493','141494','141495','141505','141507','141512','141516','141517','141518','141519','141520','141521','141533','141543','141564','141565','141566','141567','141570','141571','141596','141597','141598','141620','141621','141622','141623','141624','141626','141628','141630','141631','141633','141634','141635','141648','141649','141650','141651','141652','141653','141654','141661','141662','141663','141664','141668','141673','141688','141689','141690','141693','141708','141711','141712','141713','141714','141715','141718','141719','141720','141721','141722','141723','141724','141726','141736','141737','141738','141739','141740','141741','141742','141743','141744','141761','141799','141800','141801','141802','141803','141804','141805','141855','141856','141857','141858','141859','141860','141863','141864','141867','141885','141907','141908','141909','141910','141913','141916','141917','141918','141948','141949','141950','141951','141952','141953','141954','141955','141961','141962','141963','141967','141981','141982','141994','141996','141997','141998','142004','142005','142031','142032','142036','142037','142038','142039','142053','142063','142119','142121','142122','142123','142124','142125','142126','142130','142141','142146','142147','142148','142166','142168','142177','142178','142179','142180','142181','142183','142201','142216','142218','142221','142236','142237','142238','142239','142240','142241','142242','142243','142244','142245','142246','142247','142248','142249','142250','142251','142252','142253','142254','142255','142256','142257','142258','142259','142260','142261','142262','142263','142264','142265','142266','142267','142268','142269','142270','142271','142272','142273','142274','142275','142276','142277','142278','142279','142280','142281','142282','142283','142284','142285','142286','142287','142288','142289','142290','142291','142292','142293','142294','142295','142296','142297','142298','142299','142300','142301','142302','142303','142304','142305','142306','142307','142308','142309','142313','142314','142315','142316','142317','142320','142321','142322','142323','142325','142326','142327','142328','142329','142330','142331','142332','142333','142334','142335','142336','142337','142338','142339','142340','142341','142342','142343','142344','142345','142346','142347','142348','142349','142350','142351','142352','142353','142354','142355','142356','142357','142358','142359','142360','142361','142362','142363','142364','142365','142366','142367','142368','142369','142370','142371','142372','142373','142374','142375','142376','142377','142378','142379','142380','142381','142382','142383','142384','142385','142386','142387','142388','142389','142390','142391','142392','142394','142395','142396','142397','142398','142399','142400','142401','142402','142403','142404','142405','142406','142407','142408','142409','142410','142411','142412','142413','142414','142415','142416','142417','142418','142419','142420','142421','142422','142423','142424','142425','142426','142427','142428','142429','142430','142431','142432','142433','142434','142435','142436','142437','142438','142439','142440','142441','142442','142443','142444','142445','142446','142447','142448','142449','142450','142451','142452','142453','142454','142455','142456','142457','142458','142459','142460','142461','142462','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142490','142491','142492','142493','142494','142495','142496','142499','142500','142501','142502','142503','142504','142505','142506','142507','142508','142509','142510','142511','142512','142513','142514','142515','142516','142517','142518','142519','142520','142521','142522','142528','142529','142530','142531','142532','142533','142534','142535','142536','142537','142538','142539','142540','142541','142542','142543','142544','142545','142546','142547','142548','142549','142550','142551','142552','142553','142554','142555','142556','142557','142558','142559','142560','142561','142562','142563','142564','142565','142566','142567','142568','142569','142570','142571','142572','142573','142574','142575','142576','142577','142578','142579','142580','142581','142582','142583','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142609','142610','142611','142612','142613','142614','142615','142616','142617','142618','142619','142620','142621','142622','142623','142624','142625','142626','142627','142628','142629','142630','142631','142632','142633','142634','142635','142636','142688','142712','142713','142714','142716','142726','142727','142736','142770','142771','142772','142773','142825','142864','142865','143082','143212','143244','143268','143417','143458','143459','143460','143504','143600','143654','143662','143721','143736','143737','144195','144196','146542','146568','146583','146722','146921','146945','146947','147003','147046','147172','147716','148049','148144','148406','148737','148738','149121','149655','149905','150282','150546','150597','150830','150831','150832','150845','150847','151014','151026','151032','151033','151078','151130','151198','151213','151247','151253','151280','151281','151325','151424','151430','151448','151449','151450','151451','151452','151453','151454','151455','151633','151687','151700','151724','151854','151886','151960','151976','151977','151991','152502','152503','152504','152505','152506','152519','152552','152561','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','156218','156219','156220','156221','156222','156223','156224','156225','156226','156227','156228','156229','156230','156231','156232','156233','156234','156235','156236','156237','156238','156239','156240','156241','156242','156243','156244','156245','156246','156247','156248','156249','156250','156251','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157713','157714','157715','157716','157717','157718','157719','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158604','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','164704','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','169093','169112','169145','169146','169158','169168','169169','169172','169180','169181','169182','169235','169290','169291','169300','169302','169303','169314','169329','169335','169354','169355','169356','169357','169358','169359','169360','169361','169362','169363','169364','169365','169366','169367','169368','169369','169370','169371','169372','169373','169374','169375','169376','169377','169378','169379','169380','169381','169382','169383','169384','169385','169386','169388','169389','169390','169391','169392','169393','169394','169395','169396','169397','169398','169399','169400','169401','169402','169403','169404','169405','169406','169407','169409','169410','169411','169412','169413','169414','169415','169416','169417','169418','169419','169420','169421','169422','169423','169424','169425','169426','169427','169428','169429','169430','169431','169432','169433','169434','169435','169436','169437','169438','169439','169440','169441','169442','169443','169444','169445','169446','169447','169448','169449','169450','169451','169452','169453','169454','169455','169456','169457','169458','169459','169460','169461','169462','169463','169464','169465','169466','169467','169468','169469','169470','169471','169472','169473','169474','169475','169476','169477','169478','169479','169480','169481','169482','169483','169484','169485','169486','169487','169488','169489','169490','169491','169492','169493','169494','169495','169496','169497','169498','169499','169500','169501','169502','169503','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169514','169515','169516','169517','169518','169519','169520','169521','169522','169523','169524','169525','169526','169527','169528','169529','169530','169531','169532','169533','169534','169535','169536','169537','169538','169539','169540','169541','169542','169543','169544','169545','169546','169547','169548','169549','169550','169551','169552','169553','169554','169555','169556','169557','169558','169559','169560','169561','169562','169563','169564','169565','169566','169567','169568','169569','169570','169571','169572','169573','169574','169575','169576','169577','169578','169579','169580','169581','169582','169583','169584','169585','169586','169587','169588','169589','169590','169591','169592','169593','169787','169973','169974','169992','170306','170579','170580','170590','170646','170666','170667','170668','201199','201200','201201','215414','215464','215612','215654','215655','215778','215793','215794','215848','216023','216024','216025','216026','216027','216028','216029','216030','216031','216032','216033','216034','216035','216036','216037','216055','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','238824','238873','238885','238967','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','242064','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242964','242965','242979','242988','242991','243024','243227','243236','243237','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244321','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','248619','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','254285','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','280359','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','141559','141591','141964','142689','142853','143994','148408','148617','150063','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','169348','169859','170147','211148','211149','211150','211151','211152','211153','211154','211155','211156','211157','211158','211159','215909','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244061','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','143217','148143','148710','151725','155728','157528','158403','163645','169993','170114','170290','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','144163','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','216053','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 ('141326','141340','141343','141344','141364','141390','141391','141392','141393','141481','141482','141483','141512','141571','141598','141631','141714','141715','141718','141740','141741','141742','141743','141801','141802','141803','141907','141918','141961','141962','141967','141994','142036','142037','142038','142039','142063','142119','142125','142126','142168','142177','142181','142183','142216','142218','142422','142423','142424','142425','142426','142427','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142492','142493','142494','142495','142496','142499','142500','142501','142502','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142622','142623','142624','142625','142626','142628','142629','142630','142727','142736','143212','143721','144195','144196','151976','151977','151991','152552','153123','153124','153125','153126','154963','154971','155044','155818','155819','155820','155981','156036','156037','156038','156039','156040','156041','156042','156043','157537','158643','158644','159159','159442','160407','160434','162862','166310','167228','167832','169093','169112','169145','169181','169182','169235','169314','169329','169335','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169517','169518','169519','169520','169521','169522','169526','169573','169574','169575','238689','238690','238691','238692','238822','239355','240219','240220','242620','245082','246098','253037','256118','256837','262603','264362','264710','265000','267077','267078','267079','267080','267081','268879','274929','281007','285080','292754','292827','293467','293889','299341') 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','141319','141321','141322','141325','141326','141327','141340','141343','141344','141345','141360','141361','141362','141363','141364','141365','141366','141367','141368','141386','141387','141388','141389','141390','141391','141392','141393','141394','141395','141396','141417','141418','141467','141468','141469','141475','141476','141477','141478','141479','141480','141481','141482','141483','141484','141485','141486','141487','141488','141489','141490','141491','141492','141493','141494','141495','141505','141507','141512','141516','141517','141518','141519','141520','141521','141533','141543','141564','141565','141566','141567','141570','141571','141596','141597','141598','141620','141621','141622','141623','141624','141626','141628','141630','141631','141633','141634','141635','141648','141649','141650','141651','141652','141653','141654','141661','141662','141663','141664','141668','141673','141688','141689','141690','141693','141708','141711','141712','141713','141714','141715','141718','141719','141720','141721','141722','141723','141724','141726','141736','141737','141738','141739','141740','141741','141742','141743','141744','141761','141799','141800','141801','141802','141803','141804','141805','141855','141856','141857','141858','141859','141860','141863','141864','141867','141885','141907','141908','141909','141910','141913','141916','141917','141918','141948','141949','141950','141951','141952','141953','141954','141955','141961','141962','141963','141967','141981','141982','141994','141996','141997','141998','142004','142005','142031','142032','142036','142037','142038','142039','142053','142063','142119','142121','142122','142123','142124','142125','142126','142130','142141','142146','142147','142148','142166','142168','142177','142178','142179','142180','142181','142183','142201','142216','142218','142221','142236','142237','142238','142239','142240','142241','142242','142243','142244','142245','142246','142247','142248','142249','142250','142251','142252','142253','142254','142255','142256','142257','142258','142259','142260','142261','142262','142263','142264','142265','142266','142267','142268','142269','142270','142271','142272','142273','142274','142275','142276','142277','142278','142279','142280','142281','142282','142283','142284','142285','142286','142287','142288','142289','142290','142291','142292','142293','142294','142295','142296','142297','142298','142299','142300','142301','142302','142303','142304','142305','142306','142307','142308','142309','142313','142314','142315','142316','142317','142320','142321','142322','142323','142325','142326','142327','142328','142329','142330','142331','142332','142333','142334','142335','142336','142337','142338','142339','142340','142341','142342','142343','142344','142345','142346','142347','142348','142349','142350','142351','142352','142353','142354','142355','142356','142357','142358','142359','142360','142361','142362','142363','142364','142365','142366','142367','142368','142369','142370','142371','142372','142373','142374','142375','142376','142377','142378','142379','142380','142381','142382','142383','142384','142385','142386','142387','142388','142389','142390','142391','142392','142394','142395','142396','142397','142398','142399','142400','142401','142402','142403','142404','142405','142406','142407','142408','142409','142410','142411','142412','142413','142414','142415','142416','142417','142418','142419','142420','142421','142422','142423','142424','142425','142426','142427','142428','142429','142430','142431','142432','142433','142434','142435','142436','142437','142438','142439','142440','142441','142442','142443','142444','142445','142446','142447','142448','142449','142450','142451','142452','142453','142454','142455','142456','142457','142458','142459','142460','142461','142462','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142490','142491','142492','142493','142494','142495','142496','142499','142500','142501','142502','142503','142504','142505','142506','142507','142508','142509','142510','142511','142512','142513','142514','142515','142516','142517','142518','142519','142520','142521','142522','142528','142529','142530','142531','142532','142533','142534','142535','142536','142537','142538','142539','142540','142541','142542','142543','142544','142545','142546','142547','142548','142549','142550','142551','142552','142553','142554','142555','142556','142557','142558','142559','142560','142561','142562','142563','142564','142565','142566','142567','142568','142569','142570','142571','142572','142573','142574','142575','142576','142577','142578','142579','142580','142581','142582','142583','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142609','142610','142611','142612','142613','142614','142615','142616','142617','142618','142619','142620','142621','142622','142623','142624','142625','142626','142627','142628','142629','142630','142631','142632','142633','142634','142635','142636','142688','142712','142713','142714','142716','142726','142727','142736','142770','142771','142772','142773','142825','142864','142865','143082','143212','143244','143268','143417','143458','143459','143460','143504','143600','143654','143662','143721','143736','143737','144195','144196','146542','146568','146583','146722','146921','146945','146947','147003','147046','147172','147716','148049','148144','148406','148737','148738','149121','149655','149905','150282','150546','150597','150830','150831','150832','150845','150847','151014','151026','151032','151033','151078','151130','151198','151213','151247','151253','151280','151281','151325','151424','151430','151448','151449','151450','151451','151452','151453','151454','151455','151633','151687','151700','151724','151854','151886','151960','151976','151977','151991','152502','152503','152504','152505','152506','152519','152552','152561','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','156218','156219','156220','156221','156222','156223','156224','156225','156226','156227','156228','156229','156230','156231','156232','156233','156234','156235','156236','156237','156238','156239','156240','156241','156242','156243','156244','156245','156246','156247','156248','156249','156250','156251','156252','156253','156254','156255','156256','156257','157537','157538','157539','157540','157541','157542','157543','157545','157687','157713','157714','157715','157716','157717','157718','157719','157756','157781','157885','157887','157888','157889','157890','157891','157892','157893','157894','157898','157900','157901','158135','158147','158196','158223','158224','158243','158447','158477','158525','158578','158604','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','164704','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','169093','169112','169145','169146','169158','169168','169169','169172','169180','169181','169182','169235','169290','169291','169300','169302','169303','169314','169329','169335','169354','169355','169356','169357','169358','169359','169360','169361','169362','169363','169364','169365','169366','169367','169368','169369','169370','169371','169372','169373','169374','169375','169376','169377','169378','169379','169380','169381','169382','169383','169384','169385','169386','169388','169389','169390','169391','169392','169393','169394','169395','169396','169397','169398','169399','169400','169401','169402','169403','169404','169405','169406','169407','169409','169410','169411','169412','169413','169414','169415','169416','169417','169418','169419','169420','169421','169422','169423','169424','169425','169426','169427','169428','169429','169430','169431','169432','169433','169434','169435','169436','169437','169438','169439','169440','169441','169442','169443','169444','169445','169446','169447','169448','169449','169450','169451','169452','169453','169454','169455','169456','169457','169458','169459','169460','169461','169462','169463','169464','169465','169466','169467','169468','169469','169470','169471','169472','169473','169474','169475','169476','169477','169478','169479','169480','169481','169482','169483','169484','169485','169486','169487','169488','169489','169490','169491','169492','169493','169494','169495','169496','169497','169498','169499','169500','169501','169502','169503','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169514','169515','169516','169517','169518','169519','169520','169521','169522','169523','169524','169525','169526','169527','169528','169529','169530','169531','169532','169533','169534','169535','169536','169537','169538','169539','169540','169541','169542','169543','169544','169545','169546','169547','169548','169549','169550','169551','169552','169553','169554','169555','169556','169557','169558','169559','169560','169561','169562','169563','169564','169565','169566','169567','169568','169569','169570','169571','169572','169573','169574','169575','169576','169577','169578','169579','169580','169581','169582','169583','169584','169585','169586','169587','169588','169589','169590','169591','169592','169593','169787','169973','169974','169992','170306','170579','170580','170590','170646','170666','170667','170668','201199','201200','201201','215414','215464','215612','215654','215655','215778','215793','215794','215848','216023','216024','216025','216026','216027','216028','216029','216030','216031','216032','216033','216034','216035','216036','216037','216055','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','238824','238873','238885','238967','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','242064','242209','242237','242254','242333','242568','242620','242666','242717','242794','242855','242882','242964','242965','242979','242988','242991','243024','243227','243236','243237','243308','243346','243618','243653','243665','243668','243671','243766','243767','243831','243892','243953','244042','244052','244109','244118','244133','244164','244259','244311','244321','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','248619','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','254285','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','280359','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','141559','141591','141964','142689','142853','143994','148408','148617','150063','153569','155212','155812','157805','161056','161218','161359','162049','162278','163521','163855','164237','166896','167046','167292','167784','169348','169859','170147','211148','211149','211150','211151','211152','211153','211154','211155','211156','211157','211158','211159','215909','240469','240579','241881','241896','242586','242705','242986','243019','243192','243557','244061','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','143217','148143','148710','151725','155728','157528','158403','163645','169993','170114','170290','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','144163','155813','155814','155815','155816','155817','155821','160573','239311','242708','298515','216053','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 ('141326','141340','141343','141344','141364','141390','141391','141392','141393','141481','141482','141483','141512','141571','141598','141631','141714','141715','141718','141740','141741','141742','141743','141801','141802','141803','141907','141918','141961','141962','141967','141994','142036','142037','142038','142039','142063','142119','142125','142126','142168','142177','142181','142183','142216','142218','142422','142423','142424','142425','142426','142427','142463','142464','142465','142466','142467','142468','142469','142470','142471','142472','142473','142474','142475','142476','142477','142478','142479','142480','142481','142482','142483','142484','142485','142486','142487','142488','142489','142492','142493','142494','142495','142496','142499','142500','142501','142502','142584','142585','142586','142587','142588','142589','142590','142591','142592','142593','142594','142595','142596','142597','142598','142599','142600','142601','142602','142603','142604','142605','142606','142607','142608','142622','142623','142624','142625','142626','142628','142629','142630','142727','142736','143212','143721','144195','144196','151976','151977','151991','152552','153123','153124','153125','153126','154963','154971','155044','155818','155819','155820','155981','156036','156037','156038','156039','156040','156041','156042','156043','157537','158643','158644','159159','159442','160407','160434','162862','166310','167228','167832','169093','169112','169145','169181','169182','169235','169314','169329','169335','169504','169505','169506','169507','169508','169509','169510','169511','169512','169513','169517','169518','169519','169520','169521','169522','169526','169573','169574','169575','238689','238690','238691','238692','238822','239355','240219','240220','242620','245082','246098','253037','256118','256837','262603','264362','264710','265000','267077','267078','267079','267080','267081','268879','274929','281007','285080','292754','292827','293467','293889','299341') GROUP BY `packages` ORDER BY `packages` ASC