Error:
Regex error 'POSIX named classes are supported only within a class at offset 21'
SELECT P.*, IF(P.dealPrice>0, P.dealPrice, P.retailPrice) AS price, IF (P.quantity>0,1,0) as quanlevel,
D.distillery as prod_distillery, PA.age as prod_age, R.region as prod_region
FROM products AS P INNER JOIN product_categories PC ON (PC.productID=P.productID)
INNER JOIN categories C ON (C.categoryID=PC.categoryID)
LEFT JOIN distillery AS D ON (D.id=P.distilleryID)
LEFT JOIN product_age AS PA ON (PA.id=P.age)
LEFT JOIN regions AS R ON (R.regionID=P.regionID)
WHERE P.status > 0 AND P.productTitle REGEXP '[[:<:]]Wild Turkey \\[[:>:]]' GROUP BY P.productID ORDER by quanlevel DESC, IF(P.image1='',0,1) DESC, P.last_modified DESC, P.productID DESC