G-Nor

SELECT `formled`,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 `formled` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','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','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `formled` ORDER BY `formled` ASC

SELECT `formled`,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 `formled` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','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','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `formled` ORDER BY `formled` ASC

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 ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','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','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `leddiam` ORDER BY `leddiam` ASC

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 ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','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','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `leddiam` ORDER BY `leddiam` ASC

SELECT `color_temp`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `color_temp` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','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','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `color_temp` ORDER BY `color_temp` ASC

SELECT `color_temp`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `color_temp` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','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','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `color_temp` ORDER BY `color_temp` 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 ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','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','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') 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 ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','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','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `color` ORDER BY `color` ASC

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 ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','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','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `lens_color` ORDER BY `lens_color` ASC

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 ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','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','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `lens_color` ORDER BY `lens_color` ASC

SELECT `stock_status`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `stock_status` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','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','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `stock_status` ORDER BY `stock_status` ASC

SELECT `stock_status`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `stock_status` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','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','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `stock_status` ORDER BY `stock_status` ASC