Разъёмы низковольтные, стр. 3

SELECT `tip`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `tip` !='' AND `modx_site_content`.`id` IN ('141332','141333','141503','141821','141882','141883','141884','141886','142128','142209','142210','142211','142212','142213','142930','142943','143376','143385','143457','143513','143514','143515','143516','143517','143518','143519','143520','143521','143522','143523','143524','143525','143526','143527','143528','143529','143530','143531','143532','143533','143534','143535','143537','143538','143539','143540','143541','143542','143543','143544','143545','143546','143547','143548','143549','143550','143551','143651','143734','143771','143785','143786','143789','143790','143791','143792','143794','143796','143798','143800','143803','143805','143811','143812','143813','143825','143918','144081','144230','146587','147021','147060','147241','147876','148128','148356','148588','148590','148618','148644','148645','148646','148647','148650','148659','148661','149123','149124','149125','149126','149127','149128','149129','149130','149131','149132','149133','149134','149135','149136','149137','149138','149139','149140','149141','149142','149143','149144','149145','149146','149147','149148','149149','149150','149151','149153','149154','149155','149156','149157','149159','149160','149161','149162','149163','149164','149165','149166','149167','149168','149169','149170','149171','149172','149173','149174','149175','149176','149177','149178','149179','149180','149181','149182','149183','149184','149185','149186','149187','149188','149189','149190','149191','149192','149193','149194','149195','149196','149197','149198','149199','149200','149201','149202','149203','149204','149205','149206','149207','149208','149209','149210','149211','149212','149213','149214','149215','149216','149217','149218','149219','149664','149694','150510','150581','150598','150599','150796','150833','151002','151458','151459','151469','151808','151868','151992','152526','152657','152662','153070','153086','153801','153803','154550','154580','154581','154583','154584','154587','154588','154590','154625','154626','154627','154642','154655','154656','154657','154658','154659','154675','154690','154691','154747','154796','154951','155023','155024','155025','155065','155087','155088','155089','155090','155091','155104','155155','155748','156313','156423','156424','156425','156426','156427','156428','156429','156430','156431','156432','156433','156434','156435','156436','156437','156438','156439','156440','156441','156442','156443','156444','156445','156446','156447','156448','156475','156476','156477','156478','156479','156480','156481','156482','156483','156484','156485','156486','156487','156488','156489','156502','156503','156504','156510','157640','157666','157777','158362','158416','158455','158557','158586','158655','158662','158794','158795','158801','158840','158951','158952','158953','159031','159144','159145','159146','159282','159308','159315','159316','159333','159337','159389','159392','159436','159466','159541','159602','159603','159611','159795','159961','159988','160038','160115','160125','160126','160196','160214','160216','160217','160218','160255','160256','160266','160395','160467','160469','160470','160551','160562','160571','160606','160607','160618','160755','160761','160762','160763','160809','160844','161087','161157','161173','161197','161228','161543','161589','161724','161725','161726','161727','161756','161774','161775','161910','162009','162073','162074','162075','162076','162108','162109','162116','162117','162121','162122','162124','162177','162178','162283','162284','162291','162335','162375','162410','162429','162433','162579','162580','162635','162664','162754','162832','162924','162925','162965','162966','162985','163006','163017','163018','163026','163027','163031','163043','163114','163123','163132','163133','163135','163136','163290','163339','163395','163465','163547','163646','163723','163890','163891','163892','163922','163954','164094','164124','164269','164382','164385','164455','164456','164457','164511','164526','164665','164679','164937','164948','164996','165027','165032','165033','165034','165035','165053','165063','165082','165083','165420','165479','165488','165540','165544','165547','165565','165607','165687','165750','165915','165929','165936','166165','166315','166562','166645','166651','166670','166760','166880','167041','167073','167211','167316','167403','167426','167429','167500','167614','167634','167635','167640','167643','167664','167724','167725','167726','167727','167728','167729','167730','167731','167732','167733','167786','167831','167851','167909','167949','168033','168034','168035','168099','168115','168137','168239','168245','168266','168330','168335','168376','168393','168403','169094','169261','169262','169308','169350','170357','170358','170359','170360','170366','170367','170368','170369','170592','170593','170603','170615','202712','207394','207395','207396','207397','207398','207399','207400','207401','207402','207403','207404','207405','207406','207407','207408','207409','207410','207411','207412','207413','207414','207415','207416','207417','207418','207419','207420','207421','207422','207423','207424','207425','207426','207427','207428','207429','207430','207431','207432','207433','207434','207435','207436','207437','207438','207439','207440','207441','207442','207443','207444','207445','207446','207447','207448','207449','207450','207451','207452','207453','207454','207455','207456','207457','207458','207459','207460','207461','207462','207463','207464','207465','207466','207467','207468','207469','207470','207471','207472','207473','207474','207475','207476','207477','207478','207479','207480','207481','207482','207483','207484','207485','207486','207487','207488','207489','207490','207491','207492','207493','207494','207495','207496','207497','207498','207499','207500','207501','207502','207503','207504','207505','207506','207507','207508','207509','207510','207511','207512','207513','207514','207515','207516','207517','207518','207519','207520','207521','207522','207523','207524','207525','207526','207527','207528','207529','207530','207531','207532','207533','207534','207535','207536','207537','207538','207539','207540','207541','207542','207543','207544','207545','207546','207547','207548','207549','207550','207551','207552','207553','207554','207555','207556','207557','207558','207559','207560','207561','207562','207563','207564','207565','207566','207567','207568','207569','207571','207572','207573','207574','207575','207576','207577','207578','207579','207580','207581','207582','207583','207584','207585','207586','207587','207588','207589','207590','207591','207592','207593','207594','207595','207596','207597','207598','207599','207600','207601','207602','207603','207604','207605','207606','207607','207608','207609','207610','207611','207612','207613','207614','207615','207616','207617','207618','207619','207620','207621','207622','207623','207624','207625','207626','207627','207628','207629','207630','207631','207632','207633','207634','207635','207636','207637','207638','207639','207640','207641','207642','207643','207644','207645','207646','207647','207648','207649','207650','207651','207652','207653','207654','207655','207656','207657','207658','207659','207660','207661','207662','207663','207664','207665','207666','207667','207668','207669','207670','207671','207672','207673','207674','207675','207676','207677','207678','207679','207680','207681','207682','207683','207684','207685','207686','207687','207688','207689','207690','207691','207692','207693','207694','207695','207696','207697','207698','207699','207700','207701','207702','207703','207704','207705','207706','207707','207708','207709','207710','207711','207712','207713','207714','207715','207716','207717','207718','207719','207720','207721','207722','207723','207724','207725','207726','207727','207728','207729','207730','207731','207732','207733','207734','207735','207736','207737','207738','207739','207740','207741','207742','207743','207744','207745','207746','207747','207748','207749','207750','207751','207752','207753','207754','207755','207756','207757','207758','207759','207760','207761','207762','207763','207764','207765','207766','207767','207768','207769','207770','207771','207772','207773','207774','207775','207776','207777','207778','207779','207780','207781','207782','207783','207784','207785','207786','207787','207788','207789','207790','207791','207792','207793','207794','207795','207796','207797','207798','207799','207800','207801','207802','207803','207804','211010','215551','215602','215760','215761','215985','216012','219135','219296','219330','219380','219381','219403','219476','219546','219719','219720','219723','219724','219725','219750','219768','219769','232502','232680','232681','238301','238318','238497','238865','239268','239294','239326','239455','239567','239676','239693','239695','239696','239698','239739','239797','239899','240036','240037','240039','240040','240041','240043','240069','240095','240202','240203','240204','240207','240289','240295','240645','240748','240749','240818','240924','240925','240926','240950','241006','241007','241071','241072','241107','241110','241111','241112','241113','241114','241264','241300','241490','241491','241502','241503','241514','241540','241541','241559','241560','241566','241567','241568','241570','241571','241583','241584','241586','241596','241893','241997','241999','242000','242001','242002','242003','242232','242233','242300','242311','242312','242313','242330','242391','242394','242395','242396','242397','242398','242400','242401','242470','242471','242477','242482','242483','242525','242526','242527','242528','242529','242560','242615','242653','242654','242772','242773','242824','242839','242881','242892','242949','242950','242961','242962','243086','243230','243231','243232','243233','243234','243255','243290','243291','243292','243504','243505','243566','243567','243568','243569','243570','243571','243572','243573','243574','243575','243576','243577','243578','243579','243580','243581','243582','243769','243770','243771','243863','243889','244048','244114','244119','244120','244121','244125','244305','244306','244389','244440','244453','244457','244458','244460','244647','244658','244659','244813','244814','244967','244994','244995','245001','245005','245014','245015','245016','245064','245213','245214','245215','245231','245232','245235','245236','245237','245238','245241','245242','245264','245265','245369','245370','245371','245372','245551','245779','245788','245857','245898','245911','245912','245956','246008','246055','246125','246186','246187','246204','246212','246213','246380','246435','246436','246533','246534','246656','246807','246827','246852','247051','247103','247104','247149','247158','247276','247279','247333','247380','247381','247443','247444','247456','247457','247458','247459','247460','247488','247575','247605','247606','247607','247608','247609','247610','247613','247614','247634','247638','247698','247701','247725','247784','247785','247876','247877','247919','247920','247988','247992','248060','248061','248062','248188','248189','248197','248198','248246','248250','248255','248300','248409','248476','248479','248544','248545','248566','248567','248572','248578','248579','248603','248613','248639','248640','248641','248732','248733','248734','248735','248821','248838','248893','248895','248896','248897','248924','248930','248968','249137','249253','249264','249269','249308','249309','249382','249388','249402','249416','249439','249578','249718','249719','249748','249750','249851','249875','249925','249992','250080','250213','250334','250630','250660','250678','250701','250704','250710','250729','250730','250807','250813','250861','250904','250919','250966','250967','250994','250995','250996','251078','251110','251171','251190','251259','251360','251367','251372','251400','251408','251639','251867','251927','251929','251939','251945','251949','251985','252017','252018','252019','252045','252066','252067','252093','253033','253036','253054','253055','253070','253081','253085','253088','253094','253114','253115','253140','253158','253167','253186','253259','253260','253278','253344','253345','253360','253392','253393','253402','253403','253522','253575','253655','253685','253686','253687','253784','253813','253823','253849','253862','253867','254244','254245','254246','254247','254345','254346','254347','254368','254586','254643','254645','254739','254774','254777','254792','254804','254806','254807','254824','254826','254828','254843','254844','254856','254926','254940','254963','254964','254965','255018','255208','255225','255289','255317','255397','255398','255495','255508','255514','255603','255605','255606','255607','255664','255708','255726','255731','255733','255734','255735','255736','255740','255741','255742','255773','255809','255852','255930','255931','255932','255933','255934','255935','255936','255937','255938','256015','256023','256218','256286','256308','256353','256427','256494','256516','256566','256567','256618','256788','256791','256818','256846','256872','257133','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261706','262073','262110','262119','262352','262357','262390','262391','262393','262503','262506','262529','262530','262531','262608','262625','262753','262755','262756','262792','262865','262866','262875','262876','262877','262878','262924','262978','262997','263059','263096','263117','263119','263121','263125','263140','263176','263519','263522','263582','263583','263586','263589','263590','263591','263592','263593','263594','263598','263599','263600','263651','263652','263653','263655','263672','263727','264387','264447','264630','264681','264682','264683','264704','264705','264714','264718','264729','264735','264737','264792','264793','264824','264963','265015','265022','265065','265136','265265','265274','265276','265277','265347','265348','265351','265402','265459','265488','265539','265556','265573','265600','265635','265659','265692','265706','265742','265763','265776','265807','265808','265993','266143','266241','266244','266285','266286','266287','266561','266616','266622','266627','266628','266629','266630','266631','266660','266667','266668','266675','266676','266677','266697','266791','266797','266798','266824','266827','267066','267067','267136','267189','267193','267194','267195','267196','267197','267198','267199','267200','267201','267202','267203','267239','267285','267392','267400','267413','267517','267582','267583','267584','267602','267627','267646','267699','267707','267708','267735','267756','267862','267863','267874','267902','267912','267929','267935','267942','267959','267988','267993','268124','268134','268142','268143','268144','268167','268211','268215','268218','268219','268220','268221','268237','268239','268250','268263','268264','268312','268313','268333','268334','268361','268395','268406','268415','268594','268601','268602','268617','268623','268661','268663','268676','268679','268707','268772','268790','268834','268876','268889','268892','268906','269029','269047','269064','269065','269084','269106','269184','269204','269206','269217','269244','269246','269247','269248','269327','269351','269352','269353','269428','269443','269522','269527','269530','269571','269750','273353','273359','273378','273415','273438','273461','273469','273470','273516','273536','273590','273605','273608','273616','273617','273646','273647','273654','273655','273667','273713','273723','273828','273829','273832','273902','273910','273926','273927','274052','274054','274055','274056','274057','274118','274145','274146','274288','274352','274443','274606','274612','274622','274679','274700','274703','274744','274745','274757','274764','274817','274818','274819','274837','274838','274839','274938','274939','275011','275015','275062','275073','275074','275075','275076','275089','275116','275121','275128','275129','275188','275199','275205','275247','275252','275263','275266','275298','275332','275473','275486','275537','275594','275665','275689','275749','275753','275819','275954','275955','275979','276059','276291','276340','276378','276379','276381','276483','276511','276531','276541','276556','276635','276676','276689','276690','276823','276827','276986','277012','277037','277038','277064','277065','277066','277189','277213','277289','277336','277370','277450','277507','277512','277513','277514','277523','277712','277763','277769','277771','277772','277828','277865','277935','278022','278059','278061','278062','278066','278079','278080','278081','278096','278162','278228','278229','278230','278231','278258','278279','278310','278312','278318','278322','278340','278398','278429','278433','278434','278435','278436','278526','278532','278555','278572','278583','278603','278695','278696','278716','278717','278718','278719','278720','278742','278812','278873','278874','278875','278947','279056','279057','279153','279180','279256','279257','279266','279273','279301','279399','279406','279411','279412','279426','279440','279481','279586','279701','279735','279737','279740','279741','279749','279763','279791','279820','280289','280297','280376','280391','280404','280405','280411','280412','280594','280595','280710','280810','280829','280832','280977','281030','281054','281110','281113','281172','281183','281184','281185','281216','281239','281334','281454','281467','281468','281471','281631','281632','281705','281707','281709','281710','281718','281731','281857','282063','282109','282172','282341','282342','282347','282434','282443','282445','282482','282488','282491','282523','282528','282790','282834','282851','282861','282902','283001','283115','283193','283212','283235','283239','283338','283382','283415','283520','283521','283577','283619','283646','283653','283763','284224','284292','284358','284410','284411','284418','284443','284444','284445','284448','284449','284450','284451','284452','284497','284592','284622','284651','284654','284900','284912','285024','285025','285081','285082','285200','285345','285382','285403','285455','285462','285495','285511','285512','285548','285566','285567','285568','285578','285584','285658','285713','285715','285736','285746','285790','285793','285794','285812','285851','285852','285853','285866','285908','285943','285950','286049','286068','286092','286097','286114','286115','286116','286117','286118','286191','286213','286252','286327','286450','286654','286655','286669','286670','286810','286829','286860','286913','286914','286915','286916','286917','286918','287001','287014','287030','287031','287047','287060','287061','287064','287065','287066','287067','287068','287069','287070','287071','287072','287073','287074','287075','287076','287077','287078','287079','287080','287081','287082','287083','287084','287085','287086','287087','287088','287089','287090','287091','287092','287093','287109','287110','287111','287113','287114','287115','287116','287117','287118','287119','287120','287121','287122','287140','287148','287165','287185','287224','287512','287513','287533','287534','287546','287550','287554','287787','287790','287973','287975','287977','287978','287980','288016','288082','288085','288086','288092','288163','288217','288222','288223','288224','288227','288234','288235','288270','288278','288279','288290','288299','288334','288350','288450','288454','288472','288499','288534','288565','288580','288589','288711','288757','288850','288860','288901','289034','289035','289036','289037','289038','289039','289040','289041','289044','289045','289046','289047','289048','289049','289050','289051','289052','289053','289204','289205','289206','289209','289222','289335','289374','289375','289404','289405','289412','289413','289449','289451','289455','289462','289481','289483','289484','289485','289486','289502','289506','291613','291674','291737','291808','291818','291846','291852','291884','291887','291900','292090','292298','292303','292369','292470','292474','292496','292525','292533','292567','292624','292755','292813','292825','292836','293199','293214','293228','293253','293285','293380','293404','293409','293457','293508','293519','293577','293604','293647','293648','293649','293886','293887','294013','294209','294246','294258','294259','294277','294297','294303','294305','294326','294327','294328','294383','294391','294428','294429','294482','294544','294576','294592','294593','294664','294768','294814','294869','294895','294904','294933','294962','295310','295311','295367','295417','295419','295511','295699','295705','295724','295725','295752','295767','295838','295846','296002','296003','296004','296005','296200','296279','297096','297122','297123','297124','297125','297131','297132','297181','297201','297202','297203','297205','297211','297223','297228','297229','297244','297299','297307','297308','297330','297425','297464','297557','297610','297612','297618','297619','297628','297647','297836','297838','297839','297840','297841','297842','297843','297844','297845','297846','297847','297848','297899','297933','297937','297993','298012','298021','298036','298037','298063','298069','298070','298100','298102','298104','298105','298106','298107','298113','298118','298164','298252','298318','298319','298326','298357','298358','298359','298360','298361','298378','298379','298406','298438','298444','298535','298549','298593','299038','299081','299082','299137','299165','299356','299436','299471','299472','299488','299499','299583','299594','299603','299604','299688','299697','299698','299737','299738','299771','299797','299825','299827','299865','299880','299985','299986','300047','300050','300080','300172','300224','300243','300383','300404','300650','300918','300921','300929','300990','300991','300992','300993','301055','301779','301780','301781','301782','301783','301790','301791','301805','301857','301898','301906','301907','301908','301909','301937','301999','302066','302181','302287','302298') GROUP BY `tip` ORDER BY `tip` ASC

SELECT `tip`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `tip` !='' AND `modx_site_content`.`id` IN ('141332','141333','141503','141821','141882','141883','141884','141886','142128','142209','142210','142211','142212','142213','142930','142943','143376','143385','143457','143513','143514','143515','143516','143517','143518','143519','143520','143521','143522','143523','143524','143525','143526','143527','143528','143529','143530','143531','143533','143534','143535','143537','143538','143539','143540','143541','143542','143543','143544','143545','143546','143547','143548','143549','143550','143551','143651','143734','143771','143785','143786','143789','143790','143791','143792','143794','143796','143798','143800','143803','143805','143811','143812','143813','143825','143918','144081','144230','146587','147021','147060','147241','147876','148128','148356','148588','148590','148618','148644','148645','148646','148647','148650','148659','148661','149123','149124','149125','149126','149127','149128','149129','149130','149131','149132','149133','149134','149135','149136','149137','149138','149139','149140','149141','149142','149143','149144','149145','149146','149147','149148','149149','149150','149151','149153','149154','149155','149156','149157','149159','149160','149161','149162','149163','149164','149165','149166','149167','149168','149169','149170','149171','149172','149173','149174','149175','149176','149177','149178','149179','149180','149181','149182','149183','149184','149185','149186','149187','149188','149189','149190','149191','149192','149193','149194','149195','149196','149197','149198','149199','149200','149201','149202','149203','149204','149205','149206','149207','149208','149209','149210','149211','149212','149213','149214','149215','149216','149217','149218','149219','149664','149694','150510','150581','150598','150599','150796','150833','151002','151458','151459','151469','151808','151868','151992','152526','152657','152662','153070','153086','153801','153803','154550','154580','154581','154583','154584','154587','154588','154590','154625','154626','154627','154642','154655','154656','154657','154658','154659','154675','154690','154691','154747','154796','154951','155023','155024','155025','155065','155087','155088','155089','155090','155091','155104','155155','155748','156313','156423','156424','156425','156426','156427','156428','156429','156430','156431','156432','156433','156434','156435','156436','156437','156439','156441','156443','156445','156447','156475','156476','156477','156478','156479','156480','156481','156482','156483','156484','156485','156486','156487','156488','156489','156502','156503','156504','156510','157640','157666','157777','158362','158416','158455','158557','158586','158655','158662','158794','158795','158801','158840','158951','158952','158953','159031','159145','159146','159282','159308','159315','159316','159333','159337','159389','159392','159436','159466','159541','159602','159603','159611','159795','159961','159988','160038','160115','160125','160126','160196','160214','160216','160217','160218','160255','160256','160266','160395','160467','160469','160470','160551','160562','160571','160606','160607','160618','160755','160761','160762','160763','160809','160844','161087','161157','161173','161197','161228','161543','161589','161724','161725','161726','161727','161756','161774','161775','161910','162009','162073','162074','162075','162076','162108','162109','162116','162117','162121','162122','162124','162177','162178','162283','162284','162291','162335','162375','162410','162429','162433','162579','162580','162635','162664','162754','162832','162924','162925','162965','162966','162985','163006','163017','163018','163026','163027','163031','163043','163114','163123','163132','163133','163135','163136','163290','163339','163395','163465','163547','163646','163723','163890','163891','163892','163922','163954','164094','164124','164269','164382','164385','164455','164456','164457','164511','164526','164665','164679','164937','164948','164996','165027','165032','165033','165034','165035','165053','165063','165082','165083','165420','165479','165488','165540','165544','165547','165565','165607','165687','165750','165915','165929','165936','166165','166315','166562','166645','166651','166670','166760','166880','167041','167073','167211','167316','167403','167426','167429','167500','167614','167634','167635','167640','167643','167664','167724','167725','167726','167727','167728','167729','167730','167731','167732','167733','167786','167831','167851','167909','167949','168033','168034','168035','168099','168115','168137','168239','168245','168266','168330','168335','168376','168393','168403','169094','169261','169262','169308','169350','170357','170358','170359','170360','170366','170367','170368','170369','170592','170593','170603','170615','202712','207394','207395','207396','207397','207398','207399','207400','207401','207402','207403','207404','207405','207406','207407','207408','207409','207410','207411','207412','207413','207414','207415','207416','207417','207418','207419','207420','207421','207422','207423','207424','207425','207426','207427','207428','207429','207430','207431','207432','207433','207434','207435','207436','207437','207438','207439','207440','207441','207442','207443','207444','207445','207446','207447','207448','207449','207450','207451','207452','207453','207454','207455','207456','207457','207458','207459','207460','207461','207462','207463','207464','207465','207466','207467','207468','207469','207470','207471','207472','207473','207474','207475','207476','207477','207478','207479','207480','207481','207482','207483','207484','207485','207486','207487','207488','207489','207490','207491','207492','207493','207494','207495','207496','207497','207498','207499','207500','207501','207502','207503','207504','207505','207506','207507','207508','207509','207510','207511','207512','207513','207514','207515','207516','207517','207518','207519','207520','207521','207522','207523','207524','207525','207526','207527','207528','207529','207530','207531','207532','207533','207534','207535','207536','207537','207538','207539','207540','207541','207542','207543','207544','207545','207546','207547','207548','207549','207550','207551','207552','207553','207554','207555','207556','207557','207558','207559','207560','207561','207562','207563','207564','207565','207566','207567','207568','207569','207571','207572','207573','207574','207575','207576','207577','207578','207579','207580','207581','207582','207583','207584','207585','207586','207587','207588','207589','207590','207591','207592','207593','207594','207595','207596','207597','207598','207599','207600','207601','207602','207603','207604','207606','207607','207608','207609','207610','207611','207612','207613','207614','207615','207616','207617','207618','207619','207620','207621','207622','207623','207624','207625','207626','207627','207628','207629','207630','207631','207632','207633','207634','207635','207636','207637','207638','207639','207640','207641','207642','207643','207644','207645','207646','207647','207648','207649','207650','207651','207652','207653','207654','207655','207656','207657','207658','207659','207660','207661','207662','207663','207664','207665','207666','207667','207668','207669','207670','207671','207672','207673','207674','207675','207676','207677','207678','207679','207680','207681','207682','207683','207684','207685','207686','207687','207688','207689','207690','207691','207692','207693','207694','207695','207696','207697','207698','207699','207700','207701','207702','207703','207704','207705','207706','207707','207708','207709','207710','207711','207712','207713','207714','207715','207716','207717','207718','207719','207720','207721','207722','207723','207724','207725','207726','207727','207728','207729','207730','207731','207732','207733','207734','207735','207736','207737','207738','207739','207740','207741','207742','207743','207744','207745','207746','207747','207748','207749','207750','207751','207752','207753','207754','207755','207756','207757','207758','207759','207760','207761','207762','207763','207764','207765','207766','207767','207768','207769','207770','207771','207772','207773','207774','207775','207776','207777','207778','207779','207780','207781','207782','207783','207784','207785','207786','207787','207788','207789','207790','207791','207792','207793','207794','207795','207796','207797','207798','207799','207800','207801','207802','207803','207804','211010','215551','215602','215760','215761','215985','216012','219135','219296','219330','219380','219381','219403','219476','219546','219719','219720','219723','219724','219725','219750','219768','219769','232502','232680','232681','238301','238318','238497','238865','239268','239294','239326','239455','239567','239676','239693','239695','239696','239698','239739','239797','239899','240036','240037','240039','240040','240041','240043','240069','240095','240202','240203','240204','240207','240289','240295','240645','240748','240749','240818','240924','240925','240926','240950','241006','241007','241071','241072','241107','241110','241111','241112','241113','241114','241264','241300','241490','241491','241502','241503','241514','241540','241541','241559','241560','241566','241567','241568','241570','241571','241583','241584','241586','241596','241893','241997','241999','242000','242001','242002','242003','242232','242233','242300','242311','242312','242313','242330','242391','242394','242395','242396','242397','242398','242400','242401','242470','242471','242477','242482','242483','242525','242526','242527','242528','242529','242560','242615','242653','242654','242772','242773','242824','242839','242881','242892','242949','242950','242961','242962','243086','243230','243231','243232','243233','243234','243255','243290','243291','243292','243504','243505','243566','243567','243568','243569','243570','243571','243572','243573','243574','243575','243576','243577','243578','243579','243580','243581','243582','243769','243770','243771','243863','243889','244048','244114','244119','244120','244121','244125','244305','244306','244389','244440','244453','244457','244458','244460','244647','244658','244659','244813','244814','244967','244994','244995','245001','245005','245014','245015','245016','245064','245213','245214','245215','245231','245232','245235','245236','245237','245238','245241','245242','245264','245265','245369','245370','245371','245372','245551','245779','245788','245857','245898','245911','245912','245956','246008','246055','246125','246186','246187','246204','246212','246213','246380','246435','246436','246533','246534','246656','246807','246827','246852','247051','247103','247104','247149','247158','247276','247279','247333','247380','247381','247443','247444','247456','247457','247458','247459','247460','247488','247575','247605','247606','247607','247608','247609','247610','247613','247614','247634','247638','247698','247701','247725','247784','247785','247876','247877','247919','247920','247988','247992','248060','248061','248062','248188','248189','248197','248198','248246','248250','248255','248300','248409','248476','248479','248544','248545','248566','248567','248572','248578','248579','248603','248613','248639','248640','248641','248732','248733','248734','248735','248821','248838','248893','248895','248896','248897','248924','248930','248968','249137','249253','249264','249269','249308','249309','249382','249388','249402','249416','249439','249578','249718','249719','249748','249750','249851','249875','249925','249992','250080','250213','250334','250630','250660','250678','250701','250704','250710','250729','250730','250807','250813','250861','250904','250919','250966','250967','250994','250995','250996','251078','251110','251171','251190','251259','251360','251367','251372','251400','251408','251639','251867','251927','251929','251939','251945','251949','251985','252017','252018','252019','252045','252066','252067','252093','253033','253036','253054','253055','253070','253081','253085','253088','253094','253114','253115','253140','253158','253167','253186','253259','253260','253278','253344','253345','253360','253392','253393','253402','253403','253522','253575','253655','253685','253686','253687','253784','253813','253823','253849','253862','253867','254244','254245','254246','254247','254345','254346','254347','254368','254586','254643','254645','254739','254774','254777','254792','254804','254806','254807','254824','254826','254828','254843','254844','254856','254926','254940','254963','254964','254965','255018','255208','255225','255289','255317','255397','255398','255495','255508','255514','255603','255605','255606','255607','255664','255708','255726','255731','255733','255734','255735','255736','255740','255741','255742','255773','255809','255852','255930','255931','255932','255933','255934','255935','255936','255937','255938','256015','256023','256218','256286','256308','256353','256427','256494','256516','256566','256567','256618','256788','256791','256818','256846','256872','257133','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261706','262073','262110','262119','262352','262357','262390','262391','262393','262503','262506','262529','262530','262531','262608','262625','262753','262755','262756','262792','262865','262866','262875','262876','262877','262878','262924','262978','262997','263059','263096','263117','263119','263121','263125','263140','263176','263519','263522','263582','263583','263586','263589','263590','263591','263592','263593','263594','263598','263599','263600','263651','263652','263653','263655','263672','263727','264387','264447','264630','264681','264682','264683','264704','264705','264714','264718','264729','264735','264737','264792','264793','264824','264963','265015','265022','265065','265136','265265','265274','265276','265277','265347','265348','265351','265402','265459','265488','265539','265556','265573','265600','265635','265659','265692','265706','265742','265763','265776','265807','265808','265993','266241','266244','266285','266286','266287','266561','266616','266622','266627','266628','266629','266630','266631','266660','266667','266668','266675','266676','266677','266697','266791','266797','266798','266824','266827','267066','267067','267136','267189','267193','267194','267195','267196','267197','267198','267199','267200','267201','267202','267203','267239','267285','267392','267400','267413','267517','267582','267583','267584','267602','267627','267646','267699','267707','267708','267735','267756','267862','267863','267874','267902','267912','267929','267935','267942','267959','267988','267993','268124','268134','268142','268143','268144','268167','268211','268215','268218','268219','268220','268221','268237','268239','268250','268263','268264','268312','268313','268333','268334','268361','268395','268406','268415','268594','268601','268602','268617','268623','268661','268663','268676','268679','268707','268772','268790','268834','268876','268889','268892','268906','269029','269047','269064','269065','269084','269106','269184','269204','269206','269217','269244','269246','269247','269248','269327','269351','269352','269353','269428','269443','269522','269527','269530','269571','269750','273353','273359','273378','273415','273438','273461','273469','273470','273516','273536','273590','273605','273608','273616','273617','273646','273647','273654','273655','273667','273713','273723','273828','273829','273832','273902','273910','273926','273927','274052','274054','274055','274056','274057','274118','274145','274146','274288','274352','274443','274606','274612','274622','274679','274700','274703','274744','274745','274757','274764','274817','274818','274819','274837','274838','274839','274938','274939','275011','275015','275062','275073','275074','275075','275076','275089','275116','275121','275128','275129','275188','275199','275205','275247','275252','275263','275266','275298','275332','275473','275486','275537','275594','275665','275689','275749','275753','275819','275954','275955','275979','276059','276291','276340','276378','276379','276381','276483','276511','276531','276541','276556','276635','276676','276689','276690','276823','276827','276986','277012','277037','277038','277064','277065','277066','277189','277213','277289','277336','277370','277450','277507','277512','277513','277514','277523','277712','277763','277769','277771','277772','277828','277865','277935','278022','278059','278061','278062','278066','278079','278080','278081','278096','278162','278228','278229','278230','278231','278258','278279','278310','278312','278318','278322','278340','278398','278429','278433','278434','278435','278436','278526','278532','278555','278572','278583','278603','278695','278696','278716','278717','278718','278719','278720','278742','278812','278873','278874','278875','278947','279056','279057','279153','279180','279256','279257','279266','279273','279301','279399','279406','279411','279412','279426','279440','279481','279586','279701','279735','279737','279740','279741','279749','279763','279791','279820','280289','280297','280376','280391','280404','280405','280411','280412','280594','280595','280710','280810','280829','280832','280977','281030','281054','281110','281113','281172','281183','281184','281185','281216','281239','281334','281454','281467','281468','281471','281631','281632','281705','281707','281709','281710','281718','281731','281857','282063','282109','282172','282341','282342','282347','282434','282443','282445','282482','282488','282491','282523','282528','282790','282834','282851','282861','282902','283001','283115','283193','283212','283235','283239','283338','283382','283415','283520','283521','283577','283619','283646','283653','283763','284224','284292','284358','284410','284411','284418','284443','284444','284445','284448','284449','284450','284451','284452','284497','284592','284622','284651','284654','284900','284912','285024','285025','285081','285082','285200','285345','285382','285403','285455','285462','285495','285511','285512','285548','285566','285567','285568','285578','285584','285658','285713','285715','285736','285746','285790','285793','285794','285812','285851','285852','285853','285866','285908','285943','285950','286049','286068','286092','286097','286114','286115','286116','286117','286118','286191','286213','286252','286327','286450','286654','286655','286669','286670','286810','286829','286860','286913','286914','286915','286916','286917','286918','287001','287014','287030','287031','287047','287060','287061','287064','287065','287066','287067','287068','287069','287070','287071','287072','287073','287075','287076','287077','287078','287079','287080','287081','287082','287083','287084','287085','287086','287087','287088','287089','287090','287091','287092','287093','287109','287110','287111','287113','287114','287115','287116','287117','287118','287119','287120','287121','287122','287140','287148','287165','287185','287224','287512','287513','287533','287534','287546','287550','287554','287787','287790','287973','287975','287977','287978','287980','288016','288082','288085','288086','288092','288163','288217','288222','288223','288224','288227','288234','288235','288270','288278','288279','288290','288299','288334','288350','288450','288454','288472','288499','288534','288565','288580','288589','288711','288757','288850','288860','288901','289034','289035','289036','289037','289038','289039','289040','289041','289044','289045','289046','289047','289048','289049','289050','289051','289052','289053','289204','289205','289206','289209','289222','289335','289374','289375','289404','289405','289413','289449','289451','289455','289462','289481','289483','289484','289485','289486','289502','289506','291613','291674','291737','291808','291818','291846','291852','291884','291887','291900','292090','292298','292303','292369','292470','292474','292496','292525','292533','292567','292624','292755','292813','292825','292836','293199','293214','293228','293253','293285','293380','293404','293409','293457','293508','293519','293577','293604','293647','293648','293649','293886','293887','294013','294209','294246','294258','294259','294277','294297','294303','294305','294326','294327','294328','294383','294391','294428','294429','294482','294544','294576','294592','294593','294664','294768','294814','294869','294895','294904','294933','294962','295310','295311','295367','295417','295419','295511','295699','295705','295724','295725','295752','295767','295838','295846','296002','296003','296004','296005','296200','296279','297096','297122','297123','297124','297125','297131','297132','297181','297201','297202','297203','297205','297211','297223','297228','297229','297244','297299','297307','297308','297330','297425','297464','297557','297610','297612','297618','297619','297628','297647','297836','297838','297839','297840','297841','297842','297843','297844','297845','297846','297847','297848','297899','297933','297937','297993','298012','298021','298036','298037','298063','298069','298070','298100','298102','298104','298105','298106','298107','298113','298118','298164','298252','298318','298319','298326','298357','298358','298359','298360','298361','298378','298379','298406','298438','298444','298535','298549','298593','299038','299081','299082','299137','299165','299356','299436','299471','299472','299488','299499','299583','299594','299603','299604','299688','299697','299698','299737','299738','299771','299797','299825','299827','299865','299880','299985','299986','300047','300050','300080','300172','300224','300243','300383','300404','300650','300918','300921','300929','300990','300991','300992','300993','301055','301779','301780','301781','301782','301783','301790','301791','301805','301857','301898','301906','301907','301908','301909','301937','301999','302066','302181','302287','302298') GROUP BY `tip` ORDER BY `tip` ASC

SELECT `kol_kon`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `kol_kon` !='' AND `modx_site_content`.`id` IN ('141332','141333','141503','141821','141882','141883','141884','141886','142128','142209','142210','142211','142212','142213','142930','142943','143376','143385','143457','143513','143514','143515','143516','143517','143518','143519','143520','143521','143522','143523','143524','143525','143526','143527','143528','143529','143530','143531','143532','143533','143534','143535','143537','143538','143539','143540','143541','143542','143543','143544','143545','143546','143547','143548','143549','143550','143551','143651','143734','143771','143785','143786','143789','143790','143791','143792','143794','143796','143798','143800','143803','143805','143811','143812','143813','143825','143918','144081','144230','146587','147021','147060','147241','147876','148128','148356','148588','148590','148618','148644','148645','148646','148647','148650','148659','148661','149123','149124','149125','149126','149127','149128','149129','149130','149131','149132','149133','149134','149135','149136','149137','149138','149139','149140','149141','149142','149143','149144','149145','149146','149147','149148','149149','149150','149151','149153','149154','149155','149156','149157','149159','149160','149161','149162','149163','149164','149165','149166','149167','149168','149169','149170','149171','149172','149173','149174','149175','149176','149177','149178','149179','149180','149181','149182','149183','149184','149185','149186','149187','149188','149189','149190','149191','149192','149193','149194','149195','149196','149197','149198','149199','149200','149201','149202','149203','149204','149205','149206','149207','149208','149209','149210','149211','149212','149213','149214','149215','149216','149217','149218','149219','149664','149694','150510','150581','150598','150599','150796','150833','151002','151458','151459','151469','151808','151868','151992','152526','152657','152662','153070','153086','153801','153803','154550','154580','154581','154583','154584','154587','154588','154590','154625','154626','154627','154642','154655','154656','154657','154658','154659','154675','154690','154691','154747','154796','154951','155023','155024','155025','155065','155087','155088','155089','155090','155091','155104','155155','155748','156313','156423','156424','156425','156426','156427','156428','156429','156430','156431','156432','156433','156434','156435','156436','156437','156438','156439','156440','156441','156442','156443','156444','156445','156446','156447','156448','156475','156476','156477','156478','156479','156480','156481','156482','156483','156484','156485','156486','156487','156488','156489','156502','156503','156504','156510','157640','157666','157777','158362','158416','158455','158557','158586','158655','158662','158794','158795','158801','158840','158951','158952','158953','159031','159144','159145','159146','159282','159308','159315','159316','159333','159337','159389','159392','159436','159466','159541','159602','159603','159611','159795','159961','159988','160038','160115','160125','160126','160196','160214','160216','160217','160218','160255','160256','160266','160395','160467','160469','160470','160551','160562','160571','160606','160607','160618','160755','160761','160762','160763','160809','160844','161087','161157','161173','161197','161228','161543','161589','161724','161725','161726','161727','161756','161774','161775','161910','162009','162073','162074','162075','162076','162108','162109','162116','162117','162121','162122','162124','162177','162178','162283','162284','162291','162335','162375','162410','162429','162433','162579','162580','162635','162664','162754','162832','162924','162925','162965','162966','162985','163006','163017','163018','163026','163027','163031','163043','163114','163123','163132','163133','163135','163136','163290','163339','163395','163465','163547','163646','163723','163890','163891','163892','163922','163954','164094','164124','164269','164382','164385','164455','164456','164457','164511','164526','164665','164679','164937','164948','164996','165027','165032','165033','165034','165035','165053','165063','165082','165083','165420','165479','165488','165540','165544','165547','165565','165607','165687','165750','165915','165929','165936','166165','166315','166562','166645','166651','166670','166760','166880','167041','167073','167211','167316','167403','167426','167429','167500','167614','167634','167635','167640','167643','167664','167724','167725','167726','167727','167728','167729','167730','167731','167732','167733','167786','167831','167851','167909','167949','168033','168034','168035','168099','168115','168137','168239','168245','168266','168330','168335','168376','168393','168403','169094','169261','169262','169308','169350','170357','170358','170359','170360','170366','170367','170368','170369','170592','170593','170603','170615','202712','207394','207395','207396','207397','207398','207399','207400','207401','207402','207403','207404','207405','207406','207407','207408','207409','207410','207411','207412','207413','207414','207415','207416','207417','207418','207419','207420','207421','207422','207423','207424','207425','207426','207427','207428','207429','207430','207431','207432','207433','207434','207435','207436','207437','207438','207439','207440','207441','207442','207443','207444','207445','207446','207447','207448','207449','207450','207451','207452','207453','207454','207455','207456','207457','207458','207459','207460','207461','207462','207463','207464','207465','207466','207467','207468','207469','207470','207471','207472','207473','207474','207475','207476','207477','207478','207479','207480','207481','207482','207483','207484','207485','207486','207487','207488','207489','207490','207491','207492','207493','207494','207495','207496','207497','207498','207499','207500','207501','207502','207503','207504','207505','207506','207507','207508','207509','207510','207511','207512','207513','207514','207515','207516','207517','207518','207519','207520','207521','207522','207523','207524','207525','207526','207527','207528','207529','207530','207531','207532','207533','207534','207535','207536','207537','207538','207539','207540','207541','207542','207543','207544','207545','207546','207547','207548','207549','207550','207551','207552','207553','207554','207555','207556','207557','207558','207559','207560','207561','207562','207563','207564','207565','207566','207567','207568','207569','207571','207572','207573','207574','207575','207576','207577','207578','207579','207580','207581','207582','207583','207584','207585','207586','207587','207588','207589','207590','207591','207592','207593','207594','207595','207596','207597','207598','207599','207600','207601','207602','207603','207604','207605','207606','207607','207608','207609','207610','207611','207612','207613','207614','207615','207616','207617','207618','207619','207620','207621','207622','207623','207624','207625','207626','207627','207628','207629','207630','207631','207632','207633','207634','207635','207636','207637','207638','207639','207640','207641','207642','207643','207644','207645','207646','207647','207648','207649','207650','207651','207652','207653','207654','207655','207656','207657','207658','207659','207660','207661','207662','207663','207664','207665','207666','207667','207668','207669','207670','207671','207672','207673','207674','207675','207676','207677','207678','207679','207680','207681','207682','207683','207684','207685','207686','207687','207688','207689','207690','207691','207692','207693','207694','207695','207696','207697','207698','207699','207700','207701','207702','207703','207704','207705','207706','207707','207708','207709','207710','207711','207712','207713','207714','207715','207716','207717','207718','207719','207720','207721','207722','207723','207724','207725','207726','207727','207728','207729','207730','207731','207732','207733','207734','207735','207736','207737','207738','207739','207740','207741','207742','207743','207744','207745','207746','207747','207748','207749','207750','207751','207752','207753','207754','207755','207756','207757','207758','207759','207760','207761','207762','207763','207764','207765','207766','207767','207768','207769','207770','207771','207772','207773','207774','207775','207776','207777','207778','207779','207780','207781','207782','207783','207784','207785','207786','207787','207788','207789','207790','207791','207792','207793','207794','207795','207796','207797','207798','207799','207800','207801','207802','207803','207804','211010','215551','215602','215760','215761','215985','216012','219135','219296','219330','219380','219381','219403','219476','219546','219719','219720','219723','219724','219725','219750','219768','219769','232502','232680','232681','238301','238318','238497','238865','239268','239294','239326','239455','239567','239676','239693','239695','239696','239698','239739','239797','239899','240036','240037','240039','240040','240041','240043','240069','240095','240202','240203','240204','240207','240289','240295','240645','240748','240749','240818','240924','240925','240926','240950','241006','241007','241071','241072','241107','241110','241111','241112','241113','241114','241264','241300','241490','241491','241502','241503','241514','241540','241541','241559','241560','241566','241567','241568','241570','241571','241583','241584','241586','241596','241893','241997','241999','242000','242001','242002','242003','242232','242233','242300','242311','242312','242313','242330','242391','242394','242395','242396','242397','242398','242400','242401','242470','242471','242477','242482','242483','242525','242526','242527','242528','242529','242560','242615','242653','242654','242772','242773','242824','242839','242881','242892','242949','242950','242961','242962','243086','243230','243231','243232','243233','243234','243255','243290','243291','243292','243504','243505','243566','243567','243568','243569','243570','243571','243572','243573','243574','243575','243576','243577','243578','243579','243580','243581','243582','243769','243770','243771','243863','243889','244048','244114','244119','244120','244121','244125','244305','244306','244389','244440','244453','244457','244458','244460','244647','244658','244659','244813','244814','244967','244994','244995','245001','245005','245014','245015','245016','245064','245213','245214','245215','245231','245232','245235','245236','245237','245238','245241','245242','245264','245265','245369','245370','245371','245372','245551','245779','245788','245857','245898','245911','245912','245956','246008','246055','246125','246186','246187','246204','246212','246213','246380','246435','246436','246533','246534','246656','246807','246827','246852','247051','247103','247104','247149','247158','247276','247279','247333','247380','247381','247443','247444','247456','247457','247458','247459','247460','247488','247575','247605','247606','247607','247608','247609','247610','247613','247614','247634','247638','247698','247701','247725','247784','247785','247876','247877','247919','247920','247988','247992','248060','248061','248062','248188','248189','248197','248198','248246','248250','248255','248300','248409','248476','248479','248544','248545','248566','248567','248572','248578','248579','248603','248613','248639','248640','248641','248732','248733','248734','248735','248821','248838','248893','248895','248896','248897','248924','248930','248968','249137','249253','249264','249269','249308','249309','249382','249388','249402','249416','249439','249578','249718','249719','249748','249750','249851','249875','249925','249992','250080','250213','250334','250630','250660','250678','250701','250704','250710','250729','250730','250807','250813','250861','250904','250919','250966','250967','250994','250995','250996','251078','251110','251171','251190','251259','251360','251367','251372','251400','251408','251639','251867','251927','251929','251939','251945','251949','251985','252017','252018','252019','252045','252066','252067','252093','253033','253036','253054','253055','253070','253081','253085','253088','253094','253114','253115','253140','253158','253167','253186','253259','253260','253278','253344','253345','253360','253392','253393','253402','253403','253522','253575','253655','253685','253686','253687','253784','253813','253823','253849','253862','253867','254244','254245','254246','254247','254345','254346','254347','254368','254586','254643','254645','254739','254774','254777','254792','254804','254806','254807','254824','254826','254828','254843','254844','254856','254926','254940','254963','254964','254965','255018','255208','255225','255289','255317','255397','255398','255495','255508','255514','255603','255605','255606','255607','255664','255708','255726','255731','255733','255734','255735','255736','255740','255741','255742','255773','255809','255852','255930','255931','255932','255933','255934','255935','255936','255937','255938','256015','256023','256218','256286','256308','256353','256427','256494','256516','256566','256567','256618','256788','256791','256818','256846','256872','257133','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261706','262073','262110','262119','262352','262357','262390','262391','262393','262503','262506','262529','262530','262531','262608','262625','262753','262755','262756','262792','262865','262866','262875','262876','262877','262878','262924','262978','262997','263059','263096','263117','263119','263121','263125','263140','263176','263519','263522','263582','263583','263586','263589','263590','263591','263592','263593','263594','263598','263599','263600','263651','263652','263653','263655','263672','263727','264387','264447','264630','264681','264682','264683','264704','264705','264714','264718','264729','264735','264737','264792','264793','264824','264963','265015','265022','265065','265136','265265','265274','265276','265277','265347','265348','265351','265402','265459','265488','265539','265556','265573','265600','265635','265659','265692','265706','265742','265763','265776','265807','265808','265993','266143','266241','266244','266285','266286','266287','266561','266616','266622','266627','266628','266629','266630','266631','266660','266667','266668','266675','266676','266677','266697','266791','266797','266798','266824','266827','267066','267067','267136','267189','267193','267194','267195','267196','267197','267198','267199','267200','267201','267202','267203','267239','267285','267392','267400','267413','267517','267582','267583','267584','267602','267627','267646','267699','267707','267708','267735','267756','267862','267863','267874','267902','267912','267929','267935','267942','267959','267988','267993','268124','268134','268142','268143','268144','268167','268211','268215','268218','268219','268220','268221','268237','268239','268250','268263','268264','268312','268313','268333','268334','268361','268395','268406','268415','268594','268601','268602','268617','268623','268661','268663','268676','268679','268707','268772','268790','268834','268876','268889','268892','268906','269029','269047','269064','269065','269084','269106','269184','269204','269206','269217','269244','269246','269247','269248','269327','269351','269352','269353','269428','269443','269522','269527','269530','269571','269750','273353','273359','273378','273415','273438','273461','273469','273470','273516','273536','273590','273605','273608','273616','273617','273646','273647','273654','273655','273667','273713','273723','273828','273829','273832','273902','273910','273926','273927','274052','274054','274055','274056','274057','274118','274145','274146','274288','274352','274443','274606','274612','274622','274679','274700','274703','274744','274745','274757','274764','274817','274818','274819','274837','274838','274839','274938','274939','275011','275015','275062','275073','275074','275075','275076','275089','275116','275121','275128','275129','275188','275199','275205','275247','275252','275263','275266','275298','275332','275473','275486','275537','275594','275665','275689','275749','275753','275819','275954','275955','275979','276059','276291','276340','276378','276379','276381','276483','276511','276531','276541','276556','276635','276676','276689','276690','276823','276827','276986','277012','277037','277038','277064','277065','277066','277189','277213','277289','277336','277370','277450','277507','277512','277513','277514','277523','277712','277763','277769','277771','277772','277828','277865','277935','278022','278059','278061','278062','278066','278079','278080','278081','278096','278162','278228','278229','278230','278231','278258','278279','278310','278312','278318','278322','278340','278398','278429','278433','278434','278435','278436','278526','278532','278555','278572','278583','278603','278695','278696','278716','278717','278718','278719','278720','278742','278812','278873','278874','278875','278947','279056','279057','279153','279180','279256','279257','279266','279273','279301','279399','279406','279411','279412','279426','279440','279481','279586','279701','279735','279737','279740','279741','279749','279763','279791','279820','280289','280297','280376','280391','280404','280405','280411','280412','280594','280595','280710','280810','280829','280832','280977','281030','281054','281110','281113','281172','281183','281184','281185','281216','281239','281334','281454','281467','281468','281471','281631','281632','281705','281707','281709','281710','281718','281731','281857','282063','282109','282172','282341','282342','282347','282434','282443','282445','282482','282488','282491','282523','282528','282790','282834','282851','282861','282902','283001','283115','283193','283212','283235','283239','283338','283382','283415','283520','283521','283577','283619','283646','283653','283763','284224','284292','284358','284410','284411','284418','284443','284444','284445','284448','284449','284450','284451','284452','284497','284592','284622','284651','284654','284900','284912','285024','285025','285081','285082','285200','285345','285382','285403','285455','285462','285495','285511','285512','285548','285566','285567','285568','285578','285584','285658','285713','285715','285736','285746','285790','285793','285794','285812','285851','285852','285853','285866','285908','285943','285950','286049','286068','286092','286097','286114','286115','286116','286117','286118','286191','286213','286252','286327','286450','286654','286655','286669','286670','286810','286829','286860','286913','286914','286915','286916','286917','286918','287001','287014','287030','287031','287047','287060','287061','287064','287065','287066','287067','287068','287069','287070','287071','287072','287073','287074','287075','287076','287077','287078','287079','287080','287081','287082','287083','287084','287085','287086','287087','287088','287089','287090','287091','287092','287093','287109','287110','287111','287113','287114','287115','287116','287117','287118','287119','287120','287121','287122','287140','287148','287165','287185','287224','287512','287513','287533','287534','287546','287550','287554','287787','287790','287973','287975','287977','287978','287980','288016','288082','288085','288086','288092','288163','288217','288222','288223','288224','288227','288234','288235','288270','288278','288279','288290','288299','288334','288350','288450','288454','288472','288499','288534','288565','288580','288589','288711','288757','288850','288860','288901','289034','289035','289036','289037','289038','289039','289040','289041','289044','289045','289046','289047','289048','289049','289050','289051','289052','289053','289204','289205','289206','289209','289222','289335','289374','289375','289404','289405','289412','289413','289449','289451','289455','289462','289481','289483','289484','289485','289486','289502','289506','291613','291674','291737','291808','291818','291846','291852','291884','291887','291900','292090','292298','292303','292369','292470','292474','292496','292525','292533','292567','292624','292755','292813','292825','292836','293199','293214','293228','293253','293285','293380','293404','293409','293457','293508','293519','293577','293604','293647','293648','293649','293886','293887','294013','294209','294246','294258','294259','294277','294297','294303','294305','294326','294327','294328','294383','294391','294428','294429','294482','294544','294576','294592','294593','294664','294768','294814','294869','294895','294904','294933','294962','295310','295311','295367','295417','295419','295511','295699','295705','295724','295725','295752','295767','295838','295846','296002','296003','296004','296005','296200','296279','297096','297122','297123','297124','297125','297131','297132','297181','297201','297202','297203','297205','297211','297223','297228','297229','297244','297299','297307','297308','297330','297425','297464','297557','297610','297612','297618','297619','297628','297647','297836','297838','297839','297840','297841','297842','297843','297844','297845','297846','297847','297848','297899','297933','297937','297993','298012','298021','298036','298037','298063','298069','298070','298100','298102','298104','298105','298106','298107','298113','298118','298164','298252','298318','298319','298326','298357','298358','298359','298360','298361','298378','298379','298406','298438','298444','298535','298549','298593','299038','299081','299082','299137','299165','299356','299436','299471','299472','299488','299499','299583','299594','299603','299604','299688','299697','299698','299737','299738','299771','299797','299825','299827','299865','299880','299985','299986','300047','300050','300080','300172','300224','300243','300383','300404','300650','300918','300921','300929','300990','300991','300992','300993','301055','301779','301780','301781','301782','301783','301790','301791','301805','301857','301898','301906','301907','301908','301909','301937','301999','302066','302181','302287','302298') GROUP BY `kol_kon` ORDER BY `kol_kon` ASC

SELECT `kol_kon`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `kol_kon` !='' AND `modx_site_content`.`id` IN ('141332','141333','141503','141821','141882','141883','141884','141886','142128','142209','142210','142211','142212','142213','142930','142943','143376','143385','143457','143513','143514','143515','143516','143517','143518','143519','143520','143521','143522','143523','143524','143525','143526','143527','143528','143529','143530','143531','143533','143534','143535','143537','143538','143539','143540','143541','143542','143543','143544','143545','143546','143547','143548','143549','143550','143551','143651','143734','143771','143785','143786','143789','143790','143791','143792','143794','143796','143798','143800','143803','143805','143811','143812','143813','143825','143918','144081','144230','146587','147021','147060','147241','147876','148128','148356','148588','148590','148618','148644','148645','148646','148647','148650','148659','148661','149123','149124','149125','149126','149127','149128','149129','149130','149131','149132','149133','149134','149135','149136','149137','149138','149139','149140','149141','149142','149143','149144','149145','149146','149147','149148','149149','149150','149151','149153','149154','149155','149156','149157','149159','149160','149161','149162','149163','149164','149165','149166','149167','149168','149169','149170','149171','149172','149173','149174','149175','149176','149177','149178','149179','149180','149181','149182','149183','149184','149185','149186','149187','149188','149189','149190','149191','149192','149193','149194','149195','149196','149197','149198','149199','149200','149201','149202','149203','149204','149205','149206','149207','149208','149209','149210','149211','149212','149213','149214','149215','149216','149217','149218','149219','149664','149694','150510','150581','150598','150599','150796','150833','151002','151458','151459','151469','151808','151868','151992','152526','152657','152662','153070','153086','153801','153803','154550','154580','154581','154583','154584','154587','154588','154590','154625','154626','154627','154642','154655','154656','154657','154658','154659','154675','154690','154691','154747','154796','154951','155023','155024','155025','155065','155087','155088','155089','155090','155091','155104','155155','155748','156313','156423','156424','156425','156426','156427','156428','156429','156430','156431','156432','156433','156434','156435','156436','156437','156439','156441','156443','156445','156447','156475','156476','156477','156478','156479','156480','156481','156482','156483','156484','156485','156486','156487','156488','156489','156502','156503','156504','156510','157640','157666','157777','158362','158416','158455','158557','158586','158655','158662','158794','158795','158801','158840','158951','158952','158953','159031','159145','159146','159282','159308','159315','159316','159333','159337','159389','159392','159436','159466','159541','159602','159603','159611','159795','159961','159988','160038','160115','160125','160126','160196','160214','160216','160217','160218','160255','160256','160266','160395','160467','160469','160470','160551','160562','160571','160606','160607','160618','160755','160761','160762','160763','160809','160844','161087','161157','161173','161197','161228','161543','161589','161724','161725','161726','161727','161756','161774','161775','161910','162009','162073','162074','162075','162076','162108','162109','162116','162117','162121','162122','162124','162177','162178','162283','162284','162291','162335','162375','162410','162429','162433','162579','162580','162635','162664','162754','162832','162924','162925','162965','162966','162985','163006','163017','163018','163026','163027','163031','163043','163114','163123','163132','163133','163135','163136','163290','163339','163395','163465','163547','163646','163723','163890','163891','163892','163922','163954','164094','164124','164269','164382','164385','164455','164456','164457','164511','164526','164665','164679','164937','164948','164996','165027','165032','165033','165034','165035','165053','165063','165082','165083','165420','165479','165488','165540','165544','165547','165565','165607','165687','165750','165915','165929','165936','166165','166315','166562','166645','166651','166670','166760','166880','167041','167073','167211','167316','167403','167426','167429','167500','167614','167634','167635','167640','167643','167664','167724','167725','167726','167727','167728','167729','167730','167731','167732','167733','167786','167831','167851','167909','167949','168033','168034','168035','168099','168115','168137','168239','168245','168266','168330','168335','168376','168393','168403','169094','169261','169262','169308','169350','170357','170358','170359','170360','170366','170367','170368','170369','170592','170593','170603','170615','202712','207394','207395','207396','207397','207398','207399','207400','207401','207402','207403','207404','207405','207406','207407','207408','207409','207410','207411','207412','207413','207414','207415','207416','207417','207418','207419','207420','207421','207422','207423','207424','207425','207426','207427','207428','207429','207430','207431','207432','207433','207434','207435','207436','207437','207438','207439','207440','207441','207442','207443','207444','207445','207446','207447','207448','207449','207450','207451','207452','207453','207454','207455','207456','207457','207458','207459','207460','207461','207462','207463','207464','207465','207466','207467','207468','207469','207470','207471','207472','207473','207474','207475','207476','207477','207478','207479','207480','207481','207482','207483','207484','207485','207486','207487','207488','207489','207490','207491','207492','207493','207494','207495','207496','207497','207498','207499','207500','207501','207502','207503','207504','207505','207506','207507','207508','207509','207510','207511','207512','207513','207514','207515','207516','207517','207518','207519','207520','207521','207522','207523','207524','207525','207526','207527','207528','207529','207530','207531','207532','207533','207534','207535','207536','207537','207538','207539','207540','207541','207542','207543','207544','207545','207546','207547','207548','207549','207550','207551','207552','207553','207554','207555','207556','207557','207558','207559','207560','207561','207562','207563','207564','207565','207566','207567','207568','207569','207571','207572','207573','207574','207575','207576','207577','207578','207579','207580','207581','207582','207583','207584','207585','207586','207587','207588','207589','207590','207591','207592','207593','207594','207595','207596','207597','207598','207599','207600','207601','207602','207603','207604','207606','207607','207608','207609','207610','207611','207612','207613','207614','207615','207616','207617','207618','207619','207620','207621','207622','207623','207624','207625','207626','207627','207628','207629','207630','207631','207632','207633','207634','207635','207636','207637','207638','207639','207640','207641','207642','207643','207644','207645','207646','207647','207648','207649','207650','207651','207652','207653','207654','207655','207656','207657','207658','207659','207660','207661','207662','207663','207664','207665','207666','207667','207668','207669','207670','207671','207672','207673','207674','207675','207676','207677','207678','207679','207680','207681','207682','207683','207684','207685','207686','207687','207688','207689','207690','207691','207692','207693','207694','207695','207696','207697','207698','207699','207700','207701','207702','207703','207704','207705','207706','207707','207708','207709','207710','207711','207712','207713','207714','207715','207716','207717','207718','207719','207720','207721','207722','207723','207724','207725','207726','207727','207728','207729','207730','207731','207732','207733','207734','207735','207736','207737','207738','207739','207740','207741','207742','207743','207744','207745','207746','207747','207748','207749','207750','207751','207752','207753','207754','207755','207756','207757','207758','207759','207760','207761','207762','207763','207764','207765','207766','207767','207768','207769','207770','207771','207772','207773','207774','207775','207776','207777','207778','207779','207780','207781','207782','207783','207784','207785','207786','207787','207788','207789','207790','207791','207792','207793','207794','207795','207796','207797','207798','207799','207800','207801','207802','207803','207804','211010','215551','215602','215760','215761','215985','216012','219135','219296','219330','219380','219381','219403','219476','219546','219719','219720','219723','219724','219725','219750','219768','219769','232502','232680','232681','238301','238318','238497','238865','239268','239294','239326','239455','239567','239676','239693','239695','239696','239698','239739','239797','239899','240036','240037','240039','240040','240041','240043','240069','240095','240202','240203','240204','240207','240289','240295','240645','240748','240749','240818','240924','240925','240926','240950','241006','241007','241071','241072','241107','241110','241111','241112','241113','241114','241264','241300','241490','241491','241502','241503','241514','241540','241541','241559','241560','241566','241567','241568','241570','241571','241583','241584','241586','241596','241893','241997','241999','242000','242001','242002','242003','242232','242233','242300','242311','242312','242313','242330','242391','242394','242395','242396','242397','242398','242400','242401','242470','242471','242477','242482','242483','242525','242526','242527','242528','242529','242560','242615','242653','242654','242772','242773','242824','242839','242881','242892','242949','242950','242961','242962','243086','243230','243231','243232','243233','243234','243255','243290','243291','243292','243504','243505','243566','243567','243568','243569','243570','243571','243572','243573','243574','243575','243576','243577','243578','243579','243580','243581','243582','243769','243770','243771','243863','243889','244048','244114','244119','244120','244121','244125','244305','244306','244389','244440','244453','244457','244458','244460','244647','244658','244659','244813','244814','244967','244994','244995','245001','245005','245014','245015','245016','245064','245213','245214','245215','245231','245232','245235','245236','245237','245238','245241','245242','245264','245265','245369','245370','245371','245372','245551','245779','245788','245857','245898','245911','245912','245956','246008','246055','246125','246186','246187','246204','246212','246213','246380','246435','246436','246533','246534','246656','246807','246827','246852','247051','247103','247104','247149','247158','247276','247279','247333','247380','247381','247443','247444','247456','247457','247458','247459','247460','247488','247575','247605','247606','247607','247608','247609','247610','247613','247614','247634','247638','247698','247701','247725','247784','247785','247876','247877','247919','247920','247988','247992','248060','248061','248062','248188','248189','248197','248198','248246','248250','248255','248300','248409','248476','248479','248544','248545','248566','248567','248572','248578','248579','248603','248613','248639','248640','248641','248732','248733','248734','248735','248821','248838','248893','248895','248896','248897','248924','248930','248968','249137','249253','249264','249269','249308','249309','249382','249388','249402','249416','249439','249578','249718','249719','249748','249750','249851','249875','249925','249992','250080','250213','250334','250630','250660','250678','250701','250704','250710','250729','250730','250807','250813','250861','250904','250919','250966','250967','250994','250995','250996','251078','251110','251171','251190','251259','251360','251367','251372','251400','251408','251639','251867','251927','251929','251939','251945','251949','251985','252017','252018','252019','252045','252066','252067','252093','253033','253036','253054','253055','253070','253081','253085','253088','253094','253114','253115','253140','253158','253167','253186','253259','253260','253278','253344','253345','253360','253392','253393','253402','253403','253522','253575','253655','253685','253686','253687','253784','253813','253823','253849','253862','253867','254244','254245','254246','254247','254345','254346','254347','254368','254586','254643','254645','254739','254774','254777','254792','254804','254806','254807','254824','254826','254828','254843','254844','254856','254926','254940','254963','254964','254965','255018','255208','255225','255289','255317','255397','255398','255495','255508','255514','255603','255605','255606','255607','255664','255708','255726','255731','255733','255734','255735','255736','255740','255741','255742','255773','255809','255852','255930','255931','255932','255933','255934','255935','255936','255937','255938','256015','256023','256218','256286','256308','256353','256427','256494','256516','256566','256567','256618','256788','256791','256818','256846','256872','257133','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261706','262073','262110','262119','262352','262357','262390','262391','262393','262503','262506','262529','262530','262531','262608','262625','262753','262755','262756','262792','262865','262866','262875','262876','262877','262878','262924','262978','262997','263059','263096','263117','263119','263121','263125','263140','263176','263519','263522','263582','263583','263586','263589','263590','263591','263592','263593','263594','263598','263599','263600','263651','263652','263653','263655','263672','263727','264387','264447','264630','264681','264682','264683','264704','264705','264714','264718','264729','264735','264737','264792','264793','264824','264963','265015','265022','265065','265136','265265','265274','265276','265277','265347','265348','265351','265402','265459','265488','265539','265556','265573','265600','265635','265659','265692','265706','265742','265763','265776','265807','265808','265993','266241','266244','266285','266286','266287','266561','266616','266622','266627','266628','266629','266630','266631','266660','266667','266668','266675','266676','266677','266697','266791','266797','266798','266824','266827','267066','267067','267136','267189','267193','267194','267195','267196','267197','267198','267199','267200','267201','267202','267203','267239','267285','267392','267400','267413','267517','267582','267583','267584','267602','267627','267646','267699','267707','267708','267735','267756','267862','267863','267874','267902','267912','267929','267935','267942','267959','267988','267993','268124','268134','268142','268143','268144','268167','268211','268215','268218','268219','268220','268221','268237','268239','268250','268263','268264','268312','268313','268333','268334','268361','268395','268406','268415','268594','268601','268602','268617','268623','268661','268663','268676','268679','268707','268772','268790','268834','268876','268889','268892','268906','269029','269047','269064','269065','269084','269106','269184','269204','269206','269217','269244','269246','269247','269248','269327','269351','269352','269353','269428','269443','269522','269527','269530','269571','269750','273353','273359','273378','273415','273438','273461','273469','273470','273516','273536','273590','273605','273608','273616','273617','273646','273647','273654','273655','273667','273713','273723','273828','273829','273832','273902','273910','273926','273927','274052','274054','274055','274056','274057','274118','274145','274146','274288','274352','274443','274606','274612','274622','274679','274700','274703','274744','274745','274757','274764','274817','274818','274819','274837','274838','274839','274938','274939','275011','275015','275062','275073','275074','275075','275076','275089','275116','275121','275128','275129','275188','275199','275205','275247','275252','275263','275266','275298','275332','275473','275486','275537','275594','275665','275689','275749','275753','275819','275954','275955','275979','276059','276291','276340','276378','276379','276381','276483','276511','276531','276541','276556','276635','276676','276689','276690','276823','276827','276986','277012','277037','277038','277064','277065','277066','277189','277213','277289','277336','277370','277450','277507','277512','277513','277514','277523','277712','277763','277769','277771','277772','277828','277865','277935','278022','278059','278061','278062','278066','278079','278080','278081','278096','278162','278228','278229','278230','278231','278258','278279','278310','278312','278318','278322','278340','278398','278429','278433','278434','278435','278436','278526','278532','278555','278572','278583','278603','278695','278696','278716','278717','278718','278719','278720','278742','278812','278873','278874','278875','278947','279056','279057','279153','279180','279256','279257','279266','279273','279301','279399','279406','279411','279412','279426','279440','279481','279586','279701','279735','279737','279740','279741','279749','279763','279791','279820','280289','280297','280376','280391','280404','280405','280411','280412','280594','280595','280710','280810','280829','280832','280977','281030','281054','281110','281113','281172','281183','281184','281185','281216','281239','281334','281454','281467','281468','281471','281631','281632','281705','281707','281709','281710','281718','281731','281857','282063','282109','282172','282341','282342','282347','282434','282443','282445','282482','282488','282491','282523','282528','282790','282834','282851','282861','282902','283001','283115','283193','283212','283235','283239','283338','283382','283415','283520','283521','283577','283619','283646','283653','283763','284224','284292','284358','284410','284411','284418','284443','284444','284445','284448','284449','284450','284451','284452','284497','284592','284622','284651','284654','284900','284912','285024','285025','285081','285082','285200','285345','285382','285403','285455','285462','285495','285511','285512','285548','285566','285567','285568','285578','285584','285658','285713','285715','285736','285746','285790','285793','285794','285812','285851','285852','285853','285866','285908','285943','285950','286049','286068','286092','286097','286114','286115','286116','286117','286118','286191','286213','286252','286327','286450','286654','286655','286669','286670','286810','286829','286860','286913','286914','286915','286916','286917','286918','287001','287014','287030','287031','287047','287060','287061','287064','287065','287066','287067','287068','287069','287070','287071','287072','287073','287075','287076','287077','287078','287079','287080','287081','287082','287083','287084','287085','287086','287087','287088','287089','287090','287091','287092','287093','287109','287110','287111','287113','287114','287115','287116','287117','287118','287119','287120','287121','287122','287140','287148','287165','287185','287224','287512','287513','287533','287534','287546','287550','287554','287787','287790','287973','287975','287977','287978','287980','288016','288082','288085','288086','288092','288163','288217','288222','288223','288224','288227','288234','288235','288270','288278','288279','288290','288299','288334','288350','288450','288454','288472','288499','288534','288565','288580','288589','288711','288757','288850','288860','288901','289034','289035','289036','289037','289038','289039','289040','289041','289044','289045','289046','289047','289048','289049','289050','289051','289052','289053','289204','289205','289206','289209','289222','289335','289374','289375','289404','289405','289413','289449','289451','289455','289462','289481','289483','289484','289485','289486','289502','289506','291613','291674','291737','291808','291818','291846','291852','291884','291887','291900','292090','292298','292303','292369','292470','292474','292496','292525','292533','292567','292624','292755','292813','292825','292836','293199','293214','293228','293253','293285','293380','293404','293409','293457','293508','293519','293577','293604','293647','293648','293649','293886','293887','294013','294209','294246','294258','294259','294277','294297','294303','294305','294326','294327','294328','294383','294391','294428','294429','294482','294544','294576','294592','294593','294664','294768','294814','294869','294895','294904','294933','294962','295310','295311','295367','295417','295419','295511','295699','295705','295724','295725','295752','295767','295838','295846','296002','296003','296004','296005','296200','296279','297096','297122','297123','297124','297125','297131','297132','297181','297201','297202','297203','297205','297211','297223','297228','297229','297244','297299','297307','297308','297330','297425','297464','297557','297610','297612','297618','297619','297628','297647','297836','297838','297839','297840','297841','297842','297843','297844','297845','297846','297847','297848','297899','297933','297937','297993','298012','298021','298036','298037','298063','298069','298070','298100','298102','298104','298105','298106','298107','298113','298118','298164','298252','298318','298319','298326','298357','298358','298359','298360','298361','298378','298379','298406','298438','298444','298535','298549','298593','299038','299081','299082','299137','299165','299356','299436','299471','299472','299488','299499','299583','299594','299603','299604','299688','299697','299698','299737','299738','299771','299797','299825','299827','299865','299880','299985','299986','300047','300050','300080','300172','300224','300243','300383','300404','300650','300918','300921','300929','300990','300991','300992','300993','301055','301779','301780','301781','301782','301783','301790','301791','301805','301857','301898','301906','301907','301908','301909','301937','301999','302066','302181','302287','302298') GROUP BY `kol_kon` ORDER BY `kol_kon` ASC