childsstroke: tip
SELECT `tip`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `tip` !='' AND `modx_site_content`.`id` IN ('141527','141528','141529','141530','141568','142041','142078','142709','142710','142915','143162','148911','150653','150682','153191','153705','153713','154351','155228','155439','155825','155826','155827','155828','155829','155830','155831','155832','155833','155834','155835','155836','155837','155838','155839','155840','155841','155842','155843','155844','155845','155846','155847','155848','157547','158553','158641','158859','158970','159495','160224','160473','161067','161151','161685','165624','165625','165626','166064','166328','166329','166330','167915','169292','170334','170404','170416','190742','201314','202569','215947','232708','238684','238685','246405','253083','253084','256511','256573','256843','262385','263758','265996','266662','267002','267003','267130','268376','269035','269036','269037','269174','269203','273868','274405','274408','276386','276943','278260','280470','284951','288497','294757','294853','298086','299866','303805') GROUP BY `tip` ORDER BY `tip` ASC
childsstroke1: tip
SELECT `tip`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `tip` !='' AND `modx_site_content`.`id` IN ('141527','141528','141529','141530','141568','142041','142078','142709','142710','142915','143162','148911','150653','150682','153191','153705','153713','154351','155228','155439','155825','155826','155827','155828','155829','155830','155831','155832','155833','155834','155835','155836','155837','155838','155839','155840','155841','155842','155843','155844','155845','155846','155847','155848','157547','158553','158641','158859','158970','159495','160224','160473','161067','161151','161685','165624','165625','165626','166064','166328','166329','166330','167915','169292','170334','170404','170416','190742','201314','202569','215947','232708','238684','238685','246405','253083','253084','256511','256573','256843','262385','263758','265996','266662','267002','267003','267130','268376','269035','269036','269037','269174','269203','273868','274405','274408','276386','276943','278260','280470','284951','288497','294757','294853','298086','299866','303805') GROUP BY `tip` ORDER BY `tip` ASC
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 ('141527','141528','141529','141530','141568','142041','142078','142709','142710','142915','143162','148911','150653','150682','153191','153705','153713','154351','155228','155439','155825','155826','155827','155828','155829','155830','155831','155832','155833','155834','155835','155836','155837','155838','155839','155840','155841','155842','155843','155844','155845','155846','155847','155848','157547','158553','158641','158859','158970','159495','160224','160473','161067','161151','161685','165624','165625','165626','166064','166328','166329','166330','167915','169292','170334','170404','170416','190742','201314','202569','215947','232708','238684','238685','246405','253083','253084','256511','256573','256843','262385','263758','265996','266662','267002','267003','267130','268376','269035','269036','269037','269174','269203','273868','274405','274408','276386','276943','278260','280470','284951','288497','294757','294853','298086','299866','303805') 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 ('141527','141528','141529','141530','141568','142041','142078','142709','142710','142915','143162','148911','150653','150682','153191','153705','153713','154351','155228','155439','155825','155826','155827','155828','155829','155830','155831','155832','155833','155834','155835','155836','155837','155838','155839','155840','155841','155842','155843','155844','155845','155846','155847','155848','157547','158553','158641','158859','158970','159495','160224','160473','161067','161151','161685','165624','165625','165626','166064','166328','166329','166330','167915','169292','170334','170404','170416','190742','201314','202569','215947','232708','238684','238685','246405','253083','253084','256511','256573','256843','262385','263758','265996','266662','267002','267003','267130','268376','269035','269036','269037','269174','269203','273868','274405','274408','276386','276943','278260','280470','284951','288497','294757','294853','298086','299866','303805') GROUP BY `manuf` ORDER BY `manuf` 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 ('141527','141528','141529','141530','141568','142041','142078','142709','142710','142915','143162','148911','150653','150682','153191','153705','153713','154351','155228','155439','155825','155826','155827','155828','155829','155830','155831','155832','155833','155834','155835','155836','155837','155838','155839','155840','155841','155842','155843','155844','155845','155846','155847','155848','157547','158553','158641','158859','158970','159495','160224','160473','161067','161151','161685','165624','165625','165626','166064','166328','166329','166330','167915','169292','170334','170404','170416','190742','201314','202569','215947','232708','238684','238685','246405','253083','253084','256511','256573','256843','262385','263758','265996','266662','267002','267003','267130','268376','269035','269036','269037','269174','269203','273868','274405','274408','276386','276943','278260','280470','284951','288497','294757','294853','298086','299866','303805') 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 ('141527','141528','141529','141530','141568','142041','142078','142709','142710','142915','143162','148911','150653','150682','153191','153705','153713','154351','155228','155439','155825','155826','155827','155828','155829','155830','155831','155832','155833','155834','155835','155836','155837','155838','155839','155840','155841','155842','155843','155844','155845','155846','155847','155848','157547','158553','158641','158859','158970','159495','160224','160473','161067','161151','161685','165624','165625','165626','166064','166328','166329','166330','167915','169292','170334','170404','170416','190742','201314','202569','215947','232708','238684','238685','246405','253083','253084','256511','256573','256843','262385','263758','265996','266662','267002','267003','267130','268376','269035','269036','269037','269174','269203','273868','274405','274408','276386','276943','278260','280470','284951','288497','294757','294853','298086','299866','303805') GROUP BY `packages` ORDER BY `packages` ASC
