SELECT C.PAGE_CONTENT_ID AS #QUERY.PREFIX#FRM_PAGE_CONTENT_ID, C.OEM_ID AS #QUERY.PREFIX#FRM_OEM_ID, C.CONTENT_QUOTE AS FRM_CONTENT_QUOTE, C.CONTENT_NAME AS #QUERY.PREFIX#FRM_CONTENT_NAME, C.PHOTO_CAPTION AS #QUERY.PREFIX#FRM_PHOTO_CAPTION, C.CONTENT_PREVIEW AS #QUERY.PREFIX#FRM_CONTENT_PREVIEW, C.HAS_VIDEOS AS #QUERY.PREFIX#FRM_HAS_VIDEOS, C.PHOTO_ALBUM_ID AS #QUERY.PREFIX#FRM_PHOTO_ALBUM_ID, C.PAGE_TEMPLATE_ID AS #QUERY.PREFIX#FRM_PAGE_TEMPLATE_ID, TO_CHAR(TIMEZONE.GMT_TO_ZONE_TIME_DATE(C.START_DATE,-5,1 ,NULL) ,MM/DD/YYYY) AS #QUERY.PREFIX#FRM_START_DATE, TO_CHAR(TIMEZONE.GMT_TO_ZONE_TIME_DATE(C.START_DATE,-5,1 ,NULL) ,'MM') AS #QUERY.PREFIX#FRM_START_DATE_MM, TO_CHAR(TIMEZONE.GMT_TO_ZONE_TIME_DATE(C.START_DATE,-5,1 ,NULL) ,'DD') AS #QUERY.PREFIX#FRM_START_DATE_DD, TO_CHAR(TIMEZONE.GMT_TO_ZONE_TIME_DATE(C.START_DATE,-5,1 ,NULL) ,'YYYY') AS #QUERY.PREFIX#FRM_START_DATE_YYYY, TO_CHAR(TIMEZONE.GMT_TO_ZONE_TIME_DATE(C.START_DATE,-5,1 ,NULL) ,'YY') AS #QUERY.PREFIX#FRM_START_DATE_YY, TO_CHAR(TIMEZONE.GMT_TO_ZONE_TIME_DATE(C.END_DATE,-5,1 ,NULL) ,MM/DD/YYYY) AS #QUERY.PREFIX#FRM_END_DATE, TO_CHAR(TIMEZONE.GMT_TO_ZONE_TIME_DATE(C.END_DATE,-5,1 ,NULL) ,'MM') AS #QUERY.PREFIX#FRM_END_DATE_MM, TO_CHAR(TIMEZONE.GMT_TO_ZONE_TIME_DATE(C.END_DATE,-5,1 ,NULL) ,'DD') AS #QUERY.PREFIX#FRM_END_DATE_DD, TO_CHAR(TIMEZONE.GMT_TO_ZONE_TIME_DATE(C.END_DATE,-5,1 ,NULL) ,'YYYY') AS #QUERY.PREFIX#FRM_END_DATE_YYYY, TO_CHAR(TIMEZONE.GMT_TO_ZONE_TIME_DATE(C.END_DATE,-5,1 ,NULL) ,'YY') AS #QUERY.PREFIX#FRM_END_DATE_YY, TO_CHAR(TIMEZONE.GMT_TO_ZONE_TIME_DATE(C.START_DATE,-5,1 ,NULL) ,'YYYYMMDD') AS ORDER_BY_FIRST_DATE, TO_CHAR(TIMEZONE.GMT_TO_ZONE_TIME_DATE(C.START_DATE,-5,1 ,NULL) ,'HH24MISS') AS ORDER_BY_SECOND_DATE, C.NO_END_DATE AS #QUERY.PREFIX#FRM_NO_END_DATE, C.ACTIVE AS #QUERY.PREFIX#FRM_ACTIVE, C.SUBSCRIBER_LEVEL AS #QUERY.PREFIX#FRM_SUBSCRIBER_LEVEL, C.ORDER_ID AS #QUERY.PREFIX#FRM_ORDER_ID, C.ARTICLE_IMAGE_ID AS #QUERY.PREFIX#FRM_ARTICLE_IMAGE_ID, C.COPYRIGHT_ID AS #QUERY.PREFIX#FRM_COPYRIGHT_ID, C.MOD_ACCOUNT_ID AS #QUERY.PREFIX#FRM_MOD_ACCOUNT_ID, C.CONTENT_PATH AS #QUERY.PREFIX#FRM_CONTENT_PATH, C.PLAYER_ID AS #QUERY.PREFIX#FRM_ARTICLE_PLAYER_ID, C.MEDIA_CATEGORY_ABBR AS #QUERY.PREFIX#FRM_MEDIA_CATEGORY_ABBR, C.SPORT_ID AS #QUERY.PREFIX#FRM_SPORT_ID, C.PHOTO_CAPTION AS #QUERY.PREFIX#PHOTO_CAPTION, C.LOCATION_LINE AS #QUERY.PREFIX#LOCATION_LINE, C.PAGE_PRIORITY AS #QUERY.PREFIX#FRM_PAGE_PRIORITY, SP.SPORT_NAME AS #QUERY.PREFIX#FRM_SPORT_NAME, SP.SPORT_ABBR AS #QUERY.PREFIX#FRM_SPORT_ABBR, SP.TINY_ABBR AS #QUERY.PREFIX#FRM_TINY_ABBR, I.IMAGE_ID AS #QUERY.PREFIX#FRM_IMAGE_ID, SD.WEB_RELATIVE || '/' || '0' || '/' || SZ.FILE_NAME AS #QUERY.PREFIX#LOAD_ORIGINAL_IMAGE_PATH, SD.WEB_RELATIVE || '/' || SZ.SIZE_ID || '/' || SZ.FILE_NAME AS #QUERY.PREFIX#LOAD_THUMBNAIL_IMAGE_PATH, SD.WEB_RELATIVE AS #QUERY.PREFIX#LOAD_THUMBNAIL_WEB_RELATIVE, SZ.FILE_NAME AS #QUERY.PREFIX#LOAD_THUMBNAIL_FILE_NAME, SZ.SIZE_ID AS #QUERY.PREFIX#LOAD_THUMBNAIL_SIZE_ID, SZ.IMAGE_SIZE AS #QUERY.PREFIX#LOAD_THUMBNAIL_IMAGE_SIZE, SZ.IMAGE_HEIGHT AS #QUERY.PREFIX#LOAD_THUMBNAIL_IMAGE_HEIGHT, SZ.IMAGE_WIDTH AS #QUERY.PREFIX#LOAD_THUMBNAIL_IMAGE_WIDTH, ACY.CREDIT_NAME AS #QUERY.PREFIX#FRM_ARTICLE_CREDIT_NAME, PCY.CREDIT_NAME AS #QUERY.PREFIX#FRM_PHOTO_CREDIT_NAME, SD.WEB_RELATIVE || '/' || SZT.SIZE_ID || '/' || SZT.FILE_NAME AS #QUERY.PREFIX#LOAD_TINY_IMAGE_PATH, SZT.FILE_NAME AS #QUERY.PREFIX#LOAD_TINY_FILE_NAME, SZT.SIZE_ID AS #QUERY.PREFIX#LOAD_TINY_SIZE_ID, SZT.IMAGE_SIZE AS #QUERY.PREFIX#LOAD_TINY_IMAGE_SIZE, SZT.IMAGE_HEIGHT AS #QUERY.PREFIX#LOAD_TINY_IMAGE_HEIGHT, SZT.IMAGE_WIDTH AS #QUERY.PREFIX#LOAD_TINY_IMAGE_WIDTH, PCY.CREDIT_NAME AS #QUERY.PREFIX#FRM_PHOTO_CREDIT_NAME, I.SELL_IMAGE as #QUERY.PREFIX#FRM_PHOTO_SELL_IMAGE, SD.WEB_RELATIVE as #QUERY.PREFIX#PHOTO_WEB_RELATIVE, SZT.FILE_NAME as #QUERY.PREFIX#PHOTO_FILE_NAME, I.SHORT_DESCRIPTION as #QUERY.PREFIX#PHOTO_SHORT_DESCRIPTION, I.IS_GALLERY as #QUERY.PREFIX#FRM_IS_GALLERY, I.ORIG_FILE_NAME as #QUERY.PREFIX#FRM_IMAGE_NAME, nvl(C.CLIP_FILE_ID,C.NEULION_VIDEO_ID) as #QUERY.PREFIX#FRM_NEULION_VIDEO_ID ,sign(nvl(C.CLIP_FILE_ID,0)-nvl(C.NEULION_VIDEO_ID,0)) as #QUERY.PREFIX#NEULION_VIDEO_SRC FROM NMN_IMAGE_SIZES SZT, NMN_COPYRIGHT PCY, NMN_COPYRIGHT ACY, PC_STORAGE_DRIVES SD, NMN_IMAGE_SIZES SZ, NMN_IMAGES I, NMN_SPORTS SP, NMN_PAGE_CONTENT C WHERE C.OEM_ID = 4200 AND C.ACTIVE = 1 AND C.START_DATE <= SYSDATE AND C.START_DATE > ( SYSDATE - 120) AND C.END_DATE >= DECODE(C.NO_END_DATE, 1, C.END_DATE, SYSDATE) AND C.SUBSCRIBER_LEVEL <= NVL(0, 0) AND C.SUBSCRIBER_LEVEL = NVL(, C.SUBSCRIBER_LEVEL) AND C.SPORT_SECTION_ID IN ( SELECT SUBSEC.SPORT_SECTION_ID FROM NMN_SPORT_SECTIONS SUBSEC WHERE SUBSEC.OEM_ID = 4200 AND SUBSEC.IS_HEADLINES = 1 AND SUBSEC.ACTIVE = 1 ) AND C.MEDIA_CATEGORY_ABBR = 'ARTICLE' AND C.PAGE_PRIORITY > 0 AND C.PAGE_PRIORITY <= 10000 AND SP.SPORT_ID = C.SPORT_ID AND I.IMAGE_ID (+) = NVL( DECODE(C.FRONTPAGE_IMAGE_ID, 0 , NULL, C.FRONTPAGE_IMAGE_ID ),DECODE(C.ARTICLE_IMAGE_ID, 0, nvl(#DEFAULT_IMAGE_ID#, 0),C.ARTICLE_IMAGE_ID )) AND I.SUBSCRIBER_LEVEL (+) <= NVL(0, 0) AND SZ.IMAGE_ID (+) = I.IMAGE_ID AND SZ.SIZE_ID (+) = 600 AND SZT.IMAGE_ID (+) = I.IMAGE_ID AND SZT.SIZE_ID (+) = 160 AND SD.DRIVE_ID (+) = I.DRIVE_ID AND ACY.COPYRIGHT_ID (+) = C.COPYRIGHT_ID AND PCY.COPYRIGHT_ID (+) = I.COPYRIGHT_ID ORDER BY C.PAGE_PRIORITY DESC, ORDER_BY_FIRST_DATE DESC,C.ORDER_ID DESC, ORDER_BY_SECOND_DATE DESC