2 SQL-Abfragen kombinieren

[omata]

Neuer Versuch...

SQL-Code:

SELECT c.id, c.itemname, a.alevel, a.itemname, Anzahl1, Anzahl2
FROM tblcats c
INNER JOIN tblaccesslevels a
  ON c.alevel = a.alevel
LEFT JOIN (SELECT parentcat, COUNT(*) AS anzahl1
           FROM tblsubcats
           WHERE alevel <= 1
           GROUP BY parentcat) s
  ON c.id = s.parentcat
LEFT JOIN (SELECT parentcat, COUNT(*) AS anzahl2
           FROM tblsubcats s
           INNER JOIN tblpics p
             ON s.id = p.parentsubcat
           WHERE alevel <= 1
           GROUP BY parentcat) p
  ON c.id = p.parentcat