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 228 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=228 AND tmpCollection.PType= CONVERT('pvf' USING UCS2) ) AS tmp ON PersonRelations.PId1 = tmp.PIds WHERE PersonRelations.RelationType=1 AND tmpCollection.PId=228 AND tmpCollection.PType= CONVERT('pvf' USING UCS2) AND tmp.PIds Is Null ) AS U Johanna Quietensky,geb. Girsule1809 - Jansdorf 41,Lauterbach 4Joannes Gyrsele1775 - 1852Jansdorf 24, 25, 41Johanna Girsule,geb. Taschner~1780 - Jansdorf 25, 41, 55Ignaz Girsule1835 - Jansdorf 41