Разъемы питания 12-220В, стр. 3

SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('141544','141545','141546','141547','143164','143591','143709','143741','143795','143799','143801','143802','143804','143807','143809','143810','143826','147753','148651','149091','149092','149093','149094','149095','149096','149097','150519','150668','150671','150834','151460','151461','151689','151734','152509','152548','153545','153586','153802','154749','155083','155084','155110','155115','155770','155772','155866','156317','156318','156325','156340','156341','156342','156343','156349','156350','156351','156352','156353','156354','156355','156356','156506','156507','156508','156509','157548','158094','158776','159143','159147','159148','159151','159152','159467','159468','159639','160108','160736','160797','160934','161613','161903','161904','162222','162307','162308','162419','162420','162816','162857','163543','164247','164365','166919','166933','167096','167161','168325','169921','207182','207183','207184','207185','207186','207187','207188','207189','207190','207191','207192','207193','207194','207195','207196','207197','207198','207199','207200','207201','207202','207203','207204','207205','207206','207207','207208','207209','207210','207211','207212','207213','207214','207215','207216','207217','207218','207219','207220','207221','207222','232721','238257','238258','238259','238260','238261','238262','239879','240002','240363','240364','240365','240366','240367','240368','240369','240370','240371','240372','240378','240379','240380','240384','240385','240510','240511','240564','240565','241595','242428','242495','242901','244777','244780','244906','244926','246063','246280','246281','246282','248232','248490','248653','250205','250540','250541','250542','250543','250712','250756','251076','251296','251589','251920','252091','253138','253854','254370','255415','256279','257012','263573','263574','264752','264753','265031','265032','265068','265071','265187','265412','265595','266424','266444','266449','266881','267190','267191','267192','267205','267206','267230','268246','268247','269375','269379','269532','273439','273587','273588','273589','273731','274039','274051','274077','275499','275664','276154','277063','277264','277290','277296','277391','277433','279457','279458','280288','280374','280452','280454','280455','280456','280457','280458','280459','280460','280461','280462','280463','280488','280834','281267','281268','281276','281278','281853','281854','282111','283527','284995','284996','284998','285196','285235','285420','285702','285703','285850','286089','287204','287988','288139','288171','288411','288412','288841','288842','292068','292431','292630','293283','293922','294004','294561','294669','295840','296257','297437','297609','298258','298574','299235','299236','299237','299238','299452','299597','299979','300064','300496') GROUP BY `manuf` ORDER BY `manuf` ASC

SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('141544','141545','141546','141547','143164','143591','143709','143741','143795','143799','143801','143802','143804','143807','143809','143810','143826','147753','148651','149091','149092','149093','149094','149095','149097','150519','150668','150671','150834','151460','151461','151689','151734','152509','152548','153545','153586','153802','154749','155083','155084','155110','155115','155770','155772','155866','156317','156318','156325','156340','156341','156342','156343','156352','156353','156354','156355','156356','156506','156507','156508','156509','157548','158094','158776','159143','159148','159151','159152','159467','159468','159639','160108','160736','160797','160934','161613','161903','161904','162222','162307','162308','162419','162420','162816','162857','163543','164247','164365','166919','166933','167096','167161','168325','169921','207182','207183','207184','207185','207186','207187','207188','207189','207190','207191','207192','207193','207194','207195','207196','207197','207198','207199','207200','207201','207202','207203','207204','207205','207206','207207','207208','207209','207210','207211','207212','207213','207214','207215','207216','207217','207218','207219','207220','207221','207222','232721','238257','238258','238259','238260','238261','238262','239879','240002','240363','240364','240365','240366','240367','240368','240369','240370','240371','240372','240378','240379','240380','240384','240385','240510','240511','240564','240565','241595','242428','242495','242901','244777','244780','244906','244926','246063','246280','246281','246282','248232','248490','248653','250205','250540','250541','250542','250543','250712','250756','251076','251296','251589','251920','252091','253138','253854','254370','255415','256279','257012','263573','263574','264752','264753','265031','265032','265068','265071','265187','265412','265595','266424','266444','266449','266881','267190','267191','267192','267205','267206','267230','268246','268247','269379','269532','273439','273587','273588','273589','273731','274039','274051','274077','275499','275664','276154','277063','277264','277296','277391','277433','279457','279458','280288','280374','280452','280454','280455','280456','280457','280458','280459','280460','280461','280462','280463','280488','280834','281267','281268','281276','281278','281853','281854','282111','283527','284995','284996','284998','285196','285235','285420','285702','285703','285850','286089','287204','287988','288139','288171','288411','288412','288841','288842','292068','292431','292630','293283','293922','294004','294561','294669','295840','296257','297437','297609','298258','298574','299235','299236','299237','299238','299452','299597','299979','300064','300496') GROUP BY `manuf` ORDER BY `manuf` ASC

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 ('141544','141545','141546','141547','143164','143591','143709','143741','143795','143799','143801','143802','143804','143807','143809','143810','143826','147753','148651','149091','149092','149093','149094','149095','149096','149097','150519','150668','150671','150834','151460','151461','151689','151734','152509','152548','153545','153586','153802','154749','155083','155084','155110','155115','155770','155772','155866','156317','156318','156325','156340','156341','156342','156343','156349','156350','156351','156352','156353','156354','156355','156356','156506','156507','156508','156509','157548','158094','158776','159143','159147','159148','159151','159152','159467','159468','159639','160108','160736','160797','160934','161613','161903','161904','162222','162307','162308','162419','162420','162816','162857','163543','164247','164365','166919','166933','167096','167161','168325','169921','207182','207183','207184','207185','207186','207187','207188','207189','207190','207191','207192','207193','207194','207195','207196','207197','207198','207199','207200','207201','207202','207203','207204','207205','207206','207207','207208','207209','207210','207211','207212','207213','207214','207215','207216','207217','207218','207219','207220','207221','207222','232721','238257','238258','238259','238260','238261','238262','239879','240002','240363','240364','240365','240366','240367','240368','240369','240370','240371','240372','240378','240379','240380','240384','240385','240510','240511','240564','240565','241595','242428','242495','242901','244777','244780','244906','244926','246063','246280','246281','246282','248232','248490','248653','250205','250540','250541','250542','250543','250712','250756','251076','251296','251589','251920','252091','253138','253854','254370','255415','256279','257012','263573','263574','264752','264753','265031','265032','265068','265071','265187','265412','265595','266424','266444','266449','266881','267190','267191','267192','267205','267206','267230','268246','268247','269375','269379','269532','273439','273587','273588','273589','273731','274039','274051','274077','275499','275664','276154','277063','277264','277290','277296','277391','277433','279457','279458','280288','280374','280452','280454','280455','280456','280457','280458','280459','280460','280461','280462','280463','280488','280834','281267','281268','281276','281278','281853','281854','282111','283527','284995','284996','284998','285196','285235','285420','285702','285703','285850','286089','287204','287988','288139','288171','288411','288412','288841','288842','292068','292431','292630','293283','293922','294004','294561','294669','295840','296257','297437','297609','298258','298574','299235','299236','299237','299238','299452','299597','299979','300064','300496') GROUP BY `series` ORDER BY `series` ASC

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 ('141544','141545','141546','141547','143164','143591','143709','143741','143795','143799','143801','143802','143804','143807','143809','143810','143826','147753','148651','149091','149092','149093','149094','149095','149097','150519','150668','150671','150834','151460','151461','151689','151734','152509','152548','153545','153586','153802','154749','155083','155084','155110','155115','155770','155772','155866','156317','156318','156325','156340','156341','156342','156343','156352','156353','156354','156355','156356','156506','156507','156508','156509','157548','158094','158776','159143','159148','159151','159152','159467','159468','159639','160108','160736','160797','160934','161613','161903','161904','162222','162307','162308','162419','162420','162816','162857','163543','164247','164365','166919','166933','167096','167161','168325','169921','207182','207183','207184','207185','207186','207187','207188','207189','207190','207191','207192','207193','207194','207195','207196','207197','207198','207199','207200','207201','207202','207203','207204','207205','207206','207207','207208','207209','207210','207211','207212','207213','207214','207215','207216','207217','207218','207219','207220','207221','207222','232721','238257','238258','238259','238260','238261','238262','239879','240002','240363','240364','240365','240366','240367','240368','240369','240370','240371','240372','240378','240379','240380','240384','240385','240510','240511','240564','240565','241595','242428','242495','242901','244777','244780','244906','244926','246063','246280','246281','246282','248232','248490','248653','250205','250540','250541','250542','250543','250712','250756','251076','251296','251589','251920','252091','253138','253854','254370','255415','256279','257012','263573','263574','264752','264753','265031','265032','265068','265071','265187','265412','265595','266424','266444','266449','266881','267190','267191','267192','267205','267206','267230','268246','268247','269379','269532','273439','273587','273588','273589','273731','274039','274051','274077','275499','275664','276154','277063','277264','277296','277391','277433','279457','279458','280288','280374','280452','280454','280455','280456','280457','280458','280459','280460','280461','280462','280463','280488','280834','281267','281268','281276','281278','281853','281854','282111','283527','284995','284996','284998','285196','285235','285420','285702','285703','285850','286089','287204','287988','288139','288171','288411','288412','288841','288842','292068','292431','292630','293283','293922','294004','294561','294669','295840','296257','297437','297609','298258','298574','299235','299236','299237','299238','299452','299597','299979','300064','300496') GROUP BY `series` ORDER BY `series` ASC

SELECT `tip`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `tip` !='' AND `modx_site_content`.`id` IN ('141544','141545','141546','141547','143164','143591','143709','143741','143795','143799','143801','143802','143804','143807','143809','143810','143826','147753','148651','149091','149092','149093','149094','149095','149096','149097','150519','150668','150671','150834','151460','151461','151689','151734','152509','152548','153545','153586','153802','154749','155083','155084','155110','155115','155770','155772','155866','156317','156318','156325','156340','156341','156342','156343','156349','156350','156351','156352','156353','156354','156355','156356','156506','156507','156508','156509','157548','158094','158776','159143','159147','159148','159151','159152','159467','159468','159639','160108','160736','160797','160934','161613','161903','161904','162222','162307','162308','162419','162420','162816','162857','163543','164247','164365','166919','166933','167096','167161','168325','169921','207182','207183','207184','207185','207186','207187','207188','207189','207190','207191','207192','207193','207194','207195','207196','207197','207198','207199','207200','207201','207202','207203','207204','207205','207206','207207','207208','207209','207210','207211','207212','207213','207214','207215','207216','207217','207218','207219','207220','207221','207222','232721','238257','238258','238259','238260','238261','238262','239879','240002','240363','240364','240365','240366','240367','240368','240369','240370','240371','240372','240378','240379','240380','240384','240385','240510','240511','240564','240565','241595','242428','242495','242901','244777','244780','244906','244926','246063','246280','246281','246282','248232','248490','248653','250205','250540','250541','250542','250543','250712','250756','251076','251296','251589','251920','252091','253138','253854','254370','255415','256279','257012','263573','263574','264752','264753','265031','265032','265068','265071','265187','265412','265595','266424','266444','266449','266881','267190','267191','267192','267205','267206','267230','268246','268247','269375','269379','269532','273439','273587','273588','273589','273731','274039','274051','274077','275499','275664','276154','277063','277264','277290','277296','277391','277433','279457','279458','280288','280374','280452','280454','280455','280456','280457','280458','280459','280460','280461','280462','280463','280488','280834','281267','281268','281276','281278','281853','281854','282111','283527','284995','284996','284998','285196','285235','285420','285702','285703','285850','286089','287204','287988','288139','288171','288411','288412','288841','288842','292068','292431','292630','293283','293922','294004','294561','294669','295840','296257','297437','297609','298258','298574','299235','299236','299237','299238','299452','299597','299979','300064','300496') GROUP BY `tip` ORDER BY `tip` ASC

SELECT `tip`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `tip` !='' AND `modx_site_content`.`id` IN ('141544','141545','141546','141547','143164','143591','143709','143741','143795','143799','143801','143802','143804','143807','143809','143810','143826','147753','148651','149091','149092','149093','149094','149095','149097','150519','150668','150671','150834','151460','151461','151689','151734','152509','152548','153545','153586','153802','154749','155083','155084','155110','155115','155770','155772','155866','156317','156318','156325','156340','156341','156342','156343','156352','156353','156354','156355','156356','156506','156507','156508','156509','157548','158094','158776','159143','159148','159151','159152','159467','159468','159639','160108','160736','160797','160934','161613','161903','161904','162222','162307','162308','162419','162420','162816','162857','163543','164247','164365','166919','166933','167096','167161','168325','169921','207182','207183','207184','207185','207186','207187','207188','207189','207190','207191','207192','207193','207194','207195','207196','207197','207198','207199','207200','207201','207202','207203','207204','207205','207206','207207','207208','207209','207210','207211','207212','207213','207214','207215','207216','207217','207218','207219','207220','207221','207222','232721','238257','238258','238259','238260','238261','238262','239879','240002','240363','240364','240365','240366','240367','240368','240369','240370','240371','240372','240378','240379','240380','240384','240385','240510','240511','240564','240565','241595','242428','242495','242901','244777','244780','244906','244926','246063','246280','246281','246282','248232','248490','248653','250205','250540','250541','250542','250543','250712','250756','251076','251296','251589','251920','252091','253138','253854','254370','255415','256279','257012','263573','263574','264752','264753','265031','265032','265068','265071','265187','265412','265595','266424','266444','266449','266881','267190','267191','267192','267205','267206','267230','268246','268247','269379','269532','273439','273587','273588','273589','273731','274039','274051','274077','275499','275664','276154','277063','277264','277296','277391','277433','279457','279458','280288','280374','280452','280454','280455','280456','280457','280458','280459','280460','280461','280462','280463','280488','280834','281267','281268','281276','281278','281853','281854','282111','283527','284995','284996','284998','285196','285235','285420','285702','285703','285850','286089','287204','287988','288139','288171','288411','288412','288841','288842','292068','292431','292630','293283','293922','294004','294561','294669','295840','296257','297437','297609','298258','298574','299235','299236','299237','299238','299452','299597','299979','300064','300496') GROUP BY `tip` ORDER BY `tip` ASC

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 ('141544','141545','141546','141547','143164','143591','143709','143741','143795','143799','143801','143802','143804','143807','143809','143810','143826','147753','148651','149091','149092','149093','149094','149095','149096','149097','150519','150668','150671','150834','151460','151461','151689','151734','152509','152548','153545','153586','153802','154749','155083','155084','155110','155115','155770','155772','155866','156317','156318','156325','156340','156341','156342','156343','156349','156350','156351','156352','156353','156354','156355','156356','156506','156507','156508','156509','157548','158094','158776','159143','159147','159148','159151','159152','159467','159468','159639','160108','160736','160797','160934','161613','161903','161904','162222','162307','162308','162419','162420','162816','162857','163543','164247','164365','166919','166933','167096','167161','168325','169921','207182','207183','207184','207185','207186','207187','207188','207189','207190','207191','207192','207193','207194','207195','207196','207197','207198','207199','207200','207201','207202','207203','207204','207205','207206','207207','207208','207209','207210','207211','207212','207213','207214','207215','207216','207217','207218','207219','207220','207221','207222','232721','238257','238258','238259','238260','238261','238262','239879','240002','240363','240364','240365','240366','240367','240368','240369','240370','240371','240372','240378','240379','240380','240384','240385','240510','240511','240564','240565','241595','242428','242495','242901','244777','244780','244906','244926','246063','246280','246281','246282','248232','248490','248653','250205','250540','250541','250542','250543','250712','250756','251076','251296','251589','251920','252091','253138','253854','254370','255415','256279','257012','263573','263574','264752','264753','265031','265032','265068','265071','265187','265412','265595','266424','266444','266449','266881','267190','267191','267192','267205','267206','267230','268246','268247','269375','269379','269532','273439','273587','273588','273589','273731','274039','274051','274077','275499','275664','276154','277063','277264','277290','277296','277391','277433','279457','279458','280288','280374','280452','280454','280455','280456','280457','280458','280459','280460','280461','280462','280463','280488','280834','281267','281268','281276','281278','281853','281854','282111','283527','284995','284996','284998','285196','285235','285420','285702','285703','285850','286089','287204','287988','288139','288171','288411','288412','288841','288842','292068','292431','292630','293283','293922','294004','294561','294669','295840','296257','297437','297609','298258','298574','299235','299236','299237','299238','299452','299597','299979','300064','300496') GROUP BY `stock_status` ORDER BY `stock_status` ASC

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 ('141544','141545','141546','141547','143164','143591','143709','143741','143795','143799','143801','143802','143804','143807','143809','143810','143826','147753','148651','149091','149092','149093','149094','149095','149097','150519','150668','150671','150834','151460','151461','151689','151734','152509','152548','153545','153586','153802','154749','155083','155084','155110','155115','155770','155772','155866','156317','156318','156325','156340','156341','156342','156343','156352','156353','156354','156355','156356','156506','156507','156508','156509','157548','158094','158776','159143','159148','159151','159152','159467','159468','159639','160108','160736','160797','160934','161613','161903','161904','162222','162307','162308','162419','162420','162816','162857','163543','164247','164365','166919','166933','167096','167161','168325','169921','207182','207183','207184','207185','207186','207187','207188','207189','207190','207191','207192','207193','207194','207195','207196','207197','207198','207199','207200','207201','207202','207203','207204','207205','207206','207207','207208','207209','207210','207211','207212','207213','207214','207215','207216','207217','207218','207219','207220','207221','207222','232721','238257','238258','238259','238260','238261','238262','239879','240002','240363','240364','240365','240366','240367','240368','240369','240370','240371','240372','240378','240379','240380','240384','240385','240510','240511','240564','240565','241595','242428','242495','242901','244777','244780','244906','244926','246063','246280','246281','246282','248232','248490','248653','250205','250540','250541','250542','250543','250712','250756','251076','251296','251589','251920','252091','253138','253854','254370','255415','256279','257012','263573','263574','264752','264753','265031','265032','265068','265071','265187','265412','265595','266424','266444','266449','266881','267190','267191','267192','267205','267206','267230','268246','268247','269379','269532','273439','273587','273588','273589','273731','274039','274051','274077','275499','275664','276154','277063','277264','277296','277391','277433','279457','279458','280288','280374','280452','280454','280455','280456','280457','280458','280459','280460','280461','280462','280463','280488','280834','281267','281268','281276','281278','281853','281854','282111','283527','284995','284996','284998','285196','285235','285420','285702','285703','285850','286089','287204','287988','288139','288171','288411','288412','288841','288842','292068','292431','292630','293283','293922','294004','294561','294669','295840','296257','297437','297609','298258','298574','299235','299236','299237','299238','299452','299597','299979','300064','300496') GROUP BY `stock_status` ORDER BY `stock_status` ASC