Заказы

G-Nor

www.g-nor.com

О компании: Ningbo G-NOR Electronics Co., Ltd. специализируется в производстве оптоэлектронных компонентов.

В продуктовой линейке широкий ассортимент продукции:

  • Светодиоды
  • Светодиодные индикаторы
  • Светодиоды поверхностного монтажа (SMD) в корпусе: 7070/5630/5050/3528/
  • Светодиодные линейки и матрицы
  • Кластеры
  • Светодиодные модули для TB экранов и электронных табло
  • Устройства светодиодного освещения
  • Источники питания светодиодных модулей.

Компания СЭЛКОМ более 15 лет сотрудничает с производителем светодиодов и индикаторов, компанией G-NOR

Большинство дорожных знаков, указателей, светофоров, рекламных вывесок в различных регионах РФ производятся с использованием продукции G-NOR.

G-NOR это гарантия качества, товары отвечают всем заявленным характеристикам. Вся продукция сертифицирована и оригинальна. Цена на G-NOR не завышена и доступна, благодаря сотрудничеству напрямую с производителем, не используя посредников.

Кроме того, продукция компании G-NOR широко экспортируется во многие страны, включая Европу, США, Ближний Восток и Юго-Восточной Азия.     

Компания СЭЛКОМ поддерживает склад всей номенклатуры G-NOR.

Наши специалисты окажут техническую поддержку, подберут аналог, создадут буферный склад.

Вышлите нам ТЗ на адрес sale@radiodetali.com и мы подберем вам аналог, вышлем Data-Sheet с конкурентной ценой для анализа.

Обзорный каталог ИНДИКАТОРОВ. СКАЧАТЬ.

Выводные светодиоды G-NOR каталоги: СКАЧАТЬ

Параметрический подбор светодиодов. ПЕРЕЙТИ

Формирование названий цифровых дисплеев.  

Формирование названий светодиодных линеек.  

Цена, руб.
Поиск по ключевому слову
Форма линзы
Диаметр линзы, мм
Температура цвета, К
Цвет свечения
Цвет линзы
Статус наличия
8
childsstroke: formled
SELECT `formled`,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 `formled` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `formled` ORDER BY `formled` ASC
childsstroke1: formled
SELECT `formled`,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 `formled` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `formled` ORDER BY `formled` ASC
childsstroke: leddiam
SELECT `leddiam`,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 `leddiam` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `leddiam` ORDER BY `leddiam` ASC
childsstroke1: leddiam
SELECT `leddiam`,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 `leddiam` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `leddiam` ORDER BY `leddiam` ASC
childsstroke: color_temp
SELECT `color_temp`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `color_temp` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `color_temp` ORDER BY `color_temp` ASC
childsstroke1: color_temp
SELECT `color_temp`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `color_temp` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `color_temp` ORDER BY `color_temp` ASC
childsstroke: color
SELECT `color`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `color` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `color` ORDER BY `color` ASC
childsstroke1: color
SELECT `color`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `color` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `color` ORDER BY `color` ASC
childsstroke: lens_color
SELECT `lens_color`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `lens_color` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `lens_color` ORDER BY `lens_color` ASC
childsstroke1: lens_color
SELECT `lens_color`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `lens_color` !='' AND `modx_site_content`.`id` IN ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `lens_color` ORDER BY `lens_color` ASC
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 ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') 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 ('153081','153123','153124','153125','153126','153138','153337','153381','153382','153383','153561','153562','153563','153564','153570','153572','153573','153574','153601','153655','153879','154250','154252','154253','154319','154419','154457','154458','154459','154469','154516','154592','154621','154635','154643','154647','154648','154687','154698','154699','154700','154701','154703','154704','154707','154708','154739','154769','154798','154806','154809','154810','154811','154812','154813','154814','154815','154827','154828','154829','154830','154856','154860','154861','154865','154878','154879','154961','154962','154971','154975','154993','155044','155045','155046','155047','155048','155049','155050','155051','155052','155053','155108','155117','155118','155119','155120','155167','155168','155264','155301','155521','155522','155523','155661','155813','155814','155815','155816','155817','155818','155819','155820','155821','155866','155872','155873','155874','155875','155876','155877','155878','155879','155880','155881','155882','155883','155884','155885','155886','155887','155888','155889','155890','155891','155892','155893','155894','155895','155896','155897','155898','155899','155900','155901','155902','155903','155904','155905','155906','155907','155908','155909','155910','155911','155912','155913','155914','155915','155916','155917','155918','156017','156018','156019','156020','156021','156022','156023','156024','156025','156026','156027','156028','156029','156030','156031','156032','156033','156034','156035','156036','156037','156038','156039','156040','156041','156042','156043','156044','156045','156046','156047','156048','156049','156050','156051','156052','156053','156054','156055','156056','156057','156058','156059','156060','156061','156062','156063','156064','156065','156066','156067','156068','156069','156070','156071','156072','156073','156074','156075','156076','156077','156078','156079','156080','156081','156082','156083','156084','156085','156086','156087','156088','156089','156090','156091','156092','156093','156826','156827','156828','156829','156830','156831','156847','156848','156849','156850','156851','156852','156853','156854','156855','156856','156857','156862','156863','156864','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157054','157055','157056','157057','157058','157059','157062','157063','157064','157066','157067','157068','157082','157083','157084','157085','157086','157087','157090','157091','157092','157105','157107','157108','157109','157110','157111','157112','157113','157114','157115','157142','157143','157144','157145','157146','157147','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157165','157166','157249','157250','157251','157252','157253','157255','157537','157538','157539','157540','157541','157542','157543','157544','157580','157624','157627','157742','157743','157744','157745','157765','157766','157767','157768','157769','157770','157771','157772','157773','157774','157775','157776','157840','157946','157973','157974','157975','157976','157977','157978','157979','157980','157981','158003','158070','158171','158212','158264','158378','158387','158463','158464','158525','158529','158643','158644','158793','158805','159326','159408','159441','159442','159524','159565','159644','159649','159650','159651','159693','159863','159989','160020','160127','160205','160206','160207','160434','160721','161183','161276','161384','161385','161853','162578','162650','162721','162738','162862','163219','163778','164670','165237','165250','165421','165422','165457','165506','165507','165508','165509','165510','165511','165512','165513','165650','165706','165740','165778','166310','166910','166931','166936','167440','167479','167832','232437','232458','238283','238416','238687','238689','238690','238691','238692','238693','238694','238740','238774','238775','238779','238780','238822','238848','238849','238850','238981','239014','239097','239098','239344','239376','239557','239836','240219','240220','240223','241807','241808','241924','242910','243227','246051','247118','247912','248531','250141','250142','250294','251131','251207','251208','251209','251215','251383','251994','252024','252247','253250','253257','253258','253591','254360','255167','255764','256935','256936','262759','264908','266094','266163','266164','266165','266166','266167','266168','266583','267074','267250','268074','268812','268879','269539','273446','273447','273448','274929','277332','277375','278323','278324','278325','278326','278327','279018','279019','279020','279022','279757','284183','285552','285683','287779','288538','288645','289436','292053','292512','292696','294751','295349','297178','297440','299663') GROUP BY `stock_status` ORDER BY `stock_status` ASC
изображение GNL-1800UEC-TL
Светодиод GNL-1800UEC-TL
G-NOR
арт. 84112
Под заказ
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`=154856
изображение GNL-1810UYC-TL (сняты с производства)
Светодиод GNL-1810UYC-TL
G-NOR
арт. 84117
Под заказ
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`=154861
изображение GNL-5073PGC
Светодиод GNL-5073PGC
G-NOR
арт. 84147
Под заказ
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`=154878
Светодиод GNL-3014UYD
G-NOR
арт. 84290
Под заказ
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`=154961
изображение GNL-5013URT
Светодиод GNL-5013URT
G-NOR
арт. 84301
Под заказ
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`=154971
изображение GNL-5043UYC
Светодиод GNL-5043UYC
G-NOR
арт. 84329
Под заказ
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`=154993
изображение GNL-5013UWW
Светодиод GNL-5013UWW
G-NOR
арт. 84390
Под заказ
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`=155044
изображение GNL-5043URC
Светодиод GNL-5043URC
G-NOR
арт. 84392
Под заказ
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`=155045
изображение GNL-5043UYC-TL
Светодиод GNL-5043UYC-TL
G-NOR
арт. 84393
Под заказ
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`=155046
изображение GNL-5073UYC-TL-H
Под заказ
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`=155048
изображение GNL-5073UYC-TL-S
Под заказ
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`=155049
Светодиод GNL-2014PGD
G-NOR
арт. 84397
Под заказ
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`=155050
изображение GNL-5033BGC-TL
Светодиод GNL-5033BGC-TL
G-NOR
арт. 84399
Под заказ
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`=155052
изображение GNL-5033PGC
Светодиод GNL-5033PGC
G-NOR
арт. 84400
Под заказ
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`=155053
изображение GNL-20003UGT
Светодиод GNL-20003UGT
G-NOR
арт. 84485
Под заказ
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`=155117
изображение GNL-20003UET-TL
Под заказ
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`=155118
изображение GNM-19881AG-21
Под заказ
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`=155167
изображение GNM-19881AEG-21
Под заказ
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`=155168
изображение GNS-4011BD22N
Под заказ
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`=155264
изображение GNA-R1408ZUE-01
Под заказ
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`=155521
изображение GNA-R1715ZUG-01 (h=6,5mm)
Под заказ
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`=155522
изображение GNA-R1715ZUY-01 (h=6,5mm)
Под заказ
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`=155523
изображение GNCL-S15A4G(на базе L-5464PGD)
Под заказ
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`=155816
изображение GNCL-S21AUW9 (GNL-5013UWC/20-M-10CD)
Под заказ
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`=155818
изображение GNCL-S21AUW9 (GNL-5013UWC/20-M-15CD)
Под заказ
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`=155819
изображение GNCL-S26AUW16 (GNL-5013UWC/20-M-10CD)
Под заказ
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`=155820
изображение GNM-10881AG-21
Под заказ
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`=155872
изображение GNM-10881ASG-21
Под заказ
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`=155873
изображение GNM-10881AY-21
Под заказ
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`=155874
изображение GNM-15881ADUG-11
Под заказ
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`=155875
изображение GNM-15881BSG-11
Под заказ
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`=155877
изображение GNM-19881BSG-11 (сдвинуты выводы!)
Под заказ
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`=155878
Производители
Наши партнеры
Новости
УРМ Radiodetali
УРМ Radiodetali

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