SELECT p.products_id, p.serie_completed, pd.products_name, p.products_cust_genre, p.products_cust_zone, p.products_cust_type, p.products_cust_lng, pd.products_cust_col, pd.products_cust_misc, p.products_cust_aut, p.products_quantity, p.products_image, p.products_cust_publicprice, p.products_cust_discount, p.products_price, p.products_date_available, p.products_outstock, p.products_cust_delivery, p.products_cust_quality, p.products_tax_class_id, p.products_cust_vol, p.products_cust_serie, p2c.categories_id, ma.manufacturers_name FROM products_description pd, products_to_categories p2c, products p LEFT JOIN manufacturers ma ON ma.manufacturers_id = p.manufacturers_id WHERE p.products_id = p2c.products_id AND p.products_id = pd.products_id AND p2c.categories_status = 1 AND ( p2c.showoccaz = 0 OR (p.products_outstock!= 0 AND p.products_quantity >0) OR p.products_outstock=0) AND pd.language_id = '4' AND p.products_status = 1 AND p.products_cust_isserie = 0 AND p.products_cust_serie = '34' AND p.products_date_available <= '2008-11-19' AND p2c.categories_id = '1' ORDER BY p.products_cust_vol DESC