SELECT pobs.nombre as poblacion, ROUND((precio_pack((IF(oferta>0 AND oferta_hasta>=CURDATE() AND oferta0 AND oferta_hasta>=CURDATE() AND oferta0,1,0)) as ofertado, SUM(IF(prods_pre.carrito,1,0)) as cuantos, prods_pre.cod as codpre, foto(prods.cod) as pic, prods_pre.nombre as referencia FROM prods LEFT JOIN prods_pre ON prods_pre.cod_prod=prods.cod LEFT JOIN emp ON prods.cod_emp=emp.cod LEFT JOIN pobs ON emp.cod_pob=pobs.cod LEFT JOIN prods_fam ON prods_fam.cod_prod=prods.cod WHERE en_tienda AND prods_pre.precio >'0' AND prods.enabled AND prods_pre.cheap = '1' AND emp.cod IN (216) AND prods_fam.cod_familia=1033 GROUP BY prods.cod ORDER BY orden