1: -- CACHE: 30m SELECT DISTINCT(e.id), COUNT(en.country_id) AS 'nationalities', ei.first_name, ei.last_name, c.name AS `country`, ei.work_experience_since,ei.description, dt.name AS 'degree' FROM v2_experts e LEFT JOIN v2_membersList m ON m.user_id = e.id LEFT JOIN v2_expert_info ei ON e.id = ei.expert_id LEFT JOIN v2_degree_types dt ON ei.highest_degree=dt.id LEFT JOIN v2_expert_nationality en ON en.expert_id=e.id LEFT JOIN v2_countries c ON c.id = en.country_id WHERE m.user_type = 0 AND m.status = 1 AND m.expiration_date > NOW() AND m.expired = 0 GROUP BY e.id ORDER BY RAND() LIMIT 6

-- 6 ms; returned 5 row(s)