Дисплеи и модули

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 ('281491','286418','286419','286420','286421','286422','143923','153783','153936','157739','160830','160860','161962','162647','167511','170204','170375','232608','240531','243685','243967','244097','245698','246080','246762','246774','248570','249899','250838','251847','253754','253850','256580','266796','269051','277704','281490','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281679','291623','292473','294701','295409','295598','297254','163822','164555','166656','168318','243209','250270','261740','265109','266448','268785','274865','278111','279091','279092','281576','281577','281578','281579','281580','292042','293270','143050','143133','143205','143507','146592','151403','151530','151626','154900','157532','157533','157534','157535','157638','158656','159856','160212','160396','160569','160771','160772','160773','160783','163700','163714','163959','164211','165107','165158','165819','166752','169215','170101','170725','232644','238682','238820','239494','243393','245382','245510','245614','246836','247463','247639','247751','248372','248601','249625','250014','252234','253066','253421','253430','255627','256019','257031','262117','262183','262254','263033','263045','263721','264514','265146','265631','267573','267770','268001','268002','268045','268815','269072','273545','274431','275300','278401','279668','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281599','282821','285792','288691','289461','292364','293453','294190','294295','298183','298396','299190','299983','300934','302156','146589','153503','157759','158854','160710','161460','161516','162783','163605','163964','164059','164495','167258','167259','167448','201148','215377','215626','215832','238481','240667','240937','240957','241755','241988','242219','242558','243166','243945','244141','244148','244208','244289','244598','245358','245359','245583','246779','247378','248445','248865','248970','251011','251012','251682','253060','253437','255281','255282','257224','262940','265159','265787','265950','267284','267702','269097','274946','275017','275316','275364','276015','279089','279090','281147','281152','283583','285195','285825','285826','299762','299763','162155','162921','164401','165631','165632','166917','202650','215771','241157','244329','248899','249233','250870','251302','251431','254206','262974','265107','265513','279280','280502','281571','281572','281573','281574','281575','283572','286107','286108','286109','286111','288154','294980','294983','294984','295805','302296','302305') 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 ('143050','143133','143205','143507','143923','146589','146592','151403','151530','151626','153503','153783','153936','154900','157532','157533','157534','157535','157638','157739','157759','158656','158854','159856','160212','160396','160569','160710','160771','160772','160773','160783','160830','160860','161460','161516','161962','162155','162647','162783','162921','163605','163700','163714','163822','163959','163964','164059','164211','164401','164495','164555','165107','165158','165631','165632','165819','166656','166752','166917','167258','167259','167511','168318','169215','170101','170204','170375','170725','201148','202650','215377','215626','215771','215832','232608','232644','238481','238682','238820','239494','240531','240667','240937','240957','241157','241755','241988','242219','242558','243166','243209','243393','243685','243945','243967','244097','244148','244208','244289','244329','244598','245358','245359','245382','245510','245583','245614','245698','246080','246762','246774','246779','246836','247378','247463','247639','247751','248372','248445','248570','248601','248865','248899','248970','249233','249625','249899','250014','250270','250838','250870','251011','251012','251302','251431','251682','251847','252234','253060','253066','253421','253430','253437','253754','253850','254206','255281','255282','255627','256019','256580','257031','257224','261740','262117','262183','262254','262974','263033','263045','263721','264514','265107','265109','265146','265159','265513','265631','265787','265950','266448','266796','267284','267573','267702','267770','268001','268002','268045','268785','268815','269051','269072','269097','273545','274431','274865','274946','275017','275300','275316','275364','276015','277704','278111','278401','279089','279090','279091','279092','279280','279668','280502','281147','281152','281490','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281571','281572','281573','281574','281575','281576','281577','281578','281579','281580','281599','281679','282821','283572','283583','285195','285792','285825','285826','286107','286108','286109','286111','288154','288691','289461','291623','292042','292364','292473','293270','293453','294190','294295','294701','294980','294983','294984','295409','295598','295805','297254','298183','298396','299190','299762','299763','299983','300934','302296','302305') GROUP BY `manuf` ORDER BY `manuf` 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 ('281491','286418','286419','286420','286421','286422','143923','153783','153936','157739','160830','160860','161962','162647','167511','170204','170375','232608','240531','243685','243967','244097','245698','246080','246762','246774','248570','249899','250838','251847','253754','253850','256580','266796','269051','277704','281490','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281679','291623','292473','294701','295409','295598','297254','163822','164555','166656','168318','243209','250270','261740','265109','266448','268785','274865','278111','279091','279092','281576','281577','281578','281579','281580','292042','293270','143050','143133','143205','143507','146592','151403','151530','151626','154900','157532','157533','157534','157535','157638','158656','159856','160212','160396','160569','160771','160772','160773','160783','163700','163714','163959','164211','165107','165158','165819','166752','169215','170101','170725','232644','238682','238820','239494','243393','245382','245510','245614','246836','247463','247639','247751','248372','248601','249625','250014','252234','253066','253421','253430','255627','256019','257031','262117','262183','262254','263033','263045','263721','264514','265146','265631','267573','267770','268001','268002','268045','268815','269072','273545','274431','275300','278401','279668','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281599','282821','285792','288691','289461','292364','293453','294190','294295','298183','298396','299190','299983','300934','302156','146589','153503','157759','158854','160710','161460','161516','162783','163605','163964','164059','164495','167258','167259','167448','201148','215377','215626','215832','238481','240667','240937','240957','241755','241988','242219','242558','243166','243945','244141','244148','244208','244289','244598','245358','245359','245583','246779','247378','248445','248865','248970','251011','251012','251682','253060','253437','255281','255282','257224','262940','265159','265787','265950','267284','267702','269097','274946','275017','275316','275364','276015','279089','279090','281147','281152','283583','285195','285825','285826','299762','299763','162155','162921','164401','165631','165632','166917','202650','215771','241157','244329','248899','249233','250870','251302','251431','254206','262974','265107','265513','279280','280502','281571','281572','281573','281574','281575','283572','286107','286108','286109','286111','288154','294980','294983','294984','295805','302296','302305') 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 ('143050','143133','143205','143507','143923','146589','146592','151403','151530','151626','153503','153783','153936','154900','157532','157533','157534','157535','157638','157739','157759','158656','158854','159856','160212','160396','160569','160710','160771','160772','160773','160783','160830','160860','161460','161516','161962','162155','162647','162783','162921','163605','163700','163714','163822','163959','163964','164059','164211','164401','164495','164555','165107','165158','165631','165632','165819','166656','166752','166917','167258','167259','167511','168318','169215','170101','170204','170375','170725','201148','202650','215377','215626','215771','215832','232608','232644','238481','238682','238820','239494','240531','240667','240937','240957','241157','241755','241988','242219','242558','243166','243209','243393','243685','243945','243967','244097','244148','244208','244289','244329','244598','245358','245359','245382','245510','245583','245614','245698','246080','246762','246774','246779','246836','247378','247463','247639','247751','248372','248445','248570','248601','248865','248899','248970','249233','249625','249899','250014','250270','250838','250870','251011','251012','251302','251431','251682','251847','252234','253060','253066','253421','253430','253437','253754','253850','254206','255281','255282','255627','256019','256580','257031','257224','261740','262117','262183','262254','262974','263033','263045','263721','264514','265107','265109','265146','265159','265513','265631','265787','265950','266448','266796','267284','267573','267702','267770','268001','268002','268045','268785','268815','269051','269072','269097','273545','274431','274865','274946','275017','275300','275316','275364','276015','277704','278111','278401','279089','279090','279091','279092','279280','279668','280502','281147','281152','281490','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281571','281572','281573','281574','281575','281576','281577','281578','281579','281580','281599','281679','282821','283572','283583','285195','285792','285825','285826','286107','286108','286109','286111','288154','288691','289461','291623','292042','292364','292473','293270','293453','294190','294295','294701','294980','294983','294984','295409','295598','295805','297254','298183','298396','299190','299762','299763','299983','300934','302296','302305') GROUP BY `tip` ORDER BY `tip` ASC

SELECT `resolution`,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 `resolution` !='' AND `modx_site_content`.`id` IN ('281491','286418','286419','286420','286421','286422','143923','153783','153936','157739','160830','160860','161962','162647','167511','170204','170375','232608','240531','243685','243967','244097','245698','246080','246762','246774','248570','249899','250838','251847','253754','253850','256580','266796','269051','277704','281490','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281679','291623','292473','294701','295409','295598','297254','163822','164555','166656','168318','243209','250270','261740','265109','266448','268785','274865','278111','279091','279092','281576','281577','281578','281579','281580','292042','293270','143050','143133','143205','143507','146592','151403','151530','151626','154900','157532','157533','157534','157535','157638','158656','159856','160212','160396','160569','160771','160772','160773','160783','163700','163714','163959','164211','165107','165158','165819','166752','169215','170101','170725','232644','238682','238820','239494','243393','245382','245510','245614','246836','247463','247639','247751','248372','248601','249625','250014','252234','253066','253421','253430','255627','256019','257031','262117','262183','262254','263033','263045','263721','264514','265146','265631','267573','267770','268001','268002','268045','268815','269072','273545','274431','275300','278401','279668','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281599','282821','285792','288691','289461','292364','293453','294190','294295','298183','298396','299190','299983','300934','302156','146589','153503','157759','158854','160710','161460','161516','162783','163605','163964','164059','164495','167258','167259','167448','201148','215377','215626','215832','238481','240667','240937','240957','241755','241988','242219','242558','243166','243945','244141','244148','244208','244289','244598','245358','245359','245583','246779','247378','248445','248865','248970','251011','251012','251682','253060','253437','255281','255282','257224','262940','265159','265787','265950','267284','267702','269097','274946','275017','275316','275364','276015','279089','279090','281147','281152','283583','285195','285825','285826','299762','299763','162155','162921','164401','165631','165632','166917','202650','215771','241157','244329','248899','249233','250870','251302','251431','254206','262974','265107','265513','279280','280502','281571','281572','281573','281574','281575','283572','286107','286108','286109','286111','288154','294980','294983','294984','295805','302296','302305') GROUP BY `resolution` ORDER BY `resolution` ASC

SELECT `resolution`,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 `resolution` !='' AND `modx_site_content`.`id` IN ('143050','143133','143205','143507','143923','146589','146592','151403','151530','151626','153503','153783','153936','154900','157532','157533','157534','157535','157638','157739','157759','158656','158854','159856','160212','160396','160569','160710','160771','160772','160773','160783','160830','160860','161460','161516','161962','162155','162647','162783','162921','163605','163700','163714','163822','163959','163964','164059','164211','164401','164495','164555','165107','165158','165631','165632','165819','166656','166752','166917','167258','167259','167511','168318','169215','170101','170204','170375','170725','201148','202650','215377','215626','215771','215832','232608','232644','238481','238682','238820','239494','240531','240667','240937','240957','241157','241755','241988','242219','242558','243166','243209','243393','243685','243945','243967','244097','244148','244208','244289','244329','244598','245358','245359','245382','245510','245583','245614','245698','246080','246762','246774','246779','246836','247378','247463','247639','247751','248372','248445','248570','248601','248865','248899','248970','249233','249625','249899','250014','250270','250838','250870','251011','251012','251302','251431','251682','251847','252234','253060','253066','253421','253430','253437','253754','253850','254206','255281','255282','255627','256019','256580','257031','257224','261740','262117','262183','262254','262974','263033','263045','263721','264514','265107','265109','265146','265159','265513','265631','265787','265950','266448','266796','267284','267573','267702','267770','268001','268002','268045','268785','268815','269051','269072','269097','273545','274431','274865','274946','275017','275300','275316','275364','276015','277704','278111','278401','279089','279090','279091','279092','279280','279668','280502','281147','281152','281490','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281571','281572','281573','281574','281575','281576','281577','281578','281579','281580','281599','281679','282821','283572','283583','285195','285792','285825','285826','286107','286108','286109','286111','288154','288691','289461','291623','292042','292364','292473','293270','293453','294190','294295','294701','294980','294983','294984','295409','295598','295805','297254','298183','298396','299190','299762','299763','299983','300934','302296','302305') GROUP BY `resolution` ORDER BY `resolution` 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 ('281491','286418','286419','286420','286421','286422','143923','153783','153936','157739','160830','160860','161962','162647','167511','170204','170375','232608','240531','243685','243967','244097','245698','246080','246762','246774','248570','249899','250838','251847','253754','253850','256580','266796','269051','277704','281490','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281679','291623','292473','294701','295409','295598','297254','163822','164555','166656','168318','243209','250270','261740','265109','266448','268785','274865','278111','279091','279092','281576','281577','281578','281579','281580','292042','293270','143050','143133','143205','143507','146592','151403','151530','151626','154900','157532','157533','157534','157535','157638','158656','159856','160212','160396','160569','160771','160772','160773','160783','163700','163714','163959','164211','165107','165158','165819','166752','169215','170101','170725','232644','238682','238820','239494','243393','245382','245510','245614','246836','247463','247639','247751','248372','248601','249625','250014','252234','253066','253421','253430','255627','256019','257031','262117','262183','262254','263033','263045','263721','264514','265146','265631','267573','267770','268001','268002','268045','268815','269072','273545','274431','275300','278401','279668','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281599','282821','285792','288691','289461','292364','293453','294190','294295','298183','298396','299190','299983','300934','302156','146589','153503','157759','158854','160710','161460','161516','162783','163605','163964','164059','164495','167258','167259','167448','201148','215377','215626','215832','238481','240667','240937','240957','241755','241988','242219','242558','243166','243945','244141','244148','244208','244289','244598','245358','245359','245583','246779','247378','248445','248865','248970','251011','251012','251682','253060','253437','255281','255282','257224','262940','265159','265787','265950','267284','267702','269097','274946','275017','275316','275364','276015','279089','279090','281147','281152','283583','285195','285825','285826','299762','299763','162155','162921','164401','165631','165632','166917','202650','215771','241157','244329','248899','249233','250870','251302','251431','254206','262974','265107','265513','279280','280502','281571','281572','281573','281574','281575','283572','286107','286108','286109','286111','288154','294980','294983','294984','295805','302296','302305') 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 ('143050','143133','143205','143507','143923','146589','146592','151403','151530','151626','153503','153783','153936','154900','157532','157533','157534','157535','157638','157739','157759','158656','158854','159856','160212','160396','160569','160710','160771','160772','160773','160783','160830','160860','161460','161516','161962','162155','162647','162783','162921','163605','163700','163714','163822','163959','163964','164059','164211','164401','164495','164555','165107','165158','165631','165632','165819','166656','166752','166917','167258','167259','167511','168318','169215','170101','170204','170375','170725','201148','202650','215377','215626','215771','215832','232608','232644','238481','238682','238820','239494','240531','240667','240937','240957','241157','241755','241988','242219','242558','243166','243209','243393','243685','243945','243967','244097','244148','244208','244289','244329','244598','245358','245359','245382','245510','245583','245614','245698','246080','246762','246774','246779','246836','247378','247463','247639','247751','248372','248445','248570','248601','248865','248899','248970','249233','249625','249899','250014','250270','250838','250870','251011','251012','251302','251431','251682','251847','252234','253060','253066','253421','253430','253437','253754','253850','254206','255281','255282','255627','256019','256580','257031','257224','261740','262117','262183','262254','262974','263033','263045','263721','264514','265107','265109','265146','265159','265513','265631','265787','265950','266448','266796','267284','267573','267702','267770','268001','268002','268045','268785','268815','269051','269072','269097','273545','274431','274865','274946','275017','275300','275316','275364','276015','277704','278111','278401','279089','279090','279091','279092','279280','279668','280502','281147','281152','281490','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281571','281572','281573','281574','281575','281576','281577','281578','281579','281580','281599','281679','282821','283572','283583','285195','285792','285825','285826','286107','286108','286109','286111','288154','288691','289461','291623','292042','292364','292473','293270','293453','294190','294295','294701','294980','294983','294984','295409','295598','295805','297254','298183','298396','299190','299762','299763','299983','300934','302296','302305') GROUP BY `color` ORDER BY `color` ASC

SELECT `backlight_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 `backlight_color` !='' AND `modx_site_content`.`id` IN ('281491','286418','286419','286420','286421','286422','143923','153783','153936','157739','160830','160860','161962','162647','167511','170204','170375','232608','240531','243685','243967','244097','245698','246080','246762','246774','248570','249899','250838','251847','253754','253850','256580','266796','269051','277704','281490','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281679','291623','292473','294701','295409','295598','297254','163822','164555','166656','168318','243209','250270','261740','265109','266448','268785','274865','278111','279091','279092','281576','281577','281578','281579','281580','292042','293270','143050','143133','143205','143507','146592','151403','151530','151626','154900','157532','157533','157534','157535','157638','158656','159856','160212','160396','160569','160771','160772','160773','160783','163700','163714','163959','164211','165107','165158','165819','166752','169215','170101','170725','232644','238682','238820','239494','243393','245382','245510','245614','246836','247463','247639','247751','248372','248601','249625','250014','252234','253066','253421','253430','255627','256019','257031','262117','262183','262254','263033','263045','263721','264514','265146','265631','267573','267770','268001','268002','268045','268815','269072','273545','274431','275300','278401','279668','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281599','282821','285792','288691','289461','292364','293453','294190','294295','298183','298396','299190','299983','300934','302156','146589','153503','157759','158854','160710','161460','161516','162783','163605','163964','164059','164495','167258','167259','167448','201148','215377','215626','215832','238481','240667','240937','240957','241755','241988','242219','242558','243166','243945','244141','244148','244208','244289','244598','245358','245359','245583','246779','247378','248445','248865','248970','251011','251012','251682','253060','253437','255281','255282','257224','262940','265159','265787','265950','267284','267702','269097','274946','275017','275316','275364','276015','279089','279090','281147','281152','283583','285195','285825','285826','299762','299763','162155','162921','164401','165631','165632','166917','202650','215771','241157','244329','248899','249233','250870','251302','251431','254206','262974','265107','265513','279280','280502','281571','281572','281573','281574','281575','283572','286107','286108','286109','286111','288154','294980','294983','294984','295805','302296','302305') GROUP BY `backlight_color` ORDER BY `backlight_color` ASC

SELECT `backlight_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 `backlight_color` !='' AND `modx_site_content`.`id` IN ('143050','143133','143205','143507','143923','146589','146592','151403','151530','151626','153503','153783','153936','154900','157532','157533','157534','157535','157638','157739','157759','158656','158854','159856','160212','160396','160569','160710','160771','160772','160773','160783','160830','160860','161460','161516','161962','162155','162647','162783','162921','163605','163700','163714','163822','163959','163964','164059','164211','164401','164495','164555','165107','165158','165631','165632','165819','166656','166752','166917','167258','167259','167511','168318','169215','170101','170204','170375','170725','201148','202650','215377','215626','215771','215832','232608','232644','238481','238682','238820','239494','240531','240667','240937','240957','241157','241755','241988','242219','242558','243166','243209','243393','243685','243945','243967','244097','244148','244208','244289','244329','244598','245358','245359','245382','245510','245583','245614','245698','246080','246762','246774','246779','246836','247378','247463','247639','247751','248372','248445','248570','248601','248865','248899','248970','249233','249625','249899','250014','250270','250838','250870','251011','251012','251302','251431','251682','251847','252234','253060','253066','253421','253430','253437','253754','253850','254206','255281','255282','255627','256019','256580','257031','257224','261740','262117','262183','262254','262974','263033','263045','263721','264514','265107','265109','265146','265159','265513','265631','265787','265950','266448','266796','267284','267573','267702','267770','268001','268002','268045','268785','268815','269051','269072','269097','273545','274431','274865','274946','275017','275300','275316','275364','276015','277704','278111','278401','279089','279090','279091','279092','279280','279668','280502','281147','281152','281490','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281571','281572','281573','281574','281575','281576','281577','281578','281579','281580','281599','281679','282821','283572','283583','285195','285792','285825','285826','286107','286108','286109','286111','288154','288691','289461','291623','292042','292364','292473','293270','293453','294190','294295','294701','294980','294983','294984','295409','295598','295805','297254','298183','298396','299190','299762','299763','299983','300934','302296','302305') GROUP BY `backlight_color` ORDER BY `backlight_color` ASC

SELECT `view_mode`,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 `view_mode` !='' AND `modx_site_content`.`id` IN ('281491','286418','286419','286420','286421','286422','143923','153783','153936','157739','160830','160860','161962','162647','167511','170204','170375','232608','240531','243685','243967','244097','245698','246080','246762','246774','248570','249899','250838','251847','253754','253850','256580','266796','269051','277704','281490','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281679','291623','292473','294701','295409','295598','297254','163822','164555','166656','168318','243209','250270','261740','265109','266448','268785','274865','278111','279091','279092','281576','281577','281578','281579','281580','292042','293270','143050','143133','143205','143507','146592','151403','151530','151626','154900','157532','157533','157534','157535','157638','158656','159856','160212','160396','160569','160771','160772','160773','160783','163700','163714','163959','164211','165107','165158','165819','166752','169215','170101','170725','232644','238682','238820','239494','243393','245382','245510','245614','246836','247463','247639','247751','248372','248601','249625','250014','252234','253066','253421','253430','255627','256019','257031','262117','262183','262254','263033','263045','263721','264514','265146','265631','267573','267770','268001','268002','268045','268815','269072','273545','274431','275300','278401','279668','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281599','282821','285792','288691','289461','292364','293453','294190','294295','298183','298396','299190','299983','300934','302156','146589','153503','157759','158854','160710','161460','161516','162783','163605','163964','164059','164495','167258','167259','167448','201148','215377','215626','215832','238481','240667','240937','240957','241755','241988','242219','242558','243166','243945','244141','244148','244208','244289','244598','245358','245359','245583','246779','247378','248445','248865','248970','251011','251012','251682','253060','253437','255281','255282','257224','262940','265159','265787','265950','267284','267702','269097','274946','275017','275316','275364','276015','279089','279090','281147','281152','283583','285195','285825','285826','299762','299763','162155','162921','164401','165631','165632','166917','202650','215771','241157','244329','248899','249233','250870','251302','251431','254206','262974','265107','265513','279280','280502','281571','281572','281573','281574','281575','283572','286107','286108','286109','286111','288154','294980','294983','294984','295805','302296','302305') GROUP BY `view_mode` ORDER BY `view_mode` ASC

SELECT `view_mode`,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 `view_mode` !='' AND `modx_site_content`.`id` IN ('143050','143133','143205','143507','143923','146589','146592','151403','151530','151626','153503','153783','153936','154900','157532','157533','157534','157535','157638','157739','157759','158656','158854','159856','160212','160396','160569','160710','160771','160772','160773','160783','160830','160860','161460','161516','161962','162155','162647','162783','162921','163605','163700','163714','163822','163959','163964','164059','164211','164401','164495','164555','165107','165158','165631','165632','165819','166656','166752','166917','167258','167259','167511','168318','169215','170101','170204','170375','170725','201148','202650','215377','215626','215771','215832','232608','232644','238481','238682','238820','239494','240531','240667','240937','240957','241157','241755','241988','242219','242558','243166','243209','243393','243685','243945','243967','244097','244148','244208','244289','244329','244598','245358','245359','245382','245510','245583','245614','245698','246080','246762','246774','246779','246836','247378','247463','247639','247751','248372','248445','248570','248601','248865','248899','248970','249233','249625','249899','250014','250270','250838','250870','251011','251012','251302','251431','251682','251847','252234','253060','253066','253421','253430','253437','253754','253850','254206','255281','255282','255627','256019','256580','257031','257224','261740','262117','262183','262254','262974','263033','263045','263721','264514','265107','265109','265146','265159','265513','265631','265787','265950','266448','266796','267284','267573','267702','267770','268001','268002','268045','268785','268815','269051','269072','269097','273545','274431','274865','274946','275017','275300','275316','275364','276015','277704','278111','278401','279089','279090','279091','279092','279280','279668','280502','281147','281152','281490','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281571','281572','281573','281574','281575','281576','281577','281578','281579','281580','281599','281679','282821','283572','283583','285195','285792','285825','285826','286107','286108','286109','286111','288154','288691','289461','291623','292042','292364','292473','293270','293453','294190','294295','294701','294980','294983','294984','295409','295598','295805','297254','298183','298396','299190','299762','299763','299983','300934','302296','302305') GROUP BY `view_mode` ORDER BY `view_mode` ASC

SELECT `view_method`,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 `view_method` !='' AND `modx_site_content`.`id` IN ('281491','286418','286419','286420','286421','286422','143923','153783','153936','157739','160830','160860','161962','162647','167511','170204','170375','232608','240531','243685','243967','244097','245698','246080','246762','246774','248570','249899','250838','251847','253754','253850','256580','266796','269051','277704','281490','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281679','291623','292473','294701','295409','295598','297254','163822','164555','166656','168318','243209','250270','261740','265109','266448','268785','274865','278111','279091','279092','281576','281577','281578','281579','281580','292042','293270','143050','143133','143205','143507','146592','151403','151530','151626','154900','157532','157533','157534','157535','157638','158656','159856','160212','160396','160569','160771','160772','160773','160783','163700','163714','163959','164211','165107','165158','165819','166752','169215','170101','170725','232644','238682','238820','239494','243393','245382','245510','245614','246836','247463','247639','247751','248372','248601','249625','250014','252234','253066','253421','253430','255627','256019','257031','262117','262183','262254','263033','263045','263721','264514','265146','265631','267573','267770','268001','268002','268045','268815','269072','273545','274431','275300','278401','279668','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281599','282821','285792','288691','289461','292364','293453','294190','294295','298183','298396','299190','299983','300934','302156','146589','153503','157759','158854','160710','161460','161516','162783','163605','163964','164059','164495','167258','167259','167448','201148','215377','215626','215832','238481','240667','240937','240957','241755','241988','242219','242558','243166','243945','244141','244148','244208','244289','244598','245358','245359','245583','246779','247378','248445','248865','248970','251011','251012','251682','253060','253437','255281','255282','257224','262940','265159','265787','265950','267284','267702','269097','274946','275017','275316','275364','276015','279089','279090','281147','281152','283583','285195','285825','285826','299762','299763','162155','162921','164401','165631','165632','166917','202650','215771','241157','244329','248899','249233','250870','251302','251431','254206','262974','265107','265513','279280','280502','281571','281572','281573','281574','281575','283572','286107','286108','286109','286111','288154','294980','294983','294984','295805','302296','302305') GROUP BY `view_method` ORDER BY `view_method` ASC

SELECT `view_method`,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 `view_method` !='' AND `modx_site_content`.`id` IN ('143050','143133','143205','143507','143923','146589','146592','151403','151530','151626','153503','153783','153936','154900','157532','157533','157534','157535','157638','157739','157759','158656','158854','159856','160212','160396','160569','160710','160771','160772','160773','160783','160830','160860','161460','161516','161962','162155','162647','162783','162921','163605','163700','163714','163822','163959','163964','164059','164211','164401','164495','164555','165107','165158','165631','165632','165819','166656','166752','166917','167258','167259','167511','168318','169215','170101','170204','170375','170725','201148','202650','215377','215626','215771','215832','232608','232644','238481','238682','238820','239494','240531','240667','240937','240957','241157','241755','241988','242219','242558','243166','243209','243393','243685','243945','243967','244097','244148','244208','244289','244329','244598','245358','245359','245382','245510','245583','245614','245698','246080','246762','246774','246779','246836','247378','247463','247639','247751','248372','248445','248570','248601','248865','248899','248970','249233','249625','249899','250014','250270','250838','250870','251011','251012','251302','251431','251682','251847','252234','253060','253066','253421','253430','253437','253754','253850','254206','255281','255282','255627','256019','256580','257031','257224','261740','262117','262183','262254','262974','263033','263045','263721','264514','265107','265109','265146','265159','265513','265631','265787','265950','266448','266796','267284','267573','267702','267770','268001','268002','268045','268785','268815','269051','269072','269097','273545','274431','274865','274946','275017','275300','275316','275364','276015','277704','278111','278401','279089','279090','279091','279092','279280','279668','280502','281147','281152','281490','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281571','281572','281573','281574','281575','281576','281577','281578','281579','281580','281599','281679','282821','283572','283583','285195','285792','285825','285826','286107','286108','286109','286111','288154','288691','289461','291623','292042','292364','292473','293270','293453','294190','294295','294701','294980','294983','294984','295409','295598','295805','297254','298183','298396','299190','299762','299763','299983','300934','302296','302305') GROUP BY `view_method` ORDER BY `view_method` ASC