Error message: 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 `p`.`weight` DESC, FIELD(p.supplier,'M','H','S') ASC' at line 8


SELECT SQL_CALC_FOUND_ROWS `p`.*, `c`.`slug` AS `category_slug`, `c`.`id` AS `cid`, `c`.`title` AS `category_title`
FROM `products` AS `p` 
LEFT JOIN `categories` AS `c` ON `c`.`id` = `p`.`category_id` 

 WHERE  (`p`.`active` = 1) 
AND (`c`.`active` = 1) 
AND (`p`.`price` >= 0) 
AND (`c`.`slug`  """") 

 ORDER BY `p`.`weight` DESC, FIELD(p.supplier,'M','H','S') ASC