Stumped with complicated MySQL Query!

[eluser]crumpet[/eluser]
No sql expert but perhaps try making the service_are_basins and service_area_counties right joins....
then use max(service_area_basins.percent) AS basins_percent and max(service_area_counties) AS counties_percent
in your select query