|
Lakeshore Baseball General Information
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 \'OR (tj.standard_playground = AND m.playground_id IS NULL)
\n OR\' at line 7 SQL=SELECT m.*, p.name AS project_name
\n FROM jos_joomleague_matches AS m
\n INNER JOIN jos_joomleague AS p ON p.id=m.project_id
\n INNER JOIN jos_joomleague_team_joomleague tj ON tj.team_id = m.matchpart1
\n INNER JOIN jos_joomleague_teams t ON t.id = m.matchpart1
\n INNER JOIN jos_joomleague_clubs c ON c.id = t.club_id
\n WHERE (m.playground_id= OR (tj.standard_playground = AND m.playground_id IS NULL)
\n OR (c.standard_playground = AND m.playground_id IS NULL))
\n AND m.match_date > NOW()
\n AND m.published = 1
\n AND p.published = 1 GROUP BY m.match_id ORDER BY match_date ASC
|
 |
|