x
1
BEGIN
2
3
4
5
INSERT IGNORE INTO SubGroups (SELECT GroupID, c.ComputerID FROM SubGroupsContacts
6
JOIN MasterGroups m USING (GroupID)
7
JOIN Contacts ct USING (ContactID)
8
JOIN Computers c USING (ContactID)
9
WHERE m.ContactJoinOptions & 2 = 2);
10
11
12
INSERT IGNORE INTO SubGroups (SELECT GroupID, cc.ComputerID FROM SubGroupsContacts
13
JOIN MasterGroups m USING (GroupID)
14
JOIN Contacts ct USING (ContactID)
15
JOIN ContactComputers cc USING (ContactID)
16
WHERE m.ContactJoinOptions & 2 = 2);
17
18
19
CALL sp_AutoRemoveComputersMasterTrump();
20
END