SELECT au.auser_id, au.name, au.email, COUNT(eo.record_id) AS apps
FROM est_object eo
JOIN auser au ON eo.auser_id = au.auser_id
WHERE au.is_published = 1 AND au.is_profi_paket = 1 AND eo.is_published = 1 AND eo.is_import = 0
GROUP BY au.auser_id
ORDER BY apps DESC
limit 20