· 4 years ago · Jan 20, 2021, 09:36 PM
1CREATE TEMPORARY TABLE IF NOT EXISTS tb2101
2ENGINE=MEMORY
3AS (
4SELECT DISTINCT p2.ID
5 FROM pay_schet AS p1
6 JOIN uslugatovar AS u ON u.ID = p1.IdUsluga AND u.IsCustom IN (12,16)
7 JOIN pay_schet AS p2 ON p2.DateCreate > 1611100800 AND p2.CardNum = p1.CardNum AND p2.SummPay = p1.SummPay AND p2.DateCreate > p1.DateCreate AND p2.ID <> p1.ID
8 WHERE p1.DateCreate > 1611100800
9 );
10
11UPDATE pay_schet SET GisjkhGuid = '2101' WHERE ID IN (SELECT ID FROM tb2101);
12DROP TABLE tb2101;