/* esta consulta me esta devolviendo vacio */

--Query para obtener la informacion diaria del proceso de engorde

SELECT DATE(DATE_ADD(c.date, INTERVAL f.day DAY)) AS production_date,
       IFNULL(SUM(cs.quantity), 0) supply_consumption, s.unit supply_units,
       IFNULL(SUM(f.mortality), 0) mortality,
       IFNULL(SUM(f.weight), 0) weight
FROM   fattens f
JOIN   entercalls c ON c.id = f.call_id
JOIN   consumes cs ON cs.stage_id = f.id AND cs.stage_type = 'F'
JOIN   supplies s ON s.id = cs.supply_id
WHERE  c.farm_id = 7
AND    s.code IN ('8', '9', '10', '11')
GROUP BY DATE(DATE_ADD(c.date, INTERVAL f.day DAY)), s.unit;