use GROUP BY instead of DISTINCT ON in the state and country queries for better cross...