フジロック出演アーティストの最新ニュースをチェック!
●SQL: SELECT * FROM (
SELECT NEWS.NEWS_CD as NEWS_CD, NEWS.HEADER as HEADER, NEWS.NEWS_YMD as NEWS_YMD, IMG_FILE as IMG_FILE
FROM NEWS_ARTIST, NEWS
WHERE (NEWS_ARTIST.NEWS_CD = NEWS.NEWS_CD) AND (NEWS.NEWS_YMD > '2007/05/01') AND NEWS_ARTIST.ARTIST_CD in
(
'VIBE-ARTIST030004686',
'VIBE-ARTIST020004339',
'VIBE-ARTIST000000295',
'VIBE-ARTIST020000459',
'VIBE-ARTIST030006650',
'VIBE-ARTIST000000302',
'VIBE-ARTIST021005473',
'VIBE-ARTIST030005588',
'VIBE-ARTIST030004287',
'VIBE-ARTIST030005930',
'VIBE-ARTIST020004343',
'VIBE-ARTIST030004576',
'VIBE-ARTIST020004251',
'VIBE-ARTIST030006729',
'VIBE-ARTIST020001726',
'VIBE-ARTIST030002583',
'VIBE-ARTIST010000682',
'VIBE-ARTIST030002529',
'VIBE-ARTIST000000425',
'VIBE-ARTIST030004594',
'VIBE-ARTIST010000733',
'VIBE-ARTIST020000755',
'VIBE-ARTIST000000392',
'VIBE-ARTIST030000943',
'VIBE-ARTIST030006109',
'VIBE-ARTIST030006727',
'VIBE-ARTIST030004453',
'VIBE-ARTIST030006582',
'VIBE-ARTIST020002016',
'VIBE-ARTIST030006219',
'VIBE-ARTIST000000063',
'VIBE-ARTIST030002251',
'VIBE-ARTIST030005195',
'VIBE-ARTIST020002110',
'VIBE-ARTIST030000081',
'VIBE-ARTIST020002672',
'VIBE-ARTIST010000721',
'VIBE-ARTIST000000081',
'VIBE-ARTIST030006640',
'VIBE-ARTIST000000455',
'VIBE-ARTIST030004376',
'VIBE-ARTIST030006098',
'VIBE-ARTIST000000227',
'VIBE-ARTIST000000462',
'VIBE-ARTIST020004344',
'VIBE-ARTIST030006328',
'VIBE-ARTIST020004538',
'VIBE-ARTIST030005487',
'VIBE-ARTIST020000933',
'VIBE-ARTIST030004659',
'VIBE-ARTIST030006618',
'VIBE-ARTIST000000099',
'VIBE-ARTIST030002361',
'VIBE-ARTIST030006719',
'VIBE-ARTIST030004647',
'VIBE-ARTIST030000657',
'VIBE-ARTIST020004612',
'VIBE-ARTIST030006720',
'VIBE-ARTIST030005644',
'VIBE-ARTIST030005804',
'VIBE-ARTIST030006512',
'VIBE-ARTIST010001083',
'VIBE-ARTIST000000510',
'VIBE-ARTIST030006667',
'VIBE-ARTIST030004957',
'VIBE-ARTIST030003103',
'VIBE-ARTIST030001419',
'VIBE-ARTIST020000704',
'VIBE-ARTIST020001305',
'VIBE-ARTIST030005919',
'VIBE-ARTIST030002375',
'VIBE-ARTIST020003182',
'VIBE-ARTIST030006470',
'VIBE-ARTIST030005763',
'VIBE-ARTIST030005664',
'VIBE-ARTIST020005085',
'VIBE-ARTIST030006494',
'VIBE-ARTIST020004167',
'VIBE-ARTIST030002505',
'VIBE-ARTIST020004482',
'VIBE-ARTIST030004538',
'VIBE-ARTIST030002112',
'VIBE-ARTIST030004856',
'VIBE-ARTIST030001257',
'VIBE-ARTIST020004300',
'VIBE-ARTIST020000856',
'VIBE-ARTIST020000924',
'VIBE-ARTIST030004341',
'VIBE-ARTIST030000537',
'VIBE-ARTIST030005769',
'VIBE-ARTIST000000124',
'VIBE-ARTIST030006093',
'VIBE-ARTIST020004946',
'VIBE-ARTIST030004297',
'VIBE-ARTIST020001044',
'VIBE-ARTIST000000550',
'VIBE-ARTIST030006054',
'VIBE-ARTIST020000949'
)
ORDER BY NEWS_YMD DESC
) WHERE ROWNUM <= 50の実行に失敗しました。
ERROR: sub-SELECT in FROM must have an alias
For example, FROM (SELECT ...) [AS] foo
|