SELECT SUM(CASE WHEN t1.`statut` = 'analyze'
THEN 1 ELSE 0 END) as `ct_analyze`,
SUM(CASE WHEN t1.`statut` = 'analyzed'
THEN 1 ELSE 0 END) as `ct_analyzed`,
... ДРУГИЕ ПОЛЯ...
FROM `requests` t1
LEFT JOIN clients t2
ON t2.id_client = t1.id_client
WHERE tnd t2.id_client IS NOT NULL
GROUP BY t1.id_client