Error:

Regex error 'POSIX named classes are supported only within a class at offset 10'
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 '[[:<:]]L\\[[:>:]]' GROUP BY P.productID ORDER by quanlevel DESC, IF(P.image1='',0,1) DESC, P.last_modified DESC, P.productID DESC