Nokia Lumia Smartphone

Unieke cameratechnologie, exclusieve Live Tiles en prachtige designfuncties. Nokia Lumia Powered by Windows Phone 8.
1054 - Unknown column 'p2s.series_id' in 'where clause'

SELECT p.products_id, p.products_quantity, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_price as products_regular_price, p.products_internet_price, p.products_price_going, p.products_price_street, p.products_price_street_uplift, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, p.products_weight, p.products_last_modified, p.products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, m.manufacturers_name, p.products_ordered, p.products_opt1, p.products_opt2, p.products_opt3, p.products_opt4, p.products_opt5, p.products_opt6, p.products_opt7, p.products_opt8, p.products_opt9, p.products_canshop, p.products_dropshipment, p.sticker_id, pd.products_name, pd.products_description, pd.products_viewed, pd.meta_title, pd.meta_description, p2c.categories_id, cd.categories_name, cd.categories_h1 FROM products p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN specials s ON (p.products_id = s.products_id AND s.status = 1 AND (s.expires_date IS NULL OR s.expires_date >= NOW())) LEFT JOIN manufacturers m ON m.manufacturers_id = p.manufacturers_id LEFT JOIN products_to_categories p2c ON p2c.products_id = p.products_id LEFT JOIN categories c ON c.categories_id = p2c.categories_id LEFT JOIN categories_description cd ON c.categories_id = cd.categories_id WHERE (p.products_status = '1' OR p.products_status = '2') AND pd.language_id = '1' AND cd.language_id = '1' AND p2s.series_id = '1' ORDER BY p.products_price DESC