SELECT c.`channum`, c.`callsign`,p.`starttime`, p.`title`, p.`subtitle`, p.`description`, p.`previouslyshown` FROM program p, channel c WHERE c.chanid=p.chanid AND HOUR(p.starttime) >= 19 AND HOUR(p.starttime) < 23 AND p.previouslyshown = 0 AND c.callsign IN ("KCRA", "KQCA", "KXTV", "KOVR", "KMAX", "KXTL") AND ((p.title LIKE '%Pilot%' OR p.subtitle LIKE '%Pilot%' OR p.description LIKE '%Pilot%') OR (p.title LIKE '%Premiere%' OR p.subtitle LIKE '%Premiere%' OR p.description LIKE '%Premiere%'))

channum	callsign	starttime	title	subtitle	description
31_1	KMAX	2008-03-07 22:00:00	Entertainment Tonight	(null)	The premiere of "Sleepwalking"; "College Road Trip"; "10,000 B.C."; "Miss Pettigrew Lives for a Day"; "Snow Angels."
3_1	KCRA	2008-03-07 19:00:00	Access Hollywood	(null)	The 3,000th show; "American Idol"; the premiere of "10,000 B.C."
3	KCRA	2008-03-07 19:00:00	Access Hollywood	(null)	The 3,000th show; "American Idol"; the premiere of "10,000 B.C."
31	KMAX	2008-03-07 22:00:00	Entertainment Tonight	(null)	The premiere of "Sleepwalking"; "College Road Trip"; "10,000 B.C."; "Miss Pettigrew Lives for a Day"; "Snow Angels."