Page values for "Adore"

"albums" values

1 row is stored for this page
FieldField typeAllowed valuesValue
nameStringAdore
coverFile
SmashingPumpkins-Adore.jpg
typeList of String, delimiter: ,ep · studio · demo · live · compilation · box set · video · tribute · bootleg · promotionalstudio
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 Flood Brad Wood
engineerList of Page, delimiter: ,
releasedDate1998-06-02
discogsInteger48,743
musicbrainzString359699b3-8118-369e-9591-c96dcd07a853

"track_listings" values

127 rows are stored for this page
FieldField typeValue
songStringTo Sheila
song_page_titleStringTo Sheila
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger1
sourcePage
lengthString4:46
FieldField typeValue
songStringAva Adore
song_page_titleStringAva Adore
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger2
sourcePage
lengthString4:21
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger3
sourcePage
lengthString3:23
FieldField typeValue
songStringDaphne Descends
song_page_titleStringDaphne Descends
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger4
sourcePage
lengthString4:39
FieldField typeValue
songStringOnce Upon a Time
song_page_titleStringOnce Upon a Time
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger5
sourcePage
lengthString4:06
FieldField typeValue
songStringTear
song_page_titleStringTear
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger6
sourcePage
lengthString5:53
FieldField typeValue
songStringCrestfallen
song_page_titleStringCrestfallen
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger7
sourcePage
lengthString4:09
FieldField typeValue
songStringAppels + Oranjes
song_page_titleStringAppels + Oranjes
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger8
sourcePage
lengthString3:35
FieldField typeValue
songStringPug
song_page_titleStringPug
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger9
sourcePage
lengthString4:47
FieldField typeValue
songStringThe Tale of Dusty and Pistol Pete
song_page_titleStringThe Tale of Dusty and Pistol Pete
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger10
sourcePage
lengthString4:35
FieldField typeValue
songStringAnnie-Dog
song_page_titleStringAnnie-Dog
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger11
sourcePage
lengthString3:38
FieldField typeValue
songStringShame
song_page_titleStringShame
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger12
sourcePage
lengthString6:40
FieldField typeValue
songStringBehold! The Night Mare
song_page_titleStringBehold! The Night Mare
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger13
sourcePage
lengthString5:13
FieldField typeValue
songStringFor Martha
song_page_titleStringFor Martha
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger14
sourcePage
lengthString8:18
FieldField typeValue
songStringBlank Page
song_page_titleStringBlank Page
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger15
sourcePage
lengthString4:58
FieldField typeValue
songString17
song_page_titleString17
workStringAdore
headlineStringMain release
listing_idInteger1
main_listingBooleanYes
trackInteger16
sourcePage
lengthString0:17
FieldField typeValue
songStringOnce in a While
song_page_titleStringOnce in a While
workStringAdore
headlineStringJapanese edition bonus track
listing_idInteger2
main_listingBooleanNo
trackInteger16
sourcePage
lengthString3:33
FieldField typeValue
songStringTo Sheila
song_page_titleStringTo Sheila
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger1
sourcePage
lengthString4:40
FieldField typeValue
songStringAva Adore
song_page_titleStringAva Adore
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger2
sourcePage
lengthString4:30
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger3
sourcePage
lengthString3:22
FieldField typeValue
songStringDaphne Descends
song_page_titleStringDaphne Descends
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger4
sourcePage
lengthString4:39
FieldField typeValue
songStringOnce Upon a Time
song_page_titleStringOnce Upon a Time
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger5
sourcePage
lengthString4:04
FieldField typeValue
songStringTear
song_page_titleStringTear
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger6
sourcePage
lengthString5:52
FieldField typeValue
songStringCrestfallen
song_page_titleStringCrestfallen
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger7
sourcePage
lengthString3:57
FieldField typeValue
songStringAppels + Oranjes
song_page_titleStringAppels + Oranjes
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger8
sourcePage
lengthString3:35
FieldField typeValue
songStringPug
song_page_titleStringPug
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger9
sourcePage
lengthString4:54
FieldField typeValue
songStringThe Tale of Dusty and Pistol Pete
song_page_titleStringThe Tale of Dusty and Pistol Pete
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger10
sourcePage
lengthString4:35
FieldField typeValue
songStringAnnie-Dog
song_page_titleStringAnnie-Dog
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger11
sourcePage
lengthString3:38
FieldField typeValue
songStringShame
song_page_titleStringShame
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger12
sourcePage
lengthString6:38
FieldField typeValue
songStringBehold! The Night Mare
song_page_titleStringBehold! The Night Mare
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger13
sourcePage
lengthString5:12
FieldField typeValue
songStringFor Martha
song_page_titleStringFor Martha
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger14
sourcePage
lengthString8:16
FieldField typeValue
songStringBlank Page
song_page_titleStringBlank Page
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger15
sourcePage
lengthString4:51
FieldField typeValue
songString17
song_page_titleString17
workStringAdore
headlineString2014 Reissue CD 1: ''Adore'' Stereo Remastered
listing_idInteger3
main_listingBooleanNo
trackInteger16
sourcePage
lengthString0:19
FieldField typeValue
songStringTo Sheila
song_page_titleStringTo Sheila
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger1
sourcePage
lengthString4:39
FieldField typeValue
songStringAva Adore
song_page_titleStringAva Adore
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger2
sourcePage
lengthString4:24
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger3
sourcePage
lengthString3:29
FieldField typeValue
songStringDaphne Descends
song_page_titleStringDaphne Descends
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger4
sourcePage
lengthString4:43
FieldField typeValue
songStringOnce Upon a Time
song_page_titleStringOnce Upon a Time
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger5
sourcePage
lengthString4:06
FieldField typeValue
songStringTear
song_page_titleStringTear
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger6
sourcePage
lengthString5:51
FieldField typeValue
songStringCrestfallen
song_page_titleStringCrestfallen
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger7
sourcePage
lengthString3:56
FieldField typeValue
songStringAppels + Oranjes
song_page_titleStringAppels + Oranjes
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger8
sourcePage
lengthString3:39
FieldField typeValue
songStringPug
song_page_titleStringPug
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger9
sourcePage
lengthString4:48
FieldField typeValue
songStringThe Tale of Dusty and Pistol Pete
song_page_titleStringThe Tale of Dusty and Pistol Pete
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger10
sourcePage
lengthString4:33
FieldField typeValue
songStringAnnie-Dog
song_page_titleStringAnnie-Dog
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger11
sourcePage
lengthString3:39
FieldField typeValue
songStringShame
song_page_titleStringShame
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger12
sourcePage
lengthString6:39
FieldField typeValue
songStringBehold! The Night Mare
song_page_titleStringBehold! The Night Mare
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger13
sourcePage
lengthString5:12
FieldField typeValue
songStringFor Martha
song_page_titleStringFor Martha
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger14
sourcePage
lengthString7:07
FieldField typeValue
songStringBlank Page
song_page_titleStringBlank Page
workStringAdore
headlineString2014 Reissue CD 2: ''Adore'' Mono Remastered
listing_idInteger4
main_listingBooleanNo
trackInteger15
sourcePage
lengthString4:50
FieldField typeValue
songStringBlissed and Gone
song_page_titleStringBlissed and Gone
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger1
sourcePage1996 – Sadlands
lengthString4:17
FieldField typeValue
songStringChristmastime
song_page_titleStringChristmastime
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger2
sourcePage1996 – Sadlands
lengthString3:27
FieldField typeValue
songStringMy Mistake
song_page_titleStringMy Mistake
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger3
sourcePage1996 – Sadlands
lengthString4:50
FieldField typeValue
songStringSparrow
song_page_titleStringSparrow
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger4
sourcePage1996 – Sadlands
lengthString2:55
FieldField typeValue
songStringValentine
song_page_titleStringValentine
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger5
sourcePage1996 – Sadlands
lengthString4:22
FieldField typeValue
songStringThe Tale of Dusty and Pistol Pete
song_page_titleStringThe Tale of Dusty and Pistol Pete
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger6
sourcePage1996 – Sadlands
lengthString5:23
FieldField typeValue
songStringWhat If?
song_page_titleStringWhat If?
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger7
sourcePageAugust 1997 – Streeterville
lengthString3:27
FieldField typeValue
songStringChewing Gum
song_page_titleStringChewing Gum
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger8
sourcePageFebruary 1997 – Chicago Recording Company
lengthString3:00
FieldField typeValue
songStringThe Tale of Dusty and Pistol Pete
song_page_titleStringThe Tale of Dusty and Pistol Pete
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger9
sourcePageFebruary 1997 – Chicago Recording Company
lengthString5:01
FieldField typeValue
songStringThe Ethers Tragic
song_page_titleStringThe Ethers Tragic
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger10
sourcePageFebruary 1997 – Chicago Recording Company
lengthString2:49
FieldField typeValue
songStringThe Guns of Love Disastrous
song_page_titleStringThe Guns of Love Disastrous
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger11
sourcePageFebruary 1997 – Chicago Recording Company
lengthString2:03
FieldField typeValue
songStringAnnie-Dog
song_page_titleStringAnnie-Dog
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger12
sourcePageFebruary 1997 – Chicago Recording Company
lengthString3:25
FieldField typeValue
songStringOnce in a While
song_page_titleStringOnce in a While
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger13
sourcePageFebruary 1997 – Chicago Recording Company
lengthString3:34
FieldField typeValue
songStringDo You Close Your Eyes When You Kiss Me?
song_page_titleStringDo You Close Your Eyes When You Kiss Me?
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger14
sourcePageFebruary 1997 – Chicago Recording Company
lengthString3:07
FieldField typeValue
songStringFor Martha
song_page_titleStringFor Martha
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger15
sourcePageFebruary 1997 – Chicago Recording Company
lengthString7:19
FieldField typeValue
songStringMy Mistake
song_page_titleStringMy Mistake
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger16
sourcePageFebruary 1997 – Chicago Recording Company
lengthString4:00
FieldField typeValue
songStringBlissed and Gone
song_page_titleStringBlissed and Gone
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger17
sourcePageFebruary 1997 – Chicago Recording Company
lengthString3:29
FieldField typeValue
songStringFor Martha
song_page_titleStringFor Martha
workStringAdore
headlineString2014 Reissue CD 3: In a State of Passage
listing_idInteger5
main_listingBooleanNo
trackInteger18
sourcePageFebruary 1997 – Chicago Recording Company
lengthString5:39
FieldField typeValue
songStringFor Martha
song_page_titleStringFor Martha
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger1
sourcePage
lengthString2:40
FieldField typeValue
songStringCrestfallen
song_page_titleStringCrestfallen
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger2
sourcePage
lengthString3:39
FieldField typeValue
songStringTo Sheila
song_page_titleStringTo Sheila
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger3
sourcePage
lengthString4:24
FieldField typeValue
songStringAva Adore
song_page_titleStringAva Adore
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger4
sourcePage
lengthString4:37
FieldField typeValue
songStringO Rio
song_page_titleStringO Rio
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger5
sourcePage
lengthString2:28
FieldField typeValue
songStringWaiting
song_page_titleStringWaiting
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger6
sourcePage
lengthString3:49
FieldField typeValue
songStringOnce Upon a Time
song_page_titleStringOnce Upon a Time
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger7
sourcePage
lengthString4:20
FieldField typeValue
songStringEye
song_page_titleStringEye
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger8
sourcePage
lengthString4:54
FieldField typeValue
songStringSaturnine
song_page_titleStringSaturnine
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger9
sourcePage
lengthString3:47
FieldField typeValue
songStringCash Car Star
song_page_titleStringCash Car Star
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger10
sourcePage
lengthString4:00
FieldField typeValue
songStringPug
song_page_titleStringPug
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger11
sourcePage
lengthString4:35
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger12
sourcePage
lengthString3:24
FieldField typeValue
songStringIt's Alright
song_page_titleStringIt's Alright
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger13
sourcePage
lengthString4:20
FieldField typeValue
songStringCzarina
song_page_titleStringCzarina
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger14
sourcePage
lengthString3:57
FieldField typeValue
songStringIndecision
song_page_titleStringIndecision
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger15
sourcePage
lengthString2:43
FieldField typeValue
songStringBlank Page
song_page_titleStringBlank Page
workStringAdore
headlineString2014 Reissue CD 4: Chalices, Palaces and Deep Pools
listing_idInteger6
main_listingBooleanNo
trackInteger16
sourcePage
lengthString4:57
FieldField typeValue
songStringLet Me Give the World to You
song_page_titleStringLet Me Give the World to You
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger1
sourcePage
lengthString4:19
FieldField typeValue
songStringTear
song_page_titleStringTear
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger2
sourcePage
lengthString5:52
FieldField typeValue
songStringCross
song_page_titleStringCross (Adore outtake)
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger3
sourcePage
lengthString4:53
FieldField typeValue
songStringBecause You Are
song_page_titleStringBecause You Are
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger4
sourcePage
lengthString3:51
FieldField typeValue
songStringJersey Shore
song_page_titleStringJersey Shore
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger5
sourcePage
lengthString3:41
FieldField typeValue
songStringShame
song_page_titleStringShame
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger6
sourcePage
lengthString4:54
FieldField typeValue
songStringSummer
song_page_titleStringSummer
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger7
sourcePage
lengthString3:08
FieldField typeValue
songStringBlissed and Gone
song_page_titleStringBlissed and Gone
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger8
sourcePage
lengthString5:11
FieldField typeValue
songStringHeaven
song_page_titleStringHeaven
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger9
sourcePage
lengthString4:02
FieldField typeValue
songStringDaphne Descends
song_page_titleStringDaphne Descends
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger10
sourcePage
lengthString5:06
FieldField typeValue
songStringSaturnine
song_page_titleStringSaturnine
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger11
sourcePage
lengthString3:57
FieldField typeValue
songStringBehold! The Night Mare
song_page_titleStringBehold! The Night Mare
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger12
sourcePage
lengthString4:59
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger13
sourcePage
lengthString3:18
FieldField typeValue
songStringDo You Close Your Eyes?
song_page_titleStringDo You Close Your Eyes?
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger14
sourcePage
lengthString4:22
FieldField typeValue
songStringThe Beginning Is the End Is the Beginning
song_page_titleStringThe Beginning Is the End Is the Beginning
workStringAdore
headlineString2014 Reissue CD 5: Malice, Callous and Fools
listing_idInteger7
main_listingBooleanNo
trackInteger15
sourcePage
lengthString5:00
FieldField typeValue
songStringAva Adore
song_page_titleStringAva Adore
workStringAdore
headlineString2014 Reissue CD 6: Kissed Alive Too
listing_idInteger8
main_listingBooleanNo
trackInteger1
sourcePage
lengthString4:47
FieldField typeValue
songStringDaphne Descends
song_page_titleStringDaphne Descends
workStringAdore
headlineString2014 Reissue CD 6: Kissed Alive Too
listing_idInteger8
main_listingBooleanNo
trackInteger2
sourcePage
lengthString4:27
FieldField typeValue
songStringThe Tale of Dusty and Pistol Pete
song_page_titleStringThe Tale of Dusty and Pistol Pete
workStringAdore
headlineString2014 Reissue CD 6: Kissed Alive Too
listing_idInteger8
main_listingBooleanNo
trackInteger3
sourcePage
lengthString4:42
FieldField typeValue
songStringTear
song_page_titleStringTear
workStringAdore
headlineString2014 Reissue CD 6: Kissed Alive Too
listing_idInteger8
main_listingBooleanNo
trackInteger4
sourcePage
lengthString7:01
FieldField typeValue
songStringShame
song_page_titleStringShame
workStringAdore
headlineString2014 Reissue CD 6: Kissed Alive Too
listing_idInteger8
main_listingBooleanNo
trackInteger5
sourcePage
lengthString4:19
FieldField typeValue
songStringBlank Page
song_page_titleStringBlank Page
workStringAdore
headlineString2014 Reissue CD 6: Kissed Alive Too
listing_idInteger8
main_listingBooleanNo
trackInteger6
sourcePage
lengthString7:52
FieldField typeValue
songStringTo Sheila
song_page_titleStringTo Sheila
workStringAdore
headlineString2014 Reissue CD 6: Kissed Alive Too
listing_idInteger8
main_listingBooleanNo
trackInteger7
sourcePage
lengthString7:16
FieldField typeValue
songStringMoney (That's What I Want)
song_page_titleStringMoney (That's What I Want)
workStringAdore
headlineString2014 Reissue CD 6: Kissed Alive Too
listing_idInteger8
main_listingBooleanNo
trackInteger8
sourcePage
lengthString3:30
FieldField typeValue
songStringX.Y.U.
song_page_titleStringX.Y.U.
workStringAdore
headlineString2014 Reissue CD 6: Kissed Alive Too
listing_idInteger8
main_listingBooleanNo
trackInteger9
sourcePage
lengthString11:19
FieldField typeValue
songStringThe Ethers Tragic
song_page_titleStringThe Ethers Tragic
workStringAdore
headlineString2014 Reissue CD 6: Kissed Alive Too
listing_idInteger8
main_listingBooleanNo
trackInteger9
sourcePage
lengthString
FieldField typeValue
songStringNever Say Never
song_page_titleStringNever Say Never
workStringAdore
headlineString2014 Reissue CD 6: Kissed Alive Too
listing_idInteger8
main_listingBooleanNo
trackInteger9
sourcePage
lengthString
FieldField typeValue
songStringWhere Boys Fear to Tread
song_page_titleStringWhere Boys Fear to Tread
workStringAdore
headlineString2014 Reissue CD 6: Kissed Alive Too
listing_idInteger8
main_listingBooleanNo
trackInteger9
sourcePage
lengthString
FieldField typeValue
songStringTransmission
song_page_titleStringTransmission
workStringAdore
headlineString2014 Reissue CD 6: Kissed Alive Too
listing_idInteger8
main_listingBooleanNo
trackInteger10
sourcePage
lengthString12:51
FieldField typeValue
songStringTo Sheila
song_page_titleStringTo Sheila
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger1
sourcePage
lengthString7:11
FieldField typeValue
songStringBehold! The Night Mare
song_page_titleStringBehold! The Night Mare
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger2
sourcePage
lengthString5:16
FieldField typeValue
songStringPug
song_page_titleStringPug
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger3
sourcePage
lengthString5:06
FieldField typeValue
songStringCrestfallen
song_page_titleStringCrestfallen
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger4
sourcePage
lengthString4:30
FieldField typeValue
songStringAva Adore
song_page_titleStringAva Adore
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger5
sourcePage
lengthString5:41
FieldField typeValue
songStringTear
song_page_titleStringTear
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger6
sourcePage
lengthString9:59
FieldField typeValue
songStringAnnie-Dog
song_page_titleStringAnnie-Dog
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger7
sourcePage
lengthString4:27
FieldField typeValue
songStringPerfect
song_page_titleStringPerfect
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger8
sourcePage
lengthString3:35
FieldField typeValue
songStringThru the Eyes of Ruby
song_page_titleStringThru the Eyes of Ruby
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger9
sourcePage
lengthString10:15
FieldField typeValue
songStringTonight, Tonight
song_page_titleStringTonight, Tonight
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger10
sourcePage
lengthString4:19
FieldField typeValue
songStringOnce Upon a Time
song_page_titleStringOnce Upon a Time
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger11
sourcePage
lengthString4:37
FieldField typeValue
songStringThe Tale of Dusty and Pistol Pete
song_page_titleStringThe Tale of Dusty and Pistol Pete
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger12
sourcePage
lengthString10:20
FieldField typeValue
songStringBullet with Butterfly Wings
song_page_titleStringBullet with Butterfly Wings
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger13
sourcePage
lengthString5:30
FieldField typeValue
songStringShame
song_page_titleStringShame
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger14
sourcePage
lengthString9:17
FieldField typeValue
songStringFor Martha
song_page_titleStringFor Martha
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger15
sourcePage
lengthString8:25
FieldField typeValue
songStringBlank Page
song_page_titleStringBlank Page
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger16
sourcePage
lengthString9:48
FieldField typeValue
songStringTransmission
song_page_titleStringTransmission
workStringAdore
headlineString2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998
listing_idInteger9
main_listingBooleanNo
trackInteger17
sourcePage
lengthString25:52

"releases" values

12 rows are stored for this page
FieldField typeValue
workPageAdore
listing_idList of Integer, delimiter: ,1
release_dateDate1998-06-01
labelList of String, delimiter: ,Virgin Hut Recordings
catalog_idList of String, delimiter: ,7243 8 45879 2 5 CDHUT 51
formatList of String, delimiter: ,CD
countryStringEurope
discogsInteger12,965,344
musicbrainzStringdbb0bd27-50d3-4c5a-bfba-989a5926d944
FieldField typeValue
workPageAdore
listing_idList of Integer, delimiter: ,1
release_dateDate1998-06-01
labelList of String, delimiter: ,Virgin Hut Recordings
catalog_idList of String, delimiter: ,7243 8 45879 4 9 HUTMC 51
formatList of String, delimiter: ,Cassette
countryStringEurope
discogsInteger2,363,788
musicbrainzString
FieldField typeValue
workPageAdore
listing_idList of Integer, delimiter: ,1
release_dateDate1998-06-02
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,7243 8 45879 2 5
formatList of String, delimiter: ,CD
countryStringUS
discogsInteger1,383,202
musicbrainzString42cffa2b-7d68-37a5-a073-7e1d22998033
FieldField typeValue
workPageAdore
listing_idList of Integer, delimiter: ,1
release_dateDate1998-06-01
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,8458792
formatList of String, delimiter: ,CD
countryStringAustralia
discogsInteger1,820,569
musicbrainzStringb691145b-485f-4210-bd1c-249d5f25d1b1
FieldField typeValue
workPageAdore
listing_idList of Integer, delimiter: ,1
release_dateDate1998-08-18
labelList of String, delimiter: ,Caroline
catalog_idList of String, delimiter: ,7243 8 45879 1 8
formatList of String, delimiter: ,2LP
countryStringUS
discogsInteger445,653
musicbrainzString0d7d4f97-4405-4e1e-803d-593ec4249503
FieldField typeValue
workPageAdore
listing_idList of Integer, delimiter: ,1
release_dateDate1998-12-15
labelList of String, delimiter: ,Hut Recordings EMI
catalog_idList of String, delimiter: ,CDHUT 51 84587925
formatList of String, delimiter: ,CD VCD
countryStringHong Kong
discogsInteger1,638,574
musicbrainzString
FieldField typeValue
workPageAdore
listing_idList of Integer, delimiter: ,1
release_dateDate1998
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,72438 45879 4 9
formatList of String, delimiter: ,Cassette
countryStringUS
discogsInteger3,477,084
musicbrainzString
FieldField typeValue
workPageAdore
listing_idList of Integer, delimiter: ,2
release_dateDate1998-05-30
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,VJCP-25396
formatList of String, delimiter: ,CD
countryStringJapan
discogsInteger1,014,702
musicbrainzString5772e5e7-9447-4d43-a5fe-923fc203dd9a
FieldField typeValue
workPageAdore
listing_idList of Integer, delimiter: ,3
release_dateDate2014-09-23
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,6 02537 89926 5
formatList of String, delimiter: ,2LP
countryStringEurope
discogsInteger6,172,304
musicbrainzStringdcae11f6-16e0-4efc-9b14-9a6497ca6150
FieldField typeValue
workPageAdore
listing_idList of Integer, delimiter: ,3
release_dateDate2014-09-23
labelList of String, delimiter: ,Virgin UMe
catalog_idList of String, delimiter: ,B0021122-01 B0021122-01
formatList of String, delimiter: ,2LP
countryStringUS
discogsInteger6,179,457
musicbrainzString
FieldField typeValue
workPageAdore
listing_idList of Integer, delimiter: ,3 4 5 6 7 8 9
release_dateDate2014-09-23
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,B0020851-00
formatList of String, delimiter: ,6CD DVD
countryStringUS
discogsInteger6,129,768
musicbrainzString9200cd14-7ce3-4b41-93e2-795e66f76308
FieldField typeValue
workPageAdore
listing_idList of Integer, delimiter: ,3 4 5 6 7 8
release_dateDate2014-09-23
labelList of String, delimiter: ,Virgin
catalog_idList of String, delimiter: ,
formatList of String, delimiter: ,Digital
countryStringWorldwide
discogsInteger
musicbrainzStringdac5fc22-8ea7-4f21-87d1-1fb1da722212

"personnel_credits" values

24 rows are stored for this page
FieldField typeValue
personPageBilly Corgan
rolesList of String, delimiter: ,vocals guitar guitar piano keyboards production
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageJames Iha
rolesList of String, delimiter: ,guitar guitar vocals
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageD'arcy Wretzky
rolesList of String, delimiter: ,bass guitar
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageMatt Walker
rolesList of String, delimiter: ,drums
tracksList of Integer, delimiter: ,1 2 4 6 10 11 13
listing_idInteger1
FieldField typeValue
personPageRobbie Adams
rolesList of String, delimiter: ,engineering
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageChris Brickley
rolesList of String, delimiter: ,recording
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageFlood
rolesList of String, delimiter: ,
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageEric Greedy
rolesList of String, delimiter: ,
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageSteve Johnson
rolesList of String, delimiter: ,recording
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageRon Lowe
rolesList of String, delimiter: ,recording
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageJay Nicholas
rolesList of String, delimiter: ,
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageFrank Olinsky
rolesList of String, delimiter: ,
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageNeil Perry
rolesList of String, delimiter: ,engineering
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageMatt Prock
rolesList of String, delimiter: ,recording
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageChris Shepard
rolesList of String, delimiter: ,engineering
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageJamie Siegel
rolesList of String, delimiter: ,
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageBjorn Thorsrud
rolesList of String, delimiter: ,engineering
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageEd Tinley
rolesList of String, delimiter: ,recording
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageAndy Van Dette
rolesList of String, delimiter: ,
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageJeff Vereb
rolesList of String, delimiter: ,recording
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageHowie Weinberg
rolesList of String, delimiter: ,
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageHoward Willing
rolesList of String, delimiter: ,engineering
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageJohn Wydrycs
rolesList of String, delimiter: ,
tracksList of Integer, delimiter: ,
listing_idInteger
FieldField typeValue
personPageYelena Yemchuk
rolesList of String, delimiter: ,
tracksList of Integer, delimiter: ,
listing_idInteger

"album_charts" values

21 rows are stored for this page
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Australia

positionInteger1
dateDate1998-06-14
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Austria

positionInteger7
dateDate1998-06-28
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Flanders

positionInteger1
dateDate1998-06-13
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Wallonia

positionInteger8
dateDate1998-06-20
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

BillboardCanada

positionInteger2
dateDate1998-06-20
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Denmark

positionInteger4
dateDate
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Netherlands

positionInteger5
dateDate1998-06-13
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

European100

positionInteger1
dateDate1998-06-27
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Finland

positionInteger5
dateDate
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

France

positionInteger1
dateDate1998-06-06
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Germany4

positionInteger3
dateDate1998-06-15
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Italy

positionInteger3
dateDate1998-06-20
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

New Zealand

positionInteger1
dateDate1998-06-14
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Norway

positionInteger1
dateDate1998-06-08
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Portugal

positionInteger1
dateDate
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Scotland

positionInteger5
dateDate1998-06-07
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Spain2

positionInteger10
dateDate1998-06-10
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Sweden

positionInteger4
dateDate1998-06-12
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Switzerland

positionInteger13
dateDate1998-06-14
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

UK

positionInteger5
dateDate1998-06-13
FieldField typeValue
albumPageAdore
artistStringThe Smashing Pumpkins
chartWikitext string

Billboard200

positionInteger2
dateDate1998-06-20

"certifications" values

10 rows are stored for this page
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringAdore
typeStringalbum · single · videoalbum
awardStringPlatinum
numberInteger
regionStringAustralia
dateDate1998-06-15
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringAdore
typeStringalbum · single · videoalbum
awardStringPlatinum
numberInteger2
regionStringCanada
dateDate1998-09-09
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringAdore
typeStringalbum · single · videoalbum
awardStringGold
numberInteger
regionStringDenmark
dateDate1999
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringAdore
typeStringalbum · single · videoalbum
awardStringGold
numberInteger
regionStringFrance
dateDate1998
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringAdore
typeStringalbum · single · videoalbum
awardStringGold
numberInteger
regionStringJapan
dateDate1998
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringAdore
typeStringalbum · single · videoalbum
awardStringPlatinum
numberInteger
regionStringNew Zealand
dateDate
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringAdore
typeStringalbum · single · videoalbum
awardStringGold
numberInteger
regionStringNorway
dateDate1999
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringAdore
typeStringalbum · single · videoalbum
awardStringGold
numberInteger
regionStringSpain
dateDate1998
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringAdore
typeStringalbum · single · videoalbum
awardStringGold
numberInteger
regionStringUnited Kingdom
dateDate1998-09-25
FieldField typeAllowed valuesValue
artistStringThe Smashing Pumpkins
workStringAdore
typeStringalbum · single · videoalbum
awardStringPlatinum
numberInteger
regionStringUnited States
dateDate1998-07-08