select * from wa_contact a
    join wa_contact_malinku b on (b.contact_id = a.id)
    join wa_contact_city c on (c.city = a.id)
    left join 
    (
        select *, count(*) fotoCnt from wa_contact_foto f 
            join (select * from wa_contact 
               order by create_datetime desc 
               limit 10) x 
           on f.contact_id = x.id
           group by 1
           
    ) d on d.contact_id = a.id
    
order by a.create_datetime desc
limit 10

 
EXPLAIN  SELECT c.count,
b.anketa_url, b.growth, b.weight, d.city, b.city as city_id, b.birthday, b.sex, a.id as user_id, a.create_datetime, a.firstname as name, a.last_datetime, c.image_name, c.ext
FROM wa_contact a
JOIN wa_contact_malinku b ON (a.id = b.contact_id)
LEFT OUTER JOIN (
SELECT *, count(*) as count FROM (SELECT * FROM wa_contact_foto ORDER BY sort asc) t group BY contact_id
) as c ON c.contact_id = a.id
JOIN wa_contact_city d ON (b.city = d.id)
ORDER BY a.create_datetime DESC