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 '-9, 9' at line 21
select p.products_id, p.products_tax_class_id, p.products_image,
pd.products_name,
p2s.products_price,
s.specials_new_products_price,
((p2s.products_price - s.specials_new_products_price) / p2s.products_price) as products_difference
from products p,
products_description pd,
products_to_shops p2s,
specials s
where p2s.products_status = '1'
and p2s.shops_id = '1'
and s.status = '1'
and s.specials_new_products_price > 0
and s.specials_new_products_price < p2s.products_price
and pd.language_id = '1'
and p.products_id = p2s.products_id
and s.products_id = p.products_id
and s.shops_id = p2s.shops_id
and p.products_id = pd.products_id
group by p.products_model
order by products_difference, s.specials_date_added DESC limit -9, 9
[TEP STOP]
|
