gistfile1.sql

SELECT   TOP (@p0)
FROM     (, ROW_NUMBER() OVER(ORDER BY CURRENT_TIMESTAMP) AS __hibernate_sort_row
SELECT   p.ProjectID                                      AS ProjectID27_0_ ,
         p.CompanyID                                      AS CompanyID27_0_ ,
         p.LabID                                          AS LabID27_0_     ,
         p.ProjectTitle                                   AS ProjectT4_27_0_,
         p.CreatedBy                                      AS CreatedBy27_0_ ,
         p.CreateDate                                     AS CreateDate27_0_,
         p.Description                                    AS Descript7_27_0_,
         p.AbstractPlainText                              AS Abstract8_27_0_,
         p.Conclusion                                     AS Conclusion27_0_,
         p.ConclusionPlainText                            AS Conclus10_27_0_,
         p.Default_Health                                 AS Default11_27_0_,
         p.Default_Flammability                           AS Default12_27_0_,
         p.Default_Reactivity                             AS Default13_27_0_,
         p.Default_Equipment                              AS Default14_27_0_,
         p.ProjectTypeID                                  AS Project15_27_0_,
         p.ProjectStatusID                                AS Project16_27_0_
FROM     Project p
         INNER JOIN
                  (SELECT ParentID
                  FROM    (
                          (SELECT F1.ParentID
                          FROM    (SELECT MP.ParentID
                                  FROM    ModularProperty MP
                                  WHERE   MP.CachedPropertyValue LIKE '%chr%'
                                  AND     MP.ParentType          LIKE'%Project'
                                  AND     MP.CompanyPropertyID      = 6
                                  )
                                  F1
                          )
                          ) IDs
                  )
                  filter
         ON       p.ProjectID = filter.ParentID
WHERE    p.CompanyID          = 1
AND      p.ProjectTypeID      = 5
ORDER BY p.ProjectID DESC) AS query
WHERE    query.__hibernate_sort_row > @p1
ORDER BY query.__hibernate_sort_row