SELECT country.slug AS country_slug, city.slug AS city_slug, member_business.business_name, member_business.business_url
FROM member
INNER JOIN member_business ON member_business.member_id = member.id
INNER JOIN country ON country.id = member_business.country_id
INNER JOIN state ON state.id = member_business.state_id
INNER JOIN city ON city.id = member_business.city_id
WHERE city.slug = 'port-kennedy'
AND member.is_visible = 1
AND member_business.is_visible = 0
AND member.trash = 0
ORDER BY member_business.business_name
LIMIT 10
