SELECT ad.spec_id, ad.size_id, ad.height_id,
(IFNULL(SUM(ad.qty),0)+IFNULL(b.move_qty,0)) as qty, SUM(ad.qty) as
arrival_qty, b.move_qty as movement_qty, a.warehouse_id FROM arrival_data ad
LEFT JOIN arrivals a
 ON ad.arrival_id = a.arrival_id
LEFT JOIN (SELECT SUM(m.qty) as move_qty, m.size_id, m.height_id,
m.spec_id, mb.receiver FROM movement_data m, movements mb
WHERE mb.movement_id = m.movement_id GROUP BY m.size_id, m.height_id, m.spec_id,
mb.receiver) b
ON ad.size_id= b.size_id
    AND ad.height_id = b.height_id
    AND ad.spec_id = b.spec_id
    AND b.receiver = a.warehouse_id

GROUP BY ad.spec_id, ad.size_id, ad.height_id, a.warehouse_id