1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70
|
select
this_.ID as ID23_3_,
this_.STUDY_NUMBER as STUDY2_23_3_,
this_.PUBLICATION_TYPE as PUBLICAT3_23_3_,
this_.EXECUTIVE_SUMMARY as EXECUTIVE5_23_3_,
this_.AUTHOR as AUTHOR23_3_,
this_.SUPPLIED_BY as SUPPLIED7_23_3_,
this_.EDITOR_ID as EDITOR8_23_3_,
this_.LAST_PUBLICATION_DATE as LAST10_23_3_,
this_.DATE_MODIFICATION as DATE12_23_3_,
this_.DATE_INSERTION as DATE13_23_3_,
this_.USER_MODIFICATION as USER14_23_3_,
this_.USER_INSERTION as USER15_23_3_,
this_.OFF_LINE as OFF16_23_3_,
revisions1_.ID as ID21_0_,
revisions1_.STUDY_ID as STUDY2_21_0_,
revisions1_.REVISION_NUMBER as REVISION3_21_0_,
revisionla2_.ID as ID22_1_,
revisionla2_.REVISION_ID as REVISION2_22_1_,
revisionla2_.REVISION_NUMBER as REVISION3_22_1_,
revisionla2_.LANGUAGE as LANGUAGE22_1_,
revisionla2_.SOURCE_LANGUAGE as SOURCE5_22_1_,
revisionla2_.PUBLICATION_DATE as PUBLICAT6_22_1_,
revisionla2_.TITLE as TITLE22_1_,
revisionla2_.ABSTRACT_SUMMARY as ABSTRACT9_22_1_,
revisionla2_.NOTE as NOTE22_1_,
revisionla2_.NUMBER_OF_PAGES as NUMBER11_22_1_,
revisionla2_.ISBN_NUMBER as ISBN12_22_1_,
revisionla2_.FORCE_ARCHIVE as FORCE13_22_1_,
revisionla2_.DIFFUSION as DIFFUSION22_1_,
estthemes7_.STU_STUDY_ID as STU1_,
themes3_.ID as STU2_,
themes3_.ID as ID25_2_,
themes3_.CODE as CODE25_2_,
from
EST_STUDY this_
inner join
EST_REVISION revisions1_
on this_.ID=revisions1_.STUDY_ID
inner join
EST_REVISION_LANGUAGE revisionla2_
on revisions1_.ID=revisionla2_.REVISION_ID
inner join
EST_STUDY_THEME estthemes7_
on this_.ID=estthemes7_.STU_STUDY_ID
inner join
EST_THEME themes3_
on estthemes7_.STU_THEME_ID=themes3_.ID
where
(
this_.ID=?
or this_.ID=?
or this_.ID=?
or this_.ID=?
or this_.ID=?
or this_.ID=?
or this_.ID=?
or this_.ID=?
or this_.ID=?
or this_.ID=?
or lower(revisionla2_.TITLE) like ?
or lower(revisionla2_.ABSTRACT_SUMMARY) like ?
)
and (
this_.OFF_LINE=?
or this_.OFF_LINE is null
)
order by
revisionla2_.PUBLICATION_DATE desc |
Partager