Error Message:
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's[[:>:]].*[[:<:]]champ[[:>:]]' OR I.description RLIKE '[[:<:]]people's[[:>:]].*[' at line 1
SQL:
SELECT DISTINCT(I.productId), I.*, I.name AS SearchScore FROM cube_CubeCart_inventory AS I, cube_CubeCart_category AS C WHERE (I.name RLIKE '[[:<:]]people's[[:>:]].*[[:<:]]champ[[:>:]]' OR I.description RLIKE '[[:<:]]people's[[:>:]].*[[:<:]]champ[[:>:]]' OR I.productCode RLIKE '[[:<:]]people's[[:>:]].*[[:<:]]champ[[:>:]]') AND C.cat_id > 0 AND C.cat_id = I.cat_id AND C.hide = '0' AND (C.cat_desc != '##HIDDEN##' OR C.cat_desc IS NULL) AND I.disabled = '0' ORDER BY `date_added` DESC, `name` ASC