Joomla! 1.0 - 'Experience the Freedom'!. It has never been easier to create
your own dynamic site. Manage all your content from the best CMS admin
interface.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'AS home_name,
\n t2. AS away_name,
\n c1. AS home_\' at line 6 SQL=SELECT m.match_date AS datum,
\n m.matchpart1 AS home,
\n m.matchpart2 AS away,
\n m.*,
\n r.matchcode, r.name as round,
\n t1. AS home_name,
\n t2. AS away_name,
\n c1. AS home_logo,
\n c2. AS away_logo,
\n j.name AS project_name FROM jos_joomleague_matches AS m
\n INNER JOIN jos_joomleague AS j ON m.project_id = j.id
\n INNER JOIN jos_joomleague_rounds AS r ON m.round_id = r.id
\n INNER JOIN jos_joomleague_teams AS t1 ON m.matchpart1 = t1.id
\n INNER JOIN jos_joomleague_teams AS t2 ON m.matchpart2 = t2.id
\n LEFT JOIN jos_joomleague_clubs AS c1 ON t1.club_id = c1.id
\n LEFT JOIN jos_joomleague_clubs AS c2 ON t2.club_id = c2.id WHERE m.project_id IN (0)
\n AND DATE_ADD(m.match_date, INTERVAL \'0\' MINUTE) > \'2010-09-04 19:00:09\' ORDER by m.match_date, datum