Problem mit aufeinanderfolgenden OUTER JOINs in MySQL

[faux]

Hallo!

Danke für deine Antwort, aber leider geht es so auch nicht.

NACHTRAG:
Habs gelöst, weiß aber leider nicht genau wieso. Ich glaube es liegt am NATURAL JOIN:

SQL-Code:

SELECT sm.serie_id AS id, serie_title AS title, serie_image AS image, count(ci.serie_id) AS charguide,
   sm.author_id AS author, author_gender AS author_gender, count(sp.serie_id) AS story,
   count(ep.serie_id) AS epiguide, count(oi.serie_id) AS opening, count(ssp.serie_id) AS syncspeaker,
   count(di.serie_id) AS dvd, count(mp.serie_id) AS manga
FROM page_series_main sm
   LEFT OUTER JOIN page_author_pages ap
      ON (sm.author_id = ap.author_id AND author_visible != 0)
   LEFT OUTER JOIN page_charguide_items ci
      ON (sm.serie_id = ci.serie_id AND charguide_visible != 0)
   LEFT OUTER JOIN page_story_pages sp
      ON (sm.serie_id = sp.serie_id AND story_visible != 0)
   LEFT OUTER JOIN page_epiguide_pages ep
      ON (sm.serie_id = ep.serie_id AND epiguide_visible != 0)
   LEFT OUTER JOIN page_opening_items oi
      ON (sm.serie_id = oi.serie_id AND opening_visible != 0)
   LEFT OUTER JOIN page_syncspeaker_pages ssp
      ON (sm.serie_id = ssp.serie_id AND syncspeaker_visible != 0)
   LEFT OUTER JOIN page_dvd_items di
      ON (sm.serie_id = di.serie_id AND dvd_visible != 0)
   LEFT OUTER JOIN page_manga_pages mp
      ON (sm.serie_id = mp.serie_id AND manga_visible != 0)
WHERE sm.serie_id = 1
   AND serie_visible != 0
GROUP BY sm.serie_id
LIMIT 1

Also ich dachte der NATURAL JOIN verknüpft einfach alle in beiden Tabellen vorkommenden Felder, oder?! Dann ist das was ich jetzt geschrieben habe, doch genau das Selbe, oder?!

Grüße
Faux