Como puedo mejorar esta consulta
Código SQL:
Ver original
SELECT f.muluid, SUM(pd.zongshuliang) AS cantidad, SUM(pd.zongshuliang * pd.precio) AS total , f.name FROM pedidolist p INNER JOIN pedidomov pd ON p.pedidokey = pd.pedidokey INNER JOIN articulo a ON pd.codigo = a.codigo INNER JOIN familia f ON f.muluid = a.muluid WHERE p.fecha_c BETWEEN '2016-04-12' AND DATE_ADD( '2016-04-12', INTERVAL 1 DAY) AND (a.muluid IS NOT NULL AND a.muluid != '' AND a.muluid != '0') GROUP BY f.muluid, f.name ORDER BY f.muluid
por que tarda mucho
Saludos