Ungültiges Kommando: MySQL server has gone away: INSERT INTO UrlLogger (URL, Robot) VALUES ( CONVERT('/php2/index.php?pnfid=658' USING UCS2) ,0)Ungültige Abfrage: MySQL server has gone away: SELECT UserAgents.* FROM UserAgents WHERE UserAgents.UserAgent= CONVERT('claudebot' USING UCS2) AND UserAgents.AsCrawler=0 AND UserAgents.AsPda=0;Ungültiges Kommando: MySQL server has gone away: INSERT INTO UserAgents (UserAgent, AsCrawler, AsPda ) VALUES ( CONVERT('claudebot' USING UCS2) , 0, 0);Ungültige Abfrage: MySQL server has gone away: SELECT IdId,IdName FROM IdNames; Ungültige Abfrage: MySQL server has gone away: SELECT PageCalls.* FROM PageCalls WHERE PageCalls.QueryString= CONVERT('pnfid=658' USING UCS2) AND PageCalls.AsCrawler=0 AND PageCalls.AsPda=0 AND PageCalls.AsUser=0 AND PageCalls.AsAdmin=0;Ungültiges Kommando: MySQL server has gone away: INSERT INTO PageCalls (QueryString, AsCrawler, AsPda, AsUser, AsAdmin ) VALUES ( CONVERT('pnfid=658' USING UCS2) , 0, 0, 0, 0);Ungültige Abfrage: MySQL server has gone away:
SELECT CASE WHEN Person.Alive=0 THEN CASE WHEN Person.needsSeeLiving<>0 THEN CONVERT('durch Rechte Dritter geschĂĽtzte Person' USING UCS2) ELSE CASE WHEN Person.needsUser<>0 THEN CONVERT('durch Rechte Dritter geschĂĽtzte Person' USING UCS2) ELSE E.FullName END END ELSE CONVERT('verborgene Person' USING UCS2) END AS FullName
FROM (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person
INNER JOIN (SELECT P.PId, CONCAT(CASE WHEN VT1.PId Is Null THEN '' ELSE CONCAT(VT1.Name, CONVERT(' ' USING UCS2) ) END ,CASE WHEN VT2.PId Is Null THEN '' ELSE CONCAT(VT2.Name, CONVERT(' ' USING UCS2) ) END ,CASE WHEN AT1.PId Is Null THEN '' ELSE CONCAT(AT1.Name, CONVERT(' ' USING UCS2) ) END ,CASE WHEN AT2.PId Is Null THEN '' ELSE CONCAT(AT2.Name, CONVERT(' ' USING UCS2) ) END ,CASE WHEN VN1.PId Is Null THEN '' ELSE CONCAT(VN1.Name, CONVERT(' ' USING UCS2) ) END ,CASE WHEN VN2.PId Is Null THEN '' ELSE CONCAT(VN2.Name, CONVERT(' ' USING UCS2) ) END ,CASE WHEN NN.PId Is Null THEN '' ELSE NN.Name END ,CASE WHEN AN1.PId Is Null THEN '' ELSE CONCAT( CONVERT(', ' USING UCS2) ,AN1.Name) END ,CASE WHEN AN2.PId Is Null THEN '' ELSE CONCAT( CONVERT(' ' USING UCS2) ,AN2.Name) END ,CASE WHEN GN.PId Is Null THEN '' ELSE CONCAT( CONVERT(', geb. ' USING UCS2) ,GN.Name) END ,CASE WHEN WN.PId Is Null THEN '' ELSE CONCAT( CONVERT(', verw. ' USING UCS2) ,WN.Name) END ) AS FullName FROM (((((((((((Person AS P LEFT JOIN (SELECT PN.PId, N.Name FROM (PersonNames AS PN INNER JOIN Names AS N ON PN.NId = N.NId) INNER JOIN NameTypes AS NT ON PN.NameType = NT.NTId WHERE NT.NameTypeOrder=1 AND PN.NameOrder=1 AND PN.AliasOrder=1) AS VT1 ON P.PId=VT1.PId) LEFT JOIN (SELECT PN.PId, N.Name FROM (PersonNames AS PN INNER JOIN Names AS N ON PN.NId = N.NId) INNER JOIN NameTypes AS NT ON PN.NameType = NT.NTId WHERE NT.NameTypeOrder=1 AND PN.NameOrder=2 AND PN.AliasOrder=1) AS VT2 ON P.PId=VT2.PId) LEFT JOIN (SELECT PN.PId, N.Name FROM (PersonNames AS PN INNER JOIN Names AS N ON PN.NId = N.NId) INNER JOIN NameTypes AS NT ON PN.NameType = NT.NTId WHERE NT.NameTypeOrder=2 AND PN.NameOrder=1 AND PN.AliasOrder=1) AS AT1 ON P.PId=AT1.PId) LEFT JOIN (SELECT PN.PId, N.Name FROM (PersonNames AS PN INNER JOIN Names AS N ON PN.NId = N.NId) INNER JOIN NameTypes AS NT ON PN.NameType = NT.NTId WHERE NT.NameTypeOrder=2 AND PN.NameOrder=2 AND PN.AliasOrder=1) AS AT2 ON P.PId=AT2.PId) LEFT JOIN (SELECT PN.PId, N.Name FROM (PersonNames AS PN INNER JOIN Names AS N ON PN.NId = N.NId) INNER JOIN NameTypes AS NT ON PN.NameType = NT.NTId WHERE NT.NameTypeOrder=3 AND PN.NameOrder=1 AND PN.AliasOrder=1) AS VN1 ON P.PId=VN1.PId) LEFT JOIN (SELECT PN.PId, N.Name FROM (PersonNames AS PN INNER JOIN Names AS N ON PN.NId = N.NId) INNER JOIN NameTypes AS NT ON PN.NameType = NT.NTId WHERE NT.NameTypeOrder=3 AND PN.NameOrder=2 AND PN.AliasOrder=1) AS VN2 ON P.PId=VN2.PId) LEFT JOIN (SELECT PN.PId, N.Name FROM (PersonNames AS PN INNER JOIN Names AS N ON PN.NId = N.NId) INNER JOIN NameTypes AS NT ON PN.NameType = NT.NTId WHERE NT.NameTypeOrder=4 AND PN.NameOrder=1 AND PN.AliasOrder=1) AS NN ON P.PId=NN.PId) LEFT JOIN (SELECT PN.PId, N.Name FROM (PersonNames AS PN INNER JOIN Names AS N ON PN.NId = N.NId) INNER JOIN NameTypes AS NT ON PN.NameType = NT.NTId WHERE NT.NameTypeOrder=5 AND PN.NameOrder=1 AND PN.AliasOrder=1) AS AN1 ON P.PId=AN1.PId) LEFT JOIN (SELECT PN.PId, N.Name FROM (PersonNames AS PN INNER JOIN Names AS N ON PN.NId = N.NId) INNER JOIN NameTypes AS NT ON PN.NameType = NT.NTId WHERE NT.NameTypeOrder=5 AND PN.NameOrder=2 AND PN.AliasOrder=1) AS AN2 ON P.PId=AN2.PId) LEFT JOIN (SELECT PN.PId, N.Name FROM (PersonNames AS PN INNER JOIN Names AS N ON PN.NId = N.NId) INNER JOIN NameTypes AS NT ON PN.NameType = NT.NTId WHERE NT.NameTypeOrder=6 AND PN.NameOrder=1 AND PN.AliasOrder=1) AS GN ON P.PId=GN.PId) LEFT JOIN (SELECT PN.PId, N.Name FROM (PersonNames AS PN INNER JOIN Names AS N ON PN.NId = N.NId) INNER JOIN NameTypes AS NT ON PN.NameType = NT.NTId WHERE NT.NameTypeOrder=7 AND PN.NameOrder=1 AND PN.AliasOrder=1) AS WN ON P.PId=WN.PId) ) AS E ON Person.PId = E.PId
WHERE Person.PId = 658Ungültige Abfrage: MySQL server has gone away:
SELECT CONVERT('nid' USING UCS2) AS IdName, N.NId, N.Name
FROM (((Names AS N
INNER JOIN PersonNames AS PN ON N.NId = PN.NId)
INNER JOIN NameTypes AS NT ON PN.NameType = NT.NTId)
INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person ON PN.PId = Person.PId)
WHERE PN.PId = 658 AND ((Person.Entry=-1) AND (Person.Alive=0) AND (Person.needsSeeLiving=0) AND (Person.needsUser=0) )
ORDER BY NT.NameTypeOrder, PN.NameOrder, PN.AliasOrderUngültige Abfrage: MySQL server has gone away: SELECT PIC.PicName, PIC.Year, PIC.Copyright, PIC.OtherRight, PIC.NeedsUser, PIC.NeedsSeeLiving, PIC.PicId FROM (SELECT P.PId, P.PicId, P.PicName, P.Year, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END AS NeedsSeeLiving FROM ( (SELECT PTI.ItemId AS PId, P.PicId, P.PicName, P.Year FROM Pictures AS P INNER JOIN PicturesToItems AS PTI ON P.PicId = PTI.PicId WHERE PTI.ItemIdId = ) AS P LEFT JOIN (SELECT RTI.ItemId AS PicId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PicId = PRC.PicId) LEFT JOIN (SELECT RTI.ItemId AS PicId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PicId = PRO.PicId ) AS PIC WHERE PIC.PId = 658 ; Ungültige Abfrage: MySQL server has gone away: SELECT DISTINCT D.DId, D.Year, D.Month, D.Day, PDL.Approx, DT.DateType, '' AS PId, '' AS SearchName, L.LId, L.LocationName FROM (((PersonDatesLocations AS PDL LEFT JOIN Dates AS D ON PDL.DId = D.DId) LEFT JOIN DateTypes AS DT ON PDL.DateType = DT.DTId) LEFT JOIN Locations AS L ON PDL.LId = L.LId) INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person ON PDL.PId = Person.PId WHERE PDL.PId=658 AND ((Person.Entry=-1) AND (Person.Alive=0) AND (Person.needsSeeLiving=0) AND (Person.needsUser=0) ) ORDER BY D.Year, D.Month, D.Day; Ungültige Abfrage: MySQL server has gone away: SELECT DISTINCT SD.QId, SD.Description, SD.DocYear, PSN.NId, PSN.Name, PSN.NameTypeOrder, PSN.NameOrder FROM (PersonSourceDoc AS PSD INNER JOIN (SELECT SD.* FROM (SELECT SD.*, CASE WHEN SDRC.Copyright Is Null THEN '' ELSE SDRC.Copyright END AS Copyright, CASE WHEN SDRO.OtherRight Is Null THEN '' ELSE SDRO.OtherRight END AS OtherRight, CASE WHEN SDRO.NeedsUser Is Null THEN 0 ELSE SDRO.NeedsUser END AS NeedsUser, CASE WHEN SDRO.NeedsSeeLiving Is Null THEN 0 ELSE SDRO.NeedsSeeLiving END AS NeedsSeeLiving FROM ( SourceDoc AS SD LEFT JOIN (SELECT RTI.ItemId AS QId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS SDRC ON SD.QId = SDRC.QId) LEFT JOIN (SELECT RTI.ItemId AS QId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS SDRO ON SD.QId = SDRO.QId ) AS SD LEFT JOIN ( SELECT PersonSourceDoc.QId FROM (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person INNER JOIN PersonSourceDoc ON Person.PId = PersonSourceDoc.PId WHERE Person.Alive<>0 OR Person.NeedsSeeLiving<>0 ) AS LP ON SD.QId = LP.QId WHERE (LP.QId IS NULL) AND (SD.needsSeeLiving=0) AND (SD.needsUser=0) ) AS SD ON PSD.QId = SD.QId) LEFT JOIN ( SELECT PersonSourceDoc.PId, SourceDoc.DocYear, PersonSourceDoc.QId, NameTypes.NameTypeOrder, PersonNames.NameOrder, Names.NId, Names.Name FROM ((((SourceDoc INNER JOIN PersonSourceDoc ON SourceDoc.QId = PersonSourceDoc.QId) INNER JOIN PersonNames ON PersonSourceDoc.PId = PersonNames.PId) INNER JOIN NameTypes ON PersonNames.NameType = NameTypes.NTId) INNER JOIN Names ON PersonNames.NId = Names.NId) INNER JOIN NameSourceDoc ON PersonSourceDoc.QId = NameSourceDoc.QId AND PersonNames.NId = NameSourceDoc.NId ) AS PSN ON PSD.QId = PSN.QId AND PSD.PId = PSN.PId WHERE PSD.PId = 658 ORDER BY SD.DocYear, SD.QId, PSN.NameTypeOrder, PSN.NameOrder; Ungültige Abfrage: MySQL server has gone away: SELECT B.PId, B.ItemText, B.IdName FROM ( SELECT DISTINCT Person.PId, CONCAT(Person.SearchName, CONVERT(' (' USING UCS2) ,A.Relation, CONVERT(')' USING UCS2) ) AS ItemText, CONVERT('pid' USING UCS2) AS IdName, MIN(C.Year) AS Year, MIN(C.Month) AS Month, MIN(C.Day) AS Day FROM (( (SELECT PersonRelations.PId2 AS PId, CASE WHEN Person_1.Gender=1 THEN CONVERT('Ehemann' USING UCS2) ELSE CASE WHEN Person_1.Gender=2 THEN CONVERT('Ehefrau' USING UCS2) ELSE CONVERT('Ehepartner' USING UCS2) END END AS Relation FROM (PersonRelations INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person ON PersonRelations.PId1 = Person.PId) INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person_1 ON PersonRelations.PId2 = Person_1.PId WHERE PersonRelations.RelationType=2 AND PersonRelations.PId1=658 ) UNION ALL ( SELECT PersonRelations.PId1 AS PId, CASE WHEN Person_1.Gender=1 THEN CONVERT('Vater' USING UCS2) ELSE CASE WHEN Person_1.Gender=2 THEN CONVERT('Mutter' USING UCS2) ELSE CONVERT('Elternteil' USING UCS2) END END AS Relation FROM (PersonRelations INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person ON PersonRelations.PId2 = Person.PId) INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person_1 ON PersonRelations.PId1 = Person_1.PId WHERE PersonRelations.RelationType=1 AND PersonRelations.PId2=658 ) UNION ALL ( SELECT PersonRelations.PId2 AS PId, CASE WHEN Person.Gender=1 THEN CONVERT('Sohn' USING UCS2) ELSE CASE WHEN Person.Gender=2 THEN CONVERT('Tochter' USING UCS2) ELSE CONVERT('Kind' USING UCS2) END END AS Relation FROM (PersonRelations INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person ON PersonRelations.PId2 = Person.PId) INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person_1 ON PersonRelations.PId1 = Person_1.PId WHERE PersonRelations.RelationType=1 AND PersonRelations.PId1=658 ) UNION ALL ( SELECT DISTINCT PersonRelations_1.PId2 AS PId, CASE WHEN Person_1.Gender=1 THEN CONVERT('Bruder' USING UCS2) ELSE CASE WHEN Person_1.Gender=2 THEN CONVERT('Schwester' USING UCS2) ELSE CONVERT('Geschwister' USING UCS2) END END AS Relation FROM (PersonRelations INNER JOIN ((SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person INNER JOIN PersonRelations AS PersonRelations_1 ON Person.PId = PersonRelations_1.PId1) ON PersonRelations.PId1 = Person.PId) INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person_1 ON PersonRelations_1.PId2 = Person_1.PId WHERE PersonRelations_1.PId2 <> PersonRelations.PId2 AND PersonRelations.RelationType=1 AND PersonRelations_1.RelationType=1 AND PersonRelations.PId2=658 )) AS A INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person ON A.PId = Person.PId) LEFT JOIN (SELECT PId, Year, Month, Day FROM PersonDatesLocations INNER JOIN Dates ON PersonDatesLocations.DId = Dates.DId ) AS C ON A.PId = C.PId WHERE ((Person.Entry=-1) AND (Person.Alive=0) AND (Person.needsSeeLiving=0) AND (Person.needsUser=0) ) GROUP BY Person.PId, CONCAT(Person.SearchName, CONVERT(' (' USING UCS2) ,A.Relation, CONVERT(')' USING UCS2) ), CONVERT('pid' USING UCS2) ) AS B ORDER BY B.Year, B.Month, B.Day;Ungültiges Kommando: MySQL server has gone away: INSERT INTO tmpCollection ( PType, PId, PIds ) VALUES ( CONVERT('pnf' USING UCS2) ,658,658);Ungültiges Kommando: MySQL server has gone away: INSERT INTO tmpCollection ( PType, PId, PIds ) SELECT DISTINCT CONVERT('pnf' USING UCS2) AS T, U.P, U.PI FROM ( SELECT 658 AS P, PersonRelations.PId2 AS PI FROM (PersonRelations INNER JOIN tmpCollection ON PersonRelations.PId1 = tmpCollection.PIds) LEFT JOIN (SELECT tmpCollection.PIds FROM tmpCollection WHERE tmpCollection.PId=658 AND tmpCollection.PType= CONVERT('pnf' USING UCS2) ) AS tmp ON PersonRelations.PId2 = tmp.PIds WHERE PersonRelations.RelationType=1 AND tmpCollection.PId=658 AND tmpCollection.PType= CONVERT('pnf' USING UCS2) AND tmp.PIds Is Null ) AS U Ungültige Abfrage: MySQL server has gone away: SELECT Count(tmpCollection.PIds) AS C FROM tmpCollection WHERE tmpCollection.PId=658 AND tmpCollection.PType= CONVERT('pnf' USING UCS2) Ungültiges Kommando: MySQL server has gone away: INSERT INTO tmpCollection ( PType, PId, PIds ) SELECT DISTINCT CONVERT('pnf' USING UCS2) AS T, U.P, U.PI FROM ( SELECT 658 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=658 AND tmpCollection.PType= CONVERT('pnf' USING UCS2) ) AS tmp ON PersonRelations.PId1 = tmp.PIds WHERE PersonRelations.RelationType=1 AND tmpCollection.PId=658 AND tmpCollection.PType= CONVERT('pnf' USING UCS2) AND tmp.PIds Is Null AND PersonRelations.PId2 <> 658 ) AS U Ungültige Abfrage: MySQL server has gone away: SELECT B.PId, B.ItemText, B.IdName FROM ( SELECT DISTINCT Person.PId, CASE WHEN Person.Alive=0 THEN CASE WHEN Person.needsSeeLiving<>0 THEN 'geschĂĽtzt' ELSE CASE WHEN Person.needsUser<>0 THEN 'geschĂĽtzt' ELSE CONCAT('','lall',' ',CASE WHEN C.Approx IS NULL THEN '' ELSE CASE WHEN C.Approx = 0 THEN '' ELSE '~' END END ,CASE WHEN C.Year Is NULL THEN '' ELSE C.Year END ,' - ',CASE WHEN D.Approx IS NULL THEN '' ELSE CASE WHEN D.Approx = 0 THEN '' ELSE '~' END END ,CASE WHEN D.Year Is NULL THEN '' ELSE D.Year END ) END END ELSE 'lebende Person' END AS ItemText, 'pid' AS IdName FROM (( ( SELECT Person.PId FROM (SELECT Person.PId FROM (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person INNER JOIN tmpCollection ON Person.PId = tmpCollection.PIds WHERE tmpCollection.PId=658 AND tmpCollection.PType='pnf' ) AS Person ) AS A INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person ON A.PId = Person.PId) LEFT JOIN (SELECT PId, Year, Approx FROM PersonDatesLocations INNER JOIN Dates ON PersonDatesLocations.DId = Dates.DId WHERE PersonDatesLocations.DateType = 1 ) AS C ON A.PId = C.PId) LEFT JOIN (SELECT PId, Year, Approx FROM PersonDatesLocations INNER JOIN Dates ON PersonDatesLocations.DId = Dates.DId WHERE PersonDatesLocations.DateType = 2 ) AS D ON A.PId = D.PId ) AS B ;Ungültige Abfrage: MySQL server has gone away: SELECT PId1, PId2 FROM ( SELECT A.PId1, A.PId2, MIN(C.Year) AS Year, MIN(C.Month) AS Month, MIN(C.Day) AS Day FROM (((PersonRelations AS A INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person ON A.PId2 = Person.PId) INNER JOIN (SELECT Person.PId FROM (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person INNER JOIN tmpCollection ON Person.PId = tmpCollection.PIds WHERE tmpCollection.PId=658 AND tmpCollection.PType= CONVERT('pnf' USING UCS2) ) AS Spouses1 ON A.PId1 = Spouses1.PId) INNER JOIN (SELECT Person.PId FROM (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person INNER JOIN tmpCollection ON Person.PId = tmpCollection.PIds WHERE tmpCollection.PId=658 AND tmpCollection.PType= CONVERT('pnf' USING UCS2) ) AS Spouses2 ON A.PId2 = Spouses2.PId) LEFT JOIN (SELECT PId, Year, Month, Day FROM PersonDatesLocations INNER JOIN Dates ON PersonDatesLocations.DId = Dates.DId WHERE PersonDatesLocations.DateType = 1 ) AS C ON Person.PId = C.PId WHERE A.RelationType=2 GROUP BY A.PId1, A.PId2 ) AS B ORDER BY B.Year, B.Month, B.Day;Ungültige Abfrage: MySQL server has gone away: SELECT PId1, PId2 FROM ( SELECT A.PId1, A.PId2, MIN(C.Year) AS Year, MIN(C.Month) AS Month, MIN(C.Day) AS Day FROM (((PersonRelations AS A INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person ON A.PId2 = Person.PId) INNER JOIN (SELECT Person.PId FROM (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person INNER JOIN tmpCollection ON Person.PId = tmpCollection.PIds WHERE tmpCollection.PId=658 AND tmpCollection.PType= CONVERT('pnf' USING UCS2) ) AS Parents ON A.PId1 = Parents.PId) INNER JOIN (SELECT Person.PId FROM (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person INNER JOIN tmpCollection ON Person.PId = tmpCollection.PIds WHERE tmpCollection.PId=658 AND tmpCollection.PType= CONVERT('pnf' USING UCS2) ) AS Children ON A.PId2 = Children.PId) LEFT JOIN (SELECT PId, Year, Month, Day FROM PersonDatesLocations INNER JOIN Dates ON PersonDatesLocations.DId = Dates.DId WHERE PersonDatesLocations.DateType = 1 ) AS C ON Person.PId = C.PId WHERE A.RelationType=1 GROUP BY A.PId1, A.PId2 ) AS B ORDER BY B.Year, B.Month, B.Day, B.PId1, B.PId2;Ungültiges Kommando: MySQL server has gone away: DELETE tmpCollection.* FROM tmpCollection WHERE tmpCollection.PId=658 AND tmpCollection.PType= CONVERT('pnf' USING UCS2) Ungültige Abfrage: MySQL server has gone away:
SELECT COUNT(Beg) AS C
FROM (SELECT DISTINCT Names.NId AS Beg
FROM (Names
INNER JOIN PersonNames ON Names.NId = PersonNames.NId)
INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person ON PersonNames.PId = Person.PId
WHERE
(PersonNames.NameType<6) AND
((Person.Entry=-1) AND (Person.Alive=0) AND (Person.needsSeeLiving=0) AND (Person.needsUser=0) )
) AS A;Ungültige Abfrage: MySQL server has gone away:
SELECT DISTINCT Names.NId, Name, CONVERT('nid' USING UCS2) AS idName
FROM (Names
INNER JOIN PersonNames ON Names.NId = PersonNames.NId)
INNER JOIN (SELECT P.*, CASE WHEN PRC.Copyright Is Null THEN '' ELSE PRC.Copyright END AS Copyright, CASE WHEN PRO.OtherRight Is Null THEN '' ELSE PRO.OtherRight END AS OtherRight, CASE WHEN PRO.NeedsUser Is Null THEN 0 ELSE PRO.NeedsUser END AS NeedsUser, CASE WHEN CASE WHEN PRO.NeedsSeeLiving Is Null THEN 0 ELSE PRO.NeedsSeeLiving END OR CASE WHEN PMY.MaxYear Is Null THEN -1 ELSE PMY.MaxYear > 2024 END THEN -1 ELSE 0 END AS NeedsSeeLiving FROM (( Person AS P LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS Copyright FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = -1 AND RTI.ItemIdId = ) AS PRC ON P.PId = PRC.PId) LEFT JOIN (SELECT RTI.ItemId AS PId, R.Description AS OtherRight, R.NeedsUser, R.NeedsSeeLiving FROM Rights AS R INNER JOIN RightsToItem AS RTI ON R.RightsId = RTI.RightsId WHERE R.IsCopyright = 0 AND RTI.ItemIdId = ) AS PRO ON P.PId = PRO.PId) LEFT JOIN (SELECT PDL.PId, Max(Dates.Year+DateTypes.Years) AS MaxYear FROM (PersonDatesLocations AS PDL INNER JOIN Dates ON PDL.DId = Dates.DId) INNER JOIN DateTypes ON PDL.DateType = DateTypes.DTId GROUP BY PDL.PId ) AS PMY ON P.PId = PMY.PId ) AS Person ON PersonNames.PId = Person.PId
WHERE
(PersonNames.NameType<6) AND
((Person.Entry=-1) AND (Person.Alive=0) AND (Person.needsSeeLiving=0) AND (Person.needsUser=0) )
ORDER BY Name;
Nachfahren von unbekannte Person
