SELECT count( starportrait.idstar ) AS count, nom, star.id, photo
FROM star, starportrait, portrait WHERE type LIKE '%ma%' AND star.id = starportrait.idstar
AND portrait.id = starportrait.idportrait AND portrait.status = 0
GROUP BY starportrait.idstar ORDER BY count DESC LIMIT 14
