Couldn't execute query. SQL - SELECT *, MATCH (code, suppliername, name) AGAINST ('' IN BOOLEAN MODE) AS searchscore FROM catalogproduct WHERE active = 1 AND MATCH (code, suppliername, name) AGAINST ('' IN BOOLEAN MODE) ORDER BY searchscore, categoryid, displayorder