wrong join statement in Database drivers

[Steffen]

The generated statement is something like "JOIN (article_authors) ON ( article_authors . author_id = authors . id )" which results in an SQLite error cause ist can't find "article_authors . author_id".

Patch proposal:

--- Pdosqlite.php
+++ (clipboard)
@@ -149,7 +149,7 @@
 
 		if (count($database['join']) > 0)
 		{
-			$sql .= ' '.$database['join']['type'].'JOIN ('.implode(', ', $database['join']['tables']).') ON '.implode(' AND ', $database['join']['conditions']);
+			$sql .= ' '.$database['join']['type'].'JOIN '.implode(', ', $database['join']['tables']).' ON '.implode(' AND ', $database['join']['conditions']);
 		}
 
 		if (count($database['where']) > 0)

[Shadowhand]

Fixed in r3622, merged in r3623.