USE testdatenbank;
 
CREATE TEMPORARY TABLE temp_tabelle(
    id INT PRIMARY KEY
);

INSERT INTO temp_tabelle
SELECT id
        FROM test_tabelle_1
        WHERE (startDate < '2021-01-29 00:00:00' OR startDate IS NULL)
        AND state IN ('successful','error')
        AND kategorie IN (73,4,5,6,10,125,126,75,41,59,60,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,123,124,128,134,135);
;
 
START TRANSACTION;
        DELETE FROM test_tabelle_1 WHERE id IN (SELECT id FROM temp_tabelle);
        DELETE FROM test_tabelle_2 WHERE id IN (SELECT id FROM temp_tabelle);
COMMIT;