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 'and p.`products_price` <= 67.19 AND ((pd.products_name LIKE '%8%' ' at line 10
in:
[select count(distinct p.products_id) as total FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id and p.`products_price` >= and p.`products_price` <= 67.19 AND ((pd.products_name LIKE '%8%' OR p.products_model LIKE '%8%' ) and (pd.products_name LIKE '%inch%' OR p.products_model LIKE '%inch%' ) and (pd.products_name LIKE '%lcd%' OR p.products_model LIKE '%lcd%' ) and (pd.products_name LIKE '%digital%' OR p.products_model LIKE '%digital%' ) and (pd.products_name LIKE '%photo%' OR p.products_model LIKE '%photo%' ) and (pd.products_name LIKE '%frame%' OR p.products_model LIKE '%frame%' ) ))]