[query: select p.product_id, IF (p.oldprice >0, round(100 - (p.price / p.oldprice*100)), 0) AS oldp
from product p
join category on category.category_id=p.category_id
left join vendor on vendor.vendor_id=p.vendor_id
where p.visible=1 and p.price>0 100
error: 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 '100' at line 5
in file: /home/u16723/texnoff.com/www/inc/auto/product.inc at line: 515]
[query: select p.*, vendor.title vendor, unix_timestamp(p.add_date) add_date_uts, navy_tag, category.product_prefix, IF (p.oldprice >0, round(100 - (p.price / p.oldprice*100)), 0) AS oldp
from product p
join category on category.category_id=p.category_id
left join vendor on vendor.vendor_id=p.vendor_id
where p.visible=1 and p.price>0 100
order by p.price
limit 0,24
error: 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 '100
order by p.price
limit 0,24' at line 5
in file: /home/u16723/texnoff.com/www/inc/auto/product.inc at line: 528]
+7 (343) 202-02-79
+7 (900) 211-02-49