Promazání menuitemů
SET @id := '5';
DELETE T1, T2, T3, T4, T5
FROM menu_item TM
LEFT JOIN menu_item_x_file T1 ON T1.menu_item_id = TM.id
LEFT JOIN menu_item_x_gallery T2 ON T2.menu_item_id = TM.id
LEFT JOIN menu_item_x_menu_item T3 ON T3.menu_item_id = TM.id
LEFT JOIN menu_item_x_product T4 ON T4.menu_item_id = TM.id
LEFT JOIN menu_item_x_supplement T5 ON T5.menu_item_id = TM.id
WHERE TM.id > @id;
DELETE TM
FROM menu_item_x_menu_item TM
WHERE TM.id > @id;
DELETE TM
FROM menu_item TM
WHERE TM.id > @id;