update content 
set param_b1 = 0,param_b2 = 1, param_i1 = 2

WHERE id IN (
   SELECT * FROM (       
SELECT category.id  FROM category
left join content
on content.id = category.content_id
WHERE category.id = 6

    ) AS p
)

DELETE FROM material_machine WHERE id IN (
   SELECT * FROM (       
SELECT material_machine.id  FROM material_machine
left join material
on material.id = material_machine.material_id
WHERE material.id is null

    ) AS p
)