MySQL error:
SELECT
*,
UNIX_TIMESTAMP(`date`) AS `date`
FROM `tournament`
WHERE
`id` = join
AND`status` = 'archived'
AND `in_portfolio` = 1
ORDER BY `date` DESC
1064
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 'join
AND`status` = 'archived'
AND `in_portfolio` = 1
ORDER BY `date` DESC' at line 6