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 '' at line 1
select distinct p.products_image, p.products_artist, m.manufacturers_name, f.format_name, products_date_back, p.products_id, m.manufacturers_id, p.producttype_id, p.products_id, pd.products_name, p.products_status, p.products_date_back, p.products_price, p.products_tax_class_id, p.style_id, p.products_date_added, st.style_id, p.format_id, cd.categories_name, f.format_id, if(s.status, s.specials_new_products_price, null) as specials_new_products_price, if(s.status, s.specials_new_products_price, p.products_price) as final_price , pt.track_one_url from products as p join manufacturers as m on m.manufacturers_id = p.manufacturers_id join style as st on st.style_id = p.style_id join format as f on f.format_id = p.format_id join products_description as pd on pd.products_id = p.products_id join products_to_categories as p2c on p2c.products_id = p.products_id join categories as c on c.categories_id = p2c.categories_id join categories_description as cd on cd.categories_id = c.categories_id left join products_tracklisting as pt on pt.products_id = p.products_id left join specials as s on s.products_id = p.products_id where pd.language_id = '1' and (p.products_status=1) and to_days(now()) - to_days(p.products_date_back) < '30' order by
[TEP STOP]
|
