SELECT p.products_id, p.products_type, pd.products_name, p.products_image, min(f.pvp_eurowin) as products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status,if(f.regalo_eurowin>0 and f.desde_eurowin>0,1,0) as es_regalo, p.master_categories_id,m.manufacturers_image,p.products_referencia,p.products_refprov,componente,video,dimensiones,unidades_por_caja,capacidad,reference,relateds,rotura_stock,fecha_dispo,num_friends,products_ean,url_shop,ppf.ultimo_precio_cambio,p.impuesto,p.fecha_dispo as data_disp,p.cajas FROM bender_ofertas_eurowin f LEFT JOIN bender_products p ON (p.products_id = f.products_id and f.tarifa_eurowin='04' ) left join bender_products_to_categories c on (c.products_id=p.products_id) LEFT JOIN bender_manufacturers m on (p.manufacturers_id = m.manufacturers_id), bender_products_description pd WHERE p.products_status = 1 and (('2026-08-06' <= expires_date ) and ('2026-08-06' >= specials_date_available)) and p.products_id = f.products_id and f.status = 1 and (f.pvp_eurowin>0 or f.descuento_eurowin<>0) AND p.products_id = pd.products_id and pd.language_id = 13 group by p.products_id