Discuss DTV: SatelliteGuys Forum DTV USA Forum AVS Forum Digital Home Forum


RabbitEars TV Query

Detailed View

Could not run query: Unknown column 't.priority' in 'order clause' SELECT f.display_channel, f.dma_id, f.comm_city, f.comm_state, f.owner, l.aloc_asrn AS asrn, l.aloc_lat_dir AS lat_dir, l.aloc_lat_deg AS lat_deg, l.aloc_lat_mm AS lat_min, l.aloc_lat_ss AS lat_sec, l.aloc_long_dir AS lon_dir, l.aloc_long_deg AS lon_deg, l.aloc_long_mm AS lon_min, l.aloc_long_ss AS lon_sec, l.aloc_loc_seq_id, a.aapp_file_num, f.fac_status, f.fac_country, n.aant_rc_amsl AS rcamsl_horiz_mtr, n.aant_rc_hag AS hag_rc_mtr, v.service_code AS vsd_service, a.aapp_application_id AS application_id, IF(l.erp_fix, l.erp_fix, q.aafq_power_erp_kw) AS effective_erp, l.vertical_erp, IF(n.aant_rc_haat = 0 OR l.haat_invalid = 'Y', l.calc_haat, n.aant_rc_haat) AS haat_rc_mtr, af.afac_channel, f.facility_id, v.*, v.active_ind AS eng_record_type, n.aant_antenna_type_code AS antenna_type, n.aant_antenna_record_id AS antenna_id, IF(l.pol_fix IS NOT NULL, l.pol_fix, n.aant_polarization) AS ant_polarization, n.aant_rotation_deg AS ant_rotation, f.fac_callsign, af.licensee_name AS party_name, af.afac_channel AS station_channel, a.aapp_file_num AS app_arn, l.aloc_loc_seq_id AS site_number, n.aant_mechanical_deg, n.aant_true_deg FROM facility f, application_facility af, application_lms a, license_filing_version v, app_location l, app_antenna n, app_antenna_frequency q WHERE f.fac_callsign LIKE 'KPOB-TV%' AND (v.active_ind = 'Y' OR a.active_record = 'V') AND (a.active_record <> 'N' || a.active_record IS NULL) AND v.service_code NOT IN('ATV', 'LPA', 'LPX', 'ACA') AND v.purpose_code <> 'SCH' AND v.original_purpose_code <> 'SCH' AND f.facility_id = af.afac_facility_id AND af.afac_application_id = a.aapp_application_id AND a.aapp_application_id = v.filing_version_id AND a.aapp_application_id = l.aloc_aapp_application_id AND l.aloc_loc_record_id = n.aant_aloc_loc_record_id AND n.aant_antenna_record_id = q.aafq_aant_antenna_record_id AND (v.purpose_code IN('L2C','CP','RUL','MOD','STA','EXT') OR v.original_purpose_code IN('L2C','CP','RUL','MOD','STA','EXT')) AND v.sub_purpose_code NOT IN('LEG') AND v.service_code IN('DTS','DTV','DTX','DCA','LPD','LPT','DRT') ORDER BY f.display_channel, t.priority DESC, a.aapp_receipt_date ASC, t.station_channel, t.facility_id, l.aloc_loc_seq_id ASC, af.licensee_name DESC No records found!