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 ')
order by p.products_order,
' at line 26
select distinctrow p.products_id,
p.*,
pd.*,
m.restriction_zones,
m.restriction_allowed,
m.restriction_cart,
m.restriction_strict,
m.restriction_currency,
IF(p.products_hide_on_zero, IF(p.products_quantity > 0, 'TRUE', 'FALSE'), 'TRUE') as show_product,
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price,
IF(s.status, s.specials_new_products_price_us, NULL) as specials_new_products_price_us,
IF(s.status, s.specials_new_products_price, p.products_price) as final_price
from products p
left join products_description pd on p.products_id = pd.products_id
left join products_to_categories p2c on p.products_id = p2c.products_id
left join specials s on p.products_id = s.products_id
left join manufacturers m on m.manufacturers_id = p.manufacturers_id
where p.products_status = 1
and p.products_status_message != 'gift'
and p.products_status_message != 'discontinued'
and p.products_parent_id = 0
and p.products_id = pd.products_id
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
and p.products_favourites = 1
and p2c.categories_id in ()
order by p.products_order,
pd.products_name,
p.products_id
[TEP STOP]
|
Chat Support
