my $Query = "SELECT hfcc_sched.freq,hfcc_sched.utc_time_start,hfcc_sched.utc_time_end,"; $Query .= "hfcc_sched.power,hfcc_sched.days,hfcc_sched.lang,hfcc_sched.modulation,"; $Query .= "hfcc_site.sitename,hfcc_admin.country,"; $Query .= "hfcc_bcst.station,schedule_flat.lang "; $Query .= "FROM hfcc_sched,hfcc_site,hfcc_admin,hfcc_bcst,schedule_flat "; $Query .= "WHERE hfcc_sched.freq='" . $theSearch . "' AND "; $Query .= "hfcc_site.sitekey=hfcc_sched.location AND "; $Query .= "hfcc_admin.adminkey=hfcc_sched.country AND "; $Query .= "hfcc_bcst.bcstkey=hfcc_sched.station AND "; $Query .= "schedule_flat.utc_time_start=hfcc_sched.utc_time_start AND "; $Query .= "schedule_flat.freq LIKE hfcc_sched.freq"; print STDERR "[$Query]\n";