1 2 3 4 5
| SELECT ITEM_ID, ITEM_TYPE_ID, ITEM_SUB_TYPE_ID, ITEM_NAME, ITEM_SHORT_NAME, ITEM_ABSTRACT, ITEM_URL, ITEM_REGION_ID, ITEM_POS, ITEM_IS_SEARCH_VISIBLE, ITEM_THEME_DATE_DEB, ITEM_THEME_DATE_FIN, ITEM_THEME_IDS, ITEM_KEYWORD_IDS,ITEM_URL_LABEL, ITEM_DATE, ITEM_IS_INTERNAL, ITEM_KEYWORD_OFF_IDS, ITEM_DATE_PARUTION, UTIL_ITEM_AWARD_TYPE, UTIL_ITEM_PUBLICATION, UTIL_ITEM_GEO_AREA_1, UTIL_ITEM_GEO_AREA_2, UTIL_ITEM_GEO_AREA_3, UTIL_ITEM_GEO_AREA_4, UTIL_ITEM_GEO_AREA_5, UTIL_ITEM_GEO_AREA_6, UTIL_ITEM_GEO_AREA_7, UTIL_ITEM_GEO_AREA_8, PUBLISHED_ITEM_ID, PUBLISHED_ITEM_FORMAT, PUBLISHED_ITEM_CONTENT
FROM published_item, published_item_content, PUBLISHED_CAT_ITEM_ASSO
WHERE ITEM_ID = PUBLISHED_ITEM_ID AND ITEM_ID = CAT_ITEM_ASSO_ITEM_ID and ITEM_DATE_PARUTION is not null and ITEM_DATE is not null ORDER BY ITEM_DATE DESC |
Partager