Page values for "Rotten Apples"

"albums" values

2 rows are stored for this page
FieldField typeAllowed valuesValue
nameStringRotten Apples
coverFile
Smashing Pumpkins Greatest Hits album cover.jpg
typeList of String, delimiter: ,ep · studio · demo · live · compilation · box set · video · tribute · bootleg · promotionalcompilation
artistPageThe Smashing Pumpkins · Billy Corgan · James Iha · Jimmy Chamberlin Complex · Zwan · Various artistsThe Smashing Pumpkins
studioList of String, delimiter: ,
producerList of Page, delimiter: ,Billy Corgan Ted de Bono Flood James Iha Alan Moulder Bjorn Thorsrud Butch Vig Howard Willing Brad Wood
engineerList of Page, delimiter: ,
releasedDate2001-11-20
discogsInteger48,790
musicbrainzString629f866b-c8d1-3985-9da7-a648e8a3aaab
FieldField typeAllowed valuesValue
nameStringJudas O
coverFile
Smashing Pumpkins Greatest Hits album cover.jpg
typeList of String, delimiter: ,ep · studio · demo · live · compilation · box set · video · tribute · bootleg · promotionalcompilation
artistPageThe Smashing Pumpkins · Billy Corgan · James Iha · Jimmy Chamberlin Complex · Zwan · Various artistsThe Smashing Pumpkins
studioList of String, delimiter: ,
producerList of Page, delimiter: ,Kerry Brown Billy Corgan Ted de Bono Flood James Iha Alan Moulder Bjorn Thorsrud Butch Vig Howard Willing Brad Wood
engineerList of Page, delimiter: ,
releasedDate2001-11-20
discogsInteger
musicbrainzString

"track_listings" values

52 rows are stored for this page
FieldField typeValue
songStringSiva
song_page_titleStringSiva
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger1
sourcePage
lengthString4:21
FieldField typeValue
songStringRhinoceros
song_page_titleStringRhinoceros
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger2
sourcePage
lengthString5:53
FieldField typeValue
songStringDrown
song_page_titleStringDrown
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger3
sourcePage
lengthString4:30
FieldField typeValue
songStringCherub Rock
song_page_titleStringCherub Rock
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger4
sourcePage
lengthString4:59
FieldField typeValue
songStringToday
song_page_titleStringToday
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger5
sourcePage
lengthString3:22
FieldField typeValue
songStringDisarm
song_page_titleStringDisarm
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger6
sourcePage
lengthString3:18
FieldField typeValue
songStringLandslide
song_page_titleStringLandslide
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger7
sourcePage
lengthString3:06
FieldField typeValue
songStringBullet with Butterfly Wings
song_page_titleStringBullet with Butterfly Wings
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger8
sourcePage
lengthString4:18
FieldField typeValue
songString1979
song_page_titleString1979
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger9
sourcePage
lengthString4:23
FieldField typeValue
songStringZero
song_page_titleStringZero
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger10
sourcePage
lengthString2:41
FieldField typeValue
songStringTonight, Tonight
song_page_titleStringTonight, Tonight
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger11
sourcePage
lengthString4:15
FieldField typeValue
songStringEye
song_page_titleStringEye
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger12
sourcePage
lengthString4:54
FieldField typeValue
songStringAva Adore
song_page_titleStringAva Adore
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger13
sourcePage
lengthString4:21
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger14
sourcePage
lengthString3:22
FieldField typeValue
songStringThe Everlasting Gaze
song_page_titleStringThe Everlasting Gaze
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger15
sourcePage
lengthString4:02
FieldField typeValue
songStringStand Inside Your Love
song_page_titleStringStand Inside Your Love
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger16
sourcePage
lengthString4:13
FieldField typeValue
songStringReal Love
song_page_titleStringReal Love
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger17
sourcePage
lengthString4:10
FieldField typeValue
songStringUntitled
song_page_titleStringUntitled
workStringRotten Apples
headlineStringNorth American version
listing_idInteger1
main_listingBooleanNo
trackInteger18
sourcePage
lengthString3:51
FieldField typeValue
songStringSiva
song_page_titleStringSiva
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger1
sourcePage
lengthString4:21
FieldField typeValue
songStringRhinoceros
song_page_titleStringRhinoceros
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger2
sourcePage
lengthString5:54
FieldField typeValue
songStringDrown
song_page_titleStringDrown
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger3
sourcePage
lengthString4:30
FieldField typeValue
songStringCherub Rock
song_page_titleStringCherub Rock
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger4
sourcePage
lengthString4:58
FieldField typeValue
songStringToday
song_page_titleStringToday
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger5
sourcePage
lengthString3:22
FieldField typeValue
songStringDisarm
song_page_titleStringDisarm
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger6
sourcePage
lengthString3:17
FieldField typeValue
songStringBullet with Butterfly Wings
song_page_titleStringBullet with Butterfly Wings
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger7
sourcePage
lengthString4:17
FieldField typeValue
songString1979
song_page_titleString1979
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger8
sourcePage
lengthString4:24
FieldField typeValue
songStringZero
song_page_titleStringZero
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger9
sourcePage
lengthString2:40
FieldField typeValue
songStringTonight, Tonight
song_page_titleStringTonight, Tonight
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger10
sourcePage
lengthString4:16
FieldField typeValue
songStringEye
song_page_titleStringEye
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger11
sourcePage
lengthString4:54
FieldField typeValue
songStringAva Adore
song_page_titleStringAva Adore
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger12
sourcePage
lengthString4:20
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger13
sourcePage
lengthString3:23
FieldField typeValue
songStringThe Everlasting Gaze
song_page_titleStringThe Everlasting Gaze
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger14
sourcePage
lengthString4:02
FieldField typeValue
songStringStand Inside Your Love
song_page_titleStringStand Inside Your Love
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger15
sourcePage
lengthString4:13
FieldField typeValue
songStringTry, Try, Try
song_page_titleStringTry, Try, Try
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger16
sourcePage
lengthString5:09
FieldField typeValue
songStringReal Love
song_page_titleStringReal Love
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger17
sourcePage
lengthString4:10
FieldField typeValue
songStringUntitled
song_page_titleStringUntitled
workStringRotten Apples
headlineStringInternational version
listing_idInteger2
main_listingBooleanNo
trackInteger18
sourcePage
lengthString3:53
FieldField typeValue
songStringLucky 13
song_page_titleStringLucky 13
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger1
sourcePage
lengthString3:09
FieldField typeValue
songStringThe Aeroplane Flies High (Turns Left, Looks Right)
song_page_titleStringThe Aeroplane Flies High (Turns Left, Looks Right)
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger2
sourcePage
lengthString7:53
FieldField typeValue
songStringBecause You Are
song_page_titleStringBecause You Are
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger3
sourcePage
lengthString3:46
FieldField typeValue
songStringSlow Dawn
song_page_titleStringSlow Dawn
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger4
sourcePage
lengthString3:12
FieldField typeValue
songStringBelieve
song_page_titleStringBelieve
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger5
sourcePage
lengthString3:12
FieldField typeValue
songStringMy Mistake
song_page_titleStringMy Mistake
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger6
sourcePage
lengthString4:00
FieldField typeValue
songStringMarquis in Spades
song_page_titleStringMarquis in Spades
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger7
sourcePage
lengthString3:12
FieldField typeValue
songStringHere's to the Atom Bomb
song_page_titleStringHere's to the Atom Bomb
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger8
sourcePage
lengthString4:26
FieldField typeValue
songStringSparrow
song_page_titleStringSparrow
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger9
sourcePage
lengthString2:56
FieldField typeValue
songStringWaiting
song_page_titleStringWaiting
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger10
sourcePage
lengthString3:48
FieldField typeValue
songStringSaturnine
song_page_titleStringSaturnine
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger11
sourcePage
lengthString3:49
FieldField typeValue
songStringRock On
song_page_titleStringRock On
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger12
sourcePage
lengthString6:06
FieldField typeValue
songStringSet the Ray to Jerry
song_page_titleStringSet the Ray to Jerry
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger13
sourcePage
lengthString4:09
FieldField typeValue
songStringWinterlong
song_page_titleStringWinterlong
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger14
sourcePage
lengthString4:59
FieldField typeValue
songStringSoot and Stars
song_page_titleStringSoot and Stars
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger15
sourcePage
lengthString6:39
FieldField typeValue
songStringBlissed and Gone
song_page_titleStringBlissed and Gone
workStringRotten Apples
headlineString
listing_idInteger3
main_listingBooleanNo
trackInteger16
sourcePage
lengthString4:46

"album_charts" values

16 rows are stored for this page
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

Australia

positionInteger4
dateDate2001-12-02
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

Austria

positionInteger22
dateDate2001-12-02
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

Flanders

positionInteger15
dateDate2001-12-08
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

Wallonia

positionInteger37
dateDate2001-12-08
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

BillboardCanada

positionInteger5
dateDate2001-12-15
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

Finland

positionInteger25
dateDate2001-11-25
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

Germany4

positionInteger28
dateDate2001-12-03
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

Italy

positionInteger15
dateDate2001-11-22
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

New Zealand

positionInteger5
dateDate2001-12-02
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

Norway

positionInteger11
dateDate2001-11-26
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

Scotland

positionInteger24
dateDate2001-11-25
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

Sweden

positionInteger31
dateDate2001-11-30
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

Switzerland

positionInteger40
dateDate2001-12-02
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

UK

positionInteger28
dateDate2001-11-25
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

Billboard200

positionInteger31
dateDate2001-12-08
FieldField typeValue
albumPageRotten Apples
artistStringThe Smashing Pumpkins
chartWikitext string

BillboardAlbumSales

positionInteger31
dateDate2001-12-08

"certifications" values

5 rows are stored for this page
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringRotten Apples
typeStringalbum · single · videoalbum
awardStringGold
numberInteger
regionStringAustralia
dateDate2001-11-16
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringGreatest Hits
typeStringalbum · single · videoalbum
awardStringPlatinum
numberInteger
regionStringCanada
dateDate2002-03-28
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringRotten Apples
typeStringalbum · single · videoalbum
awardStringPlatinum
numberInteger
regionStringNew Zealand
dateDate
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringRotten Apples
typeStringalbum · single · videoalbum
awardStringGold
numberInteger
regionStringSpain
dateDate2001
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringRotten Apples – The Greatest Hits
typeStringalbum · single · videoalbum
awardStringGold
numberInteger
regionStringUnited Kingdom
dateDate2013-07-22

"releases" values

3 rows are stored for this page
FieldField typeValue
workPageRotten Apples
listing_idList of Integer, delimiter: ,2 3
release_dateDate2001-11-16
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,VJCP-68343-44
formatList of String, delimiter: ,2×CD
countryStringJapan
discogsInteger3,454,328
musicbrainzStringc56d6e94-e1ac-4afb-8ff6-9dd5dcd30c11
FieldField typeValue
workPageRotten Apples
listing_idList of Integer, delimiter: ,2 3
release_dateDate2001-11-19
labelList of String, delimiter: ,Virgin Hut Recordings
catalog_idList of String, delimiter: ,7243 8 11557 2 1 CDHUTD70
formatList of String, delimiter: ,2×CD
countryStringEurope
discogsInteger4,672,798
musicbrainzString45c57051-d92f-310c-b0db-2a7ad464343f
FieldField typeValue
workPageRotten Apples
listing_idList of Integer, delimiter: ,1 3
release_dateDate2001-11-20
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,7243 8 11318 2 4
formatList of String, delimiter: ,2×CD
countryStringUS
discogsInteger574,503
musicbrainzStringa31fdfae-e2fd-4c4e-b1ed-db8018c9a859