1:
2:
3:
4:
5:

mysql_query("SELECT id, pferdename, 
(SELECT count(id) FROM pferde WHERE hengst=p.id GROUP BY hengst) AS gedeckte, 
(SELECT count(id) FROM fohlen WHERE vid=p.id GROUP BY vid) AS fohlen, 
(SELECT count(vid) FROM pferdeABST WHERE vid=p.id GROUP BY vid) AS ausgew 
FROM pferde p WHERE geschl='Hengst' ORDER BY gedeckte+fohlen+ausgew DESC LIMIT 10") OR DIE(mysql_error());