childsstroke: manuf
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 ('148073','148074','148075','148076','148077','148078','148079','148080','148081','148082','148088','148098','148099','150065','150066','150067','150068','152534','153926','155603','157940','162769','162810','168289','211206','211207','211208','211209','211210','211211','211212','211213','211214','213756','213757','213758','213759','213760','213761','213762','213763','213764','213765','213766','213767','213768','213769','213770','213771','213772','213773','213774','213775','213776','213777','213778','213779','213780','213781','213782','213783','213784','213785','213786','213787','213788','213789','213790','213791','213792','213793','213794','213795','213796','213797','213798','213799','213800','213801','213802','213803','213804','213805','213806','213807','213808','213809','213810','213811','213812','213813','213814','213815','213816','213817','213818','213819','213820','213821','213822','213823','238674','240994','241117','245755','245758','245820','245896','247032','248902','249531','253936','255035','264427','265507','268753','279887','279888','279889','279890','279891','279892','279893','279894','279895','279896','279897','279898','279899','279900','279901','279902','279903','279904','279905','279906','279907','279908','279909','279910','279911','279912','279913','279914','279915','279916','279917','279918','279919','279920','279921','279922','279923','279924','279925','279926','279927','279928','279929','279930','279931','279932','279933','279934','279935','279936','279937','279938','279939','280010','280011','280012','280013','280014','280015','280016','280017','280018','280019','280020','280021','280022','280023','280024','280025','280026','280027','280028','280029','288533','296288','296289','296290','296291','296292','296293','296294','296295','296296','296297','296298','296299','296300','296301','296302','296303','296330','296331','296332','296333','296334','296335','296336','296337','296338','296339','296340','296341','296342','296343','296344','296345','296346','296347','296348','296349','296350','296351','296352','296353','296354','296355','296356','296357','296358','296359','296360','296361','296362','296363','296364','296365','296366','296367','296368','296369','296370','296371','296372','296373','296374','296375','296376','296377','296378','296379','296380','296381','296382','296383','296384','296385','296386','296387','296388','296389','296390','296391','296392','296393','296394','296395','296396','296397','296398','296399','296400') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke1: manuf
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 ('148073','148074','148075','148076','148077','148078','148079','148080','148081','148082','148088','148098','148099','150065','150066','150067','150068','152534','153926','155603','157940','162769','162810','168289','211206','211207','211208','211209','211210','211211','211212','211213','211214','213756','213757','213758','213759','213760','213761','213762','213763','213764','213765','213766','213767','213768','213769','213770','213771','213772','213773','213774','213775','213776','213777','213778','213779','213780','213781','213782','213783','213784','213785','213786','213787','213788','213789','213790','213791','213792','213793','213794','213795','213796','213797','213798','213799','213800','213801','213802','213803','213804','213805','213806','213807','213808','213809','213810','213811','213812','213813','213814','213815','213816','213817','213818','213819','213820','213821','213822','213823','238674','240994','241117','245755','245758','245820','245896','247032','248902','249531','253936','255035','264427','265507','268753','279887','279888','279889','279890','279891','279892','279893','279894','279895','279896','279897','279898','279899','279900','279901','279902','279903','279904','279905','279906','279907','279908','279909','279910','279911','279912','279913','279914','279915','279916','279917','279918','279919','279920','279921','279922','279923','279924','279925','279926','279927','279928','279929','279930','279931','279932','279933','279934','279935','279936','279937','279938','279939','280010','280011','280012','280013','280014','280015','280016','280017','280018','280019','280020','280021','280022','280023','280024','280025','280026','280027','280028','280029','288533','296288','296289','296290','296291','296292','296293','296294','296295','296296','296297','296298','296299','296300','296301','296302','296303','296330','296331','296332','296333','296334','296335','296336','296337','296338','296339','296340','296341','296342','296343','296344','296345','296346','296347','296348','296349','296350','296351','296352','296353','296354','296355','296356','296357','296358','296359','296360','296361','296362','296363','296364','296365','296366','296367','296368','296369','296370','296371','296372','296373','296374','296375','296376','296377','296378','296379','296380','296381','296382','296383','296384','296385','296386','296387','296388','296389','296390','296391','296392','296393','296394','296395','296396','296397','296398','296399','296400') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: out_voltage
SELECT `out_voltage`,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 `out_voltage` !='' AND `modx_site_content`.`id` IN ('148073','148074','148075','148076','148077','148078','148079','148080','148081','148082','148088','148098','148099','150065','150066','150067','150068','152534','153926','155603','157940','162769','162810','168289','211206','211207','211208','211209','211210','211211','211212','211213','211214','213756','213757','213758','213759','213760','213761','213762','213763','213764','213765','213766','213767','213768','213769','213770','213771','213772','213773','213774','213775','213776','213777','213778','213779','213780','213781','213782','213783','213784','213785','213786','213787','213788','213789','213790','213791','213792','213793','213794','213795','213796','213797','213798','213799','213800','213801','213802','213803','213804','213805','213806','213807','213808','213809','213810','213811','213812','213813','213814','213815','213816','213817','213818','213819','213820','213821','213822','213823','238674','240994','241117','245755','245758','245820','245896','247032','248902','249531','253936','255035','264427','265507','268753','279887','279888','279889','279890','279891','279892','279893','279894','279895','279896','279897','279898','279899','279900','279901','279902','279903','279904','279905','279906','279907','279908','279909','279910','279911','279912','279913','279914','279915','279916','279917','279918','279919','279920','279921','279922','279923','279924','279925','279926','279927','279928','279929','279930','279931','279932','279933','279934','279935','279936','279937','279938','279939','280010','280011','280012','280013','280014','280015','280016','280017','280018','280019','280020','280021','280022','280023','280024','280025','280026','280027','280028','280029','288533','296288','296289','296290','296291','296292','296293','296294','296295','296296','296297','296298','296299','296300','296301','296302','296303','296330','296331','296332','296333','296334','296335','296336','296337','296338','296339','296340','296341','296342','296343','296344','296345','296346','296347','296348','296349','296350','296351','296352','296353','296354','296355','296356','296357','296358','296359','296360','296361','296362','296363','296364','296365','296366','296367','296368','296369','296370','296371','296372','296373','296374','296375','296376','296377','296378','296379','296380','296381','296382','296383','296384','296385','296386','296387','296388','296389','296390','296391','296392','296393','296394','296395','296396','296397','296398','296399','296400') GROUP BY `out_voltage` ORDER BY `out_voltage` ASC
childsstroke1: out_voltage
SELECT `out_voltage`,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 `out_voltage` !='' AND `modx_site_content`.`id` IN ('148073','148074','148075','148076','148077','148078','148079','148080','148081','148082','148088','148098','148099','150065','150066','150067','150068','152534','153926','155603','157940','162769','162810','168289','211206','211207','211208','211209','211210','211211','211212','211213','211214','213756','213757','213758','213759','213760','213761','213762','213763','213764','213765','213766','213767','213768','213769','213770','213771','213772','213773','213774','213775','213776','213777','213778','213779','213780','213781','213782','213783','213784','213785','213786','213787','213788','213789','213790','213791','213792','213793','213794','213795','213796','213797','213798','213799','213800','213801','213802','213803','213804','213805','213806','213807','213808','213809','213810','213811','213812','213813','213814','213815','213816','213817','213818','213819','213820','213821','213822','213823','238674','240994','241117','245755','245758','245820','245896','247032','248902','249531','253936','255035','264427','265507','268753','279887','279888','279889','279890','279891','279892','279893','279894','279895','279896','279897','279898','279899','279900','279901','279902','279903','279904','279905','279906','279907','279908','279909','279910','279911','279912','279913','279914','279915','279916','279917','279918','279919','279920','279921','279922','279923','279924','279925','279926','279927','279928','279929','279930','279931','279932','279933','279934','279935','279936','279937','279938','279939','280010','280011','280012','280013','280014','280015','280016','280017','280018','280019','280020','280021','280022','280023','280024','280025','280026','280027','280028','280029','288533','296288','296289','296290','296291','296292','296293','296294','296295','296296','296297','296298','296299','296300','296301','296302','296303','296330','296331','296332','296333','296334','296335','296336','296337','296338','296339','296340','296341','296342','296343','296344','296345','296346','296347','296348','296349','296350','296351','296352','296353','296354','296355','296356','296357','296358','296359','296360','296361','296362','296363','296364','296365','296366','296367','296368','296369','296370','296371','296372','296373','296374','296375','296376','296377','296378','296379','296380','296381','296382','296383','296384','296385','296386','296387','296388','296389','296390','296391','296392','296393','296394','296395','296396','296397','296398','296399','296400') GROUP BY `out_voltage` ORDER BY `out_voltage` ASC
childsstroke1: SELECT `power`,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 `power` !='' AND `modx_site_content`.`id` IN ('148073','148074','148075','148076','148077','148078','148079','148080','148081','148082','148088','148098','148099','150065','150066','150067','150068','152534','153926','155603','157940','162769','162810','168289','211206','211207','211208','211209','211210','211211','211212','211213','211214','213756','213757','213758','213759','213760','213761','213762','213763','213764','213765','213766','213767','213768','213769','213770','213771','213772','213773','213774','213775','213776','213777','213778','213779','213780','213781','213782','213783','213784','213785','213786','213787','213788','213789','213790','213791','213792','213793','213794','213795','213796','213797','213798','213799','213800','213801','213802','213803','213804','213805','213806','213807','213808','213809','213810','213811','213812','213813','213814','213815','213816','213817','213818','213819','213820','213821','213822','213823','238674','240994','241117','245755','245758','245820','245896','247032','248902','249531','253936','255035','264427','265507','268753','279887','279888','279889','279890','279891','279892','279893','279894','279895','279896','279897','279898','279899','279900','279901','279902','279903','279904','279905','279906','279907','279908','279909','279910','279911','279912','279913','279914','279915','279916','279917','279918','279919','279920','279921','279922','279923','279924','279925','279926','279927','279928','279929','279930','279931','279932','279933','279934','279935','279936','279937','279938','279939','280010','280011','280012','280013','280014','280015','280016','280017','280018','280019','280020','280021','280022','280023','280024','280025','280026','280027','280028','280029','288533','296288','296289','296290','296291','296292','296293','296294','296295','296296','296297','296298','296299','296300','296301','296302','296303','296330','296331','296332','296333','296334','296335','296336','296337','296338','296339','296340','296341','296342','296343','296344','296345','296346','296347','296348','296349','296350','296351','296352','296353','296354','296355','296356','296357','296358','296359','296360','296361','296362','296363','296364','296365','296366','296367','296368','296369','296370','296371','296372','296373','296374','296375','296376','296377','296378','296379','296380','296381','296382','296383','296384','296385','296386','296387','296388','296389','296390','296391','296392','296393','296394','296395','296396','296397','296398','296399','296400') GROUP BY `power` ORDER BY `power` ASC
childsstroke: out_current
SELECT `out_current`,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 `out_current` !='' AND `modx_site_content`.`id` IN ('148073','148074','148075','148076','148077','148078','148079','148080','148081','148082','148088','148098','148099','150065','150066','150067','150068','152534','153926','155603','157940','162769','162810','168289','211206','211207','211208','211209','211210','211211','211212','211213','211214','213756','213757','213758','213759','213760','213761','213762','213763','213764','213765','213766','213767','213768','213769','213770','213771','213772','213773','213774','213775','213776','213777','213778','213779','213780','213781','213782','213783','213784','213785','213786','213787','213788','213789','213790','213791','213792','213793','213794','213795','213796','213797','213798','213799','213800','213801','213802','213803','213804','213805','213806','213807','213808','213809','213810','213811','213812','213813','213814','213815','213816','213817','213818','213819','213820','213821','213822','213823','238674','240994','241117','245755','245758','245820','245896','247032','248902','249531','253936','255035','264427','265507','268753','279887','279888','279889','279890','279891','279892','279893','279894','279895','279896','279897','279898','279899','279900','279901','279902','279903','279904','279905','279906','279907','279908','279909','279910','279911','279912','279913','279914','279915','279916','279917','279918','279919','279920','279921','279922','279923','279924','279925','279926','279927','279928','279929','279930','279931','279932','279933','279934','279935','279936','279937','279938','279939','280010','280011','280012','280013','280014','280015','280016','280017','280018','280019','280020','280021','280022','280023','280024','280025','280026','280027','280028','280029','288533','296288','296289','296290','296291','296292','296293','296294','296295','296296','296297','296298','296299','296300','296301','296302','296303','296330','296331','296332','296333','296334','296335','296336','296337','296338','296339','296340','296341','296342','296343','296344','296345','296346','296347','296348','296349','296350','296351','296352','296353','296354','296355','296356','296357','296358','296359','296360','296361','296362','296363','296364','296365','296366','296367','296368','296369','296370','296371','296372','296373','296374','296375','296376','296377','296378','296379','296380','296381','296382','296383','296384','296385','296386','296387','296388','296389','296390','296391','296392','296393','296394','296395','296396','296397','296398','296399','296400') GROUP BY `out_current` ORDER BY `out_current` ASC
childsstroke1: out_current
SELECT `out_current`,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 `out_current` !='' AND `modx_site_content`.`id` IN ('148073','148074','148075','148076','148077','148078','148079','148080','148081','148082','148088','148098','148099','150065','150066','150067','150068','152534','153926','155603','157940','162769','162810','168289','211206','211207','211208','211209','211210','211211','211212','211213','211214','213756','213757','213758','213759','213760','213761','213762','213763','213764','213765','213766','213767','213768','213769','213770','213771','213772','213773','213774','213775','213776','213777','213778','213779','213780','213781','213782','213783','213784','213785','213786','213787','213788','213789','213790','213791','213792','213793','213794','213795','213796','213797','213798','213799','213800','213801','213802','213803','213804','213805','213806','213807','213808','213809','213810','213811','213812','213813','213814','213815','213816','213817','213818','213819','213820','213821','213822','213823','238674','240994','241117','245755','245758','245820','245896','247032','248902','249531','253936','255035','264427','265507','268753','279887','279888','279889','279890','279891','279892','279893','279894','279895','279896','279897','279898','279899','279900','279901','279902','279903','279904','279905','279906','279907','279908','279909','279910','279911','279912','279913','279914','279915','279916','279917','279918','279919','279920','279921','279922','279923','279924','279925','279926','279927','279928','279929','279930','279931','279932','279933','279934','279935','279936','279937','279938','279939','280010','280011','280012','280013','280014','280015','280016','280017','280018','280019','280020','280021','280022','280023','280024','280025','280026','280027','280028','280029','288533','296288','296289','296290','296291','296292','296293','296294','296295','296296','296297','296298','296299','296300','296301','296302','296303','296330','296331','296332','296333','296334','296335','296336','296337','296338','296339','296340','296341','296342','296343','296344','296345','296346','296347','296348','296349','296350','296351','296352','296353','296354','296355','296356','296357','296358','296359','296360','296361','296362','296363','296364','296365','296366','296367','296368','296369','296370','296371','296372','296373','296374','296375','296376','296377','296378','296379','296380','296381','296382','296383','296384','296385','296386','296387','296388','296389','296390','296391','296392','296393','296394','296395','296396','296397','296398','296399','296400') GROUP BY `out_current` ORDER BY `out_current` ASC
