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