-------------- SELECT version() -------------- +-------------------------+ | version() | +-------------------------+ | 5.0.45-community-nt-log | +-------------------------+ 1 row in set (0.01 sec) -------------- EXPLAIN EXTENDED SELECT DISTINCT PUBACC_LO.call_sign, PUBACC_LO.location_state 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 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 | Extra | +----+-------------+----------------+------+---------------+-----------+---------+-------------------------+--------+------------------------------------+ | 1 | SIMPLE | PUBACC_LO | ALL | call_sign | NULL | NULL | NULL | 775465 | Using temporary; Using filesort | | 1 | SIMPLE | PUBACC_CP | ref | call_sign | call_sign | 11 | uls.PUBACC_LO.call_sign | 1 | Using index; Distinct | | 1 | SIMPLE | tblGeoStateCA1 | ref | call_sign | call_sign | 11 | uls.PUBACC_LO.call_sign | 1 | Using index; Distinct | | 1 | SIMPLE | PUBACC_HD | ref | call_sign | call_sign | 11 | uls.PUBACC_LO.call_sign | 1 | Using where; Distinct | | 1 | SIMPLE | PUBACC_FR | ref | call_sign | call_sign | 11 | uls.PUBACC_LO.call_sign | 10 | Using where; Distinct | | 1 | SIMPLE | PUBACC_EN | ref | call_sign | call_sign | 11 | uls.PUBACC_HD.call_sign | 2 | Using where; Using index; Distinct | +----+-------------+----------------+------+---------------+-----------+---------+-------------------------+--------+------------------------------------+ 6 rows in set, 1 warning (0.04 sec) -------------- SHOW WARNINGS -------------- +-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Level | Code | Message | +-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Note | 1003 | select distinct `uls`.`pubacc_lo`.`call_sign` AS `call_sign`,`uls`.`pubacc_lo`.`location_state` AS `location_state` from `uls`.`pubacc_lo` left join `uls`.`pubacc_cp` on(((`uls`.`pubacc_cp`.`call_sign` = `uls`.`pubacc_lo`.`call_sign`) and (`uls`.`pubacc_hd`.`call_sign` = `uls`.`pubacc_lo`.`call_sign`) and (`uls`.`pubacc_fr`.`call_sign` = `uls`.`pubacc_lo`.`call_sign`) and (`uls`.`pubacc_en`.`call_sign` = `uls`.`pubacc_lo`.`call_sign`))) join `uls`.`pubacc_en` join `uls`.`pubacc_hd` join `uls`.`pubacc_fr` left join `uls`.`tblgeostateca1` on(((`uls`.`tblgeostateca1`.`call_sign` = `uls`.`pubacc_lo`.`call_sign`) and (`uls`.`pubacc_hd`.`call_sign` = `uls`.`pubacc_lo`.`call_sign`) and (`uls`.`pubacc_fr`.`call_sign` = `uls`.`pubacc_lo`.`call_sign`) and (`uls`.`pubacc_en`.`call_sign` = `uls`.`pubacc_lo`.`call_sign`))) where ((`uls`.`pubacc_hd`.`call_sign` = `uls`.`pubacc_lo`.`call_sign`) and (`uls`.`pubacc_fr`.`call_sign` = `uls`.`pubacc_lo`.`call_sign`) and (`uls`.`pubacc_en`.`call_sign` = `uls`.`pubacc_lo`.`call_sign`)) 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.02 sec) Bye