Welcome Guest!

If you are already a customer and have an account with us, please login here.

Otherwise simply click on the following link to create a new account.
1054 - Unknown column 'c.parent_id' in 'where clause'

select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join (select * from (select products_id, specials_new_products_price, expires_date, status from specials where status = 1 order by products_id, specials_new_products_price, expires_date) as t group by products_id) as s on p.products_id = s.products_id, products_description pd, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and p.products_id = p2c.products_id and c.parent_id = '21' and pd.language_id = '1' and (not (p2c.categories_id in (533,523,522,499,459,460,525,500,520,356,355,341,343,381,397,399,402,401,404,398,403,406,400,414,415,407,410,412,408,409,411,413,383,390,388,387,389,391,392,393,394,396,395,457,458,32,33,35,36,37,456,342,489))) group by p.products_id order by p.products_date_added desc limit 9