Unnamed

	$query = "SELECT members.*, country.country, state.state, city.city, region.region FROM members LEFT JOIN (country, state, city) ON (members.country_id = country.id AND members.state_id = state.id AND members.city_id = city.id AND members.region_id = region.id) WHERE ".$search." ORDER BY country ASC, state ASC, city ASC, region ASC LIMIT 0";