MakeLMSPreSQLCall: Error Executing Query SELECT application.aapp_application_id AS application_id, application.aapp_expiration_date, application.aapp_file_num AS app_arn, application.aapp_file_num, application.aapp_frn, DATE_FORMAT(application.aapp_expiration_date, '%m/%d/%Y') AS cp_exp_date, DATE_FORMAT(application.aapp_receipt_date, '%m/%d/%Y') AS accepted_date, DATE_FORMAT(facility.expiration_date, '%m/%d/%Y') AS lic_expiration_date, application_facility.afac_facility_id AS facility_id, application_facility.afac_community_city AS comm_city, application_facility.afac_community_state_code AS comm_state, application_facility.station_class_code AS station_class, application_facility.country_code AS fac_country, application_facility.afac_channel AS AppChannel, application_facility.afac_community_city AS AppCity, application_facility.afac_community_state_code AS AppState, app_antenna.aant_polarization AS ant_polarization, app_antenna.aant_rotation_deg AS ant_rotation, app_antenna.aant_antenna_id AS antenna_id, app_antenna.aant_antenna_type_code AS antenna_type, app_antenna.aant_rc_amsl AS elev_amsl, app_antenna.aant_horiz_rc_haat AS haat_horiz_rc_mtr, app_antenna.aant_vert_rc_haat AS haat_vert_rc_mtr, app_antenna.aant_horiz_rc_hgt AS hag_horiz_rc_mtr, app_antenna.aant_antenna_record_id, app_antenna.aant_vert_rc_hgt AS hag_vert_rc_mtr, app_antenna.aant_max_power_gain AS max_ant_pwr_gain, app_antenna.aant_rc_haat AS max_haat, app_antenna.aant_horiz_rc_amsl AS rcamsl_horiz_mtr, app_antenna.aant_vert_rc_amsl AS rcamsl_vert_mtr, app_antenna.aant_make AS lic_ant_make, app_antenna.aant_model AS lic_ant_model_num, app_antenna.aant_power_output AS trans_power_output, app_antenna_frequency.aafq_power_erp_kw AS effective_erp, app_antenna_frequency.aafq_horiz_erp_kw AS horiz_erp, app_antenna_frequency.aafq_vert_erp_kw AS vert_erp, app_antenna_frequency.aafq_horiz_max_erp_kw AS max_horiz_erp, app_antenna_frequency.aafq_vert_max_erp_kw AS max_vert_erp, app_antenna_frequency.aafq_type_power_output AS power_output_vis_kw, app_location.aloc_asrn AS asrn, app_location.aloc_ground_elev AS elev_amsl, app_location.aloc_overall_hgt AS hag_overall_mtr, app_location.aloc_lat_deg AS lat_deg, app_location.aloc_lat_dir AS lat_dir, app_location.aloc_lat_mm AS lat_min, app_location.aloc_lat_ss AS lat_sec, app_location.aloc_long_deg AS lon_deg, app_location.aloc_long_dir AS lon_dir, app_location.aloc_long_mm AS lon_min, app_location.aloc_long_ss AS lon_sec, app_location.aloc_loc_seq_id AS site_number, app_party.apar_address_line1 AS fac_address1, app_party.apar_address_line2 AS fac_address2, app_party.apar_zip_code AS fac_zip1, '' AS assoc_facility_id, cma_location.biased_lat AS biased_lat, cma_location.biased_long AS biased_long, facility.callsign AS fac_callsign, facility.facility_uuid, facility.channel AS fac_channel, facility.community_served_city AS fac_city, facility.service_code AS fac_service, facility.community_served_state AS fac_state, facility.status_date AS fac_status_date, application_facility.afac_facility_type AS fac_type, facility.facility_status AS fac_status, facility.callsign AS FacilityCalls, facility.community_served_city AS FacilityCity, facility.community_served_state AS FacilityState, facility.primary_station, history_cards.import_letter_id AS importID, history_cards.facility_id AS historyFacID, license_filing_version.active_ind, license_filing_version.current_status_code AS app_status, license_filing_version.discriminator_code, license_filing_version.service_code, license_filing_version.service_code AS app_service, license_filing_version.auth_type_code, license_filing_version.original_auth_type_code, license_filing_version.purpose_code AS app_type, license_filing_version.original_purpose_code, license_filing_version.sub_purpose_code, license_filing_version.service_code AS asd_service, DATE_FORMAT(license_filing_version.status_date, '%m/%d/%Y') AS app_status_date, lkp_application_purpose.application_purpose_desc, lkp_application_sub_purpose.sub_purpose_desc, lkp_facility_status.facility_status_desc, lkp_authorization_type.authorization_type_desc, lkp_antenna_type.antenna_type_desc, xref_cdbs_lm_app_id_transfer.application_id AS fm_application_id, app_mm_application.contour_215_protection_ind AS 73_215_ind, facility.digital_operation as digital_status, '' AS FacilityFreq, '' AS AppFreq, '' AS eng_record_type, '' AS docket_num, '' AS da_ind, '' AS rule_73_215_req_ind, '' AS fac_frequency, '' AS file_prefix FROM license_filing_version LEFT JOIN facility ON license_filing_version.license_filing_id = facility.license_filing_id LEFT JOIN application ON application.aapp_application_id = license_filing_version.filing_version_id LEFT JOIN application_facility ON application.aapp_application_id = application_facility.afac_application_id LEFT JOIN app_location ON aapp_application_id = aloc_aapp_application_id LEFT JOIN app_antenna ON aloc_loc_record_id = aant_aloc_loc_record_id LEFT JOIN app_antenna_frequency ON aant_antenna_record_id = aafq_aant_antenna_record_id LEFT JOIN app_mm_application ON application.aapp_application_id = app_mm_application.aapp_application_id LEFT JOIN app_party ON application.aapp_application_id = app_party.apar_aapp_application_id LEFT JOIN cma_location ON application.aapp_application_id = cma_location.application_id LEFT JOIN lkp_application_purpose ON license_filing_version.purpose_code = lkp_application_purpose.application_purpose_code LEFT JOIN lkp_application_sub_purpose ON license_filing_version.sub_purpose_code = lkp_application_sub_purpose.sub_purpose_code LEFT JOIN lkp_facility_status ON facility.facility_status = lkp_facility_status.facility_status LEFT JOIN lkp_authorization_type ON license_filing_version.auth_type_code = lkp_authorization_type.authorization_type_code LEFT JOIN lkp_antenna_type ON app_antenna.aant_antenna_type_code = lkp_antenna_type.antenna_type LEFT JOIN xref_cdbs_lm_app_id_transfer ON application.aapp_application_id = xref_cdbs_lm_app_id_transfer.filing_version_id LEFT JOIN history_cards ON facility.facility_id = history_cards.facility_id LEFT JOIN gis_facility ON facility.facility_id = gis_facility.facility_id WHERE license_filing_version.current_status_code IN ('GRA', 'PEN', 'SUB') AND discriminator_code = 'FM' AND application.aapp_application_id = ? AND license_filing_version.active_ind = 'Y' for 1 Parameters: [ 25076f916f1a7913016f1b6c38770024 ] MySQL Error: Table 'lms.license_filing_version' doesn't exist