DataBase Query to verify quantitys

hello , i am looking to fix a query to verify some stock accounts those 4 to 5 tables some sums to check if the stock is right must compare the current stock vrs the sum of initial+adjuments stock and if is wrong update with the right value. SELECT [login to view URL],[login to view URL] as cantidadInv,sum([login to view URL]) as compraSt , sum([login to view URL]) as vendido, SUM(IF([login to view URL] = 'addition', [login to view URL], 0))-SUM(IF([login to view URL] = 'subtraction', [login to view URL], 0))+sum([login to view URL]) as ajustes FROM `sma_purchase_items` compra inner join sma_products productos on [login to view URL] = compra.product_id left join sma_sale_items vendidos on [login to view URL] = vendidos.product_id left join sma_adjustment_items ajustes on vendidos.product_id = ajustes.product_id group by [login to view URL] this is mostly the query must be fixed due in some rows shows another information. if need i can share the db and explain via teamviewer or similar