Заказы

KLS Electronic

www.klsele.com

 

KLSKLS Electronic (KLS) была основана в 2002 г. в настоящее время компания входит в десятку крупнейших компаний по производству электронных компонентов в Китае.

KLS располагает современными производственными и научно-исследовательскими базами в Чжэцзяне, Шанхае, Цзянсу, Шэньчжэне и Дунгуане в Китае.

KLS является холдингом в собственности которого более 10 различных компаний.

Компания KLS получила сертификаты системы менеджмента ISO9001. Продукция KLS была одобрена UL, VDE, TUV, CE, CQC, RoHS, REACH.

Партнёрами KLS являются многие компании из списка Fortune 500 и ведущие компании во многих отраслях. Продукция KLS продается более чем в 30 странах и регионах.  

KLS гордится своим автоматизированным производством, технологиями создания пресс-форм, а также передовыми технологиями контроля качества, позволяющими создавать продукты с высокой надежностью и долговечностью; в то же время у KLS есть широкие возможности по изготовлению продуктов под специальные требования заказчика (кастомизация).

KLS предоставляет универсальные решения для различных отраслей промышленности, таких как промышленная автоматизация, приборостроение, энергетика, железнодорожный транспорт, судостроение, лифты, освещение, безопасность, машиностроение и т.д.

 

Продуктовая линейка: ОБЗОРНЫЙ КАТАЛОГ- СКАЧАТЬ.

Электромеханические изделия: интерфейсные разъемы, внутрисистемные разъемы, силовые разъемы, клеммы и клеммные колодки, наконечники, кнопки и переключатели, кабели и кабельные вводы, держатели и слоты для батарей, карты памяти и предохранителей, вентиляторы, звукоизлучатели.

Радиочастотные разъемы: (SMA, SMB, BNC, MMCX, MCX, коннекторы F и N типов).

Оптоэлектронные изделия: светодиоды, светодиодные (LED) дисплеи, LCD модули.

Моточные изделия: Индуктивности (DIP, SMD), Трансформаторы, дроссели.

Пассивные компоненты: предохранители, варисторы, конденсаторы, резисторы. Полупроводниковые компоненты: (транзисторы, MOSFETs, диоды, выпрямительные мосты)

Радиаторы.

Стойки.

Корпуса.

Линейка KLS станет заменой популярным позициям производства Wago, Hirose, JST, Amphenol, TE Connectivity, Samtec, Cvilux, Hsuan Mao, Phoenix Contact, Weildmueller, Omron, Molex.

Компания обладает сертификатами соответствия стандартам UL, VDE, TUV, EXCE, CQC, RoHS, REACH;

В 2013 году все производственные, складские и логистические операции компании сертифицированы по ISO9001.

Цена, руб.
Поиск по ключевому слову
Статус наличия
Категория
Серия
11
childsstroke: stock_status
SELECT `stock_status`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `stock_status` !='' AND `modx_site_content`.`id` IN ('152640','152642','152644','152650','152651','152655','152660','152662','153090','153093','153096','153103','153105','153106','153107','153108','153109','153116','153118','153121','153122','153139','153375','153384','153385','153386','153387','153388','153389','153390','153391','153415','153416','153417','153418','153419','153420','153421','153422','153423','153424','153426','153430','153569','153571','153575','153576','153577','153585','153587','153590','153591','153592','153595','153596','153598','153599','153621','153627','153635','153639','153653','153654','153773','153798','153799','153800','153801','153802','153803','153809','153820','153824','153880','153904','153905','153906','153907','153908','153909','153910','153923','153931','154132','154133','154134','154168','154245','154257','154279','154321','154322','154332','154333','154334','154335','154336','154337','154338','154339','154340','154341','154348','154471','154472','154488','154514','154515','154529','154530','154533','154547','154548','154567','154570','154571','154580','154581','154583','154584','154587','154588','154590','154594','154598','154607','154608','154609','154610','154629','154633','154642','154655','154656','154657','154658','154659','154661','154679','154711','154712','154713','154715','154716','154717','154718','154730','154731','154736','154747','154749','154790','154791','154792','154793','154794','154795','154796','154797','154825','154834','154835','154854','154855','154877','154884','154885','154886','154906','154907','154928','154952','154990','154991','154992','155029','155031','155054','155055','155056','155057','155058','155059','155060','155061','155062','155063','155065','155066','155067','155068','155069','155070','155071','155104','155105','155109','155110','155111','155112','155113','155114','155115','155121','155150','155151','155152','155153','155154','155155','155159','155160','155199','155265','155266','155267','155268','155269','155270','155271','155272','155273','155274','155275','155281','155286','155288','155302','155303','155520','155648','155653','155655','155656','155657','155801','155812','155867','156258','156260','156261','156267','156285','156286','156314','156315','156317','156320','156321','156322','156323','156324','156326','156327','156328','156329','156334','156335','156336','156337','156338','156339','156340','156341','156342','156343','156344','156345','156346','156347','156348','156352','156353','156354','156355','156356','156357','156358','156359','156360','156379','156380','156381','156382','156383','156384','156385','156388','156392','156394','156395','156396','156397','156398','156399','156400','156401','156402','156403','156404','156406','156407','156408','156409','156410','156411','156412','156413','156414','156415','156418','156419','156420','156421','156422','156423','156424','156425','156426','156427','156428','156429','156430','156431','156432','156433','156434','156435','156436','156437','156439','156441','156443','156445','156447','156451','156452','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156465','156466','156467','156468','156469','156470','156471','156472','156473','156474','156475','156476','156477','156478','156479','156480','156481','156482','156483','156484','156485','156486','156487','156490','156491','156492','156493','156494','156495','156497','156498','156499','156500','156502','156503','156504','156505','156506','156507','156508','156509','156511','156512','156513','156514','156515','156516','156517','156518','156520','156521','156522','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','156631','156633','156634','156779','156780','156789','156790','156791','156792','156793','156794','156795','156796','156797','156799','156800','156801','156802','156803','156804','156805','156806','156873','156874','156909','156912','156913','156914','156915','156916','156917','156918','156919','156920','156921','156922','156923','156924','156925','156926','156927','156928','156929','156930','156931','156932','156933','156934','156935','156936','156937','156941','156942','156945','156946','156947','156954','156955','156956','157010','157225','157226','157227','157228','157229','157230','157231','157258','157259','157261','157263','157264','157265','157270','157271','157275','157285','157288','157289','157290','157291','157292','157293','157294','157295','157296','157297','157408','157423','157424','157425','157426','157427','157428','157429','157430','157431','157432','157436','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157460','157463','157464','157465','157466','157468','157469','157470','157471','157472','157473','157474','157475','157476','157501','157502','157504','157505','157506','157510','157548','157553','157587','157711','157728','157729','157733','157740','157761','157762','157763','157782','157841','157844','157895','157896','157897','157902','157903','157961','157989','157991','157992','157999','158000','158005','158022','158023','158031','158146','158233','158249','158250','158262','158263','158292','158339','158350','158381','158398','158399','158400','158417','158423','158424','158550','158586','158613','158662','158757','158762','158767','158776','158777','158794','158795','158810','158811','158813','158826','158841','158842','158843','158844','158845','158846','158856','158955','158971','159003','159009','159010','159019','159028','159029','159030','159078','159079','159097','159098','159121','159143','159145','159146','159148','159149','159151','159152','159153','159154','159155','159156','159205','159225','159237','159253','159255','159314','159340','159341','159342','159343','159344','159345','159346','159347','159348','159349','159350','159351','159352','159353','159354','159355','159356','159357','159362','159369','159377','159390','159424','159450','159474','159475','159476','159527','159528','159529','159534','159552','159561','159570','159666','159667','159668','159706','159815','159913','159916','159917','159986','159987','159988','160038','160049','160058','160098','160100','160125','160126','160137','160208','160209','160216','160217','160218','160288','160302','160310','160316','160317','160345','160347','160363','160364','160365','160366','160367','160373','160374','160381','160401','160403','160413','160421','160430','160441','160488','160490','160504','160505','160557','160558','160559','160560','160580','160582','160618','160650','160651','160652','160682','160683','160742','160743','160744','160754','160761','160762','160763','160797','160821','160864','160865','160866','160894','160895','160933','160952','161047','161136','161142','161143','161144','161145','161182','161221','161222','161229','161230','161231','161233','161234','161235','161236','161237','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161359','161380','161383','161421','161428','161437','161438','161444','161445','161457','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161478','161479','161529','161548','161549','161550','161551','161552','161588','161593','161598','161606','161613','161614','161617','161619','161630','161631','161632','161633','161634','161644','161667','161668','161669','161670','161708','161709','161797','161798','161809','161824','161825','161834','161886','161893','161894','161895','161903','161904','161905','161906','161907','161912','161933','161934','161935','161956','161979','161980','162029','162030','162031','162032','162049','162080','162081','162220','162227','162269','162270','162271','162272','162285','162295','162305','162306','162307','162308','162335','162349','162360','162391','162410','162414','162415','162416','162417','162419','162420','162422','162447','162449','162479','162480','162481','162492','162493','162494','162495','162529','162530','162547','162548','162555','162556','162557','162558','162559','162560','162570','162579','162580','162633','162667','162714','162739','162748','162782','162787','162816','162832','162876','162935','162936','162942','163028','163053','163103','163108','163109','163110','163111','163112','163113','163123','163153','163154','163181','163231','163232','163233','163234','163288','163289','163294','163295','163321','163344','163466','163467','163529','163540','163541','163616','163617','163618','163620','163662','163676','163703','163723','163779','163780','163781','163782','163802','163828','163868','163878','163880','163890','163891','163892','163954','163963','163982','164009','164029','164052','164094','164124','164131','164132','164133','164134','164135','164140','164141','164142','164159','164160','164167','164233','164238','164247','164316','164422','164427','164433','164485','164499','164511','164514','164521','164522','164527','164534','164543','164545','164546','164553','164556','164557','164560','164561','164562','164563','164564','164565','164566','164567','164568','164596','164624','164656','164671','164672','164673','164679','164693','164733','164734','164736','164756','164757','164758','164759','164760','164761','164762','164763','164771','164805','164808','164809','164810','164835','164853','164875','164886','164919','164932','164957','164958','164992','165000','165004','165005','165016','165017','165030','165032','165033','165034','165035','165053','165065','165078','165080','165091','165131','165134','165147','165151','165152','165153','165154','165155','165156','165157','165162','165227','165244','165288','165289','165290','165291','165292','165305','165347','165348','165362','165408','165420','165479','165480','165491','165502','165514','165517','165524','165530','165539','165542','165550','165563','165564','165565','165574','165581','165672','165673','165676','165679','165691','165731','165750','165779','165840','165841','165858','165859','165860','165861','165862','165863','165864','165865','165866','165867','165868','165895','165896','165897','165906','165915','165936','165939','165957','165958','165959','165972','165973','165974','165975','165976','165983','166054','166082','166083','166084','166112','166135','166136','166137','166138','166165','166191','166192','166193','166194','166195','166251','166324','166325','166326','166444','166447','166451','166472','166492','166510','166521','166523','166524','166585','166586','166587','166588','166589','166670','166674','166675','166685','166719','166720','166721','166722','166723','166724','166731','166763','166764','166787','166792','166848','166855','166858','166871','166880','166884','166885','166889','166905','166906','166919','166928','166983','167001','167041','167073','167077','167092','167096','167107','167109','167110','167111','167112','167113','167117','167147','167148','167149','167150','167151','167152','167161','167210','167217','167262','167263','167292','167298','167308','167389','167403','167406','167412','167483','167553','167578','167585','167586','167620','167630','167641','167643','167648','167649','167664','167707','167708','167739','167740','167760','167769','167784','167828','167833','167851','167852','167862','167871','167900','167903','167920','167949','168009','168051','168055','168239','168324','168325','168335','168340','168394','168403','169267','219748','219753','232438','232444','232461','232462','232518','232519','232561','232578','232603','232732','232780','238104','238235','238263','238264','238265','238284','238285','238286','238303','238304','238305','238406','238411','238438','238443','238450','238459','238512','238520','238528','238538','238539','238556','238567','238579','238712','238716','238717','238718','238724','238725','238734','238736','238762','238810','238832','238851','238852','238853','238854','238855','238856','238857','238858','238962','239170','239207','239217','239220','239312','239332','239514','239554','239590','239627','239818','239901','239947','240496','240571','240572','240573','240574','240575','240586','240717','240744','240875','240876','240877','240898','240924','240925','240926','240927','240989','240990','240991','240992','241279','241408','241864','241870','241871','242017','242018','242019','242020','242212','242248','242249','242250','242252','242253','242339','242443','242506','242706','242858','242902','242906','242939','242940','242941','242942','242992','242993','242994','242995','243025','243145','243146','243744','243841','243842','243845','243846','243863','243988','244106','244135','244180','244223','244224','244266','244324','244436','244548','244549','244562','244704','244780','244781','244782','244783','244784','244785','244809','244810','244811','244926','244967','245070','245073','245158','245170','245220','245221','245239','245240','245267','245268','245269','245292','245293','245294','245295','245296','245297','245391','245392','245394','245395','245396','245397','245398','245399','245400','245401','245402','245403','245404','245405','245406','245419','245493','245495','245543','245586','245587','245588','245600','245609','245778','245887','245931','245996','246063','246100','246185','246213','246252','246253','246254','246363','246443','246536','246583','246584','246585','246586','246629','246652','246667','246778','246792','246828','246919','246994','247039','247119','247120','247121','247122','247123','247124','247125','247126','247127','247128','247129','247130','247131','247132','247133','247134','247192','247196','247197','247487','247488','247497','247512','247535','247536','247599','247605','247606','247607','247608','247609','247610','247638','247674','247852','247853','247854','247855','247892','248086','248138','248168','248187','248188','248189','248199','248281','248300','248312','248315','248364','248399','248403','248404','248405','248406','248430','248446','248539','248544','248545','248596','248642','248744','248745','248913','248930','248940','248941','248950','248951','249007','249151','249166','249237','249253','249263','249302','249320','249346','249355','249356','249410','249412','249416','249418','249495','249496','249497','249541','249644','249663','249664','249685','249686','249687','249688','249716','249750','249770','249771','249784','249815','249862','249863','249896','249909','249913','249914','249922','250096','250099','250101','250126','250130','250149','250158','250159','250192','250213','250218','250292','250302','250303','250304','250305','250306','250307','250308','250309','250310','250311','250312','250313','250314','250315','250316','250317','250318','250319','250320','250321','250322','250328','250330','250348','250355','250356','250357','250358','250359','250360','250361','250362','250363','250364','250365','250366','250367','250368','250369','250370','250371','250372','250373','250374','250375','250376','250377','250378','250379','250380','250381','250382','250383','250384','250385','250386','250387','250388','250389','250390','250391','250392','250393','250394','250395','250396','250397','250398','250399','250400','250401','250402','250403','250404','250405','250406','250407','250408','250409','250410','250411','250412','250413','250414','250415','250416','250417','250418','250419','250420','250421','250422','250423','250424','250425','250426','250427','250428','250429','250430','250431','250432','250433','250434','250435','250436','250437','250438','250439','250440','250441','250442','250443','250444','250445','250446','250447','250448','250501','250502','250503','250504','250505','250525','250660','250702','250704','250756','250767','250772','250794','250796','250797','250803','250919','250966','251022','251137','251156','251172','251191','251217','251218','251219','251220','251221','251227','251252','251255','251257','251258','251259','251260','251280','251286','251344','251350','251408','251476','251520','251521','251522','251539','251550','251554','251555','251556','251557','251569','251577','251596','251597','251598','251599','251600','251602','251603','251604','251605','251606','251607','251633','251638','251639','251641','251669','251695','251733','251747','251759','251794','251795','251836','251837','251850','251867','251920','251945','251946','251947','251985','252010','252021','252045','252066','252089','252091','252093','252110','253033','253088','253125','253127','253128','253129','253136','253167','253231','253239','253241','253242','253246','253252','253253','253254','253259','253260','253263','253325','253326','253361','253392','253393','253394','253397','253398','253424','253463','253481','253488','253489','253490','253491','253513','253514','253515','253516','253517','253518','253519','253522','253537','253564','253586','253587','253588','253589','253592','253631','253638','253659','253737','253784','253792','253801','253802','253831','253832','253846','253849','253873','253874','253875','253876','253877','254196','254244','254245','254246','254247','254398','254399','254409','254410','254411','254412','254426','254459','254472','254545','254560','254561','254562','254586','254643','254748','254749','254750','254751','254752','254753','254754','254755','254756','254757','254917','254948','254991','255000','255018','255025','255078','255079','255080','255081','255193','255223','255225','255245','255344','255368','255372','255397','255398','255454','255505','255518','255605','255606','255607','255623','255638','255668','255731','255732','255733','255734','255735','255736','255740','255741','255742','255770','255809','255818','255819','255820','255821','255822','255823','255824','255825','255826','255827','255828','255829','255830','255831','255832','255833','255834','255835','255895','255896','255897','255898','255899','255900','255901','255902','255903','255904','255905','255906','255907','255908','255909','255910','255911','255912','255913','255914','255915','255916','255917','255918','255919','255920','255921','255922','255923','255924','255925','255926','255927','255928','255929','255930','255931','255932','255933','255934','255935','255936','255937','255938','255940','256103','256109','256110','256112','256122','256188','256277','256278','256279','256280','256282','256283','256284','256285','256286','256287','256288','256289','256290','256291','256292','256293','256294','256295','256296','256297','256298','256308','256317','256328','256329','256340','256343','256344','256499','256500','256507','256508','256515','256537','256539','256547','256668','256674','256675','256705','256759','256782','256783','256784','256853','256902','256904','256905','256922','256923','256931','257012','257013','257015','257016','257017','257018','257019','257021','257022','257023','257024','257025','257026','257028','257044','257045','257046','257047','257048','257049','257050','257051','257068','257117','257118','257155','257168','257169','257178','257180','257181','257192','257193','257194','257195','257197','257198','257199','257200','257201','257202','257203','257204','257205','257206','257207','257208','257209','257210','257211','257235','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261768','261936','261941','261949','261955','261956','261975','261989','262000','262032','262074','262082','262085','262086','262087','262106','262155','262188','262241','262383','262390','262440','262441','262442','262443','262444','262445','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262480','262481','262482','262483','262484','262485','262486','262487','262488','262489','262490','262491','262492','262493','262494','262495','262496','262497','262498','262499','262506','262520','262561','262608','262617','262628','262629','262630','262631','262632','262633','262634','262635','262636','262637','262638','262653','262720','262721','262738','262739','262740','262741','262742','262743','262744','262745','262746','262747','262748','262749','262750','262751','262756','262760','262783','262792','262796','262822','262823','262836','262837','262838','262839','262840','262841','262842','262843','262844','262845','262846','262847','262848','262849','262850','262851','262867','262881','262896','262898','262935','262995','262997','263085','263196','263469','263474','263507','263543','263550','263551','263635','263637','263642','263643','263651','263652','263653','263715','263754','264348','264503','264504','264505','264657','264658','264704','264705','264777','264797','264932','264934','265015','265017','265045','265063','265065','265068','265124','265125','265156','265167','265194','265195','265282','265283','265284','265319','265321','265361','265390','265429','265430','265437','265448','265520','265581','265657','265674','265675','265700','265742','265762','265776','265783','265805','265806','265917','265953','266148','266162','266245','266352','266353','266356','266408','266416','266417','266418','266419','266420','266421','266422','266423','266424','266425','266426','266427','266428','266429','266548','266582','266594','266684','266685','266686','266804','266823','266895','266988','266989','266990','267016','267024','267065','267084','267085','267089','267133','267134','267148','267169','267190','267191','267192','267193','267194','267195','267196','267197','267198','267199','267200','267201','267202','267203','267205','267206','267215','267288','267345','267356','267404','267409','267419','267420','267497','267514','267551','267565','267566','267577','267618','267664','267750','267751','267869','267959','267976','267977','268073','268141','268232','268234','268246','268247','268250','268309','268320','268352','268359','268361','268372','268374','268375','268395','268410','268412','268450','268455','268456','268484','268513','268515','268520','268523','268561','268562','268603','268705','268724','268781','268898','269031','269043','269047','269077','269106','269110','269111','269113','269149','269152','269153','269180','269204','269206','269244','269246','269247','269248','269249','269250','269251','269252','269393','269441','269470','269475','269476','269477','269478','269479','269480','269512','269513','269514','269520','269527','269557','273337','273338','273359','273370','273428','273439','273464','273472','273490','273506','273536','273588','273589','273699','273713','273723','273828','273829','273832','273844','273892','273893','273946','273960','273974','274139','274141','274278','274298','274327','274397','274398','274399','274400','274419','274443','274477','274592','274604','274607','274615','274616','274628','274657','274658','274672','274679','274682','274695','274697','274764','274778','274800','274817','274828','274836','274837','274838','274839','274840','274888','274894','274905','274912','274990','274991','275073','275074','275075','275076','275228','275248','275298','275395','275421','275458','275494','275499','275522','275555','275566','275604','275619','275655','275662','275663','275689','275692','275753','275757','275783','275822','275823','275977','276010','276059','276070','276087','276130','276145','276216','276217','276218','276255','276286','276287','276289','276290','276339','276349','276385','276388','276389','276398','276409','276410','276411','276412','276413','276414','276416','276473','276474','276481','276514','276515','276534','276546','276547','276548','276549','276550','276572','276607','276613','276614','276615','276638','276697','276700','276940','276972','276973','276993','277016','277018','277035','277037','277038','277070','277175','277176','277196','277207','277250','277255','277264','277265','277266','277289','277304','277306','277308','277313','277336','277358','277384','277397','277430','277439','277440','277441','277442','277443','277444','277445','277460','277461','277462','277474','277493','277524','277525','277526','277527','277528','277529','277530','277531','277584','277633','277645','277647','277648','277689','277712','277749','277750','277777','277791','277809','277915','277916','277917','277938','277939','277953','278054','278058','278075','278102','278103','278128','278142','278163','278164','278188','278221','278224','278240','278242','278318','278379','278429','278445','278446','278480','278507','278542','278560','278566','278572','278640','278754','278774','278850','278851','278900','278901','278950','279013','279023','279057','279059','279094','279100','279134','279207','279226','279295','279301','279336','279422','279440','279469','279479','279582','279585','279698','279705','279732','279735','279740','280303','280305','280369','280374','280375','280380','280381','280382','280386','280428','280450','280491','280492','280709','280723','280728','280729','280760','280761','280773','280778','280805','280808','280810','280832','280850','280855','280943','280944','280945','280979','281034','281056','281091','281133','281143','281144','281145','281146','281150','281151','281180','281195','281224','281230','281232','281235','281243','281268','281278','281336','281339','281473','281489','281651','281652','281689','281764','281770','281774','281776','281777','281865','282074','282144','282164','282165','282167','282168','282172','282190','282275','282295','282341','282342','282402','282476','282483','282521','282541','282572','282670','282767','282813','282843','282868','282902','282945','283001','283219','283225','283226','283227','283228','283313','283380','283504','283505','283542','283555','283597','283598','283599','283600','283611','283622','283623','283630','283634','283635','283730','283735','283736','283737','283763','284140','284284','284312','284356','284415','284441','284443','284444','284445','284504','284505','284506','284507','284508','284528','284550','284562','284599','284625','284644','284662','284745','284831','284836','284860','284896','284900','284914','284948','285024','285098','285106','285169','285177','285230','285247','285248','285249','285270','285334','285378','285379','285395','285403','285429','285444','285566','285578','285579','285591','285592','285593','285622','285627','285676','285677','285707','285732','285733','285734','285742','285793','285794','285795','285833','285903','285934','285984','286014','286028','286034','286062','286068','286120','286162','286199','286206','286344','286349','286358','286373','286400','286444','286640','286816','286860','286867','286873','286899','286913','286914','286915','286916','286917','286918','287011','287030','287031','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','287110','287111','287113','287114','287115','287116','287117','287118','287119','287120','287121','287122','287140','287141','287173','287202','287218','287557','287780','287782','287980','287982','287988','287995','288025','288026','288139','288163','288172','288173','288174','288175','288176','288177','288186','288217','288232','288234','288235','288260','288275','288299','288316','288351','288357','288358','288414','288416','288422','288441','288444','288470','288474','288477','288478','288480','288506','288534','288577','288580','288625','288663','288702','288709','288994','289011','289034','289035','289036','289037','289038','289039','289040','289041','289044','289045','289046','289047','289048','289049','289050','289051','289052','289053','289221','289227','289413','289466','289476','289483','289484','289485','289486','291708','291709','291711','291736','291744','291818','291864','291868','291869','291877','291878','291938','291947','291974','291975','291986','291987','291988','292007','292223','292224','292225','292245','292276','292304','292308','292309','292311','292312','292313','292323','292324','292339','292340','292341','292342','292343','292344','292362','292376','292399','292410','292411','292486','292492','292493','292511','292530','292531','292597','292607','292608','292609','292610','292611','292612','292621','292623','292654','292662','292692','292735','292736','292737','292738','292739','292744','292745','292746','292747','292748','292776','292839','292904','293209','293210','293231','293281','293282','293369','293373','293374','293403','293404','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','293451','293491','293519','293527','293558','293566','293575','293593','293604','293638','293934','294004','294067','294068','294069','294070','294187','294202','294273','294297','294311','294326','294327','294328','294329','294330','294371','294419','294420','294497','294509','294544','294548','294553','294561','294565','294567','294568','294570','294589','294590','294611','294664','294669','294702','294710','294725','294738','294739','294740','294741','294742','294743','294744','294803','294814','294847','294848','294849','294904','294928','294978','295153','295154','295155','295304','295316','295379','295381','295383','295384','295482','295508','295522','295565','295574','295576','295654','295662','295689','295715','295732','295779','295781','295782','295818','295865','295990','295995','296183','296200','296257','296276','297012','297028','297088','297099','297107','297120','297180','297181','297194','297244','297257','297258','297284','297285','297291','297307','297308','297325','297370','297437','297450','297458','297467','297477','297555','297556','297581','297636','297683','297684','297687','297688','297689','297704','297733','297756','297758','297829','297854','297859','297860','297861','298015','298017','298018','298019','298021','298025','298056','298063','298100','298104','298105','298106','298109','298134','298153','298157','298162','298163','298169','298170','298171','298211','298224','298244','298253','298258','298261','298318','298319','298352','298357','298358','298359','298360','298361','298373','298374','298375','298376','298378','298379','298397','298406','298411','298445','298453','298477','298516','298517','298518','298528','298572','298584','299064','299122','299132','299137','299139','299140','299142','299143','299165','299176','299277','299279','299405','299502','299564','299636','299716','299738','299764','299765','299766','299771','299772','299776','299794','299795','299822','299823','299836','299906','299907','299929','299965','299966','299967','299968','299969','299970','299971','299972','299973','299974','299975','299976','299979','300019','300030','300031','300041','300057','300174','300205','300246','300383','300404','300496','300533','300535','300578','300580','300598','300610','300620','300646','300651','300653','300654','300665','300935','300996','301002','301018','301039','301040','301041','301042','301043','301044','301045','301046','301049','301050','301051','301052','301062','301063','301064','301800','301807','301808','301809','301810','301811','301812','301855','301892','301895','301906','301907','301908','301909','301939','301978','302111','302157','302189','302221','302287','302289','302291','302316','302338','302348','302349','302350','302352','302356','303790','303818','303908','303934','303940','304020','304024') GROUP BY `stock_status` ORDER BY `stock_status` ASC
childsstroke1: stock_status
SELECT `stock_status`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `stock_status` !='' AND `modx_site_content`.`id` IN ('152640','152642','152644','152650','152651','152655','152660','152662','153090','153093','153096','153103','153105','153106','153107','153108','153109','153116','153118','153121','153122','153139','153375','153384','153385','153386','153387','153388','153389','153390','153391','153415','153416','153417','153418','153419','153420','153421','153422','153423','153424','153426','153430','153569','153571','153575','153576','153577','153585','153587','153590','153591','153592','153595','153596','153598','153599','153621','153627','153635','153639','153653','153654','153773','153798','153799','153800','153801','153802','153803','153809','153820','153824','153880','153904','153905','153906','153907','153908','153909','153910','153923','153931','154132','154133','154134','154168','154245','154257','154279','154321','154322','154332','154333','154334','154335','154336','154337','154338','154339','154340','154341','154348','154471','154472','154488','154514','154515','154529','154530','154533','154547','154548','154567','154570','154571','154580','154581','154583','154584','154587','154588','154590','154594','154598','154607','154608','154609','154610','154629','154633','154642','154655','154656','154657','154658','154659','154661','154679','154711','154712','154713','154715','154716','154717','154718','154730','154731','154736','154747','154749','154790','154791','154792','154793','154794','154795','154796','154797','154825','154834','154835','154854','154855','154877','154884','154885','154886','154906','154907','154928','154952','154990','154991','154992','155029','155031','155054','155055','155056','155057','155058','155059','155060','155061','155062','155063','155065','155066','155067','155068','155069','155070','155071','155104','155105','155109','155110','155111','155112','155113','155114','155115','155121','155150','155151','155152','155153','155154','155155','155159','155160','155199','155265','155266','155267','155268','155269','155270','155271','155272','155273','155274','155275','155281','155286','155288','155302','155303','155520','155648','155653','155655','155656','155657','155801','155812','155867','156258','156260','156261','156267','156285','156286','156314','156315','156317','156320','156321','156322','156323','156324','156326','156327','156328','156329','156334','156335','156336','156337','156338','156339','156340','156341','156342','156343','156344','156345','156346','156347','156348','156352','156353','156354','156355','156356','156357','156358','156359','156360','156379','156380','156381','156382','156383','156384','156385','156388','156392','156394','156395','156396','156397','156398','156399','156400','156401','156402','156403','156404','156406','156407','156408','156409','156410','156411','156412','156413','156414','156415','156418','156419','156420','156421','156422','156423','156424','156425','156426','156427','156428','156429','156430','156431','156432','156433','156434','156435','156436','156437','156439','156441','156443','156445','156447','156451','156452','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156465','156466','156467','156468','156469','156470','156471','156472','156473','156474','156475','156476','156477','156478','156479','156480','156481','156482','156483','156484','156485','156486','156487','156490','156491','156492','156493','156494','156495','156497','156498','156499','156500','156502','156503','156504','156505','156506','156507','156508','156509','156511','156512','156513','156514','156515','156516','156517','156518','156520','156521','156522','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','156631','156633','156634','156779','156780','156789','156790','156791','156792','156793','156794','156795','156796','156797','156799','156800','156801','156802','156803','156804','156805','156806','156873','156874','156909','156912','156913','156914','156915','156916','156917','156918','156919','156920','156921','156922','156923','156924','156925','156926','156927','156928','156929','156930','156931','156932','156933','156934','156935','156936','156937','156941','156942','156945','156946','156947','156954','156955','156956','157010','157225','157226','157227','157228','157229','157230','157231','157258','157259','157261','157263','157264','157265','157270','157271','157275','157285','157288','157289','157290','157291','157292','157293','157294','157295','157296','157297','157408','157423','157424','157425','157426','157427','157428','157429','157430','157431','157432','157436','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157460','157463','157464','157465','157466','157468','157469','157470','157471','157472','157473','157474','157475','157476','157501','157502','157504','157505','157506','157510','157548','157553','157587','157711','157728','157729','157733','157740','157761','157762','157763','157782','157841','157844','157895','157896','157897','157902','157903','157961','157989','157991','157992','157999','158000','158005','158022','158023','158031','158146','158233','158249','158250','158262','158263','158292','158339','158350','158381','158398','158399','158400','158417','158423','158424','158550','158586','158613','158662','158757','158762','158767','158776','158777','158794','158795','158810','158811','158813','158826','158841','158842','158843','158844','158845','158846','158856','158955','158971','159003','159009','159010','159019','159028','159029','159030','159078','159079','159097','159098','159121','159143','159145','159146','159148','159149','159151','159152','159153','159154','159155','159156','159205','159225','159237','159253','159255','159314','159340','159341','159342','159343','159344','159345','159346','159347','159348','159349','159350','159351','159352','159353','159354','159355','159356','159357','159362','159369','159377','159390','159424','159450','159474','159475','159476','159527','159528','159529','159534','159552','159561','159570','159666','159667','159668','159706','159815','159913','159916','159917','159986','159987','159988','160038','160049','160058','160098','160100','160125','160126','160137','160208','160209','160216','160217','160218','160288','160302','160310','160316','160317','160345','160347','160363','160364','160365','160366','160367','160373','160374','160381','160401','160403','160413','160421','160430','160441','160488','160490','160504','160505','160557','160558','160559','160560','160580','160582','160618','160650','160651','160652','160682','160683','160742','160743','160744','160754','160761','160762','160763','160797','160821','160864','160865','160866','160894','160895','160933','160952','161047','161136','161142','161143','161144','161145','161182','161221','161222','161229','161230','161231','161233','161234','161235','161236','161237','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161359','161380','161383','161421','161428','161437','161438','161444','161445','161457','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161478','161479','161529','161548','161549','161550','161551','161552','161588','161593','161598','161606','161613','161614','161617','161619','161630','161631','161632','161633','161634','161644','161667','161668','161669','161670','161708','161709','161797','161798','161809','161824','161825','161834','161886','161893','161894','161895','161903','161904','161905','161906','161907','161912','161933','161934','161935','161956','161979','161980','162029','162030','162031','162032','162049','162080','162081','162220','162227','162269','162270','162271','162272','162285','162295','162305','162306','162307','162308','162335','162349','162360','162391','162410','162414','162415','162416','162417','162419','162420','162422','162447','162449','162479','162480','162481','162492','162493','162494','162495','162529','162530','162547','162548','162555','162556','162557','162558','162559','162560','162570','162579','162580','162633','162667','162714','162739','162748','162782','162787','162816','162832','162876','162935','162936','162942','163028','163053','163103','163108','163109','163110','163111','163112','163113','163123','163153','163154','163181','163231','163232','163233','163234','163288','163289','163294','163295','163321','163344','163466','163467','163529','163540','163541','163616','163617','163618','163620','163662','163676','163703','163723','163779','163780','163781','163782','163802','163828','163868','163878','163880','163890','163891','163892','163954','163963','163982','164009','164029','164052','164094','164124','164131','164132','164133','164134','164135','164140','164141','164142','164159','164160','164167','164233','164238','164247','164316','164422','164427','164433','164485','164499','164511','164514','164521','164522','164527','164534','164543','164545','164546','164553','164556','164557','164560','164561','164562','164563','164564','164565','164566','164567','164568','164596','164624','164656','164671','164672','164673','164679','164693','164733','164734','164736','164756','164757','164758','164759','164760','164761','164762','164763','164771','164805','164808','164809','164810','164835','164853','164875','164886','164919','164932','164957','164958','164992','165000','165004','165005','165016','165017','165030','165032','165033','165034','165035','165053','165065','165078','165080','165091','165131','165134','165147','165151','165152','165153','165154','165155','165156','165157','165162','165227','165244','165288','165289','165290','165291','165292','165305','165347','165348','165362','165408','165420','165479','165480','165491','165502','165514','165517','165524','165530','165539','165542','165550','165563','165564','165565','165574','165581','165672','165673','165676','165679','165691','165731','165750','165779','165840','165841','165858','165859','165860','165861','165862','165863','165864','165865','165866','165867','165868','165895','165896','165897','165906','165915','165936','165939','165957','165958','165959','165972','165973','165974','165975','165976','165983','166054','166082','166083','166084','166112','166135','166136','166137','166138','166165','166191','166192','166193','166194','166195','166251','166324','166325','166326','166444','166447','166451','166472','166492','166510','166521','166523','166524','166585','166586','166587','166588','166589','166670','166674','166675','166685','166719','166720','166721','166722','166723','166724','166731','166763','166764','166787','166792','166848','166855','166858','166871','166880','166884','166885','166889','166905','166906','166919','166928','166983','167001','167041','167073','167077','167092','167096','167107','167109','167110','167111','167112','167113','167117','167147','167148','167149','167150','167151','167152','167161','167210','167217','167262','167263','167292','167298','167308','167389','167403','167406','167412','167483','167553','167578','167585','167586','167620','167630','167641','167643','167648','167649','167664','167707','167708','167739','167740','167760','167769','167784','167828','167833','167851','167852','167862','167871','167900','167903','167920','167949','168009','168051','168055','168239','168324','168325','168335','168340','168394','168403','219748','219753','232438','232444','232461','232462','232518','232519','232561','232578','232603','232732','232780','238104','238235','238263','238264','238265','238284','238285','238286','238303','238304','238305','238406','238411','238438','238443','238450','238459','238512','238520','238528','238538','238539','238556','238567','238579','238712','238716','238717','238718','238724','238725','238734','238736','238762','238810','238832','238851','238852','238853','238854','238855','238856','238857','238858','238962','239170','239207','239217','239220','239312','239332','239514','239554','239590','239627','239818','239901','239947','240496','240571','240572','240573','240574','240575','240586','240717','240744','240875','240876','240877','240898','240924','240925','240926','240927','240989','240990','240991','240992','241279','241408','241864','241870','241871','242017','242018','242019','242020','242212','242248','242249','242250','242252','242253','242339','242443','242506','242706','242858','242902','242906','242939','242940','242941','242942','242992','242993','242994','242995','243025','243145','243146','243744','243841','243842','243845','243846','243863','243988','244106','244135','244180','244223','244224','244266','244324','244436','244548','244549','244562','244704','244780','244781','244782','244783','244784','244785','244809','244810','244811','244926','244967','245070','245073','245158','245170','245220','245221','245239','245240','245267','245268','245269','245292','245293','245294','245295','245296','245297','245391','245392','245394','245395','245396','245397','245398','245399','245400','245401','245402','245403','245404','245405','245406','245419','245493','245495','245543','245586','245587','245588','245600','245609','245778','245887','245931','245996','246063','246100','246185','246213','246252','246253','246254','246363','246443','246536','246583','246584','246585','246586','246629','246652','246667','246778','246792','246828','246919','246994','247039','247119','247120','247121','247122','247123','247124','247125','247126','247127','247128','247129','247130','247131','247132','247133','247134','247192','247196','247197','247487','247488','247497','247512','247535','247536','247599','247605','247606','247607','247608','247609','247610','247638','247674','247852','247853','247854','247855','247892','248086','248138','248168','248187','248188','248189','248199','248281','248300','248312','248315','248364','248399','248403','248404','248405','248406','248430','248446','248539','248544','248545','248596','248642','248744','248745','248913','248930','248940','248941','248950','248951','249007','249151','249166','249237','249253','249263','249302','249320','249346','249355','249356','249410','249412','249416','249418','249495','249496','249497','249541','249644','249663','249664','249685','249686','249687','249688','249716','249750','249770','249771','249784','249815','249862','249863','249896','249909','249913','249914','249922','250096','250099','250101','250126','250130','250149','250158','250159','250192','250213','250218','250292','250302','250303','250304','250305','250306','250307','250308','250309','250310','250311','250312','250313','250314','250315','250316','250317','250318','250319','250320','250321','250322','250328','250330','250348','250355','250356','250357','250358','250359','250360','250361','250362','250363','250364','250365','250366','250367','250368','250369','250370','250371','250372','250373','250374','250375','250376','250377','250378','250379','250380','250381','250382','250383','250384','250385','250386','250387','250388','250389','250390','250391','250392','250393','250394','250395','250396','250397','250398','250399','250400','250401','250402','250403','250404','250405','250406','250407','250408','250409','250410','250411','250412','250413','250414','250415','250416','250417','250418','250419','250420','250421','250422','250423','250424','250425','250426','250427','250428','250429','250430','250431','250432','250433','250434','250435','250436','250437','250438','250439','250440','250441','250442','250443','250444','250445','250446','250447','250448','250501','250502','250503','250504','250505','250525','250660','250702','250704','250756','250767','250772','250794','250796','250797','250803','250919','250966','251022','251137','251156','251172','251191','251217','251218','251219','251220','251221','251227','251252','251255','251257','251258','251259','251260','251280','251286','251344','251350','251408','251476','251520','251521','251522','251539','251550','251554','251555','251556','251557','251569','251577','251596','251597','251598','251599','251600','251602','251603','251604','251605','251606','251607','251633','251638','251639','251641','251669','251695','251733','251747','251759','251794','251795','251836','251837','251850','251867','251920','251945','251946','251947','251985','252010','252021','252045','252066','252089','252091','252093','252110','253033','253088','253125','253127','253128','253129','253136','253167','253231','253239','253241','253242','253246','253252','253253','253254','253259','253260','253263','253325','253326','253361','253392','253393','253394','253397','253398','253424','253463','253481','253488','253489','253490','253491','253513','253514','253515','253516','253517','253518','253519','253522','253537','253564','253586','253587','253588','253589','253592','253631','253638','253659','253737','253784','253792','253801','253802','253831','253832','253846','253849','253873','253874','253875','253876','253877','254196','254244','254245','254246','254247','254398','254399','254409','254410','254411','254412','254426','254459','254472','254545','254560','254561','254562','254586','254643','254748','254749','254750','254751','254752','254753','254754','254755','254756','254757','254917','254948','254991','255000','255018','255025','255078','255079','255080','255081','255193','255223','255225','255245','255344','255368','255372','255397','255398','255454','255505','255518','255605','255606','255607','255623','255638','255668','255731','255732','255733','255734','255735','255736','255740','255741','255742','255770','255809','255818','255819','255820','255821','255822','255823','255824','255825','255826','255827','255828','255829','255830','255831','255832','255833','255834','255835','255895','255896','255897','255898','255899','255900','255901','255902','255903','255904','255905','255906','255907','255908','255909','255910','255911','255912','255913','255914','255915','255916','255917','255918','255919','255920','255921','255922','255923','255924','255925','255926','255927','255928','255929','255930','255931','255932','255933','255934','255935','255936','255937','255938','255940','256103','256109','256110','256112','256122','256188','256277','256278','256279','256280','256282','256283','256284','256285','256286','256287','256288','256289','256290','256291','256292','256293','256294','256295','256296','256297','256298','256308','256317','256328','256329','256340','256343','256344','256499','256500','256507','256508','256515','256537','256539','256547','256668','256674','256675','256705','256759','256782','256783','256784','256853','256902','256904','256905','256922','256923','256931','257012','257013','257015','257016','257017','257018','257019','257021','257022','257023','257024','257025','257026','257028','257044','257045','257046','257047','257048','257049','257050','257051','257068','257117','257118','257155','257168','257169','257178','257180','257181','257192','257193','257194','257195','257197','257198','257199','257200','257201','257202','257203','257204','257205','257206','257207','257208','257209','257210','257211','257235','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261768','261936','261941','261949','261955','261956','261975','261989','262000','262032','262074','262082','262085','262086','262087','262106','262155','262188','262241','262383','262390','262440','262441','262442','262443','262444','262445','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262480','262481','262482','262483','262484','262485','262486','262487','262488','262489','262490','262491','262492','262493','262494','262495','262496','262497','262498','262499','262506','262520','262561','262608','262617','262628','262629','262630','262631','262632','262633','262634','262635','262636','262637','262638','262653','262720','262721','262738','262739','262740','262741','262742','262743','262744','262745','262746','262747','262748','262749','262750','262751','262756','262760','262783','262792','262796','262822','262823','262836','262837','262838','262839','262840','262841','262842','262843','262844','262845','262846','262847','262848','262849','262850','262851','262867','262881','262896','262898','262935','262995','262997','263085','263196','263469','263474','263507','263543','263550','263551','263635','263637','263642','263643','263651','263652','263653','263715','263754','264348','264503','264504','264505','264657','264658','264704','264705','264777','264797','264932','264934','265015','265017','265045','265063','265065','265068','265124','265125','265156','265167','265194','265195','265282','265283','265284','265319','265321','265361','265390','265429','265430','265437','265448','265520','265581','265657','265674','265675','265700','265742','265762','265776','265783','265805','265806','265917','265953','266148','266162','266245','266352','266353','266356','266408','266416','266417','266418','266419','266420','266421','266422','266423','266424','266425','266426','266427','266428','266429','266548','266582','266594','266684','266685','266686','266804','266823','266895','266988','266989','266990','267016','267024','267065','267084','267085','267089','267133','267134','267148','267169','267190','267191','267192','267193','267194','267195','267196','267197','267198','267199','267200','267201','267202','267203','267205','267206','267215','267288','267345','267356','267404','267409','267419','267420','267497','267514','267551','267565','267566','267577','267618','267664','267750','267751','267869','267959','267976','267977','268073','268141','268232','268234','268246','268247','268250','268309','268320','268352','268359','268361','268372','268374','268375','268395','268410','268412','268450','268455','268456','268484','268513','268515','268520','268523','268561','268562','268603','268705','268724','268781','268898','269031','269043','269047','269077','269106','269110','269111','269113','269149','269152','269153','269180','269204','269206','269244','269246','269247','269248','269249','269250','269251','269252','269393','269441','269470','269475','269476','269477','269478','269479','269480','269512','269513','269514','269520','269527','269557','273337','273338','273359','273370','273428','273439','273464','273472','273490','273506','273536','273588','273589','273699','273713','273723','273828','273829','273832','273844','273892','273893','273946','273960','273974','274139','274141','274278','274298','274327','274397','274398','274399','274400','274419','274443','274477','274592','274604','274607','274615','274616','274628','274657','274658','274672','274679','274682','274695','274697','274764','274778','274800','274817','274828','274836','274837','274838','274839','274840','274888','274894','274905','274912','274990','274991','275073','275074','275075','275076','275228','275248','275298','275395','275421','275458','275494','275499','275522','275555','275566','275604','275619','275655','275662','275663','275689','275692','275753','275757','275783','275822','275823','275977','276010','276059','276070','276087','276130','276145','276216','276217','276218','276255','276286','276287','276289','276290','276339','276349','276385','276388','276389','276398','276409','276410','276411','276412','276413','276414','276416','276473','276474','276481','276514','276515','276534','276546','276547','276548','276549','276550','276572','276607','276613','276614','276615','276638','276697','276700','276940','276972','276973','276993','277016','277018','277035','277037','277038','277070','277175','277176','277196','277207','277250','277255','277264','277265','277266','277289','277304','277306','277308','277313','277336','277358','277384','277397','277430','277439','277440','277441','277442','277443','277444','277445','277460','277461','277462','277474','277493','277524','277525','277526','277527','277528','277529','277530','277531','277584','277633','277645','277647','277648','277689','277712','277749','277750','277777','277791','277809','277915','277916','277917','277938','277939','277953','278054','278058','278075','278102','278103','278128','278142','278163','278164','278188','278221','278224','278240','278242','278318','278379','278429','278445','278446','278480','278507','278542','278560','278566','278572','278640','278754','278774','278850','278851','278900','278901','278950','279013','279023','279057','279059','279094','279100','279134','279207','279226','279295','279301','279336','279422','279440','279469','279479','279582','279585','279698','279705','279732','279735','279740','280303','280305','280369','280374','280375','280380','280381','280382','280386','280428','280450','280491','280492','280709','280723','280728','280729','280760','280761','280773','280778','280805','280808','280810','280832','280850','280855','280943','280944','280945','280979','281034','281056','281091','281133','281143','281144','281145','281146','281150','281151','281180','281195','281224','281230','281232','281235','281243','281268','281278','281336','281339','281473','281489','281651','281652','281689','281764','281770','281774','281776','281777','281865','282074','282144','282164','282165','282167','282168','282172','282190','282275','282295','282341','282342','282402','282476','282483','282521','282541','282572','282670','282767','282813','282843','282868','282902','282945','283001','283219','283225','283226','283227','283228','283313','283380','283504','283505','283542','283555','283597','283598','283599','283600','283611','283622','283623','283630','283634','283635','283730','283735','283736','283737','283763','284140','284284','284312','284356','284415','284441','284443','284444','284445','284504','284505','284506','284507','284508','284528','284550','284562','284599','284625','284644','284662','284745','284831','284836','284860','284896','284900','284914','284948','285024','285098','285106','285169','285177','285230','285247','285248','285249','285270','285334','285378','285379','285395','285403','285429','285444','285566','285578','285579','285591','285592','285593','285622','285627','285676','285677','285707','285732','285733','285734','285742','285793','285794','285795','285833','285903','285934','285984','286014','286028','286034','286062','286068','286120','286162','286199','286206','286344','286349','286358','286373','286400','286444','286640','286816','286860','286867','286873','286899','286913','286914','286915','286916','286917','286918','287011','287030','287031','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','287110','287111','287113','287114','287115','287116','287117','287118','287119','287120','287121','287122','287140','287141','287173','287202','287218','287557','287780','287782','287980','287982','287988','287995','288025','288026','288139','288163','288172','288173','288174','288175','288176','288177','288186','288217','288232','288234','288235','288260','288275','288299','288316','288351','288357','288358','288414','288416','288422','288441','288444','288470','288474','288477','288478','288480','288506','288534','288577','288580','288625','288663','288702','288709','288994','289011','289034','289035','289036','289037','289038','289039','289040','289041','289044','289045','289046','289047','289048','289049','289050','289051','289052','289053','289221','289227','289413','289466','289476','289483','289484','289485','289486','291708','291709','291711','291736','291744','291818','291864','291868','291869','291877','291878','291938','291947','291974','291975','291986','291987','291988','292007','292223','292224','292225','292245','292276','292304','292308','292309','292311','292312','292313','292323','292324','292339','292340','292341','292342','292343','292344','292362','292376','292399','292410','292411','292486','292492','292493','292511','292530','292531','292597','292607','292608','292609','292610','292611','292612','292621','292623','292654','292662','292692','292735','292736','292737','292738','292739','292744','292745','292746','292747','292748','292776','292839','292904','293209','293210','293231','293281','293282','293369','293373','293374','293403','293404','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','293451','293491','293519','293527','293558','293566','293575','293593','293604','293638','293934','294004','294067','294068','294069','294070','294187','294202','294273','294297','294311','294326','294327','294328','294329','294330','294371','294419','294420','294497','294509','294544','294548','294553','294561','294565','294567','294568','294570','294589','294590','294611','294664','294669','294702','294710','294725','294738','294739','294740','294741','294742','294743','294744','294803','294814','294847','294848','294849','294904','294928','294978','295153','295154','295155','295304','295316','295379','295381','295383','295384','295482','295508','295522','295565','295574','295576','295654','295662','295689','295715','295732','295779','295781','295782','295818','295865','295990','295995','296183','296200','296257','296276','297012','297028','297088','297099','297107','297120','297180','297181','297194','297244','297257','297258','297284','297285','297291','297307','297308','297325','297370','297437','297450','297458','297467','297477','297555','297556','297581','297636','297683','297684','297687','297688','297689','297704','297733','297756','297758','297829','297854','297859','297860','297861','298015','298017','298018','298019','298021','298025','298056','298063','298100','298104','298105','298106','298109','298134','298153','298157','298162','298163','298169','298170','298171','298211','298224','298244','298253','298258','298261','298318','298319','298352','298357','298358','298359','298360','298361','298373','298374','298375','298376','298378','298379','298397','298406','298411','298445','298453','298477','298516','298517','298518','298528','298572','298584','299064','299122','299132','299137','299139','299140','299142','299143','299165','299176','299277','299279','299405','299502','299564','299636','299716','299738','299764','299765','299766','299771','299772','299776','299794','299795','299822','299823','299836','299906','299907','299929','299965','299966','299967','299968','299969','299970','299971','299972','299973','299974','299975','299976','299979','300019','300030','300031','300041','300057','300174','300205','300246','300383','300404','300496','300533','300535','300578','300580','300598','300610','300620','300646','300651','300653','300654','300665','300935','300996','301002','301018','301039','301040','301041','301042','301043','301044','301045','301046','301049','301050','301051','301052','301062','301063','301064','301800','301807','301808','301809','301810','301811','301812','301855','301892','301895','301906','301907','301908','301909','301939','301978','302111','302157','302189','302221','302287','302289','302291','302316','302338','302348','302349','302350','302352','302356','303790','303818','303908','303934','303940','304020','304024') GROUP BY `stock_status` ORDER BY `stock_status` ASC
childsstroke: parent
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 ('152640','152642','152644','152650','152651','152655','152660','152662','153090','153093','153096','153103','153105','153106','153107','153108','153109','153116','153118','153121','153122','153139','153375','153384','153385','153386','153387','153388','153389','153390','153391','153415','153416','153417','153418','153419','153420','153421','153422','153423','153424','153426','153430','153569','153571','153575','153576','153577','153585','153587','153590','153591','153592','153595','153596','153598','153599','153621','153627','153635','153639','153653','153654','153773','153798','153799','153800','153801','153802','153803','153809','153820','153824','153880','153904','153905','153906','153907','153908','153909','153910','153923','153931','154132','154133','154134','154168','154245','154257','154279','154321','154322','154332','154333','154334','154335','154336','154337','154338','154339','154340','154341','154348','154471','154472','154488','154514','154515','154529','154530','154533','154547','154548','154567','154570','154571','154580','154581','154583','154584','154587','154588','154590','154594','154598','154607','154608','154609','154610','154629','154633','154642','154655','154656','154657','154658','154659','154661','154679','154711','154712','154713','154715','154716','154717','154718','154730','154731','154736','154747','154749','154790','154791','154792','154793','154794','154795','154796','154797','154825','154834','154835','154854','154855','154877','154884','154885','154886','154906','154907','154928','154952','154990','154991','154992','155029','155031','155054','155055','155056','155057','155058','155059','155060','155061','155062','155063','155065','155066','155067','155068','155069','155070','155071','155104','155105','155109','155110','155111','155112','155113','155114','155115','155121','155150','155151','155152','155153','155154','155155','155159','155160','155199','155265','155266','155267','155268','155269','155270','155271','155272','155273','155274','155275','155281','155286','155288','155302','155303','155520','155648','155653','155655','155656','155657','155801','155812','155867','156258','156260','156261','156267','156285','156286','156314','156315','156317','156320','156321','156322','156323','156324','156326','156327','156328','156329','156334','156335','156336','156337','156338','156339','156340','156341','156342','156343','156344','156345','156346','156347','156348','156352','156353','156354','156355','156356','156357','156358','156359','156360','156379','156380','156381','156382','156383','156384','156385','156388','156392','156394','156395','156396','156397','156398','156399','156400','156401','156402','156403','156404','156406','156407','156408','156409','156410','156411','156412','156413','156414','156415','156418','156419','156420','156421','156422','156423','156424','156425','156426','156427','156428','156429','156430','156431','156432','156433','156434','156435','156436','156437','156439','156441','156443','156445','156447','156451','156452','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156465','156466','156467','156468','156469','156470','156471','156472','156473','156474','156475','156476','156477','156478','156479','156480','156481','156482','156483','156484','156485','156486','156487','156490','156491','156492','156493','156494','156495','156497','156498','156499','156500','156502','156503','156504','156505','156506','156507','156508','156509','156511','156512','156513','156514','156515','156516','156517','156518','156520','156521','156522','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','156631','156633','156634','156779','156780','156789','156790','156791','156792','156793','156794','156795','156796','156797','156799','156800','156801','156802','156803','156804','156805','156806','156873','156874','156909','156912','156913','156914','156915','156916','156917','156918','156919','156920','156921','156922','156923','156924','156925','156926','156927','156928','156929','156930','156931','156932','156933','156934','156935','156936','156937','156941','156942','156945','156946','156947','156954','156955','156956','157010','157225','157226','157227','157228','157229','157230','157231','157258','157259','157261','157263','157264','157265','157270','157271','157275','157285','157288','157289','157290','157291','157292','157293','157294','157295','157296','157297','157408','157423','157424','157425','157426','157427','157428','157429','157430','157431','157432','157436','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157460','157463','157464','157465','157466','157468','157469','157470','157471','157472','157473','157474','157475','157476','157501','157502','157504','157505','157506','157510','157548','157553','157587','157711','157728','157729','157733','157740','157761','157762','157763','157782','157841','157844','157895','157896','157897','157902','157903','157961','157989','157991','157992','157999','158000','158005','158022','158023','158031','158146','158233','158249','158250','158262','158263','158292','158339','158350','158381','158398','158399','158400','158417','158423','158424','158550','158586','158613','158662','158757','158762','158767','158776','158777','158794','158795','158810','158811','158813','158826','158841','158842','158843','158844','158845','158846','158856','158955','158971','159003','159009','159010','159019','159028','159029','159030','159078','159079','159097','159098','159121','159143','159145','159146','159148','159149','159151','159152','159153','159154','159155','159156','159205','159225','159237','159253','159255','159314','159340','159341','159342','159343','159344','159345','159346','159347','159348','159349','159350','159351','159352','159353','159354','159355','159356','159357','159362','159369','159377','159390','159424','159450','159474','159475','159476','159527','159528','159529','159534','159552','159561','159570','159666','159667','159668','159706','159815','159913','159916','159917','159986','159987','159988','160038','160049','160058','160098','160100','160125','160126','160137','160208','160209','160216','160217','160218','160288','160302','160310','160316','160317','160345','160347','160363','160364','160365','160366','160367','160373','160374','160381','160401','160403','160413','160421','160430','160441','160488','160490','160504','160505','160557','160558','160559','160560','160580','160582','160618','160650','160651','160652','160682','160683','160742','160743','160744','160754','160761','160762','160763','160797','160821','160864','160865','160866','160894','160895','160933','160952','161047','161136','161142','161143','161144','161145','161182','161221','161222','161229','161230','161231','161233','161234','161235','161236','161237','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161359','161380','161383','161421','161428','161437','161438','161444','161445','161457','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161478','161479','161529','161548','161549','161550','161551','161552','161588','161593','161598','161606','161613','161614','161617','161619','161630','161631','161632','161633','161634','161644','161667','161668','161669','161670','161708','161709','161797','161798','161809','161824','161825','161834','161886','161893','161894','161895','161903','161904','161905','161906','161907','161912','161933','161934','161935','161956','161979','161980','162029','162030','162031','162032','162049','162080','162081','162220','162227','162269','162270','162271','162272','162285','162295','162305','162306','162307','162308','162335','162349','162360','162391','162410','162414','162415','162416','162417','162419','162420','162422','162447','162449','162479','162480','162481','162492','162493','162494','162495','162529','162530','162547','162548','162555','162556','162557','162558','162559','162560','162570','162579','162580','162633','162667','162714','162739','162748','162782','162787','162816','162832','162876','162935','162936','162942','163028','163053','163103','163108','163109','163110','163111','163112','163113','163123','163153','163154','163181','163231','163232','163233','163234','163288','163289','163294','163295','163321','163344','163466','163467','163529','163540','163541','163616','163617','163618','163620','163662','163676','163703','163723','163779','163780','163781','163782','163802','163828','163868','163878','163880','163890','163891','163892','163954','163963','163982','164009','164029','164052','164094','164124','164131','164132','164133','164134','164135','164140','164141','164142','164159','164160','164167','164233','164238','164247','164316','164422','164427','164433','164485','164499','164511','164514','164521','164522','164527','164534','164543','164545','164546','164553','164556','164557','164560','164561','164562','164563','164564','164565','164566','164567','164568','164596','164624','164656','164671','164672','164673','164679','164693','164733','164734','164736','164756','164757','164758','164759','164760','164761','164762','164763','164771','164805','164808','164809','164810','164835','164853','164875','164886','164919','164932','164957','164958','164992','165000','165004','165005','165016','165017','165030','165032','165033','165034','165035','165053','165065','165078','165080','165091','165131','165134','165147','165151','165152','165153','165154','165155','165156','165157','165162','165227','165244','165288','165289','165290','165291','165292','165305','165347','165348','165362','165408','165420','165479','165480','165491','165502','165514','165517','165524','165530','165539','165542','165550','165563','165564','165565','165574','165581','165672','165673','165676','165679','165691','165731','165750','165779','165840','165841','165858','165859','165860','165861','165862','165863','165864','165865','165866','165867','165868','165895','165896','165897','165906','165915','165936','165939','165957','165958','165959','165972','165973','165974','165975','165976','165983','166054','166082','166083','166084','166112','166135','166136','166137','166138','166165','166191','166192','166193','166194','166195','166251','166324','166325','166326','166444','166447','166451','166472','166492','166510','166521','166523','166524','166585','166586','166587','166588','166589','166670','166674','166675','166685','166719','166720','166721','166722','166723','166724','166731','166763','166764','166787','166792','166848','166855','166858','166871','166880','166884','166885','166889','166905','166906','166919','166928','166983','167001','167041','167073','167077','167092','167096','167107','167109','167110','167111','167112','167113','167117','167147','167148','167149','167150','167151','167152','167161','167210','167217','167262','167263','167292','167298','167308','167389','167403','167406','167412','167483','167553','167578','167585','167586','167620','167630','167641','167643','167648','167649','167664','167707','167708','167739','167740','167760','167769','167784','167828','167833','167851','167852','167862','167871','167900','167903','167920','167949','168009','168051','168055','168239','168324','168325','168335','168340','168394','168403','169267','219748','219753','232438','232444','232461','232462','232518','232519','232561','232578','232603','232732','232780','238104','238235','238263','238264','238265','238284','238285','238286','238303','238304','238305','238406','238411','238438','238443','238450','238459','238512','238520','238528','238538','238539','238556','238567','238579','238712','238716','238717','238718','238724','238725','238734','238736','238762','238810','238832','238851','238852','238853','238854','238855','238856','238857','238858','238962','239170','239207','239217','239220','239312','239332','239514','239554','239590','239627','239818','239901','239947','240496','240571','240572','240573','240574','240575','240586','240717','240744','240875','240876','240877','240898','240924','240925','240926','240927','240989','240990','240991','240992','241279','241408','241864','241870','241871','242017','242018','242019','242020','242212','242248','242249','242250','242252','242253','242339','242443','242506','242706','242858','242902','242906','242939','242940','242941','242942','242992','242993','242994','242995','243025','243145','243146','243744','243841','243842','243845','243846','243863','243988','244106','244135','244180','244223','244224','244266','244324','244436','244548','244549','244562','244704','244780','244781','244782','244783','244784','244785','244809','244810','244811','244926','244967','245070','245073','245158','245170','245220','245221','245239','245240','245267','245268','245269','245292','245293','245294','245295','245296','245297','245391','245392','245394','245395','245396','245397','245398','245399','245400','245401','245402','245403','245404','245405','245406','245419','245493','245495','245543','245586','245587','245588','245600','245609','245778','245887','245931','245996','246063','246100','246185','246213','246252','246253','246254','246363','246443','246536','246583','246584','246585','246586','246629','246652','246667','246778','246792','246828','246919','246994','247039','247119','247120','247121','247122','247123','247124','247125','247126','247127','247128','247129','247130','247131','247132','247133','247134','247192','247196','247197','247487','247488','247497','247512','247535','247536','247599','247605','247606','247607','247608','247609','247610','247638','247674','247852','247853','247854','247855','247892','248086','248138','248168','248187','248188','248189','248199','248281','248300','248312','248315','248364','248399','248403','248404','248405','248406','248430','248446','248539','248544','248545','248596','248642','248744','248745','248913','248930','248940','248941','248950','248951','249007','249151','249166','249237','249253','249263','249302','249320','249346','249355','249356','249410','249412','249416','249418','249495','249496','249497','249541','249644','249663','249664','249685','249686','249687','249688','249716','249750','249770','249771','249784','249815','249862','249863','249896','249909','249913','249914','249922','250096','250099','250101','250126','250130','250149','250158','250159','250192','250213','250218','250292','250302','250303','250304','250305','250306','250307','250308','250309','250310','250311','250312','250313','250314','250315','250316','250317','250318','250319','250320','250321','250322','250328','250330','250348','250355','250356','250357','250358','250359','250360','250361','250362','250363','250364','250365','250366','250367','250368','250369','250370','250371','250372','250373','250374','250375','250376','250377','250378','250379','250380','250381','250382','250383','250384','250385','250386','250387','250388','250389','250390','250391','250392','250393','250394','250395','250396','250397','250398','250399','250400','250401','250402','250403','250404','250405','250406','250407','250408','250409','250410','250411','250412','250413','250414','250415','250416','250417','250418','250419','250420','250421','250422','250423','250424','250425','250426','250427','250428','250429','250430','250431','250432','250433','250434','250435','250436','250437','250438','250439','250440','250441','250442','250443','250444','250445','250446','250447','250448','250501','250502','250503','250504','250505','250525','250660','250702','250704','250756','250767','250772','250794','250796','250797','250803','250919','250966','251022','251137','251156','251172','251191','251217','251218','251219','251220','251221','251227','251252','251255','251257','251258','251259','251260','251280','251286','251344','251350','251408','251476','251520','251521','251522','251539','251550','251554','251555','251556','251557','251569','251577','251596','251597','251598','251599','251600','251602','251603','251604','251605','251606','251607','251633','251638','251639','251641','251669','251695','251733','251747','251759','251794','251795','251836','251837','251850','251867','251920','251945','251946','251947','251985','252010','252021','252045','252066','252089','252091','252093','252110','253033','253088','253125','253127','253128','253129','253136','253167','253231','253239','253241','253242','253246','253252','253253','253254','253259','253260','253263','253325','253326','253361','253392','253393','253394','253397','253398','253424','253463','253481','253488','253489','253490','253491','253513','253514','253515','253516','253517','253518','253519','253522','253537','253564','253586','253587','253588','253589','253592','253631','253638','253659','253737','253784','253792','253801','253802','253831','253832','253846','253849','253873','253874','253875','253876','253877','254196','254244','254245','254246','254247','254398','254399','254409','254410','254411','254412','254426','254459','254472','254545','254560','254561','254562','254586','254643','254748','254749','254750','254751','254752','254753','254754','254755','254756','254757','254917','254948','254991','255000','255018','255025','255078','255079','255080','255081','255193','255223','255225','255245','255344','255368','255372','255397','255398','255454','255505','255518','255605','255606','255607','255623','255638','255668','255731','255732','255733','255734','255735','255736','255740','255741','255742','255770','255809','255818','255819','255820','255821','255822','255823','255824','255825','255826','255827','255828','255829','255830','255831','255832','255833','255834','255835','255895','255896','255897','255898','255899','255900','255901','255902','255903','255904','255905','255906','255907','255908','255909','255910','255911','255912','255913','255914','255915','255916','255917','255918','255919','255920','255921','255922','255923','255924','255925','255926','255927','255928','255929','255930','255931','255932','255933','255934','255935','255936','255937','255938','255940','256103','256109','256110','256112','256122','256188','256277','256278','256279','256280','256282','256283','256284','256285','256286','256287','256288','256289','256290','256291','256292','256293','256294','256295','256296','256297','256298','256308','256317','256328','256329','256340','256343','256344','256499','256500','256507','256508','256515','256537','256539','256547','256668','256674','256675','256705','256759','256782','256783','256784','256853','256902','256904','256905','256922','256923','256931','257012','257013','257015','257016','257017','257018','257019','257021','257022','257023','257024','257025','257026','257028','257044','257045','257046','257047','257048','257049','257050','257051','257068','257117','257118','257155','257168','257169','257178','257180','257181','257192','257193','257194','257195','257197','257198','257199','257200','257201','257202','257203','257204','257205','257206','257207','257208','257209','257210','257211','257235','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261768','261936','261941','261949','261955','261956','261975','261989','262000','262032','262074','262082','262085','262086','262087','262106','262155','262188','262241','262383','262390','262440','262441','262442','262443','262444','262445','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262480','262481','262482','262483','262484','262485','262486','262487','262488','262489','262490','262491','262492','262493','262494','262495','262496','262497','262498','262499','262506','262520','262561','262608','262617','262628','262629','262630','262631','262632','262633','262634','262635','262636','262637','262638','262653','262720','262721','262738','262739','262740','262741','262742','262743','262744','262745','262746','262747','262748','262749','262750','262751','262756','262760','262783','262792','262796','262822','262823','262836','262837','262838','262839','262840','262841','262842','262843','262844','262845','262846','262847','262848','262849','262850','262851','262867','262881','262896','262898','262935','262995','262997','263085','263196','263469','263474','263507','263543','263550','263551','263635','263637','263642','263643','263651','263652','263653','263715','263754','264348','264503','264504','264505','264657','264658','264704','264705','264777','264797','264932','264934','265015','265017','265045','265063','265065','265068','265124','265125','265156','265167','265194','265195','265282','265283','265284','265319','265321','265361','265390','265429','265430','265437','265448','265520','265581','265657','265674','265675','265700','265742','265762','265776','265783','265805','265806','265917','265953','266148','266162','266245','266352','266353','266356','266408','266416','266417','266418','266419','266420','266421','266422','266423','266424','266425','266426','266427','266428','266429','266548','266582','266594','266684','266685','266686','266804','266823','266895','266988','266989','266990','267016','267024','267065','267084','267085','267089','267133','267134','267148','267169','267190','267191','267192','267193','267194','267195','267196','267197','267198','267199','267200','267201','267202','267203','267205','267206','267215','267288','267345','267356','267404','267409','267419','267420','267497','267514','267551','267565','267566','267577','267618','267664','267750','267751','267869','267959','267976','267977','268073','268141','268232','268234','268246','268247','268250','268309','268320','268352','268359','268361','268372','268374','268375','268395','268410','268412','268450','268455','268456','268484','268513','268515','268520','268523','268561','268562','268603','268705','268724','268781','268898','269031','269043','269047','269077','269106','269110','269111','269113','269149','269152','269153','269180','269204','269206','269244','269246','269247','269248','269249','269250','269251','269252','269393','269441','269470','269475','269476','269477','269478','269479','269480','269512','269513','269514','269520','269527','269557','273337','273338','273359','273370','273428','273439','273464','273472','273490','273506','273536','273588','273589','273699','273713','273723','273828','273829','273832','273844','273892','273893','273946','273960','273974','274139','274141','274278','274298','274327','274397','274398','274399','274400','274419','274443','274477','274592','274604','274607','274615','274616','274628','274657','274658','274672','274679','274682','274695','274697','274764','274778','274800','274817','274828','274836','274837','274838','274839','274840','274888','274894','274905','274912','274990','274991','275073','275074','275075','275076','275228','275248','275298','275395','275421','275458','275494','275499','275522','275555','275566','275604','275619','275655','275662','275663','275689','275692','275753','275757','275783','275822','275823','275977','276010','276059','276070','276087','276130','276145','276216','276217','276218','276255','276286','276287','276289','276290','276339','276349','276385','276388','276389','276398','276409','276410','276411','276412','276413','276414','276416','276473','276474','276481','276514','276515','276534','276546','276547','276548','276549','276550','276572','276607','276613','276614','276615','276638','276697','276700','276940','276972','276973','276993','277016','277018','277035','277037','277038','277070','277175','277176','277196','277207','277250','277255','277264','277265','277266','277289','277304','277306','277308','277313','277336','277358','277384','277397','277430','277439','277440','277441','277442','277443','277444','277445','277460','277461','277462','277474','277493','277524','277525','277526','277527','277528','277529','277530','277531','277584','277633','277645','277647','277648','277689','277712','277749','277750','277777','277791','277809','277915','277916','277917','277938','277939','277953','278054','278058','278075','278102','278103','278128','278142','278163','278164','278188','278221','278224','278240','278242','278318','278379','278429','278445','278446','278480','278507','278542','278560','278566','278572','278640','278754','278774','278850','278851','278900','278901','278950','279013','279023','279057','279059','279094','279100','279134','279207','279226','279295','279301','279336','279422','279440','279469','279479','279582','279585','279698','279705','279732','279735','279740','280303','280305','280369','280374','280375','280380','280381','280382','280386','280428','280450','280491','280492','280709','280723','280728','280729','280760','280761','280773','280778','280805','280808','280810','280832','280850','280855','280943','280944','280945','280979','281034','281056','281091','281133','281143','281144','281145','281146','281150','281151','281180','281195','281224','281230','281232','281235','281243','281268','281278','281336','281339','281473','281489','281651','281652','281689','281764','281770','281774','281776','281777','281865','282074','282144','282164','282165','282167','282168','282172','282190','282275','282295','282341','282342','282402','282476','282483','282521','282541','282572','282670','282767','282813','282843','282868','282902','282945','283001','283219','283225','283226','283227','283228','283313','283380','283504','283505','283542','283555','283597','283598','283599','283600','283611','283622','283623','283630','283634','283635','283730','283735','283736','283737','283763','284140','284284','284312','284356','284415','284441','284443','284444','284445','284504','284505','284506','284507','284508','284528','284550','284562','284599','284625','284644','284662','284745','284831','284836','284860','284896','284900','284914','284948','285024','285098','285106','285169','285177','285230','285247','285248','285249','285270','285334','285378','285379','285395','285403','285429','285444','285566','285578','285579','285591','285592','285593','285622','285627','285676','285677','285707','285732','285733','285734','285742','285793','285794','285795','285833','285903','285934','285984','286014','286028','286034','286062','286068','286120','286162','286199','286206','286344','286349','286358','286373','286400','286444','286640','286816','286860','286867','286873','286899','286913','286914','286915','286916','286917','286918','287011','287030','287031','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','287110','287111','287113','287114','287115','287116','287117','287118','287119','287120','287121','287122','287140','287141','287173','287202','287218','287557','287780','287782','287980','287982','287988','287995','288025','288026','288139','288163','288172','288173','288174','288175','288176','288177','288186','288217','288232','288234','288235','288260','288275','288299','288316','288351','288357','288358','288414','288416','288422','288441','288444','288470','288474','288477','288478','288480','288506','288534','288577','288580','288625','288663','288702','288709','288994','289011','289034','289035','289036','289037','289038','289039','289040','289041','289044','289045','289046','289047','289048','289049','289050','289051','289052','289053','289221','289227','289413','289466','289476','289483','289484','289485','289486','291708','291709','291711','291736','291744','291818','291864','291868','291869','291877','291878','291938','291947','291974','291975','291986','291987','291988','292007','292223','292224','292225','292245','292276','292304','292308','292309','292311','292312','292313','292323','292324','292339','292340','292341','292342','292343','292344','292362','292376','292399','292410','292411','292486','292492','292493','292511','292530','292531','292597','292607','292608','292609','292610','292611','292612','292621','292623','292654','292662','292692','292735','292736','292737','292738','292739','292744','292745','292746','292747','292748','292776','292839','292904','293209','293210','293231','293281','293282','293369','293373','293374','293403','293404','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','293451','293491','293519','293527','293558','293566','293575','293593','293604','293638','293934','294004','294067','294068','294069','294070','294187','294202','294273','294297','294311','294326','294327','294328','294329','294330','294371','294419','294420','294497','294509','294544','294548','294553','294561','294565','294567','294568','294570','294589','294590','294611','294664','294669','294702','294710','294725','294738','294739','294740','294741','294742','294743','294744','294803','294814','294847','294848','294849','294904','294928','294978','295153','295154','295155','295304','295316','295379','295381','295383','295384','295482','295508','295522','295565','295574','295576','295654','295662','295689','295715','295732','295779','295781','295782','295818','295865','295990','295995','296183','296200','296257','296276','297012','297028','297088','297099','297107','297120','297180','297181','297194','297244','297257','297258','297284','297285','297291','297307','297308','297325','297370','297437','297450','297458','297467','297477','297555','297556','297581','297636','297683','297684','297687','297688','297689','297704','297733','297756','297758','297829','297854','297859','297860','297861','298015','298017','298018','298019','298021','298025','298056','298063','298100','298104','298105','298106','298109','298134','298153','298157','298162','298163','298169','298170','298171','298211','298224','298244','298253','298258','298261','298318','298319','298352','298357','298358','298359','298360','298361','298373','298374','298375','298376','298378','298379','298397','298406','298411','298445','298453','298477','298516','298517','298518','298528','298572','298584','299064','299122','299132','299137','299139','299140','299142','299143','299165','299176','299277','299279','299405','299502','299564','299636','299716','299738','299764','299765','299766','299771','299772','299776','299794','299795','299822','299823','299836','299906','299907','299929','299965','299966','299967','299968','299969','299970','299971','299972','299973','299974','299975','299976','299979','300019','300030','300031','300041','300057','300174','300205','300246','300383','300404','300496','300533','300535','300578','300580','300598','300610','300620','300646','300651','300653','300654','300665','300935','300996','301002','301018','301039','301040','301041','301042','301043','301044','301045','301046','301049','301050','301051','301052','301062','301063','301064','301800','301807','301808','301809','301810','301811','301812','301855','301892','301895','301906','301907','301908','301909','301939','301978','302111','302157','302189','302221','302287','302289','302291','302316','302338','302348','302349','302350','302352','302356','303790','303818','303908','303934','303940','304020','304024') GROUP BY `parent` ORDER BY `parent` ASC
childsstroke1: parent
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 ('152640','152642','152644','152650','152651','152655','152660','152662','153090','153093','153096','153103','153105','153106','153107','153108','153109','153116','153118','153121','153122','153139','153375','153384','153385','153386','153387','153388','153389','153390','153391','153415','153416','153417','153418','153419','153420','153421','153422','153423','153424','153426','153430','153569','153571','153575','153576','153577','153585','153587','153590','153591','153592','153595','153596','153598','153599','153621','153627','153635','153639','153653','153654','153773','153798','153799','153800','153801','153802','153803','153809','153820','153824','153880','153904','153905','153906','153907','153908','153909','153910','153923','153931','154132','154133','154134','154168','154245','154257','154279','154321','154322','154332','154333','154334','154335','154336','154337','154338','154339','154340','154341','154348','154471','154472','154488','154514','154515','154529','154530','154533','154547','154548','154567','154570','154571','154580','154581','154583','154584','154587','154588','154590','154594','154598','154607','154608','154609','154610','154629','154633','154642','154655','154656','154657','154658','154659','154661','154679','154711','154712','154713','154715','154716','154717','154718','154730','154731','154736','154747','154749','154790','154791','154792','154793','154794','154795','154796','154797','154825','154834','154835','154854','154855','154877','154884','154885','154886','154906','154907','154928','154952','154990','154991','154992','155029','155031','155054','155055','155056','155057','155058','155059','155060','155061','155062','155063','155065','155066','155067','155068','155069','155070','155071','155104','155105','155109','155110','155111','155112','155113','155114','155115','155121','155150','155151','155152','155153','155154','155155','155159','155160','155199','155265','155266','155267','155268','155269','155270','155271','155272','155273','155274','155275','155281','155286','155288','155302','155303','155520','155648','155653','155655','155656','155657','155801','155812','155867','156258','156260','156261','156267','156285','156286','156314','156315','156317','156320','156321','156322','156323','156324','156326','156327','156328','156329','156334','156335','156336','156337','156338','156339','156340','156341','156342','156343','156344','156345','156346','156347','156348','156352','156353','156354','156355','156356','156357','156358','156359','156360','156379','156380','156381','156382','156383','156384','156385','156388','156392','156394','156395','156396','156397','156398','156399','156400','156401','156402','156403','156404','156406','156407','156408','156409','156410','156411','156412','156413','156414','156415','156418','156419','156420','156421','156422','156423','156424','156425','156426','156427','156428','156429','156430','156431','156432','156433','156434','156435','156436','156437','156439','156441','156443','156445','156447','156451','156452','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156465','156466','156467','156468','156469','156470','156471','156472','156473','156474','156475','156476','156477','156478','156479','156480','156481','156482','156483','156484','156485','156486','156487','156490','156491','156492','156493','156494','156495','156497','156498','156499','156500','156502','156503','156504','156505','156506','156507','156508','156509','156511','156512','156513','156514','156515','156516','156517','156518','156520','156521','156522','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','156631','156633','156634','156779','156780','156789','156790','156791','156792','156793','156794','156795','156796','156797','156799','156800','156801','156802','156803','156804','156805','156806','156873','156874','156909','156912','156913','156914','156915','156916','156917','156918','156919','156920','156921','156922','156923','156924','156925','156926','156927','156928','156929','156930','156931','156932','156933','156934','156935','156936','156937','156941','156942','156945','156946','156947','156954','156955','156956','157010','157225','157226','157227','157228','157229','157230','157231','157258','157259','157261','157263','157264','157265','157270','157271','157275','157285','157288','157289','157290','157291','157292','157293','157294','157295','157296','157297','157408','157423','157424','157425','157426','157427','157428','157429','157430','157431','157432','157436','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157460','157463','157464','157465','157466','157468','157469','157470','157471','157472','157473','157474','157475','157476','157501','157502','157504','157505','157506','157510','157548','157553','157587','157711','157728','157729','157733','157740','157761','157762','157763','157782','157841','157844','157895','157896','157897','157902','157903','157961','157989','157991','157992','157999','158000','158005','158022','158023','158031','158146','158233','158249','158250','158262','158263','158292','158339','158350','158381','158398','158399','158400','158417','158423','158424','158550','158586','158613','158662','158757','158762','158767','158776','158777','158794','158795','158810','158811','158813','158826','158841','158842','158843','158844','158845','158846','158856','158955','158971','159003','159009','159010','159019','159028','159029','159030','159078','159079','159097','159098','159121','159143','159145','159146','159148','159149','159151','159152','159153','159154','159155','159156','159205','159225','159237','159253','159255','159314','159340','159341','159342','159343','159344','159345','159346','159347','159348','159349','159350','159351','159352','159353','159354','159355','159356','159357','159362','159369','159377','159390','159424','159450','159474','159475','159476','159527','159528','159529','159534','159552','159561','159570','159666','159667','159668','159706','159815','159913','159916','159917','159986','159987','159988','160038','160049','160058','160098','160100','160125','160126','160137','160208','160209','160216','160217','160218','160288','160302','160310','160316','160317','160345','160347','160363','160364','160365','160366','160367','160373','160374','160381','160401','160403','160413','160421','160430','160441','160488','160490','160504','160505','160557','160558','160559','160560','160580','160582','160618','160650','160651','160652','160682','160683','160742','160743','160744','160754','160761','160762','160763','160797','160821','160864','160865','160866','160894','160895','160933','160952','161047','161136','161142','161143','161144','161145','161182','161221','161222','161229','161230','161231','161233','161234','161235','161236','161237','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161359','161380','161383','161421','161428','161437','161438','161444','161445','161457','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161478','161479','161529','161548','161549','161550','161551','161552','161588','161593','161598','161606','161613','161614','161617','161619','161630','161631','161632','161633','161634','161644','161667','161668','161669','161670','161708','161709','161797','161798','161809','161824','161825','161834','161886','161893','161894','161895','161903','161904','161905','161906','161907','161912','161933','161934','161935','161956','161979','161980','162029','162030','162031','162032','162049','162080','162081','162220','162227','162269','162270','162271','162272','162285','162295','162305','162306','162307','162308','162335','162349','162360','162391','162410','162414','162415','162416','162417','162419','162420','162422','162447','162449','162479','162480','162481','162492','162493','162494','162495','162529','162530','162547','162548','162555','162556','162557','162558','162559','162560','162570','162579','162580','162633','162667','162714','162739','162748','162782','162787','162816','162832','162876','162935','162936','162942','163028','163053','163103','163108','163109','163110','163111','163112','163113','163123','163153','163154','163181','163231','163232','163233','163234','163288','163289','163294','163295','163321','163344','163466','163467','163529','163540','163541','163616','163617','163618','163620','163662','163676','163703','163723','163779','163780','163781','163782','163802','163828','163868','163878','163880','163890','163891','163892','163954','163963','163982','164009','164029','164052','164094','164124','164131','164132','164133','164134','164135','164140','164141','164142','164159','164160','164167','164233','164238','164247','164316','164422','164427','164433','164485','164499','164511','164514','164521','164522','164527','164534','164543','164545','164546','164553','164556','164557','164560','164561','164562','164563','164564','164565','164566','164567','164568','164596','164624','164656','164671','164672','164673','164679','164693','164733','164734','164736','164756','164757','164758','164759','164760','164761','164762','164763','164771','164805','164808','164809','164810','164835','164853','164875','164886','164919','164932','164957','164958','164992','165000','165004','165005','165016','165017','165030','165032','165033','165034','165035','165053','165065','165078','165080','165091','165131','165134','165147','165151','165152','165153','165154','165155','165156','165157','165162','165227','165244','165288','165289','165290','165291','165292','165305','165347','165348','165362','165408','165420','165479','165480','165491','165502','165514','165517','165524','165530','165539','165542','165550','165563','165564','165565','165574','165581','165672','165673','165676','165679','165691','165731','165750','165779','165840','165841','165858','165859','165860','165861','165862','165863','165864','165865','165866','165867','165868','165895','165896','165897','165906','165915','165936','165939','165957','165958','165959','165972','165973','165974','165975','165976','165983','166054','166082','166083','166084','166112','166135','166136','166137','166138','166165','166191','166192','166193','166194','166195','166251','166324','166325','166326','166444','166447','166451','166472','166492','166510','166521','166523','166524','166585','166586','166587','166588','166589','166670','166674','166675','166685','166719','166720','166721','166722','166723','166724','166731','166763','166764','166787','166792','166848','166855','166858','166871','166880','166884','166885','166889','166905','166906','166919','166928','166983','167001','167041','167073','167077','167092','167096','167107','167109','167110','167111','167112','167113','167117','167147','167148','167149','167150','167151','167152','167161','167210','167217','167262','167263','167292','167298','167308','167389','167403','167406','167412','167483','167553','167578','167585','167586','167620','167630','167641','167643','167648','167649','167664','167707','167708','167739','167740','167760','167769','167784','167828','167833','167851','167852','167862','167871','167900','167903','167920','167949','168009','168051','168055','168239','168324','168325','168335','168340','168394','168403','219748','219753','232438','232444','232461','232462','232518','232519','232561','232578','232603','232732','232780','238104','238235','238263','238264','238265','238284','238285','238286','238303','238304','238305','238406','238411','238438','238443','238450','238459','238512','238520','238528','238538','238539','238556','238567','238579','238712','238716','238717','238718','238724','238725','238734','238736','238762','238810','238832','238851','238852','238853','238854','238855','238856','238857','238858','238962','239170','239207','239217','239220','239312','239332','239514','239554','239590','239627','239818','239901','239947','240496','240571','240572','240573','240574','240575','240586','240717','240744','240875','240876','240877','240898','240924','240925','240926','240927','240989','240990','240991','240992','241279','241408','241864','241870','241871','242017','242018','242019','242020','242212','242248','242249','242250','242252','242253','242339','242443','242506','242706','242858','242902','242906','242939','242940','242941','242942','242992','242993','242994','242995','243025','243145','243146','243744','243841','243842','243845','243846','243863','243988','244106','244135','244180','244223','244224','244266','244324','244436','244548','244549','244562','244704','244780','244781','244782','244783','244784','244785','244809','244810','244811','244926','244967','245070','245073','245158','245170','245220','245221','245239','245240','245267','245268','245269','245292','245293','245294','245295','245296','245297','245391','245392','245394','245395','245396','245397','245398','245399','245400','245401','245402','245403','245404','245405','245406','245419','245493','245495','245543','245586','245587','245588','245600','245609','245778','245887','245931','245996','246063','246100','246185','246213','246252','246253','246254','246363','246443','246536','246583','246584','246585','246586','246629','246652','246667','246778','246792','246828','246919','246994','247039','247119','247120','247121','247122','247123','247124','247125','247126','247127','247128','247129','247130','247131','247132','247133','247134','247192','247196','247197','247487','247488','247497','247512','247535','247536','247599','247605','247606','247607','247608','247609','247610','247638','247674','247852','247853','247854','247855','247892','248086','248138','248168','248187','248188','248189','248199','248281','248300','248312','248315','248364','248399','248403','248404','248405','248406','248430','248446','248539','248544','248545','248596','248642','248744','248745','248913','248930','248940','248941','248950','248951','249007','249151','249166','249237','249253','249263','249302','249320','249346','249355','249356','249410','249412','249416','249418','249495','249496','249497','249541','249644','249663','249664','249685','249686','249687','249688','249716','249750','249770','249771','249784','249815','249862','249863','249896','249909','249913','249914','249922','250096','250099','250101','250126','250130','250149','250158','250159','250192','250213','250218','250292','250302','250303','250304','250305','250306','250307','250308','250309','250310','250311','250312','250313','250314','250315','250316','250317','250318','250319','250320','250321','250322','250328','250330','250348','250355','250356','250357','250358','250359','250360','250361','250362','250363','250364','250365','250366','250367','250368','250369','250370','250371','250372','250373','250374','250375','250376','250377','250378','250379','250380','250381','250382','250383','250384','250385','250386','250387','250388','250389','250390','250391','250392','250393','250394','250395','250396','250397','250398','250399','250400','250401','250402','250403','250404','250405','250406','250407','250408','250409','250410','250411','250412','250413','250414','250415','250416','250417','250418','250419','250420','250421','250422','250423','250424','250425','250426','250427','250428','250429','250430','250431','250432','250433','250434','250435','250436','250437','250438','250439','250440','250441','250442','250443','250444','250445','250446','250447','250448','250501','250502','250503','250504','250505','250525','250660','250702','250704','250756','250767','250772','250794','250796','250797','250803','250919','250966','251022','251137','251156','251172','251191','251217','251218','251219','251220','251221','251227','251252','251255','251257','251258','251259','251260','251280','251286','251344','251350','251408','251476','251520','251521','251522','251539','251550','251554','251555','251556','251557','251569','251577','251596','251597','251598','251599','251600','251602','251603','251604','251605','251606','251607','251633','251638','251639','251641','251669','251695','251733','251747','251759','251794','251795','251836','251837','251850','251867','251920','251945','251946','251947','251985','252010','252021','252045','252066','252089','252091','252093','252110','253033','253088','253125','253127','253128','253129','253136','253167','253231','253239','253241','253242','253246','253252','253253','253254','253259','253260','253263','253325','253326','253361','253392','253393','253394','253397','253398','253424','253463','253481','253488','253489','253490','253491','253513','253514','253515','253516','253517','253518','253519','253522','253537','253564','253586','253587','253588','253589','253592','253631','253638','253659','253737','253784','253792','253801','253802','253831','253832','253846','253849','253873','253874','253875','253876','253877','254196','254244','254245','254246','254247','254398','254399','254409','254410','254411','254412','254426','254459','254472','254545','254560','254561','254562','254586','254643','254748','254749','254750','254751','254752','254753','254754','254755','254756','254757','254917','254948','254991','255000','255018','255025','255078','255079','255080','255081','255193','255223','255225','255245','255344','255368','255372','255397','255398','255454','255505','255518','255605','255606','255607','255623','255638','255668','255731','255732','255733','255734','255735','255736','255740','255741','255742','255770','255809','255818','255819','255820','255821','255822','255823','255824','255825','255826','255827','255828','255829','255830','255831','255832','255833','255834','255835','255895','255896','255897','255898','255899','255900','255901','255902','255903','255904','255905','255906','255907','255908','255909','255910','255911','255912','255913','255914','255915','255916','255917','255918','255919','255920','255921','255922','255923','255924','255925','255926','255927','255928','255929','255930','255931','255932','255933','255934','255935','255936','255937','255938','255940','256103','256109','256110','256112','256122','256188','256277','256278','256279','256280','256282','256283','256284','256285','256286','256287','256288','256289','256290','256291','256292','256293','256294','256295','256296','256297','256298','256308','256317','256328','256329','256340','256343','256344','256499','256500','256507','256508','256515','256537','256539','256547','256668','256674','256675','256705','256759','256782','256783','256784','256853','256902','256904','256905','256922','256923','256931','257012','257013','257015','257016','257017','257018','257019','257021','257022','257023','257024','257025','257026','257028','257044','257045','257046','257047','257048','257049','257050','257051','257068','257117','257118','257155','257168','257169','257178','257180','257181','257192','257193','257194','257195','257197','257198','257199','257200','257201','257202','257203','257204','257205','257206','257207','257208','257209','257210','257211','257235','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261768','261936','261941','261949','261955','261956','261975','261989','262000','262032','262074','262082','262085','262086','262087','262106','262155','262188','262241','262383','262390','262440','262441','262442','262443','262444','262445','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262480','262481','262482','262483','262484','262485','262486','262487','262488','262489','262490','262491','262492','262493','262494','262495','262496','262497','262498','262499','262506','262520','262561','262608','262617','262628','262629','262630','262631','262632','262633','262634','262635','262636','262637','262638','262653','262720','262721','262738','262739','262740','262741','262742','262743','262744','262745','262746','262747','262748','262749','262750','262751','262756','262760','262783','262792','262796','262822','262823','262836','262837','262838','262839','262840','262841','262842','262843','262844','262845','262846','262847','262848','262849','262850','262851','262867','262881','262896','262898','262935','262995','262997','263085','263196','263469','263474','263507','263543','263550','263551','263635','263637','263642','263643','263651','263652','263653','263715','263754','264348','264503','264504','264505','264657','264658','264704','264705','264777','264797','264932','264934','265015','265017','265045','265063','265065','265068','265124','265125','265156','265167','265194','265195','265282','265283','265284','265319','265321','265361','265390','265429','265430','265437','265448','265520','265581','265657','265674','265675','265700','265742','265762','265776','265783','265805','265806','265917','265953','266148','266162','266245','266352','266353','266356','266408','266416','266417','266418','266419','266420','266421','266422','266423','266424','266425','266426','266427','266428','266429','266548','266582','266594','266684','266685','266686','266804','266823','266895','266988','266989','266990','267016','267024','267065','267084','267085','267089','267133','267134','267148','267169','267190','267191','267192','267193','267194','267195','267196','267197','267198','267199','267200','267201','267202','267203','267205','267206','267215','267288','267345','267356','267404','267409','267419','267420','267497','267514','267551','267565','267566','267577','267618','267664','267750','267751','267869','267959','267976','267977','268073','268141','268232','268234','268246','268247','268250','268309','268320','268352','268359','268361','268372','268374','268375','268395','268410','268412','268450','268455','268456','268484','268513','268515','268520','268523','268561','268562','268603','268705','268724','268781','268898','269031','269043','269047','269077','269106','269110','269111','269113','269149','269152','269153','269180','269204','269206','269244','269246','269247','269248','269249','269250','269251','269252','269393','269441','269470','269475','269476','269477','269478','269479','269480','269512','269513','269514','269520','269527','269557','273337','273338','273359','273370','273428','273439','273464','273472','273490','273506','273536','273588','273589','273699','273713','273723','273828','273829','273832','273844','273892','273893','273946','273960','273974','274139','274141','274278','274298','274327','274397','274398','274399','274400','274419','274443','274477','274592','274604','274607','274615','274616','274628','274657','274658','274672','274679','274682','274695','274697','274764','274778','274800','274817','274828','274836','274837','274838','274839','274840','274888','274894','274905','274912','274990','274991','275073','275074','275075','275076','275228','275248','275298','275395','275421','275458','275494','275499','275522','275555','275566','275604','275619','275655','275662','275663','275689','275692','275753','275757','275783','275822','275823','275977','276010','276059','276070','276087','276130','276145','276216','276217','276218','276255','276286','276287','276289','276290','276339','276349','276385','276388','276389','276398','276409','276410','276411','276412','276413','276414','276416','276473','276474','276481','276514','276515','276534','276546','276547','276548','276549','276550','276572','276607','276613','276614','276615','276638','276697','276700','276940','276972','276973','276993','277016','277018','277035','277037','277038','277070','277175','277176','277196','277207','277250','277255','277264','277265','277266','277289','277304','277306','277308','277313','277336','277358','277384','277397','277430','277439','277440','277441','277442','277443','277444','277445','277460','277461','277462','277474','277493','277524','277525','277526','277527','277528','277529','277530','277531','277584','277633','277645','277647','277648','277689','277712','277749','277750','277777','277791','277809','277915','277916','277917','277938','277939','277953','278054','278058','278075','278102','278103','278128','278142','278163','278164','278188','278221','278224','278240','278242','278318','278379','278429','278445','278446','278480','278507','278542','278560','278566','278572','278640','278754','278774','278850','278851','278900','278901','278950','279013','279023','279057','279059','279094','279100','279134','279207','279226','279295','279301','279336','279422','279440','279469','279479','279582','279585','279698','279705','279732','279735','279740','280303','280305','280369','280374','280375','280380','280381','280382','280386','280428','280450','280491','280492','280709','280723','280728','280729','280760','280761','280773','280778','280805','280808','280810','280832','280850','280855','280943','280944','280945','280979','281034','281056','281091','281133','281143','281144','281145','281146','281150','281151','281180','281195','281224','281230','281232','281235','281243','281268','281278','281336','281339','281473','281489','281651','281652','281689','281764','281770','281774','281776','281777','281865','282074','282144','282164','282165','282167','282168','282172','282190','282275','282295','282341','282342','282402','282476','282483','282521','282541','282572','282670','282767','282813','282843','282868','282902','282945','283001','283219','283225','283226','283227','283228','283313','283380','283504','283505','283542','283555','283597','283598','283599','283600','283611','283622','283623','283630','283634','283635','283730','283735','283736','283737','283763','284140','284284','284312','284356','284415','284441','284443','284444','284445','284504','284505','284506','284507','284508','284528','284550','284562','284599','284625','284644','284662','284745','284831','284836','284860','284896','284900','284914','284948','285024','285098','285106','285169','285177','285230','285247','285248','285249','285270','285334','285378','285379','285395','285403','285429','285444','285566','285578','285579','285591','285592','285593','285622','285627','285676','285677','285707','285732','285733','285734','285742','285793','285794','285795','285833','285903','285934','285984','286014','286028','286034','286062','286068','286120','286162','286199','286206','286344','286349','286358','286373','286400','286444','286640','286816','286860','286867','286873','286899','286913','286914','286915','286916','286917','286918','287011','287030','287031','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','287110','287111','287113','287114','287115','287116','287117','287118','287119','287120','287121','287122','287140','287141','287173','287202','287218','287557','287780','287782','287980','287982','287988','287995','288025','288026','288139','288163','288172','288173','288174','288175','288176','288177','288186','288217','288232','288234','288235','288260','288275','288299','288316','288351','288357','288358','288414','288416','288422','288441','288444','288470','288474','288477','288478','288480','288506','288534','288577','288580','288625','288663','288702','288709','288994','289011','289034','289035','289036','289037','289038','289039','289040','289041','289044','289045','289046','289047','289048','289049','289050','289051','289052','289053','289221','289227','289413','289466','289476','289483','289484','289485','289486','291708','291709','291711','291736','291744','291818','291864','291868','291869','291877','291878','291938','291947','291974','291975','291986','291987','291988','292007','292223','292224','292225','292245','292276','292304','292308','292309','292311','292312','292313','292323','292324','292339','292340','292341','292342','292343','292344','292362','292376','292399','292410','292411','292486','292492','292493','292511','292530','292531','292597','292607','292608','292609','292610','292611','292612','292621','292623','292654','292662','292692','292735','292736','292737','292738','292739','292744','292745','292746','292747','292748','292776','292839','292904','293209','293210','293231','293281','293282','293369','293373','293374','293403','293404','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','293451','293491','293519','293527','293558','293566','293575','293593','293604','293638','293934','294004','294067','294068','294069','294070','294187','294202','294273','294297','294311','294326','294327','294328','294329','294330','294371','294419','294420','294497','294509','294544','294548','294553','294561','294565','294567','294568','294570','294589','294590','294611','294664','294669','294702','294710','294725','294738','294739','294740','294741','294742','294743','294744','294803','294814','294847','294848','294849','294904','294928','294978','295153','295154','295155','295304','295316','295379','295381','295383','295384','295482','295508','295522','295565','295574','295576','295654','295662','295689','295715','295732','295779','295781','295782','295818','295865','295990','295995','296183','296200','296257','296276','297012','297028','297088','297099','297107','297120','297180','297181','297194','297244','297257','297258','297284','297285','297291','297307','297308','297325','297370','297437','297450','297458','297467','297477','297555','297556','297581','297636','297683','297684','297687','297688','297689','297704','297733','297756','297758','297829','297854','297859','297860','297861','298015','298017','298018','298019','298021','298025','298056','298063','298100','298104','298105','298106','298109','298134','298153','298157','298162','298163','298169','298170','298171','298211','298224','298244','298253','298258','298261','298318','298319','298352','298357','298358','298359','298360','298361','298373','298374','298375','298376','298378','298379','298397','298406','298411','298445','298453','298477','298516','298517','298518','298528','298572','298584','299064','299122','299132','299137','299139','299140','299142','299143','299165','299176','299277','299279','299405','299502','299564','299636','299716','299738','299764','299765','299766','299771','299772','299776','299794','299795','299822','299823','299836','299906','299907','299929','299965','299966','299967','299968','299969','299970','299971','299972','299973','299974','299975','299976','299979','300019','300030','300031','300041','300057','300174','300205','300246','300383','300404','300496','300533','300535','300578','300580','300598','300610','300620','300646','300651','300653','300654','300665','300935','300996','301002','301018','301039','301040','301041','301042','301043','301044','301045','301046','301049','301050','301051','301052','301062','301063','301064','301800','301807','301808','301809','301810','301811','301812','301855','301892','301895','301906','301907','301908','301909','301939','301978','302111','302157','302189','302221','302287','302289','302291','302316','302338','302348','302349','302350','302352','302356','303790','303818','303908','303934','303940','304020','304024') GROUP BY `parent` ORDER BY `parent` ASC
childsstroke: series
SELECT `series`,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 `series` !='' AND `modx_site_content`.`id` IN ('152640','152642','152644','152650','152651','152655','152660','152662','153090','153093','153096','153103','153105','153106','153107','153108','153109','153116','153118','153121','153122','153139','153375','153384','153385','153386','153387','153388','153389','153390','153391','153415','153416','153417','153418','153419','153420','153421','153422','153423','153424','153426','153430','153569','153571','153575','153576','153577','153585','153587','153590','153591','153592','153595','153596','153598','153599','153621','153627','153635','153639','153653','153654','153773','153798','153799','153800','153801','153802','153803','153809','153820','153824','153880','153904','153905','153906','153907','153908','153909','153910','153923','153931','154132','154133','154134','154168','154245','154257','154279','154321','154322','154332','154333','154334','154335','154336','154337','154338','154339','154340','154341','154348','154471','154472','154488','154514','154515','154529','154530','154533','154547','154548','154567','154570','154571','154580','154581','154583','154584','154587','154588','154590','154594','154598','154607','154608','154609','154610','154629','154633','154642','154655','154656','154657','154658','154659','154661','154679','154711','154712','154713','154715','154716','154717','154718','154730','154731','154736','154747','154749','154790','154791','154792','154793','154794','154795','154796','154797','154825','154834','154835','154854','154855','154877','154884','154885','154886','154906','154907','154928','154952','154990','154991','154992','155029','155031','155054','155055','155056','155057','155058','155059','155060','155061','155062','155063','155065','155066','155067','155068','155069','155070','155071','155104','155105','155109','155110','155111','155112','155113','155114','155115','155121','155150','155151','155152','155153','155154','155155','155159','155160','155199','155265','155266','155267','155268','155269','155270','155271','155272','155273','155274','155275','155281','155286','155288','155302','155303','155520','155648','155653','155655','155656','155657','155801','155812','155867','156258','156260','156261','156267','156285','156286','156314','156315','156317','156320','156321','156322','156323','156324','156326','156327','156328','156329','156334','156335','156336','156337','156338','156339','156340','156341','156342','156343','156344','156345','156346','156347','156348','156352','156353','156354','156355','156356','156357','156358','156359','156360','156379','156380','156381','156382','156383','156384','156385','156388','156392','156394','156395','156396','156397','156398','156399','156400','156401','156402','156403','156404','156406','156407','156408','156409','156410','156411','156412','156413','156414','156415','156418','156419','156420','156421','156422','156423','156424','156425','156426','156427','156428','156429','156430','156431','156432','156433','156434','156435','156436','156437','156439','156441','156443','156445','156447','156451','156452','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156465','156466','156467','156468','156469','156470','156471','156472','156473','156474','156475','156476','156477','156478','156479','156480','156481','156482','156483','156484','156485','156486','156487','156490','156491','156492','156493','156494','156495','156497','156498','156499','156500','156502','156503','156504','156505','156506','156507','156508','156509','156511','156512','156513','156514','156515','156516','156517','156518','156520','156521','156522','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','156631','156633','156634','156779','156780','156789','156790','156791','156792','156793','156794','156795','156796','156797','156799','156800','156801','156802','156803','156804','156805','156806','156873','156874','156909','156912','156913','156914','156915','156916','156917','156918','156919','156920','156921','156922','156923','156924','156925','156926','156927','156928','156929','156930','156931','156932','156933','156934','156935','156936','156937','156941','156942','156945','156946','156947','156954','156955','156956','157010','157225','157226','157227','157228','157229','157230','157231','157258','157259','157261','157263','157264','157265','157270','157271','157275','157285','157288','157289','157290','157291','157292','157293','157294','157295','157296','157297','157408','157423','157424','157425','157426','157427','157428','157429','157430','157431','157432','157436','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157460','157463','157464','157465','157466','157468','157469','157470','157471','157472','157473','157474','157475','157476','157501','157502','157504','157505','157506','157510','157548','157553','157587','157711','157728','157729','157733','157740','157761','157762','157763','157782','157841','157844','157895','157896','157897','157902','157903','157961','157989','157991','157992','157999','158000','158005','158022','158023','158031','158146','158233','158249','158250','158262','158263','158292','158339','158350','158381','158398','158399','158400','158417','158423','158424','158550','158586','158613','158662','158757','158762','158767','158776','158777','158794','158795','158810','158811','158813','158826','158841','158842','158843','158844','158845','158846','158856','158955','158971','159003','159009','159010','159019','159028','159029','159030','159078','159079','159097','159098','159121','159143','159145','159146','159148','159149','159151','159152','159153','159154','159155','159156','159205','159225','159237','159253','159255','159314','159340','159341','159342','159343','159344','159345','159346','159347','159348','159349','159350','159351','159352','159353','159354','159355','159356','159357','159362','159369','159377','159390','159424','159450','159474','159475','159476','159527','159528','159529','159534','159552','159561','159570','159666','159667','159668','159706','159815','159913','159916','159917','159986','159987','159988','160038','160049','160058','160098','160100','160125','160126','160137','160208','160209','160216','160217','160218','160288','160302','160310','160316','160317','160345','160347','160363','160364','160365','160366','160367','160373','160374','160381','160401','160403','160413','160421','160430','160441','160488','160490','160504','160505','160557','160558','160559','160560','160580','160582','160618','160650','160651','160652','160682','160683','160742','160743','160744','160754','160761','160762','160763','160797','160821','160864','160865','160866','160894','160895','160933','160952','161047','161136','161142','161143','161144','161145','161182','161221','161222','161229','161230','161231','161233','161234','161235','161236','161237','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161359','161380','161383','161421','161428','161437','161438','161444','161445','161457','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161478','161479','161529','161548','161549','161550','161551','161552','161588','161593','161598','161606','161613','161614','161617','161619','161630','161631','161632','161633','161634','161644','161667','161668','161669','161670','161708','161709','161797','161798','161809','161824','161825','161834','161886','161893','161894','161895','161903','161904','161905','161906','161907','161912','161933','161934','161935','161956','161979','161980','162029','162030','162031','162032','162049','162080','162081','162220','162227','162269','162270','162271','162272','162285','162295','162305','162306','162307','162308','162335','162349','162360','162391','162410','162414','162415','162416','162417','162419','162420','162422','162447','162449','162479','162480','162481','162492','162493','162494','162495','162529','162530','162547','162548','162555','162556','162557','162558','162559','162560','162570','162579','162580','162633','162667','162714','162739','162748','162782','162787','162816','162832','162876','162935','162936','162942','163028','163053','163103','163108','163109','163110','163111','163112','163113','163123','163153','163154','163181','163231','163232','163233','163234','163288','163289','163294','163295','163321','163344','163466','163467','163529','163540','163541','163616','163617','163618','163620','163662','163676','163703','163723','163779','163780','163781','163782','163802','163828','163868','163878','163880','163890','163891','163892','163954','163963','163982','164009','164029','164052','164094','164124','164131','164132','164133','164134','164135','164140','164141','164142','164159','164160','164167','164233','164238','164247','164316','164422','164427','164433','164485','164499','164511','164514','164521','164522','164527','164534','164543','164545','164546','164553','164556','164557','164560','164561','164562','164563','164564','164565','164566','164567','164568','164596','164624','164656','164671','164672','164673','164679','164693','164733','164734','164736','164756','164757','164758','164759','164760','164761','164762','164763','164771','164805','164808','164809','164810','164835','164853','164875','164886','164919','164932','164957','164958','164992','165000','165004','165005','165016','165017','165030','165032','165033','165034','165035','165053','165065','165078','165080','165091','165131','165134','165147','165151','165152','165153','165154','165155','165156','165157','165162','165227','165244','165288','165289','165290','165291','165292','165305','165347','165348','165362','165408','165420','165479','165480','165491','165502','165514','165517','165524','165530','165539','165542','165550','165563','165564','165565','165574','165581','165672','165673','165676','165679','165691','165731','165750','165779','165840','165841','165858','165859','165860','165861','165862','165863','165864','165865','165866','165867','165868','165895','165896','165897','165906','165915','165936','165939','165957','165958','165959','165972','165973','165974','165975','165976','165983','166054','166082','166083','166084','166112','166135','166136','166137','166138','166165','166191','166192','166193','166194','166195','166251','166324','166325','166326','166444','166447','166451','166472','166492','166510','166521','166523','166524','166585','166586','166587','166588','166589','166670','166674','166675','166685','166719','166720','166721','166722','166723','166724','166731','166763','166764','166787','166792','166848','166855','166858','166871','166880','166884','166885','166889','166905','166906','166919','166928','166983','167001','167041','167073','167077','167092','167096','167107','167109','167110','167111','167112','167113','167117','167147','167148','167149','167150','167151','167152','167161','167210','167217','167262','167263','167292','167298','167308','167389','167403','167406','167412','167483','167553','167578','167585','167586','167620','167630','167641','167643','167648','167649','167664','167707','167708','167739','167740','167760','167769','167784','167828','167833','167851','167852','167862','167871','167900','167903','167920','167949','168009','168051','168055','168239','168324','168325','168335','168340','168394','168403','169267','219748','219753','232438','232444','232461','232462','232518','232519','232561','232578','232603','232732','232780','238104','238235','238263','238264','238265','238284','238285','238286','238303','238304','238305','238406','238411','238438','238443','238450','238459','238512','238520','238528','238538','238539','238556','238567','238579','238712','238716','238717','238718','238724','238725','238734','238736','238762','238810','238832','238851','238852','238853','238854','238855','238856','238857','238858','238962','239170','239207','239217','239220','239312','239332','239514','239554','239590','239627','239818','239901','239947','240496','240571','240572','240573','240574','240575','240586','240717','240744','240875','240876','240877','240898','240924','240925','240926','240927','240989','240990','240991','240992','241279','241408','241864','241870','241871','242017','242018','242019','242020','242212','242248','242249','242250','242252','242253','242339','242443','242506','242706','242858','242902','242906','242939','242940','242941','242942','242992','242993','242994','242995','243025','243145','243146','243744','243841','243842','243845','243846','243863','243988','244106','244135','244180','244223','244224','244266','244324','244436','244548','244549','244562','244704','244780','244781','244782','244783','244784','244785','244809','244810','244811','244926','244967','245070','245073','245158','245170','245220','245221','245239','245240','245267','245268','245269','245292','245293','245294','245295','245296','245297','245391','245392','245394','245395','245396','245397','245398','245399','245400','245401','245402','245403','245404','245405','245406','245419','245493','245495','245543','245586','245587','245588','245600','245609','245778','245887','245931','245996','246063','246100','246185','246213','246252','246253','246254','246363','246443','246536','246583','246584','246585','246586','246629','246652','246667','246778','246792','246828','246919','246994','247039','247119','247120','247121','247122','247123','247124','247125','247126','247127','247128','247129','247130','247131','247132','247133','247134','247192','247196','247197','247487','247488','247497','247512','247535','247536','247599','247605','247606','247607','247608','247609','247610','247638','247674','247852','247853','247854','247855','247892','248086','248138','248168','248187','248188','248189','248199','248281','248300','248312','248315','248364','248399','248403','248404','248405','248406','248430','248446','248539','248544','248545','248596','248642','248744','248745','248913','248930','248940','248941','248950','248951','249007','249151','249166','249237','249253','249263','249302','249320','249346','249355','249356','249410','249412','249416','249418','249495','249496','249497','249541','249644','249663','249664','249685','249686','249687','249688','249716','249750','249770','249771','249784','249815','249862','249863','249896','249909','249913','249914','249922','250096','250099','250101','250126','250130','250149','250158','250159','250192','250213','250218','250292','250302','250303','250304','250305','250306','250307','250308','250309','250310','250311','250312','250313','250314','250315','250316','250317','250318','250319','250320','250321','250322','250328','250330','250348','250355','250356','250357','250358','250359','250360','250361','250362','250363','250364','250365','250366','250367','250368','250369','250370','250371','250372','250373','250374','250375','250376','250377','250378','250379','250380','250381','250382','250383','250384','250385','250386','250387','250388','250389','250390','250391','250392','250393','250394','250395','250396','250397','250398','250399','250400','250401','250402','250403','250404','250405','250406','250407','250408','250409','250410','250411','250412','250413','250414','250415','250416','250417','250418','250419','250420','250421','250422','250423','250424','250425','250426','250427','250428','250429','250430','250431','250432','250433','250434','250435','250436','250437','250438','250439','250440','250441','250442','250443','250444','250445','250446','250447','250448','250501','250502','250503','250504','250505','250525','250660','250702','250704','250756','250767','250772','250794','250796','250797','250803','250919','250966','251022','251137','251156','251172','251191','251217','251218','251219','251220','251221','251227','251252','251255','251257','251258','251259','251260','251280','251286','251344','251350','251408','251476','251520','251521','251522','251539','251550','251554','251555','251556','251557','251569','251577','251596','251597','251598','251599','251600','251602','251603','251604','251605','251606','251607','251633','251638','251639','251641','251669','251695','251733','251747','251759','251794','251795','251836','251837','251850','251867','251920','251945','251946','251947','251985','252010','252021','252045','252066','252089','252091','252093','252110','253033','253088','253125','253127','253128','253129','253136','253167','253231','253239','253241','253242','253246','253252','253253','253254','253259','253260','253263','253325','253326','253361','253392','253393','253394','253397','253398','253424','253463','253481','253488','253489','253490','253491','253513','253514','253515','253516','253517','253518','253519','253522','253537','253564','253586','253587','253588','253589','253592','253631','253638','253659','253737','253784','253792','253801','253802','253831','253832','253846','253849','253873','253874','253875','253876','253877','254196','254244','254245','254246','254247','254398','254399','254409','254410','254411','254412','254426','254459','254472','254545','254560','254561','254562','254586','254643','254748','254749','254750','254751','254752','254753','254754','254755','254756','254757','254917','254948','254991','255000','255018','255025','255078','255079','255080','255081','255193','255223','255225','255245','255344','255368','255372','255397','255398','255454','255505','255518','255605','255606','255607','255623','255638','255668','255731','255732','255733','255734','255735','255736','255740','255741','255742','255770','255809','255818','255819','255820','255821','255822','255823','255824','255825','255826','255827','255828','255829','255830','255831','255832','255833','255834','255835','255895','255896','255897','255898','255899','255900','255901','255902','255903','255904','255905','255906','255907','255908','255909','255910','255911','255912','255913','255914','255915','255916','255917','255918','255919','255920','255921','255922','255923','255924','255925','255926','255927','255928','255929','255930','255931','255932','255933','255934','255935','255936','255937','255938','255940','256103','256109','256110','256112','256122','256188','256277','256278','256279','256280','256282','256283','256284','256285','256286','256287','256288','256289','256290','256291','256292','256293','256294','256295','256296','256297','256298','256308','256317','256328','256329','256340','256343','256344','256499','256500','256507','256508','256515','256537','256539','256547','256668','256674','256675','256705','256759','256782','256783','256784','256853','256902','256904','256905','256922','256923','256931','257012','257013','257015','257016','257017','257018','257019','257021','257022','257023','257024','257025','257026','257028','257044','257045','257046','257047','257048','257049','257050','257051','257068','257117','257118','257155','257168','257169','257178','257180','257181','257192','257193','257194','257195','257197','257198','257199','257200','257201','257202','257203','257204','257205','257206','257207','257208','257209','257210','257211','257235','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261768','261936','261941','261949','261955','261956','261975','261989','262000','262032','262074','262082','262085','262086','262087','262106','262155','262188','262241','262383','262390','262440','262441','262442','262443','262444','262445','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262480','262481','262482','262483','262484','262485','262486','262487','262488','262489','262490','262491','262492','262493','262494','262495','262496','262497','262498','262499','262506','262520','262561','262608','262617','262628','262629','262630','262631','262632','262633','262634','262635','262636','262637','262638','262653','262720','262721','262738','262739','262740','262741','262742','262743','262744','262745','262746','262747','262748','262749','262750','262751','262756','262760','262783','262792','262796','262822','262823','262836','262837','262838','262839','262840','262841','262842','262843','262844','262845','262846','262847','262848','262849','262850','262851','262867','262881','262896','262898','262935','262995','262997','263085','263196','263469','263474','263507','263543','263550','263551','263635','263637','263642','263643','263651','263652','263653','263715','263754','264348','264503','264504','264505','264657','264658','264704','264705','264777','264797','264932','264934','265015','265017','265045','265063','265065','265068','265124','265125','265156','265167','265194','265195','265282','265283','265284','265319','265321','265361','265390','265429','265430','265437','265448','265520','265581','265657','265674','265675','265700','265742','265762','265776','265783','265805','265806','265917','265953','266148','266162','266245','266352','266353','266356','266408','266416','266417','266418','266419','266420','266421','266422','266423','266424','266425','266426','266427','266428','266429','266548','266582','266594','266684','266685','266686','266804','266823','266895','266988','266989','266990','267016','267024','267065','267084','267085','267089','267133','267134','267148','267169','267190','267191','267192','267193','267194','267195','267196','267197','267198','267199','267200','267201','267202','267203','267205','267206','267215','267288','267345','267356','267404','267409','267419','267420','267497','267514','267551','267565','267566','267577','267618','267664','267750','267751','267869','267959','267976','267977','268073','268141','268232','268234','268246','268247','268250','268309','268320','268352','268359','268361','268372','268374','268375','268395','268410','268412','268450','268455','268456','268484','268513','268515','268520','268523','268561','268562','268603','268705','268724','268781','268898','269031','269043','269047','269077','269106','269110','269111','269113','269149','269152','269153','269180','269204','269206','269244','269246','269247','269248','269249','269250','269251','269252','269393','269441','269470','269475','269476','269477','269478','269479','269480','269512','269513','269514','269520','269527','269557','273337','273338','273359','273370','273428','273439','273464','273472','273490','273506','273536','273588','273589','273699','273713','273723','273828','273829','273832','273844','273892','273893','273946','273960','273974','274139','274141','274278','274298','274327','274397','274398','274399','274400','274419','274443','274477','274592','274604','274607','274615','274616','274628','274657','274658','274672','274679','274682','274695','274697','274764','274778','274800','274817','274828','274836','274837','274838','274839','274840','274888','274894','274905','274912','274990','274991','275073','275074','275075','275076','275228','275248','275298','275395','275421','275458','275494','275499','275522','275555','275566','275604','275619','275655','275662','275663','275689','275692','275753','275757','275783','275822','275823','275977','276010','276059','276070','276087','276130','276145','276216','276217','276218','276255','276286','276287','276289','276290','276339','276349','276385','276388','276389','276398','276409','276410','276411','276412','276413','276414','276416','276473','276474','276481','276514','276515','276534','276546','276547','276548','276549','276550','276572','276607','276613','276614','276615','276638','276697','276700','276940','276972','276973','276993','277016','277018','277035','277037','277038','277070','277175','277176','277196','277207','277250','277255','277264','277265','277266','277289','277304','277306','277308','277313','277336','277358','277384','277397','277430','277439','277440','277441','277442','277443','277444','277445','277460','277461','277462','277474','277493','277524','277525','277526','277527','277528','277529','277530','277531','277584','277633','277645','277647','277648','277689','277712','277749','277750','277777','277791','277809','277915','277916','277917','277938','277939','277953','278054','278058','278075','278102','278103','278128','278142','278163','278164','278188','278221','278224','278240','278242','278318','278379','278429','278445','278446','278480','278507','278542','278560','278566','278572','278640','278754','278774','278850','278851','278900','278901','278950','279013','279023','279057','279059','279094','279100','279134','279207','279226','279295','279301','279336','279422','279440','279469','279479','279582','279585','279698','279705','279732','279735','279740','280303','280305','280369','280374','280375','280380','280381','280382','280386','280428','280450','280491','280492','280709','280723','280728','280729','280760','280761','280773','280778','280805','280808','280810','280832','280850','280855','280943','280944','280945','280979','281034','281056','281091','281133','281143','281144','281145','281146','281150','281151','281180','281195','281224','281230','281232','281235','281243','281268','281278','281336','281339','281473','281489','281651','281652','281689','281764','281770','281774','281776','281777','281865','282074','282144','282164','282165','282167','282168','282172','282190','282275','282295','282341','282342','282402','282476','282483','282521','282541','282572','282670','282767','282813','282843','282868','282902','282945','283001','283219','283225','283226','283227','283228','283313','283380','283504','283505','283542','283555','283597','283598','283599','283600','283611','283622','283623','283630','283634','283635','283730','283735','283736','283737','283763','284140','284284','284312','284356','284415','284441','284443','284444','284445','284504','284505','284506','284507','284508','284528','284550','284562','284599','284625','284644','284662','284745','284831','284836','284860','284896','284900','284914','284948','285024','285098','285106','285169','285177','285230','285247','285248','285249','285270','285334','285378','285379','285395','285403','285429','285444','285566','285578','285579','285591','285592','285593','285622','285627','285676','285677','285707','285732','285733','285734','285742','285793','285794','285795','285833','285903','285934','285984','286014','286028','286034','286062','286068','286120','286162','286199','286206','286344','286349','286358','286373','286400','286444','286640','286816','286860','286867','286873','286899','286913','286914','286915','286916','286917','286918','287011','287030','287031','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','287110','287111','287113','287114','287115','287116','287117','287118','287119','287120','287121','287122','287140','287141','287173','287202','287218','287557','287780','287782','287980','287982','287988','287995','288025','288026','288139','288163','288172','288173','288174','288175','288176','288177','288186','288217','288232','288234','288235','288260','288275','288299','288316','288351','288357','288358','288414','288416','288422','288441','288444','288470','288474','288477','288478','288480','288506','288534','288577','288580','288625','288663','288702','288709','288994','289011','289034','289035','289036','289037','289038','289039','289040','289041','289044','289045','289046','289047','289048','289049','289050','289051','289052','289053','289221','289227','289413','289466','289476','289483','289484','289485','289486','291708','291709','291711','291736','291744','291818','291864','291868','291869','291877','291878','291938','291947','291974','291975','291986','291987','291988','292007','292223','292224','292225','292245','292276','292304','292308','292309','292311','292312','292313','292323','292324','292339','292340','292341','292342','292343','292344','292362','292376','292399','292410','292411','292486','292492','292493','292511','292530','292531','292597','292607','292608','292609','292610','292611','292612','292621','292623','292654','292662','292692','292735','292736','292737','292738','292739','292744','292745','292746','292747','292748','292776','292839','292904','293209','293210','293231','293281','293282','293369','293373','293374','293403','293404','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','293451','293491','293519','293527','293558','293566','293575','293593','293604','293638','293934','294004','294067','294068','294069','294070','294187','294202','294273','294297','294311','294326','294327','294328','294329','294330','294371','294419','294420','294497','294509','294544','294548','294553','294561','294565','294567','294568','294570','294589','294590','294611','294664','294669','294702','294710','294725','294738','294739','294740','294741','294742','294743','294744','294803','294814','294847','294848','294849','294904','294928','294978','295153','295154','295155','295304','295316','295379','295381','295383','295384','295482','295508','295522','295565','295574','295576','295654','295662','295689','295715','295732','295779','295781','295782','295818','295865','295990','295995','296183','296200','296257','296276','297012','297028','297088','297099','297107','297120','297180','297181','297194','297244','297257','297258','297284','297285','297291','297307','297308','297325','297370','297437','297450','297458','297467','297477','297555','297556','297581','297636','297683','297684','297687','297688','297689','297704','297733','297756','297758','297829','297854','297859','297860','297861','298015','298017','298018','298019','298021','298025','298056','298063','298100','298104','298105','298106','298109','298134','298153','298157','298162','298163','298169','298170','298171','298211','298224','298244','298253','298258','298261','298318','298319','298352','298357','298358','298359','298360','298361','298373','298374','298375','298376','298378','298379','298397','298406','298411','298445','298453','298477','298516','298517','298518','298528','298572','298584','299064','299122','299132','299137','299139','299140','299142','299143','299165','299176','299277','299279','299405','299502','299564','299636','299716','299738','299764','299765','299766','299771','299772','299776','299794','299795','299822','299823','299836','299906','299907','299929','299965','299966','299967','299968','299969','299970','299971','299972','299973','299974','299975','299976','299979','300019','300030','300031','300041','300057','300174','300205','300246','300383','300404','300496','300533','300535','300578','300580','300598','300610','300620','300646','300651','300653','300654','300665','300935','300996','301002','301018','301039','301040','301041','301042','301043','301044','301045','301046','301049','301050','301051','301052','301062','301063','301064','301800','301807','301808','301809','301810','301811','301812','301855','301892','301895','301906','301907','301908','301909','301939','301978','302111','302157','302189','302221','302287','302289','302291','302316','302338','302348','302349','302350','302352','302356','303790','303818','303908','303934','303940','304020','304024') GROUP BY `series` ORDER BY `series` ASC
childsstroke1: series
SELECT `series`,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 `series` !='' AND `modx_site_content`.`id` IN ('152640','152642','152644','152650','152651','152655','152660','152662','153090','153093','153096','153103','153105','153106','153107','153108','153109','153116','153118','153121','153122','153139','153375','153384','153385','153386','153387','153388','153389','153390','153391','153415','153416','153417','153418','153419','153420','153421','153422','153423','153424','153426','153430','153569','153571','153575','153576','153577','153585','153587','153590','153591','153592','153595','153596','153598','153599','153621','153627','153635','153639','153653','153654','153773','153798','153799','153800','153801','153802','153803','153809','153820','153824','153880','153904','153905','153906','153907','153908','153909','153910','153923','153931','154132','154133','154134','154168','154245','154257','154279','154321','154322','154332','154333','154334','154335','154336','154337','154338','154339','154340','154341','154348','154471','154472','154488','154514','154515','154529','154530','154533','154547','154548','154567','154570','154571','154580','154581','154583','154584','154587','154588','154590','154594','154598','154607','154608','154609','154610','154629','154633','154642','154655','154656','154657','154658','154659','154661','154679','154711','154712','154713','154715','154716','154717','154718','154730','154731','154736','154747','154749','154790','154791','154792','154793','154794','154795','154796','154797','154825','154834','154835','154854','154855','154877','154884','154885','154886','154906','154907','154928','154952','154990','154991','154992','155029','155031','155054','155055','155056','155057','155058','155059','155060','155061','155062','155063','155065','155066','155067','155068','155069','155070','155071','155104','155105','155109','155110','155111','155112','155113','155114','155115','155121','155150','155151','155152','155153','155154','155155','155159','155160','155199','155265','155266','155267','155268','155269','155270','155271','155272','155273','155274','155275','155281','155286','155288','155302','155303','155520','155648','155653','155655','155656','155657','155801','155812','155867','156258','156260','156261','156267','156285','156286','156314','156315','156317','156320','156321','156322','156323','156324','156326','156327','156328','156329','156334','156335','156336','156337','156338','156339','156340','156341','156342','156343','156344','156345','156346','156347','156348','156352','156353','156354','156355','156356','156357','156358','156359','156360','156379','156380','156381','156382','156383','156384','156385','156388','156392','156394','156395','156396','156397','156398','156399','156400','156401','156402','156403','156404','156406','156407','156408','156409','156410','156411','156412','156413','156414','156415','156418','156419','156420','156421','156422','156423','156424','156425','156426','156427','156428','156429','156430','156431','156432','156433','156434','156435','156436','156437','156439','156441','156443','156445','156447','156451','156452','156453','156454','156455','156456','156457','156458','156459','156460','156461','156462','156463','156464','156465','156466','156467','156468','156469','156470','156471','156472','156473','156474','156475','156476','156477','156478','156479','156480','156481','156482','156483','156484','156485','156486','156487','156490','156491','156492','156493','156494','156495','156497','156498','156499','156500','156502','156503','156504','156505','156506','156507','156508','156509','156511','156512','156513','156514','156515','156516','156517','156518','156520','156521','156522','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','156631','156633','156634','156779','156780','156789','156790','156791','156792','156793','156794','156795','156796','156797','156799','156800','156801','156802','156803','156804','156805','156806','156873','156874','156909','156912','156913','156914','156915','156916','156917','156918','156919','156920','156921','156922','156923','156924','156925','156926','156927','156928','156929','156930','156931','156932','156933','156934','156935','156936','156937','156941','156942','156945','156946','156947','156954','156955','156956','157010','157225','157226','157227','157228','157229','157230','157231','157258','157259','157261','157263','157264','157265','157270','157271','157275','157285','157288','157289','157290','157291','157292','157293','157294','157295','157296','157297','157408','157423','157424','157425','157426','157427','157428','157429','157430','157431','157432','157436','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157460','157463','157464','157465','157466','157468','157469','157470','157471','157472','157473','157474','157475','157476','157501','157502','157504','157505','157506','157510','157548','157553','157587','157711','157728','157729','157733','157740','157761','157762','157763','157782','157841','157844','157895','157896','157897','157902','157903','157961','157989','157991','157992','157999','158000','158005','158022','158023','158031','158146','158233','158249','158250','158262','158263','158292','158339','158350','158381','158398','158399','158400','158417','158423','158424','158550','158586','158613','158662','158757','158762','158767','158776','158777','158794','158795','158810','158811','158813','158826','158841','158842','158843','158844','158845','158846','158856','158955','158971','159003','159009','159010','159019','159028','159029','159030','159078','159079','159097','159098','159121','159143','159145','159146','159148','159149','159151','159152','159153','159154','159155','159156','159205','159225','159237','159253','159255','159314','159340','159341','159342','159343','159344','159345','159346','159347','159348','159349','159350','159351','159352','159353','159354','159355','159356','159357','159362','159369','159377','159390','159424','159450','159474','159475','159476','159527','159528','159529','159534','159552','159561','159570','159666','159667','159668','159706','159815','159913','159916','159917','159986','159987','159988','160038','160049','160058','160098','160100','160125','160126','160137','160208','160209','160216','160217','160218','160288','160302','160310','160316','160317','160345','160347','160363','160364','160365','160366','160367','160373','160374','160381','160401','160403','160413','160421','160430','160441','160488','160490','160504','160505','160557','160558','160559','160560','160580','160582','160618','160650','160651','160652','160682','160683','160742','160743','160744','160754','160761','160762','160763','160797','160821','160864','160865','160866','160894','160895','160933','160952','161047','161136','161142','161143','161144','161145','161182','161221','161222','161229','161230','161231','161233','161234','161235','161236','161237','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161359','161380','161383','161421','161428','161437','161438','161444','161445','161457','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161478','161479','161529','161548','161549','161550','161551','161552','161588','161593','161598','161606','161613','161614','161617','161619','161630','161631','161632','161633','161634','161644','161667','161668','161669','161670','161708','161709','161797','161798','161809','161824','161825','161834','161886','161893','161894','161895','161903','161904','161905','161906','161907','161912','161933','161934','161935','161956','161979','161980','162029','162030','162031','162032','162049','162080','162081','162220','162227','162269','162270','162271','162272','162285','162295','162305','162306','162307','162308','162335','162349','162360','162391','162410','162414','162415','162416','162417','162419','162420','162422','162447','162449','162479','162480','162481','162492','162493','162494','162495','162529','162530','162547','162548','162555','162556','162557','162558','162559','162560','162570','162579','162580','162633','162667','162714','162739','162748','162782','162787','162816','162832','162876','162935','162936','162942','163028','163053','163103','163108','163109','163110','163111','163112','163113','163123','163153','163154','163181','163231','163232','163233','163234','163288','163289','163294','163295','163321','163344','163466','163467','163529','163540','163541','163616','163617','163618','163620','163662','163676','163703','163723','163779','163780','163781','163782','163802','163828','163868','163878','163880','163890','163891','163892','163954','163963','163982','164009','164029','164052','164094','164124','164131','164132','164133','164134','164135','164140','164141','164142','164159','164160','164167','164233','164238','164247','164316','164422','164427','164433','164485','164499','164511','164514','164521','164522','164527','164534','164543','164545','164546','164553','164556','164557','164560','164561','164562','164563','164564','164565','164566','164567','164568','164596','164624','164656','164671','164672','164673','164679','164693','164733','164734','164736','164756','164757','164758','164759','164760','164761','164762','164763','164771','164805','164808','164809','164810','164835','164853','164875','164886','164919','164932','164957','164958','164992','165000','165004','165005','165016','165017','165030','165032','165033','165034','165035','165053','165065','165078','165080','165091','165131','165134','165147','165151','165152','165153','165154','165155','165156','165157','165162','165227','165244','165288','165289','165290','165291','165292','165305','165347','165348','165362','165408','165420','165479','165480','165491','165502','165514','165517','165524','165530','165539','165542','165550','165563','165564','165565','165574','165581','165672','165673','165676','165679','165691','165731','165750','165779','165840','165841','165858','165859','165860','165861','165862','165863','165864','165865','165866','165867','165868','165895','165896','165897','165906','165915','165936','165939','165957','165958','165959','165972','165973','165974','165975','165976','165983','166054','166082','166083','166084','166112','166135','166136','166137','166138','166165','166191','166192','166193','166194','166195','166251','166324','166325','166326','166444','166447','166451','166472','166492','166510','166521','166523','166524','166585','166586','166587','166588','166589','166670','166674','166675','166685','166719','166720','166721','166722','166723','166724','166731','166763','166764','166787','166792','166848','166855','166858','166871','166880','166884','166885','166889','166905','166906','166919','166928','166983','167001','167041','167073','167077','167092','167096','167107','167109','167110','167111','167112','167113','167117','167147','167148','167149','167150','167151','167152','167161','167210','167217','167262','167263','167292','167298','167308','167389','167403','167406','167412','167483','167553','167578','167585','167586','167620','167630','167641','167643','167648','167649','167664','167707','167708','167739','167740','167760','167769','167784','167828','167833','167851','167852','167862','167871','167900','167903','167920','167949','168009','168051','168055','168239','168324','168325','168335','168340','168394','168403','219748','219753','232438','232444','232461','232462','232518','232519','232561','232578','232603','232732','232780','238104','238235','238263','238264','238265','238284','238285','238286','238303','238304','238305','238406','238411','238438','238443','238450','238459','238512','238520','238528','238538','238539','238556','238567','238579','238712','238716','238717','238718','238724','238725','238734','238736','238762','238810','238832','238851','238852','238853','238854','238855','238856','238857','238858','238962','239170','239207','239217','239220','239312','239332','239514','239554','239590','239627','239818','239901','239947','240496','240571','240572','240573','240574','240575','240586','240717','240744','240875','240876','240877','240898','240924','240925','240926','240927','240989','240990','240991','240992','241279','241408','241864','241870','241871','242017','242018','242019','242020','242212','242248','242249','242250','242252','242253','242339','242443','242506','242706','242858','242902','242906','242939','242940','242941','242942','242992','242993','242994','242995','243025','243145','243146','243744','243841','243842','243845','243846','243863','243988','244106','244135','244180','244223','244224','244266','244324','244436','244548','244549','244562','244704','244780','244781','244782','244783','244784','244785','244809','244810','244811','244926','244967','245070','245073','245158','245170','245220','245221','245239','245240','245267','245268','245269','245292','245293','245294','245295','245296','245297','245391','245392','245394','245395','245396','245397','245398','245399','245400','245401','245402','245403','245404','245405','245406','245419','245493','245495','245543','245586','245587','245588','245600','245609','245778','245887','245931','245996','246063','246100','246185','246213','246252','246253','246254','246363','246443','246536','246583','246584','246585','246586','246629','246652','246667','246778','246792','246828','246919','246994','247039','247119','247120','247121','247122','247123','247124','247125','247126','247127','247128','247129','247130','247131','247132','247133','247134','247192','247196','247197','247487','247488','247497','247512','247535','247536','247599','247605','247606','247607','247608','247609','247610','247638','247674','247852','247853','247854','247855','247892','248086','248138','248168','248187','248188','248189','248199','248281','248300','248312','248315','248364','248399','248403','248404','248405','248406','248430','248446','248539','248544','248545','248596','248642','248744','248745','248913','248930','248940','248941','248950','248951','249007','249151','249166','249237','249253','249263','249302','249320','249346','249355','249356','249410','249412','249416','249418','249495','249496','249497','249541','249644','249663','249664','249685','249686','249687','249688','249716','249750','249770','249771','249784','249815','249862','249863','249896','249909','249913','249914','249922','250096','250099','250101','250126','250130','250149','250158','250159','250192','250213','250218','250292','250302','250303','250304','250305','250306','250307','250308','250309','250310','250311','250312','250313','250314','250315','250316','250317','250318','250319','250320','250321','250322','250328','250330','250348','250355','250356','250357','250358','250359','250360','250361','250362','250363','250364','250365','250366','250367','250368','250369','250370','250371','250372','250373','250374','250375','250376','250377','250378','250379','250380','250381','250382','250383','250384','250385','250386','250387','250388','250389','250390','250391','250392','250393','250394','250395','250396','250397','250398','250399','250400','250401','250402','250403','250404','250405','250406','250407','250408','250409','250410','250411','250412','250413','250414','250415','250416','250417','250418','250419','250420','250421','250422','250423','250424','250425','250426','250427','250428','250429','250430','250431','250432','250433','250434','250435','250436','250437','250438','250439','250440','250441','250442','250443','250444','250445','250446','250447','250448','250501','250502','250503','250504','250505','250525','250660','250702','250704','250756','250767','250772','250794','250796','250797','250803','250919','250966','251022','251137','251156','251172','251191','251217','251218','251219','251220','251221','251227','251252','251255','251257','251258','251259','251260','251280','251286','251344','251350','251408','251476','251520','251521','251522','251539','251550','251554','251555','251556','251557','251569','251577','251596','251597','251598','251599','251600','251602','251603','251604','251605','251606','251607','251633','251638','251639','251641','251669','251695','251733','251747','251759','251794','251795','251836','251837','251850','251867','251920','251945','251946','251947','251985','252010','252021','252045','252066','252089','252091','252093','252110','253033','253088','253125','253127','253128','253129','253136','253167','253231','253239','253241','253242','253246','253252','253253','253254','253259','253260','253263','253325','253326','253361','253392','253393','253394','253397','253398','253424','253463','253481','253488','253489','253490','253491','253513','253514','253515','253516','253517','253518','253519','253522','253537','253564','253586','253587','253588','253589','253592','253631','253638','253659','253737','253784','253792','253801','253802','253831','253832','253846','253849','253873','253874','253875','253876','253877','254196','254244','254245','254246','254247','254398','254399','254409','254410','254411','254412','254426','254459','254472','254545','254560','254561','254562','254586','254643','254748','254749','254750','254751','254752','254753','254754','254755','254756','254757','254917','254948','254991','255000','255018','255025','255078','255079','255080','255081','255193','255223','255225','255245','255344','255368','255372','255397','255398','255454','255505','255518','255605','255606','255607','255623','255638','255668','255731','255732','255733','255734','255735','255736','255740','255741','255742','255770','255809','255818','255819','255820','255821','255822','255823','255824','255825','255826','255827','255828','255829','255830','255831','255832','255833','255834','255835','255895','255896','255897','255898','255899','255900','255901','255902','255903','255904','255905','255906','255907','255908','255909','255910','255911','255912','255913','255914','255915','255916','255917','255918','255919','255920','255921','255922','255923','255924','255925','255926','255927','255928','255929','255930','255931','255932','255933','255934','255935','255936','255937','255938','255940','256103','256109','256110','256112','256122','256188','256277','256278','256279','256280','256282','256283','256284','256285','256286','256287','256288','256289','256290','256291','256292','256293','256294','256295','256296','256297','256298','256308','256317','256328','256329','256340','256343','256344','256499','256500','256507','256508','256515','256537','256539','256547','256668','256674','256675','256705','256759','256782','256783','256784','256853','256902','256904','256905','256922','256923','256931','257012','257013','257015','257016','257017','257018','257019','257021','257022','257023','257024','257025','257026','257028','257044','257045','257046','257047','257048','257049','257050','257051','257068','257117','257118','257155','257168','257169','257178','257180','257181','257192','257193','257194','257195','257197','257198','257199','257200','257201','257202','257203','257204','257205','257206','257207','257208','257209','257210','257211','257235','261685','261686','261687','261688','261689','261690','261691','261692','261693','261694','261695','261696','261768','261936','261941','261949','261955','261956','261975','261989','262000','262032','262074','262082','262085','262086','262087','262106','262155','262188','262241','262383','262390','262440','262441','262442','262443','262444','262445','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262480','262481','262482','262483','262484','262485','262486','262487','262488','262489','262490','262491','262492','262493','262494','262495','262496','262497','262498','262499','262506','262520','262561','262608','262617','262628','262629','262630','262631','262632','262633','262634','262635','262636','262637','262638','262653','262720','262721','262738','262739','262740','262741','262742','262743','262744','262745','262746','262747','262748','262749','262750','262751','262756','262760','262783','262792','262796','262822','262823','262836','262837','262838','262839','262840','262841','262842','262843','262844','262845','262846','262847','262848','262849','262850','262851','262867','262881','262896','262898','262935','262995','262997','263085','263196','263469','263474','263507','263543','263550','263551','263635','263637','263642','263643','263651','263652','263653','263715','263754','264348','264503','264504','264505','264657','264658','264704','264705','264777','264797','264932','264934','265015','265017','265045','265063','265065','265068','265124','265125','265156','265167','265194','265195','265282','265283','265284','265319','265321','265361','265390','265429','265430','265437','265448','265520','265581','265657','265674','265675','265700','265742','265762','265776','265783','265805','265806','265917','265953','266148','266162','266245','266352','266353','266356','266408','266416','266417','266418','266419','266420','266421','266422','266423','266424','266425','266426','266427','266428','266429','266548','266582','266594','266684','266685','266686','266804','266823','266895','266988','266989','266990','267016','267024','267065','267084','267085','267089','267133','267134','267148','267169','267190','267191','267192','267193','267194','267195','267196','267197','267198','267199','267200','267201','267202','267203','267205','267206','267215','267288','267345','267356','267404','267409','267419','267420','267497','267514','267551','267565','267566','267577','267618','267664','267750','267751','267869','267959','267976','267977','268073','268141','268232','268234','268246','268247','268250','268309','268320','268352','268359','268361','268372','268374','268375','268395','268410','268412','268450','268455','268456','268484','268513','268515','268520','268523','268561','268562','268603','268705','268724','268781','268898','269031','269043','269047','269077','269106','269110','269111','269113','269149','269152','269153','269180','269204','269206','269244','269246','269247','269248','269249','269250','269251','269252','269393','269441','269470','269475','269476','269477','269478','269479','269480','269512','269513','269514','269520','269527','269557','273337','273338','273359','273370','273428','273439','273464','273472','273490','273506','273536','273588','273589','273699','273713','273723','273828','273829','273832','273844','273892','273893','273946','273960','273974','274139','274141','274278','274298','274327','274397','274398','274399','274400','274419','274443','274477','274592','274604','274607','274615','274616','274628','274657','274658','274672','274679','274682','274695','274697','274764','274778','274800','274817','274828','274836','274837','274838','274839','274840','274888','274894','274905','274912','274990','274991','275073','275074','275075','275076','275228','275248','275298','275395','275421','275458','275494','275499','275522','275555','275566','275604','275619','275655','275662','275663','275689','275692','275753','275757','275783','275822','275823','275977','276010','276059','276070','276087','276130','276145','276216','276217','276218','276255','276286','276287','276289','276290','276339','276349','276385','276388','276389','276398','276409','276410','276411','276412','276413','276414','276416','276473','276474','276481','276514','276515','276534','276546','276547','276548','276549','276550','276572','276607','276613','276614','276615','276638','276697','276700','276940','276972','276973','276993','277016','277018','277035','277037','277038','277070','277175','277176','277196','277207','277250','277255','277264','277265','277266','277289','277304','277306','277308','277313','277336','277358','277384','277397','277430','277439','277440','277441','277442','277443','277444','277445','277460','277461','277462','277474','277493','277524','277525','277526','277527','277528','277529','277530','277531','277584','277633','277645','277647','277648','277689','277712','277749','277750','277777','277791','277809','277915','277916','277917','277938','277939','277953','278054','278058','278075','278102','278103','278128','278142','278163','278164','278188','278221','278224','278240','278242','278318','278379','278429','278445','278446','278480','278507','278542','278560','278566','278572','278640','278754','278774','278850','278851','278900','278901','278950','279013','279023','279057','279059','279094','279100','279134','279207','279226','279295','279301','279336','279422','279440','279469','279479','279582','279585','279698','279705','279732','279735','279740','280303','280305','280369','280374','280375','280380','280381','280382','280386','280428','280450','280491','280492','280709','280723','280728','280729','280760','280761','280773','280778','280805','280808','280810','280832','280850','280855','280943','280944','280945','280979','281034','281056','281091','281133','281143','281144','281145','281146','281150','281151','281180','281195','281224','281230','281232','281235','281243','281268','281278','281336','281339','281473','281489','281651','281652','281689','281764','281770','281774','281776','281777','281865','282074','282144','282164','282165','282167','282168','282172','282190','282275','282295','282341','282342','282402','282476','282483','282521','282541','282572','282670','282767','282813','282843','282868','282902','282945','283001','283219','283225','283226','283227','283228','283313','283380','283504','283505','283542','283555','283597','283598','283599','283600','283611','283622','283623','283630','283634','283635','283730','283735','283736','283737','283763','284140','284284','284312','284356','284415','284441','284443','284444','284445','284504','284505','284506','284507','284508','284528','284550','284562','284599','284625','284644','284662','284745','284831','284836','284860','284896','284900','284914','284948','285024','285098','285106','285169','285177','285230','285247','285248','285249','285270','285334','285378','285379','285395','285403','285429','285444','285566','285578','285579','285591','285592','285593','285622','285627','285676','285677','285707','285732','285733','285734','285742','285793','285794','285795','285833','285903','285934','285984','286014','286028','286034','286062','286068','286120','286162','286199','286206','286344','286349','286358','286373','286400','286444','286640','286816','286860','286867','286873','286899','286913','286914','286915','286916','286917','286918','287011','287030','287031','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','287110','287111','287113','287114','287115','287116','287117','287118','287119','287120','287121','287122','287140','287141','287173','287202','287218','287557','287780','287782','287980','287982','287988','287995','288025','288026','288139','288163','288172','288173','288174','288175','288176','288177','288186','288217','288232','288234','288235','288260','288275','288299','288316','288351','288357','288358','288414','288416','288422','288441','288444','288470','288474','288477','288478','288480','288506','288534','288577','288580','288625','288663','288702','288709','288994','289011','289034','289035','289036','289037','289038','289039','289040','289041','289044','289045','289046','289047','289048','289049','289050','289051','289052','289053','289221','289227','289413','289466','289476','289483','289484','289485','289486','291708','291709','291711','291736','291744','291818','291864','291868','291869','291877','291878','291938','291947','291974','291975','291986','291987','291988','292007','292223','292224','292225','292245','292276','292304','292308','292309','292311','292312','292313','292323','292324','292339','292340','292341','292342','292343','292344','292362','292376','292399','292410','292411','292486','292492','292493','292511','292530','292531','292597','292607','292608','292609','292610','292611','292612','292621','292623','292654','292662','292692','292735','292736','292737','292738','292739','292744','292745','292746','292747','292748','292776','292839','292904','293209','293210','293231','293281','293282','293369','293373','293374','293403','293404','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','293451','293491','293519','293527','293558','293566','293575','293593','293604','293638','293934','294004','294067','294068','294069','294070','294187','294202','294273','294297','294311','294326','294327','294328','294329','294330','294371','294419','294420','294497','294509','294544','294548','294553','294561','294565','294567','294568','294570','294589','294590','294611','294664','294669','294702','294710','294725','294738','294739','294740','294741','294742','294743','294744','294803','294814','294847','294848','294849','294904','294928','294978','295153','295154','295155','295304','295316','295379','295381','295383','295384','295482','295508','295522','295565','295574','295576','295654','295662','295689','295715','295732','295779','295781','295782','295818','295865','295990','295995','296183','296200','296257','296276','297012','297028','297088','297099','297107','297120','297180','297181','297194','297244','297257','297258','297284','297285','297291','297307','297308','297325','297370','297437','297450','297458','297467','297477','297555','297556','297581','297636','297683','297684','297687','297688','297689','297704','297733','297756','297758','297829','297854','297859','297860','297861','298015','298017','298018','298019','298021','298025','298056','298063','298100','298104','298105','298106','298109','298134','298153','298157','298162','298163','298169','298170','298171','298211','298224','298244','298253','298258','298261','298318','298319','298352','298357','298358','298359','298360','298361','298373','298374','298375','298376','298378','298379','298397','298406','298411','298445','298453','298477','298516','298517','298518','298528','298572','298584','299064','299122','299132','299137','299139','299140','299142','299143','299165','299176','299277','299279','299405','299502','299564','299636','299716','299738','299764','299765','299766','299771','299772','299776','299794','299795','299822','299823','299836','299906','299907','299929','299965','299966','299967','299968','299969','299970','299971','299972','299973','299974','299975','299976','299979','300019','300030','300031','300041','300057','300174','300205','300246','300383','300404','300496','300533','300535','300578','300580','300598','300610','300620','300646','300651','300653','300654','300665','300935','300996','301002','301018','301039','301040','301041','301042','301043','301044','301045','301046','301049','301050','301051','301052','301062','301063','301064','301800','301807','301808','301809','301810','301811','301812','301855','301892','301895','301906','301907','301908','301909','301939','301978','302111','302157','302189','302221','302287','302289','302291','302316','302338','302348','302349','302350','302352','302356','303790','303818','303908','303934','303940','304020','304024') GROUP BY `series` ORDER BY `series` ASC
изображение KLS17-SBJW04-FF-200mm-24AWG
27
113,71 руб.
от 200 шт - 113,71 руб. с НДС
от 60 шт - 117,92 руб. с НДС
от 30 шт - 122,13 руб. с НДС
от 10 шт - 147,40 руб. с НДС
В наличии: 222 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=286120
80
38,28 руб.
от 1 шт - 38,28 руб. с НДС
В наличии: 4 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=286162
изображение L-KLS1-3.96A-05-S
Разъём L-KLS1-3.96A-05-S
KLS Electronic
арт. 142422
1029
2,98 руб.
от 1 шт - 2,98 руб. с НДС
В наличии: 2980 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=286913
изображение L-KLS1-3.96A-05-H
Разъём L-KLS1-3.96A-05-H
KLS Electronic
арт. 142423
1956
1,57 руб.
от 1 шт - 1,57 руб. с НДС
В наличии: 2950 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=286914
изображение L-KLS1-3.96A-02-S
Разъём L-KLS1-3.96A-02-S
KLS Electronic
арт. 142424
2620
1,17 руб.
от 1 шт - 1,17 руб. с НДС
В наличии: 9950 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=286915
изображение L-KLS1-3.96A-08-S
Разъём L-KLS1-3.96A-08-S
KLS Electronic
арт. 142540
655
4,69 руб.
от 1 шт - 4,69 руб. с НДС
В наличии: 3000 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287031
изображение L-KLS1-3.96A-04-H
Разъём L-KLS1-3.96A-04-H
KLS Electronic
арт. 142574
3179
0,97 руб.
от 1 шт - 0,97 руб. с НДС
В наличии: 7266 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287064
изображение L-KLS1-3.96A-06-H
Разъём L-KLS1-3.96A-06-H
KLS Electronic
арт. 142575
1854
1,66 руб.
от 1 шт - 1,66 руб. с НДС
В наличии: 5000 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287065
изображение L-KLS1-3.96A-09-H
Разъём L-KLS1-3.96A-09-H
KLS Electronic
арт. 142578
1235
2,49 руб.
от 1 шт - 2,49 руб. с НДС
В наличии: 1000 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287068
изображение L-KLS1-3.96A-11-H
Разъём L-KLS1-3.96A-11-H
KLS Electronic
арт. 142579
1011
3,04 руб.
от 1 шт - 3,04 руб. с НДС
В наличии: 1000 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287069
изображение L-KLS1-3.96A-11-S
Разъём L-KLS1-3.96A-11-S
KLS Electronic
арт. 142580
531
5,78 руб.
от 1 шт - 5,78 руб. с НДС
В наличии: 1000 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287070
изображение L-KLS1-3.96A-04-S
Разъём L-KLS1-3.96A-04-S
KLS Electronic
арт. 142585
1108
3,06 руб.
от 1000 шт - 3,06 руб. с НДС
от 500 шт - 3,82 руб. с НДС
В наличии: 2095 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287075
изображение L-KLS1-3.96A-06-S
Разъём L-KLS1-3.96A-06-S
KLS Electronic
арт. 142587
857
3,58 руб.
от 1 шт - 3,58 руб. с НДС
В наличии: 4000 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287077
изображение L-KLS1-3.96A-09-S
Разъём L-KLS1-3.96A-09-S
KLS Electronic
арт. 142590
649
4,73 руб.
от 1 шт - 4,73 руб. с НДС
В наличии: 1000 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287080
изображение L-KLS1-3.96A-02-VM
Разъём L-KLS1-3.96A-02-VM
KLS Electronic
арт. 142594
394
7,79 руб.
от 1 шт - 7,79 руб. с НДС
В наличии: 1200 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287084
изображение L-KLS1-3.96A-02-RM
Разъём L-KLS1-3.96A-02-RM
KLS Electronic
арт. 142595
586
5,24 руб.
от 1 шт - 5,24 руб. с НДС
В наличии: 1050 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287085
изображение L-KLS1-3.96A-03-VM
Разъём L-KLS1-3.96A-03-VM
KLS Electronic
арт. 142596
333
9,21 руб.
от 1 шт - 9,21 руб. с НДС
В наличии: 1200 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287086
изображение L-KLS1-3.96A-03-RM
Разъём L-KLS1-3.96A-03-RM
KLS Electronic
арт. 142597
471
6,52 руб.
от 1 шт - 6,52 руб. с НДС
В наличии: 1200 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287087
изображение L-KLS1-3.96A-04-VM
Разъём L-KLS1-3.96A-04-VM
KLS Electronic
арт. 142598
293
10,48 руб.
от 1 шт - 10,48 руб. с НДС
В наличии: 1198 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287088
изображение L-KLS1-3.96A-04-RM
Разъём L-KLS1-3.96A-04-RM
KLS Electronic
арт. 142599
394
7,79 руб.
от 1 шт - 7,79 руб. с НДС
В наличии: 1200 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287089
изображение L-KLS1-3.96A-05-VM
Разъём L-KLS1-3.96A-05-VM
KLS Electronic
арт. 142600
261
11,76 руб.
от 1 шт - 11,76 руб. с НДС
В наличии: 1200 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287090
изображение L-KLS1-3.96A-05-RM
Разъём L-KLS1-3.96A-05-RM
KLS Electronic
арт. 142601
333
9,21 руб.
от 1 шт - 9,21 руб. с НДС
В наличии: 1200 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287091
изображение L-KLS1-3.96A-06-RM
Разъём L-KLS1-3.96A-06-RM
KLS Electronic
арт. 142602
293
10,48 руб.
от 1 шт - 10,48 руб. с НДС
В наличии: 1200 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287092
изображение L-KLS1-3.96A-06-VM
Разъём L-KLS1-3.96A-06-VM
KLS Electronic
арт. 142603
236
13,03 руб.
от 1 шт - 13,03 руб. с НДС
В наличии: 1200 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287093
изображение L-KLS1-4.20-1X06-SW
Разъём L-KLS1-4.20-1X06-SW
KLS Electronic
арт. 142650
162
18,98 руб.
от 1 шт - 18,98 руб. с НДС
В наличии: 952 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287140
изображение L-KLS1-1816-B-R
Разъём L-KLS1-1816-B-R USB 2.0
KLS Electronic
арт. 142651
489
6,28 руб.
от 1 шт - 6,28 руб. с НДС
В наличии: 3413 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287141
изображение L-KLS1-SD4.0-004-R
43
70,76 руб.
от 200 шт - 70,76 руб. с НДС
от 60 шт - 73,38 руб. с НДС
от 30 шт - 76,00 руб. с НДС
от 10 шт - 91,73 руб. с НДС
В наличии: 2190 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287202
изображение L-KLS1-208B-4.3-2-20-T3-4,6x6,2-B-R
Разъём L-KLS1-208B-4.3-2-20-T3-4,6x6,2-B-R
KLS Electronic
арт. 142726
143
21,40 руб.
от 1 шт - 21,40 руб. с НДС
В наличии: 41 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287218
изображение L-KLS1-218-2-80-S-3x6x19.4
Разъем L-KLS1-218-2-80-S-3x6x19.4
KLS Electronic
арт. 143065
79
38,99 руб.
от 200 шт - 38,99 руб. с НДС
от 60 шт - 40,43 руб. с НДС
от 30 шт - 41,88 руб. с НДС
от 10 шт - 50,54 руб. с НДС
В наличии: 1586 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287557
106
28,99 руб.
от 1 шт - 28,99 руб. с НДС
В наличии: 909 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287780
изображение L-KLS12-201-G-6P4C (housing)
Кожух L-KLS12-201-G-6P4C
KLS Electronic
арт. 143294
1263
2,43 руб.
от 1 шт - 2,43 руб. с НДС
В наличии: 9999 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287782
изображение L-KLS8-0513-GM-141A
508
6,04 руб.
от 2000 шт - 6,04 руб. с НДС
от 800 шт - 6,26 руб. с НДС
от 400 шт - 6,69 руб. с НДС
от 200 шт - 7,99 руб. с НДС
В наличии: 1835 шт
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=287995
Производители
Наши партнеры
Новости
УРМ Radiodetali
УРМ Radiodetali

Удаленное рабочее место «Radiodetali», предназначено для резервирования, заказа, оформления счета на оплату и получения электронных компонентов, хранящихся на складах и удаленных складах поставщиков.