UPDATE
incomes_items AS ii
JOIN incomes_attributes AS ia ON ia.incomes_attributes_id = ii.incomes_attributes_id
JOIN statuses AS s ON s.statuses_id = ii.incomes_items_status

SET ii.incomes_items_status = 125
, ii.incomes_items_sub_status = 158

WHERE ia.incomes_id = 7278
;

UPDATE

incomes_attributes AS ia


SET ia.incomes_attributes_status = 7 -- Неактивно (ассортимент)

WHERE ia.incomes_id = 7278;


INSERT INTO marking_shelves_to_objects (marking_shelves_id, object_id, entities_id, customers_id)

SELECT

4152 AS marking_shelves_id -- Ц. 2.6.2
, ii.incomes_items_id AS object_id
, 69 as entities_id
, 1 AS customers_id


FROM
 incomes_items AS ii
JOIN incomes_attributes AS ia ON ia.incomes_attributes_id = ii.incomes_attributes_id

WHERE ia.incomes_id = 7278;