A Database Error Occurred

Error Number: 1064

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 'rows FROM products as P WHERE P.pid!='' and P.isShow=1 and ( P.product_categ...' at line 1

SELECT COUNT(P.pid) as rows FROM products as P WHERE P.pid!='' and P.isShow=1 and ( P.product_category REGEXP "[[:<:]]44[[:>:]]" ) and ( P.color LIKE "%F5F5DC%" or P.color LIKE "%FFA500%" ) and ( P.size REGEXP "[[:<:]]13[[:>:]]" or P.size REGEXP "[[:<:]]2.4[[:>:]]" )

Filename: modules/front/models/Front_model.php

Line Number: 108