Сегментные индикаторы

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 ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169091','169092','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169339','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169679','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238823','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264380','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') 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 ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') GROUP BY `manuf` ORDER BY `manuf` ASC

SELECT `vid`,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 `vid` !='' AND `modx_site_content`.`id` IN ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169091','169092','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169339','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169679','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238823','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264380','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') GROUP BY `vid` ORDER BY `vid` ASC

SELECT `vid`,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 `vid` !='' AND `modx_site_content`.`id` IN ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') GROUP BY `vid` ORDER BY `vid` ASC

SELECT `digits`,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 `digits` !='' AND `modx_site_content`.`id` IN ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169091','169092','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169339','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169679','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238823','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264380','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') GROUP BY `digits` ORDER BY `digits` ASC

SELECT `digits`,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 `digits` !='' AND `modx_site_content`.`id` IN ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') GROUP BY `digits` ORDER BY `digits` 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 ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169091','169092','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169339','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169679','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238823','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264380','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') 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 ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') GROUP BY `color` ORDER BY `color` ASC

SELECT `shema_upr`,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 `shema_upr` !='' AND `modx_site_content`.`id` IN ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169091','169092','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169339','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169679','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238823','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264380','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') GROUP BY `shema_upr` ORDER BY `shema_upr` ASC

SELECT `shema_upr`,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 `shema_upr` !='' AND `modx_site_content`.`id` IN ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') GROUP BY `shema_upr` ORDER BY `shema_upr` ASC

SELECT `gabarity`,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 `gabarity` !='' AND `modx_site_content`.`id` IN ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169091','169092','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169339','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169679','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238823','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264380','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') GROUP BY `gabarity` ORDER BY `gabarity` ASC

SELECT `gabarity`,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 `gabarity` !='' AND `modx_site_content`.`id` IN ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') GROUP BY `gabarity` ORDER BY `gabarity` ASC

SELECT `digit_height`,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 `digit_height` !='' AND `modx_site_content`.`id` IN ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169091','169092','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169339','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169679','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238823','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264380','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') GROUP BY `digit_height` ORDER BY `digit_height` ASC

SELECT `digit_height`,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 `digit_height` !='' AND `modx_site_content`.`id` IN ('141323','141324','141342','141346','141347','141348','141349','141350','141419','141420','141421','141422','141462','141463','141498','141499','141522','141572','141573','141574','141575','141599','141600','141601','141665','141666','141667','141745','141746','141747','141762','141763','141764','142091','142092','142112','142113','142114','142127','142136','142167','142217','142646','142647','142648','142649','142650','142651','142652','142653','142654','142655','142656','142657','142658','142659','142660','142661','142662','142663','142664','142665','142670','142671','142672','142673','142674','142675','142676','142677','142678','142679','142680','142681','142682','142683','142684','142685','142686','142687','142703','142728','142751','142758','142759','142760','142887','142895','143269','143361','143579','143673','144967','146488','146566','146578','148362','148602','148740','149122','149616','149712','150611','151333','151405','151615','151963','151964','152514','152641','153138','153337','153562','153563','153570','153572','153573','153574','153601','153628','153655','153885','153886','153887','153889','154163','154253','154319','154457','154458','154459','154635','154694','154695','154696','154697','154698','154699','154703','154704','154707','154708','154739','154769','154798','154805','154806','154827','154828','154830','155264','155522','155523','155661','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','155919','155920','155921','155922','155923','157544','157624','157627','157796','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158171','158175','158379','158575','158585','158805','159207','159575','159649','159650','159651','160111','160205','160206','160207','160245','161183','161370','162650','163282','163519','163778','164295','164397','164398','164971','165047','165173','165300','165421','165422','165599','166910','166913','166915','167198','167440','169096','169097','169098','169099','169100','169101','169102','169103','169104','169105','169107','169148','169149','169150','169191','169192','169204','169221','169222','169274','169288','169334','169340','169597','169598','169599','169600','169601','169602','169603','169604','169605','169606','169607','169608','169609','169610','169611','169612','169613','169614','169615','169616','169617','169618','169619','169620','169621','169622','169623','169624','169625','169626','169627','169628','169629','169630','169631','169632','169633','169634','169635','169636','169637','169638','169639','169640','169641','169642','169643','169644','169645','169646','169647','169648','169649','169650','169651','169652','169653','169654','169655','169656','169657','169658','169659','169660','169661','169662','169663','169664','169665','169666','169667','169668','169669','169670','169671','169672','169674','169676','169677','169678','169680','169681','169682','169683','169684','169685','169686','169687','169688','169689','169690','169691','169692','169693','169694','169695','169696','169697','169698','169699','169700','169701','169702','169703','169704','169705','169706','169707','169708','169709','169710','169711','169712','169713','169714','169715','169716','169717','169718','169719','169720','169721','169722','169723','169724','169725','169726','169727','169728','169729','169736','169737','169738','169739','169753','169768','169786','169800','169815','169816','169823','169829','169830','169870','170069','170142','170143','170144','170145','170402','170403','170411','170647','200019','202771','202772','215280','215385','215423','215774','215775','215861','215889','216000','232437','232729','238052','238687','238848','238849','238850','239014','239097','239098','239344','239376','239557','239958','241341','241918','241924','242910','243111','243350','243561','243593','243667','245148','245723','245866','246347','247692','247773','247774','247869','247881','247912','248054','248559','248600','248934','248969','249518','249523','249839','250056','250141','250142','250623','251131','251215','251380','251994','253250','253743','254360','255297','255406','255707','255764','257103','257186','261990','262759','264696','265362','265419','266094','266163','266164','266165','266166','266167','266168','266972','267411','267482','268082','268354','269423','269590','274708','274775','274779','274927','275352','275830','276107','276782','277317','277318','277319','277320','277857','278690','280600','280853','280923','281263','282276','282365','282422','282506','283518','284183','285060','285256','285273','285508','286157','286266','286605','287779','288006','292512','294559','294655','294656','294871','295771','297136','297279','297875','299634','299687','300201','300614','300939','302106','302142','302143','302153') GROUP BY `digit_height` ORDER BY `digit_height` ASC