select
       pr1.GUID_ID, pr1.Entry_ID, pr1.JourFixe_GUID, pr1.Project_GUID, pr1.Place_GUID, pr1.System_GUID, pr1.State,
       CAST('' AS VARCHAR(200)) AS Description,
       pr1.Address_GUID, pr1.Date_ToDoFrom, pr1.Date_ToDo, pr1.Date_Done,
       pr1.ObjType, 
       pr1.EntryInfo,
       pr1.Text,
      CAST(
       SELECT LIST(ORDERED (IF(COALESCE(a.CompanyName, '') = '', a.FullName, a.CompanyName)) USING '; ') AS AddressText
       FROM Prj0B81D213852C4CBFB477583B45EDD46C.RefObjects
       LEFT OUTER JOIN p3md.vw_AddressFullNames a ON a.GUID_ID=RefObjects.REF_GUID
       WHERE Project_GUID=:aProject_GUID AND JourFixe_GUID=:aJourFixe_GUID AND RefObjects.EntryType=0 AND RefObjects.Item_GUID=pr1.GUID_ID
      AS VARCHAR(1024)) AS AddressText,
      CAST(
       SELECT LIST(ORDERED Place_PathText(RefObjects.REF_GUID) USING '; ') AS SystemText
       FROM Prj0B81D213852C4CBFB477583B45EDD46C.RefObjects
       WHERE Project_GUID=:aProject_GUID AND JourFixe_GUID=:aJourFixe_GUID AND RefObjects.EntryType=1 AND RefObjects.Item_GUID=pr1.GUID_ID
      AS VARCHAR(1024)) AS SystemText,
      CAST(
       SELECT LIST(ORDERED Place_PathText(RefObjects.REF_GUID) USING '; ') AS PlaceText
       FROM Prj0B81D213852C4CBFB477583B45EDD46C.RefObjects
       WHERE Project_GUID=:aProject_GUID AND JourFixe_GUID=:aJourFixe_GUID AND RefObjects.EntryType=2 AND RefObjects.Item_GUID=pr1.GUID_ID
      AS VARCHAR(1024)) AS PlaceText,       
      CAST(
       SELECT LIST(ORDERED Catalog_PathText(RefObjects.REF_GUID, RefObjects.REF_TEXT) USING '; ') AS PlaceText
       FROM Prj0B81D213852C4CBFB477583B45EDD46C.RefObjects
       WHERE Project_GUID=:aProject_GUID AND JourFixe_GUID=:aJourFixe_GUID AND RefObjects.EntryType=3 AND RefObjects.Item_GUID=pr1.GUID_ID
      AS VARCHAR(1024)) AS ChapterText,       
       pr1.CreateDate, pr1.ModifyDate,
       pt1.*,
       a.*
 from Prj0B81D213852C4CBFB477583B45EDD46C.EntryJourFixeMapping RPM
        LEFT OUTER JOIN Prj0B81D213852C4CBFB477583B45EDD46C.JourFixeEntry pr1 ON pr1.GUID_ID = RPM.Entry_GUID AND pr1.JourFixe_GUID = RPM.EntryS_JourFixe_GUID
        LEFT OUTER JOIN Prj0B81D213852C4CBFB477583B45EDD46C."JourFixe" pt1 ON (pt1.GUID_ID = RPM.EntryS_JourFixe_GUID)
        LEFT OUTER JOIN p3md."vw_AddressFullNames" a ON (a.GUID_ID = pr1.Address_GUID)
        WHERE RPM.JourFixe_GUID=:aJourFixe_GUID AND pr1.Project_GUID=:aProject_GUID
        ORDER BY pr1.CreateDate DESC, pr1.Entry_ID