SELECT pobs.nombre as poblacion, ROUND((precio_pack((IF(oferta>0 AND oferta_hasta>=CURDATE() AND oferta
0 AND oferta_hasta>=CURDATE() AND oferta0,1,0)) as ofertado, SUM(IF(prods_pre.carrito,1,0)) as cuantos, prods_pre.cod as codpre, IF(prods_fotos.foto<>'',prods_fotos.foto,pf.foto) AS pic, IF(prods_fotos.foto<>'',prods_fotos.nombre_en,pf.nombre_en) AS nompic, prods_pre.nombre as referencia, prods_pre.min, prods_pre.stock, prods_pre.carrito, prods_pre.texto as nota 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 LEFT JOIN prods_fotos ON prods_fotos.cod=prods_pre.cod_foto LEFT JOIN prods_fotos pf ON pf.cod_prod=prods.cod WHERE en_tienda AND prods_pre.precio >'0' AND prods.enabled AND prods_pre.cheap = '1' AND emp.cod IN (691) AND prods_fam.cod_familia=83669 GROUP BY prods.cod ORDER BY prods.cod DESC
