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 'AND websiteID = 2 THEN 0 ELSE 1 END AS type, (SELECT COU...' at line 5