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 93 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=93 AND tmpCollection.PType= CONVERT('pvf' USING UCS2) ) AS tmp ON PersonRelations.PId1 = tmp.PIds WHERE PersonRelations.RelationType=1 AND tmpCollection.PId=93 AND tmpCollection.PType= CONVERT('pvf' USING UCS2) AND tmp.PIds Is Null ) AS U
1818: Geburt in Jansdorf 50
1850 Jansdorf 50 (Franz Kinzel)
Wenzel Kinzel 1790 (Vater)
Katharina Kinzel ca. 1790 (Mutter)
Anna Girsule 1815 (Schwester)
Johann Kinzel 1820 (Bruder)
Anton Kinzel 1828 (Bruder)
Josef Kinzel 1848 (Bruder)