gistfile1.txt

select sum(op.products_quantity) as quantity
 from orders o
 join orders_products op on o.orders_id = op.orders_id
 join products p on op.products_id = p.products_id
 join parts pa on p.products_id = pa.products_id
 where o.orders_status in (1,5)
 and pa.parts_id = xxxx;