Ungültiges Kommando: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO tmpCollection ( PType, PId, PIds ) SELECT DISTINCT CONVERT('pvf' USING UCS2) AS T, U.P, U.PI FROM ( SELECT 81 AS P, PersonRelations.PId1 AS PI FROM (PersonRelations INNER JOIN tmpCollection ON PersonRelations.PId2 = tmpCollection.PIds) LEFT JOIN (SELECT tmpCollection.PIds FROM tmpCollection WHERE tmpCollection.PId=81 AND tmpCollection.PType= CONVERT('pvf' USING UCS2) ) AS tmp ON PersonRelations.PId1 = tmp.PIds WHERE PersonRelations.RelationType=1 AND tmpCollection.PId=81 AND tmpCollection.PType= CONVERT('pvf' USING UCS2) AND tmp.PIds Is Null ) AS U Franz Girsule1841 - 1922Jansdorf 81Anna Girsule, geb.Kral1849 - 1909Jansdorf 130, 81Barbara Kinzl, geb.Girsule1880 - 1940Jansdorf 81Alois Girsule1905 - 1944Boulogne, Jansdorf81