1064: SELECT p.id,p.title,p.alt2,p.cprice,p.thumb,p.short,p.price,pc.category as cattitle,c.title as pcname
FROM products p INNER JOIN product_prices pp ON p.id=pp.product_id
LEFT JOIN productcategories pc ON p.category=pc.id
LEFT JOIN category c ON p.pc=c.id
WHERE p.price * 4.95 >= AND p.price * 4.95 <=99999999 AND p.pc=1 and pp.country_id=5072
group by p.id ORDER BY p.id DESC LIMIT 4
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.price * 4.95 <=99999999 AND p.pc=1 and pp.country_id=5072
group by p.id ' at line 5