SELECT
user.id as id,
user.country as country
FROM
photos INNER JOIN user ON photos.user_id = user.id
WHERE
user.lifchik_status IS NOT NULL AND
user.country IN ("Australia","Canada","Hong Kong","Ireland","New Zealand","South Africa","United Kingdom","United States","United States Minor Outlying Islands")
Detailed information about user brad : www.FirstClickFriend.com
