SELECT REPLACE(CAST(GROUP_CONCAT(DISTINCT hdtv ORDER BY hdtv DESC SEPARATOR ', ') as CHAR), ', 0', '') 'HDTV', REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((SELECT GROUP_CONCAT(DISTINCT channel.callsign ORDER BY channel.callsign ASC SEPARATOR ', ') FROM mythconverg.channel WHERE channel.chanid = program.chanid GROUP BY channel.callsign),'WGBH', 'PBS WGBH'),'WBZ', 'CBS WBZ'),'WCVB', 'ABC WCVB'),'WHDH', 'NBC WHDH'),'WFXT', 'FOX WFXT'),'WLVI', 'CW WLVI') 'Channel', mythconverg.program.title 'Title', GROUP_CONCAT(DISTINCT category ORDER BY category ASC SEPARATOR ', ') 'Category', COUNT(mythconverg.program.title) 'Count', GROUP_CONCAT(DISTINCT subtitle ORDER BY subtitle ASC SEPARATOR '\n') 'SubTitle', GROUP_CONCAT(DISTINCT description ORDER BY subtitle ASC SEPARATOR '\n') 'Description', REPLACE(CAST(GROUP_CONCAT(DISTINCT previouslyshown ORDER BY previouslyshown ASC SEPARATOR ', ') as CHAR), ', 1', '') 'PreviouslyShown',(SELECT COUNT(mythhelper.past_titles.pasttitle) FROM mythhelper.past_titles WHERE mythhelper.past_titles.pasttitle = mythconverg.program.title) 'MythHelperCount' FROM mythconverg.program WHERE starttime > NOW() AND (SELECT COUNT(mythhelper.past_titles.pasttitle) FROM mythhelper.past_titles WHERE mythhelper.past_titles.pasttitle = mythconverg.program.title) < 1 AND category_type!='movie' AND category_type!='sports' AND category!='Shopping' AND category NOT LIKE '%Sports%' AND category!='Cartoon' AND category!='Anime' AND category!='News' AND category!='Weather' AND category NOT LIKE 'Religious%' AND category!='Animated' AND category NOT LIKE 'Children%' AND category!='Soap' AND category!='Auto Racing' AND program.chanid NOT IN (SELECT channel.chanid FROM mythconverg.channel WHERE channel.callsign = 'RTPI' OR channel.callsign = 'EWTN' OR channel.callsign = 'HSN' OR channel.callsign = 'WNEU' OR channel.callsign = 'WENH' OR channel.callsign = 'BCTC' OR channel.callsign = 'WUNI' OR channel.callsign = 'QVC') GROUP BY mythconverg.program.title ORDER BY HDTV DESC, mythconverg.program.title ASC, mythconverg.program.starttime ASC LIMIT 333