Error in query: SELECT `ID`, (TO_DAYS(NOW())-TO_DAYS(`Date`)) AS `Diff` FROM `games` WHERE `CompID` IN (1087) AND `Status` NOT IN ('/', '!', '-', '0', '1', '2', '3', '4', '5', '6', '7','8', '9', '#') AND ((`TeamA` IN (472)) OR (`TeamB` IN (472) OR (`TeamC` IN (472))) ORDER BY `Date` ASC, `Nr`, `Location`, `TeamA`
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `Date` ASC, `Nr`, `Location`, `TeamA`' at line 1
Tracing information:
File: /var/www/vhosts/nijb.nl/httpdocs/result.ajax.php Line: 70 Function: kompsos_query(0=SELECT `ID`, (TO_DAYS(NOW())-TO_DAYS(`Date`)) AS `Diff` FROM `games` WHERE `CompID` IN (1087) AND `Status` NOT IN ('/', '!', '-', '0', '1', '2', '3', '4', '5', '6', '7','8', '9', '#') AND ((`TeamA` IN (472)) OR (`TeamB` IN (472) OR (`TeamC` IN (472))) ORDER BY `Date` ASC, `Nr`, `Location`, `TeamA`;)
File: /var/www/vhosts/nijb.nl/httpdocs/result.ajax.php Line: 223 Function: showResults(0=Array;1=472;)
User: Unknown (not logged in)
Host:
Addr: 77.74.50.11
The page you asked for generated an error and cannot be displayed. This error has been reported to the system-administrator and will in general be corrected within 24 hours.