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 ((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
40_1	KTXL	2008-03-02 21:30:00	Unhitched	Pilot	Jack's re-entry into the dating scene gets off to a rocky start; Kate learns a lesson when she dates a member of the Boston Celtics; Dr. Freddy finds that love is not cheap with the woman of his dreams.
40_1	KTXL	2008-03-04 21:00:00	New Amsterdam	Pilot	The murder of a socialite forces John to face his past.
40_1	KTXL	2008-03-10 20:00:00	Canterbury's Law	Pilot	A lawyer buries herself in work, going to great lengths to defend the wrongfully accused after the disappearance of her young son.
40_1	KTXL	2008-03-14 20:00:00	The Return of Jezebel James	Pilot; Frankenstein Baby	Successful editor Sarah Tompkins, unable to have a child on her own, asks her estranged sister to carry a baby for her.
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."
256	TCM	2008-03-20 22:30:00	Sunday in New York	(null)	An innocent upstater (Jane Fonda) visits her airline-pilot brother (Cliff Robertson) and meets a stranger (Rod Taylor) she tries to seduce.
269	HISTORY	2008-03-07 20:00:00	Dogfights	Death of the Luftwaffe	One of the greatest dogfights in history takes place Jan. 1, 1945, over Belgium during World War II, as American fighter pilots hasten the demise of the German Luftwaffe.
339	FUSE	2008-03-07 21:00:00	Talking Metal	Rob Halford; Glen Danzig; In This Moment	Hanging with Rob Halford at the premiere of his movie "Fight: War of Words;" a tour of Glen Danzig's mansion; In This Moment.
339	FUSE	2008-03-09 20:00:00	Talking Metal	Rob Halford; Glen Danzig; In This Moment	Hanging with Rob Halford at the premiere of his movie "Fight: War of Words;" a tour of Glen Danzig's mansion; In This Moment.
339	FUSE	2008-03-11 21:30:00	Talking Metal	Rob Halford; Glen Danzig; In This Moment	Hanging with Rob Halford at the premiere of his movie "Fight: War of Words;" a tour of Glen Danzig's mansion; In This Moment.
339	FUSE	2008-03-13 19:30:00	Talking Metal	Rob Halford; Glen Danzig; In This Moment	Hanging with Rob Halford at the premiere of his movie "Fight: War of Words;" a tour of Glen Danzig's mansion; In This Moment.
339	FUSE	2008-03-14 21:30:00	Talking Metal	Rob Halford; Glen Danzig; In This Moment	Hanging with Rob Halford at the premiere of his movie "Fight: War of Words;" a tour of Glen Danzig's mansion; In This Moment.
339	FUSE	2008-03-16 21:30:00	Talking Metal	Rob Halford; Glen Danzig; In This Moment	Hanging with Rob Halford at the premiere of his movie "Fight: War of Words;" a tour of Glen Danzig's mansion; In This Moment.
339	FUSE	2008-03-20 19:30:00	Talking Metal	Rob Halford; Glen Danzig; In This Moment	Hanging with Rob Halford at the premiere of his movie "Fight: War of Words;" a tour of Glen Danzig's mansion; In This Moment.
253	LMN	2008-03-04 22:33:00	Nowhere to Land	(null)	A pilot (Jack Wagner) must safely land a 747 with deadly nerve gas aboard on a flight from Sydney to Los Angeles.
232	FLIVING	2008-03-03 22:30:00	Cool Kids' Parties	Home Movie Premiere Party	An end of soccer season premiere party with faux cocktails, hors d'oeuvres and Hollywood themed games.
254	AMC	2008-03-06 20:00:00	Iron Eagle	(null)	A retired fighter pilot (Louis Gossett Jr.) helps an Air Force brat (Jason Gedrick) free his father with two borrowed F-16s.
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."
40	KTXL	2008-03-02 21:30:00	Unhitched	Pilot	Jack's re-entry into the dating scene gets off to a rocky start; Kate learns a lesson when she dates a member of the Boston Celtics; Dr. Freddy finds that love is not cheap with the woman of his dreams.
40	KTXL	2008-03-04 21:00:00	New Amsterdam	Pilot	The murder of a socialite forces John to face his past.
40	KTXL	2008-03-10 20:00:00	Canterbury's Law	Pilot	A lawyer buries herself in work, going to great lengths to defend the wrongfully accused after the disappearance of her young son.
40	KTXL	2008-03-14 20:00:00	The Return of Jezebel James	Pilot; Frankenstein Baby	Successful editor Sarah Tompkins, unable to have a child on her own, asks her estranged sister to carry a baby for her.
309	THEN	2008-03-11 20:00:00	Kenan & Kel	Pilot	Kenan and Kel scheme to buy a used car.
3	KCRADT	2008-03-07 19:00:00	Access Hollywood	(null)	The 3,000th show; "American Idol"; the premiere of "10,000 B.C."
40	KTXLDT	2008-03-02 21:30:00	Unhitched	Pilot	Jack's re-entry into the dating scene gets off to a rocky start; Kate learns a lesson when she dates a member of the Boston Celtics; Dr. Freddy finds that love is not cheap with the woman of his dreams.
40	KTXLDT	2008-03-04 21:00:00	New Amsterdam	Pilot	The murder of a socialite forces John to face his past.
40	KTXLDT	2008-03-10 20:00:00	Canterbury's Law	Pilot	A lawyer buries herself in work, going to great lengths to defend the wrongfully accused after the disappearance of her young son.
40	KTXLDT	2008-03-14 20:00:00	The Return of Jezebel James	Pilot; Frankenstein Baby	Successful editor Sarah Tompkins, unable to have a child on her own, asks her estranged sister to carry a baby for her.
31	KMAXDT	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."