SQL-Code:
SELECT * FROM phpbb_voc v LEFT JOIN (phpbb_voc_cat c JOIN phpbb_voc_rows r ON c.cat_id = r.cat_id)
ON r.cat_id = v.cat_id WHERE v.cat_id = c.cat_id AND r.row_id = v.voc_row AND c.cat_id = 2
Kann es sein, das das "v.cat_id = c.cat_id" hinter dem "WHERE" überflüssig ist?
SQL-Code:
SELECT * FROM phpbb_voc v LEFT JOIN (phpbb_voc_cat c JOIN phpbb_voc_rows r ON c.cat_id = r.cat_id)
ON r.cat_id = v.cat_id WHERE r.row_id = v.voc_row AND c.cat_id = 2
Aber, egal, Hauptsache, Du hast die Lösung
