Re: Very slow query, help please

[Jaume Roca]

Thank you for your suggestions I didn't know new mysql version features, but I think that I have the solution:

select id_prov_treb, tipus_prov_treb, nom, ROUND(coalesce(materials,0)+coalesce(stock,0),2) as fac from proveidors_treballadors
left join (select id_prov_treb, tipus_prov_treb,
ROUND(sum(quantitat*multiplicatiu),2) as materials
from albarans
inner join comandes_albarans_families using (id_albara)
where tipus_prov_treb = 'proveidor' group by id_prov_treb, tipus_prov_treb)
T1 using (id_prov_treb, tipus_prov_treb)
left join (select id_prov_treb, tipus_prov_treb,
ROUND(sum(quantitat*multiplicatiu),2) as stock
from albarans
inner join albarans_families using (id_albara)
where tipus_prov_treb = 'proveidor' group by id_prov_treb, tipus_prov_treb)
T2 using (id_prov_treb, tipus_prov_treb)
where tipus_prov_treb = 'proveidor'

0.0463 seg, Is great :)

What do you think for this query?

Thank you so much.

Regards!