SELECT s.id,s.age,s.name,c.name as country, ct.name as city FROM foreignl_search.search_index s LEFT JOIN foreignl_search.country c ON s.country = c.id LEFT JOIN foreignl_search.city ct ON s.city = ct.id LEFT JOIN foreignl.t_hotlist f ON f.fk_women_id = s.id WHERE f.fk_profile = ? ORDER BY id DESC LIMIT 0,10