-------------- SELECT version() -------------- +------------------+ | version() | +------------------+ | 5.1.50-community | +------------------+ 1 row in set (0.00 sec) -------------- EXPLAIN EXTENDED SELECT DISTINCT PUBACC_FR.frequency_assigned , PUBACC_FR.call_sign , PUBACC_HD.license_status , PUBACC_HD.radio_service_code , PUBACC_FR.class_station_code , PUBACC_LO.location_state , PUBACC_LO.location_county , PUBACC_LO.location_city , PUBACC_LO.location_address , PUBACC_LO.location_name , tblGeoStateCA1.contact_licensee , PUBACC_EN.entity_name , PUBACC_EN.state , PUBACC_EN.city , PUBACC_EN.street_address , PUBACC_CP.state_code , PUBACC_CP.control_county , PUBACC_CP.control_city , PUBACC_CP.control_address , PUBACC_CP.control_phone , PUBACC_FR.cnt_mobile_units , PUBACC_HD.grant_date , PUBACC_HD.expired_date , PUBACC_HD.cancellation_date , PUBACC_HD.effective_date , PUBACC_HD.last_action_date , PUBACC_FR.unique_system_identifier , PUBACC_FR.ULS_File_Number , PUBACC_LO.ground_elevation , PUBACC_LO.lat_degrees , PUBACC_LO.lat_minutes , PUBACC_LO.lat_seconds , PUBACC_LO.lat_direction , PUBACC_LO.long_degrees , PUBACC_LO.long_minutes , PUBACC_LO.long_seconds , PUBACC_LO.long_direction , PUBACC_FR.frequency_upper_band , PUBACC_FR.frequency_carrier , PUBACC_FR.db_id FROM PUBACC_LO LEFT JOIN PUBACC_CP ON PUBACC_LO.call_sign=PUBACC_CP.call_sign INNER JOIN PUBACC_EN ON PUBACC_LO.call_sign=PUBACC_EN.call_sign INNER JOIN PUBACC_HD ON PUBACC_LO.call_sign=PUBACC_HD.call_sign INNER JOIN PUBACC_FR ON PUBACC_LO.call_sign=PUBACC_FR.call_sign LEFT JOIN tblGeoStateCA1 ON PUBACC_LO.call_sign=tblGeoStateCA1.call_sign WHERE (PUBACC_EN.entity_type = 'L') AND (location_state='CA' OR state='CA' OR state_code='CA') ORDER BY PUBACC_FR.frequency_assigned, PUBACC_FR.call_sign, PUBACC_HD.license_status, PUBACC_HD.radio_service_code, PUBACC_FR.class_station_code, PUBACC_LO.location_state, PUBACC_LO.location_county, PUBACC_LO.location_city, PUBACC_LO.location_address -------------- +----+-------------+----------------+------+-----------------------------+-------------+---------+-------------------------+---------+----------+----------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra | +----+-------------+----------------+------+-----------------------------+-------------+---------+-------------------------+---------+----------+----------------------------------------------+ | 1 | SIMPLE | PUBACC_EN | ref | call_sign,state,entity_type | entity_type | 3 | const | 1004177 | 100.00 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | PUBACC_HD | ref | call_sign | call_sign | 11 | uls.PUBACC_EN.call_sign | 1 | 100.00 | Using where | | 1 | SIMPLE | PUBACC_LO | ref | call_sign,location_state | call_sign | 11 | uls.PUBACC_HD.call_sign | 1 | 100.00 | Using where | | 1 | SIMPLE | PUBACC_CP | ref | call_sign | call_sign | 11 | uls.PUBACC_HD.call_sign | 1 | 100.00 | Using where | | 1 | SIMPLE | tblGeoStateCA1 | ref | call_sign | call_sign | 11 | uls.PUBACC_LO.call_sign | 1 | 100.00 | | | 1 | SIMPLE | PUBACC_FR | ref | call_sign | call_sign | 11 | uls.PUBACC_LO.call_sign | 9 | 100.00 | Using where | +----+-------------+----------------+------+-----------------------------+-------------+---------+-------------------------+---------+----------+----------------------------------------------+ 6 rows in set, 1 warning (0.19 sec) -------------- SHOW WARNINGS -------------- +-------+------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Level | Code | Message | +-------+------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Note | 1003 | select distinct `uls`.`pubacc_fr`.`frequency_assigned` AS `frequency_assigned`,`uls`.`pubacc_fr`.`call_sign` AS `call_sign`,`uls`.`pubacc_hd`.`license_status` AS `license_status`,`uls`.`pubacc_hd`.`radio_service_code` AS `radio_service_code`,`uls`.`pubacc_fr`.`class_station_code` AS `class_station_code`,`uls`.`pubacc_lo`.`location_state` AS `location_state`,`uls`.`pubacc_lo`.`location_county` AS `location_county`,`uls`.`pubacc_lo`.`location_city` AS `location_city`,`uls`.`pubacc_lo`.`location_address` AS `location_address`,`uls`.`pubacc_lo`.`location_name` AS `location_name`,`uls`.`tblgeostateca1`.`contact_licensee` AS `contact_licensee`,`uls`.`pubacc_en`.`entity_name` AS `entity_name`,`uls`.`pubacc_en`.`state` AS `state`,`uls`.`pubacc_en`.`city` AS `city`,`uls`.`pubacc_en`.`street_address` AS `street_address`,`uls`.`pubacc_cp`.`state_code` AS `state_code`,`uls`.`pubacc_cp`.`control_county` AS `control_county`,`uls`.`pubacc_cp`.`control_city` AS `control_city`,`uls`.`pubacc_cp`.`control_address` AS `control_address`,`uls`.`pubacc_cp`.`control_phone` AS `control_phone`,`uls`.`pubacc_fr`.`cnt_mobile_units` AS `cnt_mobile_units`,`uls`.`pubacc_hd`.`grant_date` AS `grant_date`,`uls`.`pubacc_hd`.`expired_date` AS `expired_date`,`uls`.`pubacc_hd`.`cancellation_date` AS `cancellation_date`,`uls`.`pubacc_hd`.`effective_date` AS `effective_date`,`uls`.`pubacc_hd`.`last_action_date` AS `last_action_date`,`uls`.`pubacc_fr`.`unique_system_identifier` AS `unique_system_identifier`,`uls`.`pubacc_fr`.`uls_file_number` AS `ULS_File_Number`,`uls`.`pubacc_lo`.`ground_elevation` AS `ground_elevation`,`uls`.`pubacc_lo`.`lat_degrees` AS `lat_degrees`,`uls`.`pubacc_lo`.`lat_minutes` AS `lat_minutes`,`uls`.`pubacc_lo`.`lat_seconds` AS `lat_seconds`,`uls`.`pubacc_lo`.`lat_direction` AS `lat_direction`,`uls`.`pubacc_lo`.`long_degrees` AS `long_degrees`,`uls`.`pubacc_lo`.`long_minutes` AS `long_minutes`,`uls`.`pubacc_lo`.`long_seconds` AS `long_seconds`,`uls`.`pubacc_lo`.`long_direction` AS `long_direction`,`uls`.`pubacc_fr`.`frequency_upper_band` AS `frequency_upper_band`,`uls`.`pubacc_fr`.`frequency_carrier` AS `frequency_carrier`,`uls`.`pubacc_fr`.`db_id` AS `db_id` from `uls`.`pubacc_lo` left join `uls`.`pubacc_cp` on(((`uls`.`pubacc_hd`.`call_sign` = `uls`.`pubacc_en`.`call_sign`) and (`uls`.`pubacc_lo`.`call_sign` = `uls`.`pubacc_en`.`call_sign`) and (`uls`.`pubacc_cp`.`call_sign` = `uls`.`pubacc_en`.`call_sign`) and (`uls`.`pubacc_fr`.`call_sign` = `uls`.`pubacc_en`.`call_sign`))) join `uls`.`pubacc_en` join `uls`.`pubacc_hd` join `uls`.`pubacc_fr` left join `uls`.`tblgeostateca1` on(((`uls`.`pubacc_hd`.`call_sign` = `uls`.`pubacc_en`.`call_sign`) and (`uls`.`pubacc_lo`.`call_sign` = `uls`.`pubacc_en`.`call_sign`) and (`uls`.`tblgeostateca1`.`call_sign` = `uls`.`pubacc_en`.`call_sign`) and (`uls`.`pubacc_fr`.`call_sign` = `uls`.`pubacc_en`.`call_sign`))) where ((`uls`.`pubacc_hd`.`call_sign` = `uls`.`pubacc_en`.`call_sign`) and (`uls`.`pubacc_lo`.`call_sign` = `uls`.`pubacc_en`.`call_sign`) and (`uls`.`pubacc_fr`.`call_sign` = `uls`.`pubacc_en`.`call_sign`) and (`uls`.`pubacc_en`.`entity_type` = 'L') and ((`uls`.`pubacc_lo`.`location_state` = 'CA') or (`uls`.`pubacc_en`.`state` = 'CA') or (`uls`.`pubacc_cp`.`state_code` = 'CA'))) order by `uls`.`pubacc_fr`.`frequency_assigned`,`uls`.`pubacc_fr`.`call_sign`,`uls`.`pubacc_hd`.`license_status`,`uls`.`pubacc_hd`.`radio_service_code`,`uls`.`pubacc_fr`.`class_station_code`,`uls`.`pubacc_lo`.`location_state`,`uls`.`pubacc_lo`.`location_county`,`uls`.`pubacc_lo`.`location_city`,`uls`.`pubacc_lo`.`location_address` | +-------+------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) Bye