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 ('142926','153332','155122','155123','155124','155125','157639','158271','158287','158288','158655','159395','159402','159403','159404','159460','159461','159462','159463','159464','159465','159466','159467','159468','159912','160194','160196','160395','160437','160489','160513','160534','160562','160725','160851','160852','160932','161197','161545','161756','161910','162073','162074','162222','162235','162340','162341','162342','162343','162344','162345','162346','162347','162348','162365','162390','162510','162565','163031','163547','163922','164065','164263','164362','164365','164548','164654','164897','164937','165551','165552','165555','165917','165929','166020','166217','166218','166437','166438','166439','166440','166441','166442','166795','166796','166801','166933','167085','167104','167114','167175','167183','167211','167326','167358','167365','167402','167502','167619','167687','167724','167725','167726','167727','167728','167729','167730','167731','167732','167733','167786','168017','168025','168115','168272','168329','169915','232450','232463','232502','232526','232541','232542','232544','238259','238260','238261','238262','238268','239505','239506','240038','240968','241517','242330','242497','242563','242860','243769','243770','243771','243909','244125','244389','244468','244618','244647','244777','245034','245895','245898','246212','246340','246533','246534','246631','246677','246997','246998','246999','247000','247001','247009','247150','247254','247381','247395','247412','247597','247697','247786','247866','248904','248968','249067','249249','249264','249352','249393','249411','249635','249641','249810','249818','249854','249915','250007','250210','250695','250697','250721','250773','250793','250795','250967','251020','251021','251079','251155','251233','251493','251588','251793','251835','251845','251907','251908','251917','251918','251919','251921','251922','251923','251924','251925','251934','251935','251949','251966','252018','252019','252064','252067','252146','252157','252237','253042','253070','253079','253080','253081','253089','253094','253271','253278','253360','253568','253765','253834','253879','253892','254250','254384','254396','254454','254521','254522','254544','255001','255109','255169','255185','255289','255510','255603','255675','255710','255776','255787','255839','255882','256006','256015','256078','256174','256202','256353','256618','256679','256848','256872','256873','257133','257165','257216','261706','261728','261781','261801','261943','262112','262755','262925','262926','263060','263117','263119','263121','263200','263483','263534','263636','264356','264456','264637','264735','264737','264792','264793','264820','264876','264949','265022','265187','265265','265274','265425','265442','265763','265897','265944','266161','266197','266230','266254','266271','266307','266454','266723','266827','266950','266956','267022','267023','267029','267066','267358','267502','267542','267607','267735','267863','267935','267936','268086','268100','268101','268144','268167','268249','268312','268388','268471','268606','268625','268676','268707','268754','268756','268780','268873','268909','269013','269015','269064','269084','269151','269428','269432','269447','269488','269532','269624','273382','273418','273419','273438','273544','273606','273902','273958','274040','274082','274267','274427','274612','274627','274693','274703','274704','274749','274763','274829','274845','275067','275094','275218','275240','275247','275332','275484','275589','275665','275739','275749','275750','275780','275805','275952','276291','276350','276531','276694','276823','276986','277006','277288','277354','277476','277520','277586','277676','277762','277763','277936','278009','278011','278104','278169','278258','278290','278291','278312','278490','278502','278526','279000','279004','279056','279151','279152','279153','279179','279283','279361','279362','279470','279586','279689','279691','279701','279737','279749','279763','280288','280289','280297','280298','280323','280415','280573','280642','280710','280817','280856','280882','280964','280977','280983','281023','281025','281054','281077','281079','281117','281148','281183','281436','281659','281660','281687','281730','281731','281933','282063','282069','282106','282109','282160','282347','282368','282488','282523','282528','282764','282790','282834','282851','283139','283382','283385','283490','283601','283717','283764','284136','284137','284275','284448','284449','284450','284451','284452','284497','284532','284654','284829','284962','285025','285081','285082','285083','285147','285148','285150','285151','285200','285245','285251','285253','285255','285262','285455','285462','285494','285495','285540','285614','285660','285680','285702','285703','285704','285713','285715','285746','285790','285803','285804','285835','286015','286016','286049','286070','286141','286213','286214','286215','286265','286350','286450','286452','286657','286810','286814','286850','286852','286905','287014','287017','287046','287047','287049','287050','287051','287056','287057','287060','287061','287062','287165','287204','287220','287543','287777','288171','288218','288287','288350','288472','288574','288704','288705','288860','288901','289374','289375','289385','289401','289404','289405','289451','289487','291648','291649','291737','291887','291940','291941','291994','292090','292091','292256','292292','292327','292328','292329','292484','292496','292525','292533','292624','292673','292727','292755','292851','293253','293257','293409','293457','293489','293573','293574','293596','294013','294188','294189','294240','294241','294277','294283','294300','294334','294373','294562','294576','294583','294596','294597','294615','294670','294673','294690','294895','294899','295310','295311','295413','295420','295524','295658','295699','295744','295752','295838','295989','295997','296279','297083','297084','297085','297096','297165','297211','297230','297464','297557','297568','297569','297601','297609','297610','297612','297618','297619','297696','297697','297699','297700','297701','297712','297802','298107','298113','298394','298435','298535','299038','299090','299107','299116','299138','299172','299192','299211','299275','299481','299483','299499','299547','299549','299583','299604','299654','299688','299751','299798','299799','299829','299985','299986','300064','300172','300243','300324','300407','300929','300999','301056','301790','301791','301849','301886','301887','301937','301999','302051','302067','302086','302272','303906') 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 ('142926','153332','155122','155123','155124','155125','157639','158271','158287','158288','158655','159395','159402','159403','159404','159460','159461','159462','159463','159464','159465','159466','159467','159468','159912','160194','160196','160395','160437','160489','160513','160534','160562','160725','160851','160852','160932','161197','161545','161756','161910','162073','162074','162222','162235','162340','162341','162342','162343','162344','162345','162346','162347','162348','162365','162390','162510','162565','163031','163547','163922','164065','164263','164362','164365','164548','164654','164897','164937','165551','165552','165555','165917','165929','166020','166217','166218','166437','166438','166439','166440','166441','166442','166795','166796','166801','166933','167085','167104','167114','167175','167183','167211','167326','167358','167365','167402','167502','167619','167687','167724','167725','167726','167727','167728','167729','167730','167731','167732','167733','167786','168017','168025','168115','168272','168329','169915','232450','232463','232502','232526','232541','232542','232544','238259','238260','238261','238262','238268','239505','239506','240038','240968','241517','242330','242497','242563','242860','243769','243770','243771','243909','244125','244389','244468','244618','244647','244777','245034','245895','245898','246212','246340','246533','246534','246631','246677','246997','246998','246999','247000','247001','247009','247150','247254','247381','247395','247412','247597','247697','247786','247866','248904','248968','249067','249249','249264','249352','249393','249411','249635','249641','249810','249818','249854','249915','250007','250210','250695','250697','250721','250773','250793','250795','250967','251020','251021','251079','251155','251233','251493','251588','251793','251835','251845','251907','251908','251917','251918','251919','251921','251922','251923','251924','251925','251934','251935','251949','251966','252018','252019','252064','252067','252146','252157','252237','253042','253070','253079','253080','253081','253089','253094','253271','253278','253360','253568','253765','253834','253879','253892','254250','254384','254396','254454','254521','254522','254544','255001','255109','255169','255185','255289','255510','255603','255675','255710','255776','255787','255839','255882','256006','256015','256078','256174','256202','256353','256618','256679','256848','256872','256873','257133','257165','257216','261706','261728','261781','261801','261943','262112','262755','262925','262926','263060','263117','263119','263121','263200','263483','263534','263636','264356','264456','264637','264735','264737','264792','264793','264820','264876','264949','265022','265187','265265','265274','265425','265442','265763','265897','265944','266161','266197','266230','266254','266271','266307','266454','266723','266827','266950','266956','267022','267023','267029','267066','267358','267502','267542','267607','267735','267863','267935','267936','268086','268100','268101','268144','268167','268249','268312','268388','268471','268606','268625','268676','268707','268754','268756','268780','268873','268909','269013','269015','269064','269084','269151','269428','269432','269447','269488','269532','269624','273382','273418','273419','273438','273544','273606','273902','273958','274040','274082','274267','274427','274612','274627','274693','274703','274704','274749','274763','274829','274845','275067','275094','275218','275240','275247','275332','275484','275589','275665','275739','275749','275750','275780','275805','275952','276291','276350','276531','276694','276823','276986','277006','277288','277354','277476','277520','277586','277676','277762','277763','277936','278009','278011','278104','278169','278258','278290','278291','278312','278490','278502','278526','279000','279004','279056','279151','279152','279153','279179','279283','279361','279362','279470','279586','279689','279691','279701','279737','279749','279763','280288','280289','280297','280298','280323','280415','280573','280642','280710','280817','280856','280882','280964','280977','280983','281023','281025','281054','281077','281079','281117','281148','281183','281436','281659','281660','281687','281730','281731','281933','282063','282069','282106','282109','282160','282347','282368','282488','282523','282528','282764','282790','282834','282851','283139','283382','283385','283490','283601','283717','283764','284136','284137','284275','284448','284449','284450','284451','284452','284497','284532','284654','284829','284962','285025','285081','285082','285083','285147','285148','285150','285151','285200','285245','285251','285253','285255','285262','285455','285462','285494','285495','285540','285614','285660','285680','285702','285703','285704','285713','285715','285746','285790','285803','285804','285835','286015','286016','286049','286070','286141','286213','286214','286215','286265','286350','286450','286452','286657','286810','286814','286850','286852','286905','287014','287017','287046','287047','287049','287050','287051','287056','287057','287060','287061','287062','287165','287204','287220','287543','287777','288171','288218','288287','288350','288472','288574','288704','288705','288860','288901','289374','289375','289385','289401','289404','289405','289451','289487','291648','291649','291737','291887','291940','291941','291994','292090','292091','292256','292292','292327','292328','292329','292484','292496','292525','292533','292624','292673','292727','292755','292851','293253','293257','293409','293457','293489','293573','293574','293596','294013','294188','294189','294240','294241','294277','294283','294300','294334','294373','294562','294576','294583','294596','294597','294615','294670','294673','294690','294895','294899','295310','295311','295413','295420','295524','295658','295699','295744','295752','295838','295989','295997','296279','297083','297084','297085','297096','297165','297211','297230','297464','297557','297568','297569','297601','297609','297610','297612','297618','297619','297696','297697','297699','297700','297701','297712','297802','298107','298113','298394','298435','298535','299038','299090','299107','299116','299138','299172','299192','299211','299275','299481','299483','299499','299547','299549','299583','299604','299654','299688','299751','299798','299799','299829','299985','299986','300064','300172','300243','300324','300407','300929','300999','301056','301790','301791','301849','301886','301887','301937','301999','302051','302067','302086','302272','303906') GROUP BY `tip` ORDER BY `tip` ASC