Клеммы, стр. 20

SELECT `parent`,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 `parent` !='' AND `modx_site_content`.`id` IN ('19','74','77','168','169','188','268','160219','240253','240314','240362','240666','242919','243149','243150','243739','244859','246151','246704','246705','247044','251221','252205','253071','254457','256751','256839','256928','256929','262607','263661','264367','265233','267444','275203','292787','293987','297523','300024','300030','300391','300550','302147','157782','160144','160468','164391','164392','166860','167425','168367','239148','239401','241287','241305','243961','244116','244371','245552','247448','251056','251060','255389','255390','262944','267700','153657','153658','155518','155519','158443','158930','158931','160112','160629','160630','161893','161894','163458','164172','164970','167660','167661','167662','239441','243151','243152','244623','245515','246275','248112','250999','251228','253160','253729','253730','264377','264417','265760','267638','267640','267641','268251','268252','273601','275320','276491','278234','278235','279282','280863','285115','285155','285156','302339','164386','167127','247445','247454','283636','153096','153639','153758','154168','154653','155012','155431','155453','156643','156790','156791','156792','156793','156794','157754','157761','157762','157763','157798','157803','157804','158512','158741','158744','158835','158844','158845','158846','158856','159342','159343','159347','159348','159349','159350','159351','159352','159353','159354','159355','159356','159357','160349','160413','162276','162422','162486','163841','164104','164167','164390','164433','164522','164527','164594','164633','164758','164759','164760','164761','164762','164763','165162','165524','165563','165672','165673','165697','165728','165729','165916','165950','166036','166134','166150','166484','166911','166990','167136','167173','167419','167462','167612','167613','168106','238861','238995','240328','240928','240929','241399','241899','242240','242251','242885','243088','243293','243595','243749','243750','244722','244809','244810','244811','246185','246657','247070','247120','247121','247122','247123','247124','247125','247126','247127','247128','247129','247130','247131','247132','247133','247134','247449','247497','247566','247630','248048','248089','248438','248443','248855','248875','249092','249131','249132','249157','249158','249159','249160','249305','249397','249532','249632','249633','249707','249744','249761','250522','250888','251052','251053','251054','251055','251057','251058','251059','251061','251062','251160','251240','251258','251287','251623','251852','254392','254602','254942','255124','255358','255368','255687','255698','255780','256131','256132','256695','256753','256835','257085','261989','262106','262780','262929','262948','262965','262966','262967','262968','262969','262970','262971','262972','264694','264695','264736','265058','265156','265167','265390','265430','265590','265591','265599','265705','266011','266302','266303','266304','266594','266691','266823','267123','267148','267263','267418','267514','267896','268162','268478','268479','268713','268846','268850','268868','268884','269042','269495','273622','273837','273981','274011','274691','274747','274853','274894','274906','274942','275065','276122','276498','276572','276995','276996','276997','276998','277907','278064','278355','278886','279027','280615','280802','280823','280872','280922','281256','281258','281414','281484','281693','281716','282006','282145','282331','282436','282437','282560','282817','282985','283181','283182','283183','283219','283226','283227','283228','283735','283775','284139','284154','284534','284535','284586','284594','284947','285193','285509','285510','285641','285642','285645','285983','286059','286186','286370','286399','286796','286812','287792','287972','288142','288346','288422','288471','288473','289501','291974','291986','291987','291988','292357','292565','292808','292815','293212','294552','294834','294890','295624','296202','296204','296283','297281','297282','297452','297785','297862','297902','297968','298096','298243','298592','299636','299694','300230','301005','301978','153514','153515','154514','156789','157795','157799','157806','157808','158740','158947','159344','159345','159346','159500','159638','159661','160572','160713','160962','161275','161478','161479','161943','162294','162786','162942','163518','164706','164756','164757','165163','165635','166401','168209','239267','239271','239298','240322','240635','240769','241413','241877','242137','243425','244708','245208','247069','247491','247693','248008','248444','248538','249135','249326','249327','249685','249686','249687','249688','249710','250585','251260','251573','251752','253018','253072','253073','253375','254830','255604','255637','255695','256752','256944','257042','262241','262864','263201','263751','264661','264957','264958','266463','266738','266767','267597','267932','267933','268206','268826','269018','274014','274332','274442','274840','274940','275027','275125','276389','276393','276446','277369','277382','277974','278017','278050','278051','278905','278906','278907','278908','278909','278910','279023','279102','279272','279478','280827','280852','281029','282895','284274','284745','284830','284845','284919','285259','285288','285305','287981','289447','291744','292033','292564','294661','294824','294828','294849','295623','295739','298083','298084','298097','298098','298216','300561','301839','301840','301841','304021','156636','156637','156638','156639','156640','156641','156642','157758','166432','168097','168098','244362','244363','244364','247068','249558','251189','254959','254960','254961','254962','265283','265284','267363','267364','267365','276260','279258','279403','287386','292639','292640','297353','297356','297361','297362','298575','298576','299939','242453','264743','265440','267890','274333','274334','274918','276433','276586','278232','280352','280353','280354','280355','280356','280611','280612','282490','285065') GROUP BY `parent` ORDER BY `parent` ASC

SELECT `parent`,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 `parent` !='' AND `modx_site_content`.`id` IN ('153096','153514','153515','153639','153657','153658','153758','154168','154514','154653','155012','155431','155453','155518','155519','156636','156637','156638','156639','156640','156641','156642','156643','156789','156790','156791','156792','156793','156794','157754','157758','157761','157762','157763','157782','157795','157798','157799','157803','157804','157806','157808','158443','158512','158740','158741','158744','158835','158844','158845','158846','158856','158930','158931','158947','159342','159343','159344','159345','159346','159347','159348','159349','159350','159351','159352','159353','159354','159355','159356','159357','159500','159638','159661','160112','160144','160219','160349','160413','160468','160572','160629','160630','160713','160962','161275','161478','161479','161893','161894','161943','162276','162294','162422','162486','162786','162942','163458','163518','163841','164104','164167','164172','164386','164390','164391','164392','164433','164522','164527','164594','164633','164706','164756','164757','164758','164759','164760','164761','164762','164763','164970','165162','165163','165524','165563','165635','165672','165673','165697','165728','165729','165916','165950','166036','166134','166150','166401','166432','166484','166860','166911','166990','167127','167136','167173','167419','167425','167462','167612','167613','167660','167661','167662','168097','168098','168106','168209','168367','238861','238995','239148','239267','239271','239298','239401','239441','240253','240314','240322','240328','240362','240635','240666','240769','240928','240929','241287','241305','241399','241413','241877','241899','242137','242240','242251','242453','242885','242919','243088','243149','243150','243151','243152','243293','243425','243595','243739','243749','243750','243961','244116','244362','244363','244364','244371','244623','244708','244722','244809','244810','244811','244859','245208','245515','245552','246151','246185','246275','246657','246704','246705','247044','247068','247069','247070','247120','247121','247122','247123','247124','247125','247126','247127','247128','247129','247130','247131','247132','247133','247134','247445','247448','247449','247454','247491','247497','247566','247630','247693','248008','248048','248089','248112','248438','248443','248444','248538','248855','248875','249092','249131','249132','249135','249157','249158','249159','249160','249305','249326','249327','249397','249532','249558','249632','249633','249685','249686','249687','249688','249707','249710','249744','249761','250522','250585','250888','250999','251052','251053','251054','251055','251056','251057','251058','251059','251060','251061','251062','251160','251189','251221','251228','251240','251258','251260','251287','251573','251623','251752','251852','252205','253018','253071','253072','253073','253160','253375','253729','253730','254392','254457','254602','254830','254942','254959','254960','254961','254962','255124','255358','255368','255389','255390','255604','255637','255687','255695','255698','255780','256131','256132','256695','256751','256752','256753','256835','256839','256928','256929','256944','257042','257085','261989','262106','262241','262607','262780','262864','262929','262944','262948','262965','262966','262967','262968','262969','262970','262971','262972','263201','263661','263751','264367','264377','264417','264661','264694','264695','264736','264743','264957','264958','265058','265156','265167','265233','265283','265284','265390','265430','265440','265590','265591','265599','265705','265760','266011','266302','266303','266304','266463','266594','266691','266738','266767','266823','267123','267148','267263','267363','267364','267365','267418','267444','267514','267597','267638','267640','267641','267700','267890','267896','267932','267933','268162','268206','268251','268252','268478','268479','268713','268826','268846','268850','268868','268884','269018','269042','269495','273601','273622','273837','273981','274011','274014','274332','274333','274334','274442','274691','274747','274840','274853','274894','274906','274918','274940','274942','275027','275065','275125','275203','275320','276122','276260','276389','276393','276433','276446','276491','276498','276572','276586','276995','276996','276997','276998','277369','277382','277907','277974','278017','278050','278051','278064','278232','278234','278235','278355','278886','278905','278906','278907','278908','278909','278910','279023','279027','279102','279258','279272','279282','279403','279478','280352','280353','280354','280355','280356','280611','280612','280615','280802','280823','280827','280852','280863','280872','280922','281029','281256','281258','281414','281484','281693','281716','282006','282145','282331','282436','282437','282490','282560','282817','282895','282985','283181','283182','283183','283219','283226','283227','283228','283636','283735','283775','284139','284154','284274','284534','284535','284586','284594','284745','284830','284845','284919','284947','285065','285115','285155','285156','285193','285259','285288','285305','285509','285510','285641','285642','285645','285983','286059','286186','286370','286399','286796','286812','287386','287792','287972','287981','288142','288346','288422','288471','288473','289447','289501','291744','291974','291986','291987','291988','292033','292357','292564','292565','292639','292640','292787','292808','292815','293212','293987','294552','294661','294824','294828','294834','294849','294890','295623','295624','295739','296202','296204','296283','297281','297282','297353','297356','297361','297362','297452','297523','297785','297862','297902','297968','298083','298084','298096','298097','298098','298216','298243','298575','298576','298592','299636','299694','299939','300024','300030','300230','300391','300550','300561','301005','301839','301840','301841','301978','302147','302339','304021') GROUP BY `parent` ORDER BY `parent` 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 ('19','74','77','168','169','188','268','160219','240253','240314','240362','240666','242919','243149','243150','243739','244859','246151','246704','246705','247044','251221','252205','253071','254457','256751','256839','256928','256929','262607','263661','264367','265233','267444','275203','292787','293987','297523','300024','300030','300391','300550','302147','157782','160144','160468','164391','164392','166860','167425','168367','239148','239401','241287','241305','243961','244116','244371','245552','247448','251056','251060','255389','255390','262944','267700','153657','153658','155518','155519','158443','158930','158931','160112','160629','160630','161893','161894','163458','164172','164970','167660','167661','167662','239441','243151','243152','244623','245515','246275','248112','250999','251228','253160','253729','253730','264377','264417','265760','267638','267640','267641','268251','268252','273601','275320','276491','278234','278235','279282','280863','285115','285155','285156','302339','164386','167127','247445','247454','283636','153096','153639','153758','154168','154653','155012','155431','155453','156643','156790','156791','156792','156793','156794','157754','157761','157762','157763','157798','157803','157804','158512','158741','158744','158835','158844','158845','158846','158856','159342','159343','159347','159348','159349','159350','159351','159352','159353','159354','159355','159356','159357','160349','160413','162276','162422','162486','163841','164104','164167','164390','164433','164522','164527','164594','164633','164758','164759','164760','164761','164762','164763','165162','165524','165563','165672','165673','165697','165728','165729','165916','165950','166036','166134','166150','166484','166911','166990','167136','167173','167419','167462','167612','167613','168106','238861','238995','240328','240928','240929','241399','241899','242240','242251','242885','243088','243293','243595','243749','243750','244722','244809','244810','244811','246185','246657','247070','247120','247121','247122','247123','247124','247125','247126','247127','247128','247129','247130','247131','247132','247133','247134','247449','247497','247566','247630','248048','248089','248438','248443','248855','248875','249092','249131','249132','249157','249158','249159','249160','249305','249397','249532','249632','249633','249707','249744','249761','250522','250888','251052','251053','251054','251055','251057','251058','251059','251061','251062','251160','251240','251258','251287','251623','251852','254392','254602','254942','255124','255358','255368','255687','255698','255780','256131','256132','256695','256753','256835','257085','261989','262106','262780','262929','262948','262965','262966','262967','262968','262969','262970','262971','262972','264694','264695','264736','265058','265156','265167','265390','265430','265590','265591','265599','265705','266011','266302','266303','266304','266594','266691','266823','267123','267148','267263','267418','267514','267896','268162','268478','268479','268713','268846','268850','268868','268884','269042','269495','273622','273837','273981','274011','274691','274747','274853','274894','274906','274942','275065','276122','276498','276572','276995','276996','276997','276998','277907','278064','278355','278886','279027','280615','280802','280823','280872','280922','281256','281258','281414','281484','281693','281716','282006','282145','282331','282436','282437','282560','282817','282985','283181','283182','283183','283219','283226','283227','283228','283735','283775','284139','284154','284534','284535','284586','284594','284947','285193','285509','285510','285641','285642','285645','285983','286059','286186','286370','286399','286796','286812','287792','287972','288142','288346','288422','288471','288473','289501','291974','291986','291987','291988','292357','292565','292808','292815','293212','294552','294834','294890','295624','296202','296204','296283','297281','297282','297452','297785','297862','297902','297968','298096','298243','298592','299636','299694','300230','301005','301978','153514','153515','154514','156789','157795','157799','157806','157808','158740','158947','159344','159345','159346','159500','159638','159661','160572','160713','160962','161275','161478','161479','161943','162294','162786','162942','163518','164706','164756','164757','165163','165635','166401','168209','239267','239271','239298','240322','240635','240769','241413','241877','242137','243425','244708','245208','247069','247491','247693','248008','248444','248538','249135','249326','249327','249685','249686','249687','249688','249710','250585','251260','251573','251752','253018','253072','253073','253375','254830','255604','255637','255695','256752','256944','257042','262241','262864','263201','263751','264661','264957','264958','266463','266738','266767','267597','267932','267933','268206','268826','269018','274014','274332','274442','274840','274940','275027','275125','276389','276393','276446','277369','277382','277974','278017','278050','278051','278905','278906','278907','278908','278909','278910','279023','279102','279272','279478','280827','280852','281029','282895','284274','284745','284830','284845','284919','285259','285288','285305','287981','289447','291744','292033','292564','294661','294824','294828','294849','295623','295739','298083','298084','298097','298098','298216','300561','301839','301840','301841','304021','156636','156637','156638','156639','156640','156641','156642','157758','166432','168097','168098','244362','244363','244364','247068','249558','251189','254959','254960','254961','254962','265283','265284','267363','267364','267365','276260','279258','279403','287386','292639','292640','297353','297356','297361','297362','298575','298576','299939','242453','264743','265440','267890','274333','274334','274918','276433','276586','278232','280352','280353','280354','280355','280356','280611','280612','282490','285065') 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 ('153096','153514','153515','153639','153657','153658','153758','154168','154514','154653','155012','155431','155453','155518','155519','156636','156637','156638','156639','156640','156641','156642','156643','156789','156790','156791','156792','156793','156794','157754','157758','157761','157762','157763','157782','157795','157798','157799','157803','157804','157806','157808','158443','158512','158740','158741','158744','158835','158844','158845','158846','158856','158930','158931','158947','159342','159343','159344','159345','159346','159347','159348','159349','159350','159351','159352','159353','159354','159355','159356','159357','159500','159638','159661','160112','160144','160219','160349','160413','160468','160572','160629','160630','160713','160962','161275','161478','161479','161893','161894','161943','162276','162294','162422','162486','162786','162942','163458','163518','163841','164104','164167','164172','164386','164390','164391','164392','164433','164522','164527','164594','164633','164706','164756','164757','164758','164759','164760','164761','164762','164763','164970','165162','165163','165524','165563','165635','165672','165673','165697','165728','165729','165916','165950','166036','166134','166150','166401','166432','166484','166860','166911','166990','167127','167136','167173','167419','167425','167462','167612','167613','167660','167661','167662','168097','168098','168106','168209','168367','238861','238995','239148','239267','239271','239298','239401','239441','240253','240314','240322','240328','240362','240635','240666','240769','240928','240929','241287','241305','241399','241413','241877','241899','242137','242240','242251','242453','242885','242919','243088','243149','243150','243151','243152','243293','243425','243595','243739','243749','243750','243961','244116','244362','244363','244364','244371','244623','244708','244722','244809','244810','244811','244859','245208','245515','245552','246151','246185','246275','246657','246704','246705','247044','247068','247069','247070','247120','247121','247122','247123','247124','247125','247126','247127','247128','247129','247130','247131','247132','247133','247134','247445','247448','247449','247454','247491','247497','247566','247630','247693','248008','248048','248089','248112','248438','248443','248444','248538','248855','248875','249092','249131','249132','249135','249157','249158','249159','249160','249305','249326','249327','249397','249532','249558','249632','249633','249685','249686','249687','249688','249707','249710','249744','249761','250522','250585','250888','250999','251052','251053','251054','251055','251056','251057','251058','251059','251060','251061','251062','251160','251189','251221','251228','251240','251258','251260','251287','251573','251623','251752','251852','252205','253018','253071','253072','253073','253160','253375','253729','253730','254392','254457','254602','254830','254942','254959','254960','254961','254962','255124','255358','255368','255389','255390','255604','255637','255687','255695','255698','255780','256131','256132','256695','256751','256752','256753','256835','256839','256928','256929','256944','257042','257085','261989','262106','262241','262607','262780','262864','262929','262944','262948','262965','262966','262967','262968','262969','262970','262971','262972','263201','263661','263751','264367','264377','264417','264661','264694','264695','264736','264743','264957','264958','265058','265156','265167','265233','265283','265284','265390','265430','265440','265590','265591','265599','265705','265760','266011','266302','266303','266304','266463','266594','266691','266738','266767','266823','267123','267148','267263','267363','267364','267365','267418','267444','267514','267597','267638','267640','267641','267700','267890','267896','267932','267933','268162','268206','268251','268252','268478','268479','268713','268826','268846','268850','268868','268884','269018','269042','269495','273601','273622','273837','273981','274011','274014','274332','274333','274334','274442','274691','274747','274840','274853','274894','274906','274918','274940','274942','275027','275065','275125','275203','275320','276122','276260','276389','276393','276433','276446','276491','276498','276572','276586','276995','276996','276997','276998','277369','277382','277907','277974','278017','278050','278051','278064','278232','278234','278235','278355','278886','278905','278906','278907','278908','278909','278910','279023','279027','279102','279258','279272','279282','279403','279478','280352','280353','280354','280355','280356','280611','280612','280615','280802','280823','280827','280852','280863','280872','280922','281029','281256','281258','281414','281484','281693','281716','282006','282145','282331','282436','282437','282490','282560','282817','282895','282985','283181','283182','283183','283219','283226','283227','283228','283636','283735','283775','284139','284154','284274','284534','284535','284586','284594','284745','284830','284845','284919','284947','285065','285115','285155','285156','285193','285259','285288','285305','285509','285510','285641','285642','285645','285983','286059','286186','286370','286399','286796','286812','287386','287792','287972','287981','288142','288346','288422','288471','288473','289447','289501','291744','291974','291986','291987','291988','292033','292357','292564','292565','292639','292640','292787','292808','292815','293212','293987','294552','294661','294824','294828','294834','294849','294890','295623','295624','295739','296202','296204','296283','297281','297282','297353','297356','297361','297362','297452','297523','297785','297862','297902','297968','298083','298084','298096','298097','298098','298216','298243','298575','298576','298592','299636','299694','299939','300024','300030','300230','300391','300550','300561','301005','301839','301840','301841','301978','302147','302339','304021') GROUP BY `manuf` ORDER BY `manuf` ASC