Разъемы цилиндрические

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 ('141868','141870','141871','141983','142079','142080','142081','142082','142083','142084','142085','142750','142752','142753','142831','142894','143372','143373','143397','143399','143406','143407','143408','143409','143596','143597','143608','143688','143689','144050','147067','147087','147173','147883','148027','148028','148412','150213','150214','150215','150216','150672','150689','150690','150691','150692','151842','151996','151997','151998','152634','152635','153430','153627','153669','153822','154274','154275','154276','154277','154547','154967','154968','154969','154970','154991','154992','155031','155054','155055','155056','155057','155058','155107','155122','155123','155124','155125','155141','155150','155151','155152','155153','155156','155157','155158','155520','155537','155719','155721','156320','156321','156322','156323','156324','156344','156345','156346','156358','156365','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156813','156814','156815','156816','157554','157841','158302','158350','158614','158615','158681','159062','159122','159140','159205','159314','159336','159793','159794','160288','160967','161517','161976','161986','161987','161988','161989','161990','161991','161992','162205','162432','162436','162437','162443','162444','162654','162684','162715','162755','163231','163232','163233','163234','164445','164446','164524','164674','164675','164836','164875','164931','164949','165425','165630','165852','166574','166575','166576','166577','166578','166944','166945','167039','167040','167206','167443','167609','167749','168225','169263','169264','169265','169266','169301','169323','169769','169819','169994','169995','170126','170206','170207','170528','202623','202824','207838','207839','207840','207841','207842','207843','207844','207845','207846','207847','207848','207849','207850','207851','207852','207853','207854','207855','207856','207857','207858','207859','207860','207861','207862','207863','207864','207865','207866','207867','207868','207869','207870','207871','207872','207873','207874','207875','207876','207877','207878','207879','207884','212535','212536','212537','212538','212539','212540','212541','212542','212543','212544','212545','212546','212547','212548','212549','212550','212551','212552','212553','212554','212555','212556','212557','212558','212559','212560','212561','212562','212563','212564','212565','212566','212567','212568','212569','212570','212571','212572','212573','212574','212575','212576','212577','212578','212579','212580','212581','212582','212583','212584','212585','212586','212587','212588','212589','212590','212591','212592','212593','212594','212595','212596','212597','212598','212599','212600','212601','212602','212603','212604','212605','212606','212607','212608','212609','212610','212611','212612','212613','212614','212615','212616','212617','212618','212619','215310','215311','215312','215721','215821','215882','215986','232551','232645','238235','238472','238473','238512','238567','238737','238851','238852','238853','238854','238855','238856','238857','238858','239220','239342','239579','239585','239586','239587','239588','240256','240257','240258','240259','240260','240261','240262','240263','240264','240265','240266','240269','240474','240658','240693','240695','240696','240702','240730','240731','240770','240810','240873','240900','240901','240902','240953','240954','240958','240959','241067','241600','241601','241859','241860','241984','242235','242236','242238','242267','242718','242719','242951','242984','243461','243462','243509','243510','243511','243525','243715','243845','243846','244047','244252','244286','244287','244296','245112','245259','245365','245366','245367','245368','245386','245387','245647','245837','245909','246336','246778','246853','246854','246878','246921','247602','247631','247752','247852','247853','247854','247855','247882','247883','247885','247886','247887','248001','248005','248072','248073','248074','248075','248076','248077','248078','248079','248080','248169','248170','248304','248373','248374','248769','248947','249321','249541','249638','250582','250586','250613','250622','250962','253057','253841','254399','255245','255341','256110','256251','257280','261709','261713','261743','261772','262017','262018','262019','262020','262021','262022','262023','262024','262025','262026','262027','262028','262124','262244','262245','263643','263654','264476','264495','264496','264711','264712','264713','264727','264759','264761','264856','264917','264952','264953','264980','265267','265268','265269','265326','265327','265343','265344','265345','265346','265449','265702','265841','265842','265887','266193','266323','266324','266325','266400','266440','266656','266704','266782','266787','267014','267015','267395','267565','267566','268058','268059','268412','268457','268678','268799','268900','268901','269024','269176','269348','269358','269374','269417','269450','269451','269455','269456','269569','269570','273493','273529','273552','273619','273620','273746','273747','273809','273942','274091','274100','274308','274375','274377','274381','274407','274673','274701','274836','274887','275230','275231','275323','275324','275428','275429','275468','275511','275560','275593','275779','275803','275809','275853','275991','275993','276011','276040','276449','276450','276648','276649','276985','276992','277170','277782','277783','277833','278021','278128','278153','278256','278268','278329','278330','278343','278510','278524','278712','278741','278904','278970','279428','279704','279794','279795','280836','280842','280915','281111','281143','281234','281336','281719','281763','282303','282571','282819','282918','282919','282983','283061','283160','283204','283206','283208','283477','283647','284191','284192','284532','284645','284929','284931','284933','284934','285243','285265','285342','285418','285450','285755','285835','285845','286045','286192','286440','286671','288143','288144','288145','288146','288147','288295','289458','289478','291901','291911','291913','292299','292366','292777','292849','293899','294074','294075','294076','294077','294078','294156','294178','294207','294240','294287','294409','294410','294411','294412','294413','294414','294415','294416','294417','294418','294452','294453','294594','294653','294739','294740','294741','294742','294743','294744','294770','294772','294799','294800','294986','294987','295510','295761','295997','296214','296250','297157','297309','297310','297426','297752','298516','298517','298518','299098','299351','299424','299425','300425','300901','300902','300903','301929','301953','301954','302233','302234','302272') GROUP BY `manuf` ORDER BY `manuf` ASC

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 ('141868','141870','141871','141983','142079','142080','142081','142082','142083','142084','142750','142752','142753','142894','143372','143373','143397','143399','143406','143407','143408','143409','143596','143597','143608','143688','143689','144050','147067','147087','147173','147883','148027','148028','148412','150213','150214','150215','150216','150672','150689','150690','150691','150692','151842','151996','151997','151998','152634','152635','153430','153627','153669','153822','154274','154275','154276','154547','154967','154968','154969','154970','154991','154992','155031','155054','155055','155056','155057','155058','155107','155122','155123','155124','155125','155141','155150','155151','155152','155153','155157','155158','155520','155537','155721','156320','156321','156322','156323','156324','156344','156345','156346','156358','156365','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156813','156814','157554','157841','158302','158350','158614','158615','158681','159062','159122','159140','159205','159314','159336','159793','159794','160288','160967','161517','161976','161986','161987','161988','161989','161990','161991','161992','162205','162432','162436','162437','162443','162444','162654','162684','162715','162755','163231','163232','163233','163234','164445','164446','164524','164674','164675','164836','164875','164931','164949','165425','165630','165852','166574','166575','166576','166577','166578','166944','166945','167039','167040','167206','167443','167609','167749','168225','169263','169264','169265','169266','169301','169323','169769','169994','169995','170126','170206','170207','170528','202623','202824','207838','207839','207840','207841','207842','207843','207844','207845','207846','207847','207848','207849','207850','207851','207852','207853','207854','207855','207856','207857','207858','207859','207860','207861','207862','207863','207864','207865','207866','207867','207868','207869','207870','207871','207872','207873','207874','207875','207876','207877','207878','207879','207884','212535','212536','212537','212538','212539','212540','212541','212542','212543','212544','212545','212546','212547','212548','212549','212550','212551','212552','212553','212554','212555','212556','212557','212558','212559','212560','212561','212562','212563','212564','212565','212566','212567','212568','212569','212570','212571','212572','212573','212574','212575','212576','212577','212578','212579','212580','212581','212582','212583','212584','212585','212586','212587','212588','212589','212590','212591','212592','212593','212594','212595','212596','212597','212598','212599','212600','212601','212602','212603','212604','212605','212606','212607','212608','212609','212610','212611','212612','212613','212614','212615','212616','212617','212618','212619','215310','215311','215312','215721','215882','215986','232551','232645','238235','238472','238473','238512','238567','238737','238851','238852','238853','238854','238855','238856','238857','238858','239220','239342','239579','239585','239586','239587','239588','240256','240257','240258','240259','240260','240261','240262','240263','240264','240265','240266','240269','240474','240658','240693','240695','240696','240702','240730','240731','240770','240810','240873','240900','240901','240902','240953','240954','240958','240959','241067','241600','241601','241859','241860','241984','242235','242236','242238','242267','242718','242719','242951','242984','243461','243462','243509','243510','243511','243525','243715','243845','243846','244047','244252','244286','244287','244296','245112','245259','245365','245366','245367','245368','245386','245387','245647','245837','245909','246336','246778','246853','246854','246878','246921','247602','247631','247752','247852','247853','247854','247855','247882','247883','247885','247886','247887','248001','248005','248072','248073','248074','248075','248076','248077','248078','248079','248080','248169','248170','248304','248373','248374','248769','248947','249321','249541','249638','250582','250586','250613','250622','250962','253057','253841','254399','255245','255341','256110','256251','257280','261709','261713','261743','261772','262017','262018','262019','262020','262021','262022','262023','262024','262025','262026','262027','262028','262124','263643','263654','264476','264495','264496','264711','264712','264713','264727','264759','264761','264856','264917','264952','264953','264980','265267','265268','265269','265326','265327','265343','265344','265345','265346','265449','265702','265841','265842','265887','266193','266323','266324','266325','266400','266440','266656','266704','266782','266787','267014','267015','267395','267565','267566','268058','268059','268412','268457','268678','268799','268900','268901','269024','269176','269348','269358','269374','269417','269450','269451','269455','269456','269569','269570','273493','273529','273552','273619','273620','273746','273747','273809','273942','274091','274100','274308','274375','274377','274381','274407','274673','274701','274836','274887','275230','275231','275323','275324','275428','275429','275468','275511','275560','275593','275779','275803','275809','275853','275991','275993','276011','276040','276449','276450','276648','276649','276985','276992','277170','277782','277783','277833','278021','278128','278153','278256','278268','278329','278330','278343','278510','278524','278712','278741','278904','278970','279428','280836','280842','280915','281111','281143','281234','281336','281719','281763','282303','282571','282819','282918','282919','282983','283061','283160','283204','283206','283208','283477','283647','284191','284192','284532','284645','284929','284931','284933','284934','285243','285265','285342','285418','285450','285755','285835','285845','286045','286192','286440','286671','288144','288145','288146','288147','288295','289458','289478','291901','291911','291913','292299','292366','292777','292849','293899','294074','294075','294076','294077','294078','294156','294178','294207','294240','294287','294594','294653','294739','294740','294741','294742','294743','294744','294770','294772','294799','294800','294986','294987','295510','295761','295997','296214','296250','297157','297309','297310','297426','297752','298516','298517','298518','299098','299351','299424','299425','300425','300901','300902','300903','301929','301953','301954','302233','302234','302272') GROUP BY `manuf` ORDER BY `manuf` ASC

SELECT `series`,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 `series` !='' AND `modx_site_content`.`id` IN ('141868','141870','141871','141983','142079','142080','142081','142082','142083','142084','142085','142750','142752','142753','142831','142894','143372','143373','143397','143399','143406','143407','143408','143409','143596','143597','143608','143688','143689','144050','147067','147087','147173','147883','148027','148028','148412','150213','150214','150215','150216','150672','150689','150690','150691','150692','151842','151996','151997','151998','152634','152635','153430','153627','153669','153822','154274','154275','154276','154277','154547','154967','154968','154969','154970','154991','154992','155031','155054','155055','155056','155057','155058','155107','155122','155123','155124','155125','155141','155150','155151','155152','155153','155156','155157','155158','155520','155537','155719','155721','156320','156321','156322','156323','156324','156344','156345','156346','156358','156365','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156813','156814','156815','156816','157554','157841','158302','158350','158614','158615','158681','159062','159122','159140','159205','159314','159336','159793','159794','160288','160967','161517','161976','161986','161987','161988','161989','161990','161991','161992','162205','162432','162436','162437','162443','162444','162654','162684','162715','162755','163231','163232','163233','163234','164445','164446','164524','164674','164675','164836','164875','164931','164949','165425','165630','165852','166574','166575','166576','166577','166578','166944','166945','167039','167040','167206','167443','167609','167749','168225','169263','169264','169265','169266','169301','169323','169769','169819','169994','169995','170126','170206','170207','170528','202623','202824','207838','207839','207840','207841','207842','207843','207844','207845','207846','207847','207848','207849','207850','207851','207852','207853','207854','207855','207856','207857','207858','207859','207860','207861','207862','207863','207864','207865','207866','207867','207868','207869','207870','207871','207872','207873','207874','207875','207876','207877','207878','207879','207884','212535','212536','212537','212538','212539','212540','212541','212542','212543','212544','212545','212546','212547','212548','212549','212550','212551','212552','212553','212554','212555','212556','212557','212558','212559','212560','212561','212562','212563','212564','212565','212566','212567','212568','212569','212570','212571','212572','212573','212574','212575','212576','212577','212578','212579','212580','212581','212582','212583','212584','212585','212586','212587','212588','212589','212590','212591','212592','212593','212594','212595','212596','212597','212598','212599','212600','212601','212602','212603','212604','212605','212606','212607','212608','212609','212610','212611','212612','212613','212614','212615','212616','212617','212618','212619','215310','215311','215312','215721','215821','215882','215986','232551','232645','238235','238472','238473','238512','238567','238737','238851','238852','238853','238854','238855','238856','238857','238858','239220','239342','239579','239585','239586','239587','239588','240256','240257','240258','240259','240260','240261','240262','240263','240264','240265','240266','240269','240474','240658','240693','240695','240696','240702','240730','240731','240770','240810','240873','240900','240901','240902','240953','240954','240958','240959','241067','241600','241601','241859','241860','241984','242235','242236','242238','242267','242718','242719','242951','242984','243461','243462','243509','243510','243511','243525','243715','243845','243846','244047','244252','244286','244287','244296','245112','245259','245365','245366','245367','245368','245386','245387','245647','245837','245909','246336','246778','246853','246854','246878','246921','247602','247631','247752','247852','247853','247854','247855','247882','247883','247885','247886','247887','248001','248005','248072','248073','248074','248075','248076','248077','248078','248079','248080','248169','248170','248304','248373','248374','248769','248947','249321','249541','249638','250582','250586','250613','250622','250962','253057','253841','254399','255245','255341','256110','256251','257280','261709','261713','261743','261772','262017','262018','262019','262020','262021','262022','262023','262024','262025','262026','262027','262028','262124','262244','262245','263643','263654','264476','264495','264496','264711','264712','264713','264727','264759','264761','264856','264917','264952','264953','264980','265267','265268','265269','265326','265327','265343','265344','265345','265346','265449','265702','265841','265842','265887','266193','266323','266324','266325','266400','266440','266656','266704','266782','266787','267014','267015','267395','267565','267566','268058','268059','268412','268457','268678','268799','268900','268901','269024','269176','269348','269358','269374','269417','269450','269451','269455','269456','269569','269570','273493','273529','273552','273619','273620','273746','273747','273809','273942','274091','274100','274308','274375','274377','274381','274407','274673','274701','274836','274887','275230','275231','275323','275324','275428','275429','275468','275511','275560','275593','275779','275803','275809','275853','275991','275993','276011','276040','276449','276450','276648','276649','276985','276992','277170','277782','277783','277833','278021','278128','278153','278256','278268','278329','278330','278343','278510','278524','278712','278741','278904','278970','279428','279704','279794','279795','280836','280842','280915','281111','281143','281234','281336','281719','281763','282303','282571','282819','282918','282919','282983','283061','283160','283204','283206','283208','283477','283647','284191','284192','284532','284645','284929','284931','284933','284934','285243','285265','285342','285418','285450','285755','285835','285845','286045','286192','286440','286671','288143','288144','288145','288146','288147','288295','289458','289478','291901','291911','291913','292299','292366','292777','292849','293899','294074','294075','294076','294077','294078','294156','294178','294207','294240','294287','294409','294410','294411','294412','294413','294414','294415','294416','294417','294418','294452','294453','294594','294653','294739','294740','294741','294742','294743','294744','294770','294772','294799','294800','294986','294987','295510','295761','295997','296214','296250','297157','297309','297310','297426','297752','298516','298517','298518','299098','299351','299424','299425','300425','300901','300902','300903','301929','301953','301954','302233','302234','302272') GROUP BY `series` ORDER BY `series` ASC

SELECT `series`,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 `series` !='' AND `modx_site_content`.`id` IN ('141868','141870','141871','141983','142079','142080','142081','142082','142083','142084','142750','142752','142753','142894','143372','143373','143397','143399','143406','143407','143408','143409','143596','143597','143608','143688','143689','144050','147067','147087','147173','147883','148027','148028','148412','150213','150214','150215','150216','150672','150689','150690','150691','150692','151842','151996','151997','151998','152634','152635','153430','153627','153669','153822','154274','154275','154276','154547','154967','154968','154969','154970','154991','154992','155031','155054','155055','155056','155057','155058','155107','155122','155123','155124','155125','155141','155150','155151','155152','155153','155157','155158','155520','155537','155721','156320','156321','156322','156323','156324','156344','156345','156346','156358','156365','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156813','156814','157554','157841','158302','158350','158614','158615','158681','159062','159122','159140','159205','159314','159336','159793','159794','160288','160967','161517','161976','161986','161987','161988','161989','161990','161991','161992','162205','162432','162436','162437','162443','162444','162654','162684','162715','162755','163231','163232','163233','163234','164445','164446','164524','164674','164675','164836','164875','164931','164949','165425','165630','165852','166574','166575','166576','166577','166578','166944','166945','167039','167040','167206','167443','167609','167749','168225','169263','169264','169265','169266','169301','169323','169769','169994','169995','170126','170206','170207','170528','202623','202824','207838','207839','207840','207841','207842','207843','207844','207845','207846','207847','207848','207849','207850','207851','207852','207853','207854','207855','207856','207857','207858','207859','207860','207861','207862','207863','207864','207865','207866','207867','207868','207869','207870','207871','207872','207873','207874','207875','207876','207877','207878','207879','207884','212535','212536','212537','212538','212539','212540','212541','212542','212543','212544','212545','212546','212547','212548','212549','212550','212551','212552','212553','212554','212555','212556','212557','212558','212559','212560','212561','212562','212563','212564','212565','212566','212567','212568','212569','212570','212571','212572','212573','212574','212575','212576','212577','212578','212579','212580','212581','212582','212583','212584','212585','212586','212587','212588','212589','212590','212591','212592','212593','212594','212595','212596','212597','212598','212599','212600','212601','212602','212603','212604','212605','212606','212607','212608','212609','212610','212611','212612','212613','212614','212615','212616','212617','212618','212619','215310','215311','215312','215721','215882','215986','232551','232645','238235','238472','238473','238512','238567','238737','238851','238852','238853','238854','238855','238856','238857','238858','239220','239342','239579','239585','239586','239587','239588','240256','240257','240258','240259','240260','240261','240262','240263','240264','240265','240266','240269','240474','240658','240693','240695','240696','240702','240730','240731','240770','240810','240873','240900','240901','240902','240953','240954','240958','240959','241067','241600','241601','241859','241860','241984','242235','242236','242238','242267','242718','242719','242951','242984','243461','243462','243509','243510','243511','243525','243715','243845','243846','244047','244252','244286','244287','244296','245112','245259','245365','245366','245367','245368','245386','245387','245647','245837','245909','246336','246778','246853','246854','246878','246921','247602','247631','247752','247852','247853','247854','247855','247882','247883','247885','247886','247887','248001','248005','248072','248073','248074','248075','248076','248077','248078','248079','248080','248169','248170','248304','248373','248374','248769','248947','249321','249541','249638','250582','250586','250613','250622','250962','253057','253841','254399','255245','255341','256110','256251','257280','261709','261713','261743','261772','262017','262018','262019','262020','262021','262022','262023','262024','262025','262026','262027','262028','262124','263643','263654','264476','264495','264496','264711','264712','264713','264727','264759','264761','264856','264917','264952','264953','264980','265267','265268','265269','265326','265327','265343','265344','265345','265346','265449','265702','265841','265842','265887','266193','266323','266324','266325','266400','266440','266656','266704','266782','266787','267014','267015','267395','267565','267566','268058','268059','268412','268457','268678','268799','268900','268901','269024','269176','269348','269358','269374','269417','269450','269451','269455','269456','269569','269570','273493','273529','273552','273619','273620','273746','273747','273809','273942','274091','274100','274308','274375','274377','274381','274407','274673','274701','274836','274887','275230','275231','275323','275324','275428','275429','275468','275511','275560','275593','275779','275803','275809','275853','275991','275993','276011','276040','276449','276450','276648','276649','276985','276992','277170','277782','277783','277833','278021','278128','278153','278256','278268','278329','278330','278343','278510','278524','278712','278741','278904','278970','279428','280836','280842','280915','281111','281143','281234','281336','281719','281763','282303','282571','282819','282918','282919','282983','283061','283160','283204','283206','283208','283477','283647','284191','284192','284532','284645','284929','284931','284933','284934','285243','285265','285342','285418','285450','285755','285835','285845','286045','286192','286440','286671','288144','288145','288146','288147','288295','289458','289478','291901','291911','291913','292299','292366','292777','292849','293899','294074','294075','294076','294077','294078','294156','294178','294207','294240','294287','294594','294653','294739','294740','294741','294742','294743','294744','294770','294772','294799','294800','294986','294987','295510','295761','295997','296214','296250','297157','297309','297310','297426','297752','298516','298517','298518','299098','299351','299424','299425','300425','300901','300902','300903','301929','301953','301954','302233','302234','302272') GROUP BY `series` ORDER BY `series` ASC

SELECT `tip`,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 `tip` !='' AND `modx_site_content`.`id` IN ('141868','141870','141871','141983','142079','142080','142081','142082','142083','142084','142085','142750','142752','142753','142831','142894','143372','143373','143397','143399','143406','143407','143408','143409','143596','143597','143608','143688','143689','144050','147067','147087','147173','147883','148027','148028','148412','150213','150214','150215','150216','150672','150689','150690','150691','150692','151842','151996','151997','151998','152634','152635','153430','153627','153669','153822','154274','154275','154276','154277','154547','154967','154968','154969','154970','154991','154992','155031','155054','155055','155056','155057','155058','155107','155122','155123','155124','155125','155141','155150','155151','155152','155153','155156','155157','155158','155520','155537','155719','155721','156320','156321','156322','156323','156324','156344','156345','156346','156358','156365','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156813','156814','156815','156816','157554','157841','158302','158350','158614','158615','158681','159062','159122','159140','159205','159314','159336','159793','159794','160288','160967','161517','161976','161986','161987','161988','161989','161990','161991','161992','162205','162432','162436','162437','162443','162444','162654','162684','162715','162755','163231','163232','163233','163234','164445','164446','164524','164674','164675','164836','164875','164931','164949','165425','165630','165852','166574','166575','166576','166577','166578','166944','166945','167039','167040','167206','167443','167609','167749','168225','169263','169264','169265','169266','169301','169323','169769','169819','169994','169995','170126','170206','170207','170528','202623','202824','207838','207839','207840','207841','207842','207843','207844','207845','207846','207847','207848','207849','207850','207851','207852','207853','207854','207855','207856','207857','207858','207859','207860','207861','207862','207863','207864','207865','207866','207867','207868','207869','207870','207871','207872','207873','207874','207875','207876','207877','207878','207879','207884','212535','212536','212537','212538','212539','212540','212541','212542','212543','212544','212545','212546','212547','212548','212549','212550','212551','212552','212553','212554','212555','212556','212557','212558','212559','212560','212561','212562','212563','212564','212565','212566','212567','212568','212569','212570','212571','212572','212573','212574','212575','212576','212577','212578','212579','212580','212581','212582','212583','212584','212585','212586','212587','212588','212589','212590','212591','212592','212593','212594','212595','212596','212597','212598','212599','212600','212601','212602','212603','212604','212605','212606','212607','212608','212609','212610','212611','212612','212613','212614','212615','212616','212617','212618','212619','215310','215311','215312','215721','215821','215882','215986','232551','232645','238235','238472','238473','238512','238567','238737','238851','238852','238853','238854','238855','238856','238857','238858','239220','239342','239579','239585','239586','239587','239588','240256','240257','240258','240259','240260','240261','240262','240263','240264','240265','240266','240269','240474','240658','240693','240695','240696','240702','240730','240731','240770','240810','240873','240900','240901','240902','240953','240954','240958','240959','241067','241600','241601','241859','241860','241984','242235','242236','242238','242267','242718','242719','242951','242984','243461','243462','243509','243510','243511','243525','243715','243845','243846','244047','244252','244286','244287','244296','245112','245259','245365','245366','245367','245368','245386','245387','245647','245837','245909','246336','246778','246853','246854','246878','246921','247602','247631','247752','247852','247853','247854','247855','247882','247883','247885','247886','247887','248001','248005','248072','248073','248074','248075','248076','248077','248078','248079','248080','248169','248170','248304','248373','248374','248769','248947','249321','249541','249638','250582','250586','250613','250622','250962','253057','253841','254399','255245','255341','256110','256251','257280','261709','261713','261743','261772','262017','262018','262019','262020','262021','262022','262023','262024','262025','262026','262027','262028','262124','262244','262245','263643','263654','264476','264495','264496','264711','264712','264713','264727','264759','264761','264856','264917','264952','264953','264980','265267','265268','265269','265326','265327','265343','265344','265345','265346','265449','265702','265841','265842','265887','266193','266323','266324','266325','266400','266440','266656','266704','266782','266787','267014','267015','267395','267565','267566','268058','268059','268412','268457','268678','268799','268900','268901','269024','269176','269348','269358','269374','269417','269450','269451','269455','269456','269569','269570','273493','273529','273552','273619','273620','273746','273747','273809','273942','274091','274100','274308','274375','274377','274381','274407','274673','274701','274836','274887','275230','275231','275323','275324','275428','275429','275468','275511','275560','275593','275779','275803','275809','275853','275991','275993','276011','276040','276449','276450','276648','276649','276985','276992','277170','277782','277783','277833','278021','278128','278153','278256','278268','278329','278330','278343','278510','278524','278712','278741','278904','278970','279428','279704','279794','279795','280836','280842','280915','281111','281143','281234','281336','281719','281763','282303','282571','282819','282918','282919','282983','283061','283160','283204','283206','283208','283477','283647','284191','284192','284532','284645','284929','284931','284933','284934','285243','285265','285342','285418','285450','285755','285835','285845','286045','286192','286440','286671','288143','288144','288145','288146','288147','288295','289458','289478','291901','291911','291913','292299','292366','292777','292849','293899','294074','294075','294076','294077','294078','294156','294178','294207','294240','294287','294409','294410','294411','294412','294413','294414','294415','294416','294417','294418','294452','294453','294594','294653','294739','294740','294741','294742','294743','294744','294770','294772','294799','294800','294986','294987','295510','295761','295997','296214','296250','297157','297309','297310','297426','297752','298516','298517','298518','299098','299351','299424','299425','300425','300901','300902','300903','301929','301953','301954','302233','302234','302272') GROUP BY `tip` ORDER BY `tip` ASC

SELECT `tip`,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 `tip` !='' AND `modx_site_content`.`id` IN ('141868','141870','141871','141983','142079','142080','142081','142082','142083','142084','142750','142752','142753','142894','143372','143373','143397','143399','143406','143407','143408','143409','143596','143597','143608','143688','143689','144050','147067','147087','147173','147883','148027','148028','148412','150213','150214','150215','150216','150672','150689','150690','150691','150692','151842','151996','151997','151998','152634','152635','153430','153627','153669','153822','154274','154275','154276','154547','154967','154968','154969','154970','154991','154992','155031','155054','155055','155056','155057','155058','155107','155122','155123','155124','155125','155141','155150','155151','155152','155153','155157','155158','155520','155537','155721','156320','156321','156322','156323','156324','156344','156345','156346','156358','156365','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156813','156814','157554','157841','158302','158350','158614','158615','158681','159062','159122','159140','159205','159314','159336','159793','159794','160288','160967','161517','161976','161986','161987','161988','161989','161990','161991','161992','162205','162432','162436','162437','162443','162444','162654','162684','162715','162755','163231','163232','163233','163234','164445','164446','164524','164674','164675','164836','164875','164931','164949','165425','165630','165852','166574','166575','166576','166577','166578','166944','166945','167039','167040','167206','167443','167609','167749','168225','169263','169264','169265','169266','169301','169323','169769','169994','169995','170126','170206','170207','170528','202623','202824','207838','207839','207840','207841','207842','207843','207844','207845','207846','207847','207848','207849','207850','207851','207852','207853','207854','207855','207856','207857','207858','207859','207860','207861','207862','207863','207864','207865','207866','207867','207868','207869','207870','207871','207872','207873','207874','207875','207876','207877','207878','207879','207884','212535','212536','212537','212538','212539','212540','212541','212542','212543','212544','212545','212546','212547','212548','212549','212550','212551','212552','212553','212554','212555','212556','212557','212558','212559','212560','212561','212562','212563','212564','212565','212566','212567','212568','212569','212570','212571','212572','212573','212574','212575','212576','212577','212578','212579','212580','212581','212582','212583','212584','212585','212586','212587','212588','212589','212590','212591','212592','212593','212594','212595','212596','212597','212598','212599','212600','212601','212602','212603','212604','212605','212606','212607','212608','212609','212610','212611','212612','212613','212614','212615','212616','212617','212618','212619','215310','215311','215312','215721','215882','215986','232551','232645','238235','238472','238473','238512','238567','238737','238851','238852','238853','238854','238855','238856','238857','238858','239220','239342','239579','239585','239586','239587','239588','240256','240257','240258','240259','240260','240261','240262','240263','240264','240265','240266','240269','240474','240658','240693','240695','240696','240702','240730','240731','240770','240810','240873','240900','240901','240902','240953','240954','240958','240959','241067','241600','241601','241859','241860','241984','242235','242236','242238','242267','242718','242719','242951','242984','243461','243462','243509','243510','243511','243525','243715','243845','243846','244047','244252','244286','244287','244296','245112','245259','245365','245366','245367','245368','245386','245387','245647','245837','245909','246336','246778','246853','246854','246878','246921','247602','247631','247752','247852','247853','247854','247855','247882','247883','247885','247886','247887','248001','248005','248072','248073','248074','248075','248076','248077','248078','248079','248080','248169','248170','248304','248373','248374','248769','248947','249321','249541','249638','250582','250586','250613','250622','250962','253057','253841','254399','255245','255341','256110','256251','257280','261709','261713','261743','261772','262017','262018','262019','262020','262021','262022','262023','262024','262025','262026','262027','262028','262124','263643','263654','264476','264495','264496','264711','264712','264713','264727','264759','264761','264856','264917','264952','264953','264980','265267','265268','265269','265326','265327','265343','265344','265345','265346','265449','265702','265841','265842','265887','266193','266323','266324','266325','266400','266440','266656','266704','266782','266787','267014','267015','267395','267565','267566','268058','268059','268412','268457','268678','268799','268900','268901','269024','269176','269348','269358','269374','269417','269450','269451','269455','269456','269569','269570','273493','273529','273552','273619','273620','273746','273747','273809','273942','274091','274100','274308','274375','274377','274381','274407','274673','274701','274836','274887','275230','275231','275323','275324','275428','275429','275468','275511','275560','275593','275779','275803','275809','275853','275991','275993','276011','276040','276449','276450','276648','276649','276985','276992','277170','277782','277783','277833','278021','278128','278153','278256','278268','278329','278330','278343','278510','278524','278712','278741','278904','278970','279428','280836','280842','280915','281111','281143','281234','281336','281719','281763','282303','282571','282819','282918','282919','282983','283061','283160','283204','283206','283208','283477','283647','284191','284192','284532','284645','284929','284931','284933','284934','285243','285265','285342','285418','285450','285755','285835','285845','286045','286192','286440','286671','288144','288145','288146','288147','288295','289458','289478','291901','291911','291913','292299','292366','292777','292849','293899','294074','294075','294076','294077','294078','294156','294178','294207','294240','294287','294594','294653','294739','294740','294741','294742','294743','294744','294770','294772','294799','294800','294986','294987','295510','295761','295997','296214','296250','297157','297309','297310','297426','297752','298516','298517','298518','299098','299351','299424','299425','300425','300901','300902','300903','301929','301953','301954','302233','302234','302272') GROUP BY `tip` ORDER BY `tip` ASC

SELECT `kol_kon`,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 `kol_kon` !='' AND `modx_site_content`.`id` IN ('141868','141870','141871','141983','142079','142080','142081','142082','142083','142084','142085','142750','142752','142753','142831','142894','143372','143373','143397','143399','143406','143407','143408','143409','143596','143597','143608','143688','143689','144050','147067','147087','147173','147883','148027','148028','148412','150213','150214','150215','150216','150672','150689','150690','150691','150692','151842','151996','151997','151998','152634','152635','153430','153627','153669','153822','154274','154275','154276','154277','154547','154967','154968','154969','154970','154991','154992','155031','155054','155055','155056','155057','155058','155107','155122','155123','155124','155125','155141','155150','155151','155152','155153','155156','155157','155158','155520','155537','155719','155721','156320','156321','156322','156323','156324','156344','156345','156346','156358','156365','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156813','156814','156815','156816','157554','157841','158302','158350','158614','158615','158681','159062','159122','159140','159205','159314','159336','159793','159794','160288','160967','161517','161976','161986','161987','161988','161989','161990','161991','161992','162205','162432','162436','162437','162443','162444','162654','162684','162715','162755','163231','163232','163233','163234','164445','164446','164524','164674','164675','164836','164875','164931','164949','165425','165630','165852','166574','166575','166576','166577','166578','166944','166945','167039','167040','167206','167443','167609','167749','168225','169263','169264','169265','169266','169301','169323','169769','169819','169994','169995','170126','170206','170207','170528','202623','202824','207838','207839','207840','207841','207842','207843','207844','207845','207846','207847','207848','207849','207850','207851','207852','207853','207854','207855','207856','207857','207858','207859','207860','207861','207862','207863','207864','207865','207866','207867','207868','207869','207870','207871','207872','207873','207874','207875','207876','207877','207878','207879','207884','212535','212536','212537','212538','212539','212540','212541','212542','212543','212544','212545','212546','212547','212548','212549','212550','212551','212552','212553','212554','212555','212556','212557','212558','212559','212560','212561','212562','212563','212564','212565','212566','212567','212568','212569','212570','212571','212572','212573','212574','212575','212576','212577','212578','212579','212580','212581','212582','212583','212584','212585','212586','212587','212588','212589','212590','212591','212592','212593','212594','212595','212596','212597','212598','212599','212600','212601','212602','212603','212604','212605','212606','212607','212608','212609','212610','212611','212612','212613','212614','212615','212616','212617','212618','212619','215310','215311','215312','215721','215821','215882','215986','232551','232645','238235','238472','238473','238512','238567','238737','238851','238852','238853','238854','238855','238856','238857','238858','239220','239342','239579','239585','239586','239587','239588','240256','240257','240258','240259','240260','240261','240262','240263','240264','240265','240266','240269','240474','240658','240693','240695','240696','240702','240730','240731','240770','240810','240873','240900','240901','240902','240953','240954','240958','240959','241067','241600','241601','241859','241860','241984','242235','242236','242238','242267','242718','242719','242951','242984','243461','243462','243509','243510','243511','243525','243715','243845','243846','244047','244252','244286','244287','244296','245112','245259','245365','245366','245367','245368','245386','245387','245647','245837','245909','246336','246778','246853','246854','246878','246921','247602','247631','247752','247852','247853','247854','247855','247882','247883','247885','247886','247887','248001','248005','248072','248073','248074','248075','248076','248077','248078','248079','248080','248169','248170','248304','248373','248374','248769','248947','249321','249541','249638','250582','250586','250613','250622','250962','253057','253841','254399','255245','255341','256110','256251','257280','261709','261713','261743','261772','262017','262018','262019','262020','262021','262022','262023','262024','262025','262026','262027','262028','262124','262244','262245','263643','263654','264476','264495','264496','264711','264712','264713','264727','264759','264761','264856','264917','264952','264953','264980','265267','265268','265269','265326','265327','265343','265344','265345','265346','265449','265702','265841','265842','265887','266193','266323','266324','266325','266400','266440','266656','266704','266782','266787','267014','267015','267395','267565','267566','268058','268059','268412','268457','268678','268799','268900','268901','269024','269176','269348','269358','269374','269417','269450','269451','269455','269456','269569','269570','273493','273529','273552','273619','273620','273746','273747','273809','273942','274091','274100','274308','274375','274377','274381','274407','274673','274701','274836','274887','275230','275231','275323','275324','275428','275429','275468','275511','275560','275593','275779','275803','275809','275853','275991','275993','276011','276040','276449','276450','276648','276649','276985','276992','277170','277782','277783','277833','278021','278128','278153','278256','278268','278329','278330','278343','278510','278524','278712','278741','278904','278970','279428','279704','279794','279795','280836','280842','280915','281111','281143','281234','281336','281719','281763','282303','282571','282819','282918','282919','282983','283061','283160','283204','283206','283208','283477','283647','284191','284192','284532','284645','284929','284931','284933','284934','285243','285265','285342','285418','285450','285755','285835','285845','286045','286192','286440','286671','288143','288144','288145','288146','288147','288295','289458','289478','291901','291911','291913','292299','292366','292777','292849','293899','294074','294075','294076','294077','294078','294156','294178','294207','294240','294287','294409','294410','294411','294412','294413','294414','294415','294416','294417','294418','294452','294453','294594','294653','294739','294740','294741','294742','294743','294744','294770','294772','294799','294800','294986','294987','295510','295761','295997','296214','296250','297157','297309','297310','297426','297752','298516','298517','298518','299098','299351','299424','299425','300425','300901','300902','300903','301929','301953','301954','302233','302234','302272') GROUP BY `kol_kon` ORDER BY `kol_kon` ASC

SELECT `kol_kon`,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 `kol_kon` !='' AND `modx_site_content`.`id` IN ('141868','141870','141871','141983','142079','142080','142081','142082','142083','142084','142750','142752','142753','142894','143372','143373','143397','143399','143406','143407','143408','143409','143596','143597','143608','143688','143689','144050','147067','147087','147173','147883','148027','148028','148412','150213','150214','150215','150216','150672','150689','150690','150691','150692','151842','151996','151997','151998','152634','152635','153430','153627','153669','153822','154274','154275','154276','154547','154967','154968','154969','154970','154991','154992','155031','155054','155055','155056','155057','155058','155107','155122','155123','155124','155125','155141','155150','155151','155152','155153','155157','155158','155520','155537','155721','156320','156321','156322','156323','156324','156344','156345','156346','156358','156365','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156813','156814','157554','157841','158302','158350','158614','158615','158681','159062','159122','159140','159205','159314','159336','159793','159794','160288','160967','161517','161976','161986','161987','161988','161989','161990','161991','161992','162205','162432','162436','162437','162443','162444','162654','162684','162715','162755','163231','163232','163233','163234','164445','164446','164524','164674','164675','164836','164875','164931','164949','165425','165630','165852','166574','166575','166576','166577','166578','166944','166945','167039','167040','167206','167443','167609','167749','168225','169263','169264','169265','169266','169301','169323','169769','169994','169995','170126','170206','170207','170528','202623','202824','207838','207839','207840','207841','207842','207843','207844','207845','207846','207847','207848','207849','207850','207851','207852','207853','207854','207855','207856','207857','207858','207859','207860','207861','207862','207863','207864','207865','207866','207867','207868','207869','207870','207871','207872','207873','207874','207875','207876','207877','207878','207879','207884','212535','212536','212537','212538','212539','212540','212541','212542','212543','212544','212545','212546','212547','212548','212549','212550','212551','212552','212553','212554','212555','212556','212557','212558','212559','212560','212561','212562','212563','212564','212565','212566','212567','212568','212569','212570','212571','212572','212573','212574','212575','212576','212577','212578','212579','212580','212581','212582','212583','212584','212585','212586','212587','212588','212589','212590','212591','212592','212593','212594','212595','212596','212597','212598','212599','212600','212601','212602','212603','212604','212605','212606','212607','212608','212609','212610','212611','212612','212613','212614','212615','212616','212617','212618','212619','215310','215311','215312','215721','215882','215986','232551','232645','238235','238472','238473','238512','238567','238737','238851','238852','238853','238854','238855','238856','238857','238858','239220','239342','239579','239585','239586','239587','239588','240256','240257','240258','240259','240260','240261','240262','240263','240264','240265','240266','240269','240474','240658','240693','240695','240696','240702','240730','240731','240770','240810','240873','240900','240901','240902','240953','240954','240958','240959','241067','241600','241601','241859','241860','241984','242235','242236','242238','242267','242718','242719','242951','242984','243461','243462','243509','243510','243511','243525','243715','243845','243846','244047','244252','244286','244287','244296','245112','245259','245365','245366','245367','245368','245386','245387','245647','245837','245909','246336','246778','246853','246854','246878','246921','247602','247631','247752','247852','247853','247854','247855','247882','247883','247885','247886','247887','248001','248005','248072','248073','248074','248075','248076','248077','248078','248079','248080','248169','248170','248304','248373','248374','248769','248947','249321','249541','249638','250582','250586','250613','250622','250962','253057','253841','254399','255245','255341','256110','256251','257280','261709','261713','261743','261772','262017','262018','262019','262020','262021','262022','262023','262024','262025','262026','262027','262028','262124','263643','263654','264476','264495','264496','264711','264712','264713','264727','264759','264761','264856','264917','264952','264953','264980','265267','265268','265269','265326','265327','265343','265344','265345','265346','265449','265702','265841','265842','265887','266193','266323','266324','266325','266400','266440','266656','266704','266782','266787','267014','267015','267395','267565','267566','268058','268059','268412','268457','268678','268799','268900','268901','269024','269176','269348','269358','269374','269417','269450','269451','269455','269456','269569','269570','273493','273529','273552','273619','273620','273746','273747','273809','273942','274091','274100','274308','274375','274377','274381','274407','274673','274701','274836','274887','275230','275231','275323','275324','275428','275429','275468','275511','275560','275593','275779','275803','275809','275853','275991','275993','276011','276040','276449','276450','276648','276649','276985','276992','277170','277782','277783','277833','278021','278128','278153','278256','278268','278329','278330','278343','278510','278524','278712','278741','278904','278970','279428','280836','280842','280915','281111','281143','281234','281336','281719','281763','282303','282571','282819','282918','282919','282983','283061','283160','283204','283206','283208','283477','283647','284191','284192','284532','284645','284929','284931','284933','284934','285243','285265','285342','285418','285450','285755','285835','285845','286045','286192','286440','286671','288144','288145','288146','288147','288295','289458','289478','291901','291911','291913','292299','292366','292777','292849','293899','294074','294075','294076','294077','294078','294156','294178','294207','294240','294287','294594','294653','294739','294740','294741','294742','294743','294744','294770','294772','294799','294800','294986','294987','295510','295761','295997','296214','296250','297157','297309','297310','297426','297752','298516','298517','298518','299098','299351','299424','299425','300425','300901','300902','300903','301929','301953','301954','302233','302234','302272') GROUP BY `kol_kon` ORDER BY `kol_kon` ASC

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 ('141868','141870','141871','141983','142079','142080','142081','142082','142083','142084','142085','142750','142752','142753','142831','142894','143372','143373','143397','143399','143406','143407','143408','143409','143596','143597','143608','143688','143689','144050','147067','147087','147173','147883','148027','148028','148412','150213','150214','150215','150216','150672','150689','150690','150691','150692','151842','151996','151997','151998','152634','152635','153430','153627','153669','153822','154274','154275','154276','154277','154547','154967','154968','154969','154970','154991','154992','155031','155054','155055','155056','155057','155058','155107','155122','155123','155124','155125','155141','155150','155151','155152','155153','155156','155157','155158','155520','155537','155719','155721','156320','156321','156322','156323','156324','156344','156345','156346','156358','156365','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156813','156814','156815','156816','157554','157841','158302','158350','158614','158615','158681','159062','159122','159140','159205','159314','159336','159793','159794','160288','160967','161517','161976','161986','161987','161988','161989','161990','161991','161992','162205','162432','162436','162437','162443','162444','162654','162684','162715','162755','163231','163232','163233','163234','164445','164446','164524','164674','164675','164836','164875','164931','164949','165425','165630','165852','166574','166575','166576','166577','166578','166944','166945','167039','167040','167206','167443','167609','167749','168225','169263','169264','169265','169266','169301','169323','169769','169819','169994','169995','170126','170206','170207','170528','202623','202824','207838','207839','207840','207841','207842','207843','207844','207845','207846','207847','207848','207849','207850','207851','207852','207853','207854','207855','207856','207857','207858','207859','207860','207861','207862','207863','207864','207865','207866','207867','207868','207869','207870','207871','207872','207873','207874','207875','207876','207877','207878','207879','207884','212535','212536','212537','212538','212539','212540','212541','212542','212543','212544','212545','212546','212547','212548','212549','212550','212551','212552','212553','212554','212555','212556','212557','212558','212559','212560','212561','212562','212563','212564','212565','212566','212567','212568','212569','212570','212571','212572','212573','212574','212575','212576','212577','212578','212579','212580','212581','212582','212583','212584','212585','212586','212587','212588','212589','212590','212591','212592','212593','212594','212595','212596','212597','212598','212599','212600','212601','212602','212603','212604','212605','212606','212607','212608','212609','212610','212611','212612','212613','212614','212615','212616','212617','212618','212619','215310','215311','215312','215721','215821','215882','215986','232551','232645','238235','238472','238473','238512','238567','238737','238851','238852','238853','238854','238855','238856','238857','238858','239220','239342','239579','239585','239586','239587','239588','240256','240257','240258','240259','240260','240261','240262','240263','240264','240265','240266','240269','240474','240658','240693','240695','240696','240702','240730','240731','240770','240810','240873','240900','240901','240902','240953','240954','240958','240959','241067','241600','241601','241859','241860','241984','242235','242236','242238','242267','242718','242719','242951','242984','243461','243462','243509','243510','243511','243525','243715','243845','243846','244047','244252','244286','244287','244296','245112','245259','245365','245366','245367','245368','245386','245387','245647','245837','245909','246336','246778','246853','246854','246878','246921','247602','247631','247752','247852','247853','247854','247855','247882','247883','247885','247886','247887','248001','248005','248072','248073','248074','248075','248076','248077','248078','248079','248080','248169','248170','248304','248373','248374','248769','248947','249321','249541','249638','250582','250586','250613','250622','250962','253057','253841','254399','255245','255341','256110','256251','257280','261709','261713','261743','261772','262017','262018','262019','262020','262021','262022','262023','262024','262025','262026','262027','262028','262124','262244','262245','263643','263654','264476','264495','264496','264711','264712','264713','264727','264759','264761','264856','264917','264952','264953','264980','265267','265268','265269','265326','265327','265343','265344','265345','265346','265449','265702','265841','265842','265887','266193','266323','266324','266325','266400','266440','266656','266704','266782','266787','267014','267015','267395','267565','267566','268058','268059','268412','268457','268678','268799','268900','268901','269024','269176','269348','269358','269374','269417','269450','269451','269455','269456','269569','269570','273493','273529','273552','273619','273620','273746','273747','273809','273942','274091','274100','274308','274375','274377','274381','274407','274673','274701','274836','274887','275230','275231','275323','275324','275428','275429','275468','275511','275560','275593','275779','275803','275809','275853','275991','275993','276011','276040','276449','276450','276648','276649','276985','276992','277170','277782','277783','277833','278021','278128','278153','278256','278268','278329','278330','278343','278510','278524','278712','278741','278904','278970','279428','279704','279794','279795','280836','280842','280915','281111','281143','281234','281336','281719','281763','282303','282571','282819','282918','282919','282983','283061','283160','283204','283206','283208','283477','283647','284191','284192','284532','284645','284929','284931','284933','284934','285243','285265','285342','285418','285450','285755','285835','285845','286045','286192','286440','286671','288143','288144','288145','288146','288147','288295','289458','289478','291901','291911','291913','292299','292366','292777','292849','293899','294074','294075','294076','294077','294078','294156','294178','294207','294240','294287','294409','294410','294411','294412','294413','294414','294415','294416','294417','294418','294452','294453','294594','294653','294739','294740','294741','294742','294743','294744','294770','294772','294799','294800','294986','294987','295510','295761','295997','296214','296250','297157','297309','297310','297426','297752','298516','298517','298518','299098','299351','299424','299425','300425','300901','300902','300903','301929','301953','301954','302233','302234','302272') GROUP BY `color` ORDER BY `color` ASC

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 ('141868','141870','141871','141983','142079','142080','142081','142082','142083','142084','142750','142752','142753','142894','143372','143373','143397','143399','143406','143407','143408','143409','143596','143597','143608','143688','143689','144050','147067','147087','147173','147883','148027','148028','148412','150213','150214','150215','150216','150672','150689','150690','150691','150692','151842','151996','151997','151998','152634','152635','153430','153627','153669','153822','154274','154275','154276','154547','154967','154968','154969','154970','154991','154992','155031','155054','155055','155056','155057','155058','155107','155122','155123','155124','155125','155141','155150','155151','155152','155153','155157','155158','155520','155537','155721','156320','156321','156322','156323','156324','156344','156345','156346','156358','156365','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156813','156814','157554','157841','158302','158350','158614','158615','158681','159062','159122','159140','159205','159314','159336','159793','159794','160288','160967','161517','161976','161986','161987','161988','161989','161990','161991','161992','162205','162432','162436','162437','162443','162444','162654','162684','162715','162755','163231','163232','163233','163234','164445','164446','164524','164674','164675','164836','164875','164931','164949','165425','165630','165852','166574','166575','166576','166577','166578','166944','166945','167039','167040','167206','167443','167609','167749','168225','169263','169264','169265','169266','169301','169323','169769','169994','169995','170126','170206','170207','170528','202623','202824','207838','207839','207840','207841','207842','207843','207844','207845','207846','207847','207848','207849','207850','207851','207852','207853','207854','207855','207856','207857','207858','207859','207860','207861','207862','207863','207864','207865','207866','207867','207868','207869','207870','207871','207872','207873','207874','207875','207876','207877','207878','207879','207884','212535','212536','212537','212538','212539','212540','212541','212542','212543','212544','212545','212546','212547','212548','212549','212550','212551','212552','212553','212554','212555','212556','212557','212558','212559','212560','212561','212562','212563','212564','212565','212566','212567','212568','212569','212570','212571','212572','212573','212574','212575','212576','212577','212578','212579','212580','212581','212582','212583','212584','212585','212586','212587','212588','212589','212590','212591','212592','212593','212594','212595','212596','212597','212598','212599','212600','212601','212602','212603','212604','212605','212606','212607','212608','212609','212610','212611','212612','212613','212614','212615','212616','212617','212618','212619','215310','215311','215312','215721','215882','215986','232551','232645','238235','238472','238473','238512','238567','238737','238851','238852','238853','238854','238855','238856','238857','238858','239220','239342','239579','239585','239586','239587','239588','240256','240257','240258','240259','240260','240261','240262','240263','240264','240265','240266','240269','240474','240658','240693','240695','240696','240702','240730','240731','240770','240810','240873','240900','240901','240902','240953','240954','240958','240959','241067','241600','241601','241859','241860','241984','242235','242236','242238','242267','242718','242719','242951','242984','243461','243462','243509','243510','243511','243525','243715','243845','243846','244047','244252','244286','244287','244296','245112','245259','245365','245366','245367','245368','245386','245387','245647','245837','245909','246336','246778','246853','246854','246878','246921','247602','247631','247752','247852','247853','247854','247855','247882','247883','247885','247886','247887','248001','248005','248072','248073','248074','248075','248076','248077','248078','248079','248080','248169','248170','248304','248373','248374','248769','248947','249321','249541','249638','250582','250586','250613','250622','250962','253057','253841','254399','255245','255341','256110','256251','257280','261709','261713','261743','261772','262017','262018','262019','262020','262021','262022','262023','262024','262025','262026','262027','262028','262124','263643','263654','264476','264495','264496','264711','264712','264713','264727','264759','264761','264856','264917','264952','264953','264980','265267','265268','265269','265326','265327','265343','265344','265345','265346','265449','265702','265841','265842','265887','266193','266323','266324','266325','266400','266440','266656','266704','266782','266787','267014','267015','267395','267565','267566','268058','268059','268412','268457','268678','268799','268900','268901','269024','269176','269348','269358','269374','269417','269450','269451','269455','269456','269569','269570','273493','273529','273552','273619','273620','273746','273747','273809','273942','274091','274100','274308','274375','274377','274381','274407','274673','274701','274836','274887','275230','275231','275323','275324','275428','275429','275468','275511','275560','275593','275779','275803','275809','275853','275991','275993','276011','276040','276449','276450','276648','276649','276985','276992','277170','277782','277783','277833','278021','278128','278153','278256','278268','278329','278330','278343','278510','278524','278712','278741','278904','278970','279428','280836','280842','280915','281111','281143','281234','281336','281719','281763','282303','282571','282819','282918','282919','282983','283061','283160','283204','283206','283208','283477','283647','284191','284192','284532','284645','284929','284931','284933','284934','285243','285265','285342','285418','285450','285755','285835','285845','286045','286192','286440','286671','288144','288145','288146','288147','288295','289458','289478','291901','291911','291913','292299','292366','292777','292849','293899','294074','294075','294076','294077','294078','294156','294178','294207','294240','294287','294594','294653','294739','294740','294741','294742','294743','294744','294770','294772','294799','294800','294986','294987','295510','295761','295997','296214','296250','297157','297309','297310','297426','297752','298516','298517','298518','299098','299351','299424','299425','300425','300901','300902','300903','301929','301953','301954','302233','302234','302272') GROUP BY `color` ORDER BY `color` ASC