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 ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') 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 ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: core
SELECT `core`,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 `core` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `core` ORDER BY `core` ASC
childsstroke1: core
SELECT `core`,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 `core` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `core` ORDER BY `core` ASC
childsstroke: bit_depth
SELECT `bit_depth`,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 `bit_depth` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `bit_depth` ORDER BY `bit_depth` ASC
childsstroke1: bit_depth
SELECT `bit_depth`,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 `bit_depth` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `bit_depth` ORDER BY `bit_depth` ASC
childsstroke: max_freq_mhz
SELECT `max_freq_mhz`,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 `max_freq_mhz` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `max_freq_mhz` ORDER BY `max_freq_mhz` ASC
childsstroke1: max_freq_mhz
SELECT `max_freq_mhz`,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 `max_freq_mhz` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `max_freq_mhz` ORDER BY `max_freq_mhz` ASC
childsstroke: flash
SELECT `flash`,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 `flash` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `flash` ORDER BY `flash` ASC
childsstroke1: flash
SELECT `flash`,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 `flash` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `flash` ORDER BY `flash` ASC
childsstroke: ram
SELECT `ram`,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 `ram` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `ram` ORDER BY `ram` ASC
childsstroke1: ram
SELECT `ram`,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 `ram` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `ram` ORDER BY `ram` ASC
childsstroke: gpio
SELECT `gpio`,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 `gpio` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `gpio` ORDER BY `gpio` ASC
childsstroke1: gpio
SELECT `gpio`,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 `gpio` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `gpio` ORDER BY `gpio` ASC
childsstroke: packages
SELECT `packages`,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 `packages` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `packages` ORDER BY `packages` ASC
childsstroke1: packages
SELECT `packages`,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 `packages` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `packages` ORDER BY `packages` ASC
childsstroke: ethernet
SELECT `ethernet`,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 `ethernet` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `ethernet` ORDER BY `ethernet` ASC
childsstroke1: ethernet
SELECT `ethernet`,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 `ethernet` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `ethernet` ORDER BY `ethernet` ASC
childsstroke: bluetooth
SELECT `bluetooth`,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 `bluetooth` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `bluetooth` ORDER BY `bluetooth` ASC
childsstroke1: bluetooth
SELECT `bluetooth`,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 `bluetooth` !='' AND `modx_site_content`.`id` IN ('142947','143074','143220','143413','143625','143972','143973','144148','146483','146690','147697','147882','147968','148134','148138','150451','150469','150719','150743','150762','150764','150765','150771','150789','150837','151021','151064','151245','151248','151297','151301','151304','151428','151477','151494','151682','151723','151740','151752','153049','153071','153286','153336','153784','153795','153900','154196','154356','154357','154364','154433','154978','157322','157324','157341','157381','158019','158166','158261','158300','158509','158556','158734','159082','159130','159189','159219','159264','159375','159383','159625','159653','159660','159713','159744','159861','160286','160361','160442','160484','160506','160603','160669','160690','160811','160912','160969','161209','161267','161317','161323','161404','161602','161698','161985','162231','162245','162262','162378','162468','162576','162856','163323','163513','163520','163539','163688','163692','163754','163783','163794','163805','163893','163998','164087','164245','164319','164396','164593','164651','164663','164750','164905','164987','165100','165101','165103','165286','165369','165373','165733','165746','165755','165784','165978','166076','166080','166113','166147','166158','166159','166197','166241','166529','166530','166777','166852','166876','167202','167336','167337','167399','167826','167907','168136','168141','168300','168319','168378','170138','170788','215221','215550','215646','232769','238279','238323','239881','239883','241704','241760','241994','242378','243194','243517','243656','243755','243936','243937','244091','244326','244449','244869','245252','245634','246180','246210','246248','246645','246650','246688','247089','247264','247505','247528','248554','249075','249156','249283','250136','250175','250184','250859','250860','250985','251018','251453','251666','251993','252239','253093','253166','253228','253390','253440','253648','253816','253903','254204','254228','254455','254793','254870','255381','255996','256310','256361','256590','256862','257104','257106','261752','261790','262206','262321','262647','262863','262934','262938','263183','263184','263610','263631','264475','264532','264654','264795','264807','264813','265196','265294','265322','265354','265355','265634','265637','265668','265698','265703','265751','265764','265785','265786','265871','265911','265973','266010','266105','266222','266242','266373','266404','266409','266442','266606','266607','266724','266731','266760','266783','266813','266859','266874','266893','266897','267004','267005','267008','267009','267010','267011','267119','267127','267132','267173','267177','267181','267182','267183','267229','267287','267378','267515','267541','267596','267745','267749','267775','267814','267867','267957','267984','268130','268166','268169','268202','268230','268280','268366','268413','268567','268591','268607','268668','268709','268766','268789','268798','268825','268856','268914','269053','269120','269156','269186','269308','269349','269365','269367','269486','269753','273310','273330','273351','273430','273482','273504','273513','273554','273799','273800','273956','274112','274115','274246','274260','274266','274287','274296','274297','274343','274512','274597','274689','274711','274805','274866','274870','274947','274989','275120','275368','275397','275469','275490','275497','275759','275848','275978','275983','276013','276018','276058','276257','276270','276271','276344','276407','276408','276417','276472','276522','276523','276542','276570','276581','276612','276785','276787','276830','277033','277180','277226','277249','277283','277299','277329','277365','277372','277390','277446','277666','277667','277710','277751','277780','277820','277869','277908','278101','278110','278117','278141','278161','278284','278368','278457','278614','278749','278750','278767','278892','278980','279001','279009','279031','279058','279086','279233','279270','279363','279373','279384','279414','279417','279418','279446','279482','279751','280423','280525','280739','280790','280929','280958','280959','281083','281125','281160','281163','281181','281277','281279','281405','281406','281682','281683','281684','281749','281790','281862','282064','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282130','282131','282132','282133','282134','282135','282136','282137','282153','282235','282312','282424','282474','282478','282534','282668','282835','282872','282910','282948','282988','283049','283114','283238','283419','283547','284231','284234','284549','284576','284617','285090','285091','285092','285093','285112','285113','285114','285188','285190','285281','285295','285314','285318','285360','285377','285391','285432','285571','285573','285586','285671','285712','285775','285935','286021','286036','286106','286326','286591','286815','286820','286876','287175','287187','288030','288107','288120','288410','288670','288713','288747','289015','289064','289075','289243','289444','291636','291730','291881','291959','291979','292230','292279','292337','292424','292761','292847','292854','292866','293238','293266','293268','293376','293470','293472','293497','293507','294010','294159','294208','294353','294503','294759','295172','295178','295436','295503','295532','295533','295601','295817','295825','296226','297021','297259','297280','297302','297329','297336','297459','297762','297905','298279','298290','298494','298534','299134','299216','299404','299511','299546','299585','299601','299633','299915','299920','300036','300236','300237','300244','300291','300302','300554','300570','300628','301038','301865','301970','301984','302064','302144','302236','302297','302361','303862','303866','303918') GROUP BY `bluetooth` ORDER BY `bluetooth` ASC
childsstroke: work_temp
childsstroke1: work_temp
