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 /*+ MAX_EXECUTION_TIME(8000) */ f.display_channel, f.dma_id, f.comm_city, f.comm_state, f.owner, IF(l.asrn_fix, l.asrn_fix, l.aloc_asrn) AS asrn, IF(l.cf_ind = 'Y', l.cf_lat_dir, l.aloc_lat_dir) AS lat_dir, IF(l.cf_ind = 'Y', l.cf_lat_deg, l.aloc_lat_deg) AS lat_deg, IF(l.cf_ind = 'Y', l.cf_lat_mm, l.aloc_lat_mm) AS lat_min, IF(l.cf_ind = 'Y', l.cf_lat_ss, l.aloc_lat_ss) AS lat_sec, IF(l.cf_ind = 'Y', l.cf_lon_dir, l.aloc_long_dir) AS lon_dir, IF(l.cf_ind = 'Y', l.cf_lon_deg, l.aloc_long_deg) AS lon_deg, IF(l.cf_ind = 'Y', l.cf_lon_mm, l.aloc_long_mm) AS lon_min, IF(l.cf_ind = 'Y', l.cf_lon_ss, l.aloc_long_ss) AS lon_sec, l.aloc_loc_seq_id, a.aapp_file_num, f.fac_status, f.fac_country, IF(l.rcamsl_fix, l.rcamsl_fix, n.aant_rc_amsl) AS rcamsl_horiz_mtr, IF(l.hagl_fix, l.hagl_fix, n.aant_rc_hag) AS hag_rc_mtr, IF(a.svc_code_fix IS NULL OR a.svc_code_fix = '', v.service_code, a.svc_code_fix) 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, IF(a.channel_fix, a.channel_fix, af.afac_channel) AS station_channel, f.facility_id, v.*, v.active_ind AS eng_record_type, IF(l.ant_type IS NULL OR l.ant_type = '', n.aant_antenna_type_code, l.ant_type) AS antenna_type, IF(l.ant_pattern IS NULL OR l.ant_pattern = '', n.aant_antenna_record_id, l.ant_pattern) AS antenna_id, IF(l.pol_fix IS NULL OR l.pol_fix = '', n.aant_polarization, l.pol_fix) AS ant_polarization, IF(l.ant_rotation, l.ant_rotation, n.aant_rotation_deg) AS ant_rotation, f.fac_callsign, af.licensee_name AS party_name, 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 'KDSE%' AND (v.active_ind = 'Y' OR a.active_record = 'V') AND (a.active_record <> 'N' || a.active_record IS NULL) 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','SIL','SSL') AND (CASE WHEN (a.svc_code_fix IS NULL OR a.svc_code_fix = '') THEN v.service_code IN('DTV','DTS','DTX','DCA','LPD','LPT','DRT') ELSE a.svc_code_fix IN('DTV','DTS','DTX','DCA','LPD','LPT','DRT') END) 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!