phpBB3 forum on Oracle DB

When you create a phpBB3 forum and use Oracle as the database host. make sure that you are using Oracle Database 10g or later as previous releases may cause unpredictable errors, i.e.:

SELECT a.*, b.*, ac.something…
FROM phpb3_forums a, phpb3_topics b…
LEFT JOIN phpb3_topics_watch ac ON …
WHERE a.topic_….

…will cause a ORA-00904: “A”: invalid identifier [904] as it seems it can not utilise both a.* and b.*