View table: track_listings
Table structure:
- song - String (mandatory)
- song_page_title - String (mandatory)
- work - String (mandatory)
- headline - String
- listing_id - Integer
- main_listing - Boolean
- track - Integer
- source - Page
- length - String
This table has 3,183 rows altogether.
| Page | song | song page title | work | headline | listing id | main listing | track | source | length |
|---|---|---|---|---|---|---|---|---|---|
| ...This Would Be Paradise (edit) | The Key | The Key | ...This Would Be Paradise | 1 | No | 1 | 3:56 | ||
| ...This Would Be Paradise (edit) | This Would Be Paradise | This Would Be Paradise (song) | ...This Would Be Paradise | 1 | No | 3 | 2:46 | ||
| ...This Would Be Paradise (edit) | Willing Enabler | Willing Enabler | ...This Would Be Paradise | 1 | No | 2 | 4:16 | ||
| 1979 (edit) | 1979 | 1979 | 1979 | 1979 Mixes | 4 | No | 1 | 5:08 | |
| 1979 (edit) | 1979 | 1979 | 1979 | 1979 Mixes | 4 | No | 4 | 4:40 | |
| 1979 (edit) | 1979 | 1979 | 1979 | 1979 Mixes | 4 | No | 3 | 6:39 | |
| 1979 (edit) | 1979 | 1979 | 1979 | 1979 Mixes | 4 | No | 2 | 5:17 | |
| 1979 (edit) | 1979 | 1979 | 1979 | 1996 Re-issue/Max-CD | 2 | No | 1 | 4:24 | |
| 1979 (edit) | 1979 | 1979 | 1979 | UK/US CD single/UK 12" | 1 | No | 1 | 4:24 | |
| 1979 (edit) | 1979 | 1979 | 1979 | US 7" double A-side single | 3 | No | 1 | 4:24 | |
| 1979 (edit) | Believe | Believe | 1979 | 1996 Re-issue/Max-CD | 2 | No | 5 | 3:15 | |
| 1979 (edit) | Believe | Believe | 1979 | UK/US CD single/UK 12" | 1 | No | 3 | 3:15 | |
| 1979 (edit) | Bullet with Butterfly Wings | Bullet with Butterfly Wings | 1979 | US 7" double A-side single | 3 | No | 2 | 4:16 | |
| 1979 (edit) | Cherry | Cherry | 1979 | 1996 Re-issue/Max-CD | 2 | No | 4 | 4:02 | |
| 1979 (edit) | Cherry | Cherry | 1979 | UK/US CD single/UK 12" | 1 | No | 4 | 4:02 | |
| 1979 (edit) | Set The Ray To Jerry | Set The Ray To Jerry | 1979 | 1996 Re-issue/Max-CD | 2 | No | 6 | 4:10 | |
| 1979 (edit) | The Boy | The Boy | 1979 | 1996 Re-issue/Max-CD | 2 | No | 3 | 3:04 | |
| 1979 (edit) | Ugly | Ugly | 1979 | 1996 Re-issue/Max-CD | 2 | No | 2 | 2:28 | |
| 1979 (edit) | Ugly | Ugly | 1979 | UK/US CD single/UK 12" | 1 | No | 2 | 2:28 | |
| 20 Explosive Dynamic Super Smash Hit Explosions! (edit) | Jackie Blue | Jackie Blue | 20 Explosive Dynamic Super Smash Hit Explosions! | 1 | No | 3 | 3:51 | ||
| 23 Minutes (edit) | Cherub Rock | Cherub Rock | 23 Minutes | 1 | No | 3 | |||
| 23 Minutes (edit) | Disarm | Disarm | 23 Minutes | 1 | No | 5 | |||
| 23 Minutes (edit) | Rhinoceros | Rhinoceros | 23 Minutes | 1 | No | 2 | |||
| 23 Minutes (edit) | Siva | Siva | 23 Minutes | 1 | No | 1 | |||
| 23 Minutes (edit) | Today | Today | 23 Minutes | 1 | No | 4 | |||
| 3 Feet High (edit) | Cherub Rock | Cherub Rock | 3 Feet High | 1 | No | 8 | 4:42 | ||
| 3 Feet High (edit) | Disarm | Disarm | 3 Feet High | 1 | No | 7 | 3:14 | ||
| 3 Feet High (edit) | Geek U.S.A. | Geek U.S.A. | 3 Feet High | 1 | No | 5 | 5:17 | ||
| 3 Feet High (edit) | Hummer | Hummer | 3 Feet High | 1 | No | 9 | 7:04 | ||
| 3 Feet High (edit) | I Am One | I Am One | 3 Feet High | 1 | No | 6 | 4:14 | ||
| 3 Feet High (edit) | Mayonaise | Mayonaise | 3 Feet High | 1 | No | 11 | 6:39 | ||
| 3 Feet High (edit) | Quiet | Quiet | 3 Feet High | 1 | No | 2 | 3:29 | ||
| 3 Feet High (edit) | Rhinoceros | Rhinoceros | 3 Feet High | 1 | No | 4 | 4:35 | ||
| 3 Feet High (edit) | Rocket | Rocket | 3 Feet High | 1 | No | 1 | 4:19 | ||
| 3 Feet High (edit) | Silverfuck | Silverfuck | 3 Feet High | 1 | No | 10 | 11:54 | ||
| 3 Feet High (edit) | Today | Today | 3 Feet High | 1 | No | 3 | 3:22 | ||
| 666 (edit) | Funk Jam | Funk Jam | 666 | 1 | No | 2 | 1:14 | ||
| 666 (edit) | Porcelina of the Vast Oceans | Porcelina of the Vast Oceans | 666 | 1 | No | 5 | 8:40 | ||
| 666 (edit) | The Black Rider | The Black Rider | 666 | 1 | No | 10 | 2:56 | ||
| 666 (edit) | The Viper | The Viper | 666 | 1 | No | 1 | 4:51 | ||
| 666 (edit) | Thru the Eyes of Ruby | Thru the Eyes of Ruby | 666 | 1 | No | 9 | 4:09 | ||
| 666 (edit) | Tribute to Johnny | Tribute to Johnny | 666 | 1 | No | 3 | 4:43 | ||
| 666 (edit) | V-8 | V-8 | 666 | 1 | No | 12 | 4:01 | ||
| 666 (edit) | Where Boys Fear to Tread | Where Boys Fear to Tread | 666 | 1 | No | 4 | 1:03 | ||
| 666 (edit) | X.Y.U. | X.Y.U. | 666 | 1 | No | 6 | 4:10 | ||
| 666 (edit) | X.Y.U. | X.Y.U. | 666 | 1 | No | 11 | 5:51 | ||
| 666 (edit) | Zero | Zero | 666 | 1 | No | 14 | 4:09 | ||
| 666 (edit) | Zero | Zero | 666 | 1 | No | 13 | 1:10 | ||
| 666 (edit) | Zero | Zero | 666 | 1 | No | 7 | 2:14 | ||
| 666 (edit) | Zero | Zero | 666 | 1 | No | 8 | 3:27 | ||
| A Gothic–Industrial Tribute to Smashing Pumpkins (edit) | 1979 | 1979 | A Gothic–Industrial Tribute to Smashing Pumpkins | 1 | No | 8 | 4:59 | ||
| A Gothic–Industrial Tribute to Smashing Pumpkins (edit) | Ava Adore | Ava Adore | A Gothic–Industrial Tribute to Smashing Pumpkins | 1 | No | 2 | 4:23 | ||
| A Gothic–Industrial Tribute to Smashing Pumpkins (edit) | Bullet with Butterfly Wings | Bullet with Butterfly Wings | A Gothic–Industrial Tribute to Smashing Pumpkins | 1 | No | 3 | 4:32 | ||
| A Gothic–Industrial Tribute to Smashing Pumpkins (edit) | Cherub Rock | Cherub Rock | A Gothic–Industrial Tribute to Smashing Pumpkins | 1 | No | 6 | 4:59 | ||
| A Gothic–Industrial Tribute to Smashing Pumpkins (edit) | Disarm | Disarm | A Gothic–Industrial Tribute to Smashing Pumpkins | 1 | No | 5 | 3:34 | ||
| A Gothic–Industrial Tribute to Smashing Pumpkins (edit) | Eye | Eye | A Gothic–Industrial Tribute to Smashing Pumpkins | 1 | No | 11 | 4:52 | ||
| A Gothic–Industrial Tribute to Smashing Pumpkins (edit) | Frail and Bedazzled | Frail and Bedazzled | A Gothic–Industrial Tribute to Smashing Pumpkins | 1 | No | 9 | 3:20 | ||
| A Gothic–Industrial Tribute to Smashing Pumpkins (edit) | God | God | A Gothic–Industrial Tribute to Smashing Pumpkins | 1 | No | 7 | 3:24 | ||
| A Gothic–Industrial Tribute to Smashing Pumpkins (edit) | Rhinoceros | Rhinoceros | A Gothic–Industrial Tribute to Smashing Pumpkins | 1 | No | 1 | 4:59 | ||
| A Gothic–Industrial Tribute to Smashing Pumpkins (edit) | Soma | Soma | A Gothic–Industrial Tribute to Smashing Pumpkins | 1 | No | 12 | 4:33 | ||
| A Gothic–Industrial Tribute to Smashing Pumpkins (edit) | The End Is the Beginning Is the End | The End Is the Beginning Is the End | A Gothic–Industrial Tribute to Smashing Pumpkins | 1 | No | 4 | 4:53 | ||
| A Gothic–Industrial Tribute to Smashing Pumpkins (edit) | Today | Today | A Gothic–Industrial Tribute to Smashing Pumpkins | 1 | No | 10 | 4:59 | ||
| A Gothic–Industrial Tribute to Smashing Pumpkins (edit) | Zero | Zero | A Gothic–Industrial Tribute to Smashing Pumpkins | 1 | No | 13 | 3:50 | ||
| A Song for a Son (edit) | A Song for a Son | A Song for a Son | A Song for a Son | MP3 release | 1 | No | 1 | 6:03 | |
| A Stitch in Time (edit) | A Stitch in Time | A Stitch in Time | A Stitch in Time | Astral Planes / A Stitch In Time | 1 | No | 2 | 3:33 | |
| A Stitch in Time (edit) | A Stitch in Time | A Stitch in Time | A Stitch in Time | MP3 release | 2 | No | 1 | 3:33 | |
| A Stitch in Time (edit) | Astral Planes | Astral Planes | A Stitch in Time | Astral Planes / A Stitch In Time | 1 | No | 1 | 4:05 | |
| A Very Special Christmas 3 (edit) | Christmastime | Christmastime | A Very Special Christmas 3 | 1 | No | 2 | 3:16 | ||
| Acoustic Series (edit) | Blue | Blue | Acoustic Series | 1 | No | 8 | The Smashing Pumpkins 1991-10-22 (Atomic Records) | 3:33 | |
| Acoustic Series (edit) | Cherub Rock | Cherub Rock | Acoustic Series | 1 | No | 9 | The Smashing Pumpkins 1993-12-12 | 4:27 | |
| Acoustic Series (edit) | Dancing in the Moonlight | Dancing in the Moonlight | Acoustic Series | 1 | No | 1 | The Smashing Pumpkins 1993-06-30 | 4:09 | |
| Acoustic Series (edit) | Disarm | Disarm | Acoustic Series | 1 | No | 11 | |||
| Acoustic Series (edit) | Disarm | Disarm | Acoustic Series | 1 | No | 3 | The Smashing Pumpkins 1993-06-30 | 3:18 | |
| Acoustic Series (edit) | Disarm / Sunshine Of Your Love | Disarm / Sunshine Of Your Love | Acoustic Series | 1 | No | 11 | The Smashing Pumpkins 1993-09-XX (London, UK) | 3:21 | |
| Acoustic Series (edit) | Hummer | Hummer | Acoustic Series | 1 | No | 7 | The Smashing Pumpkins 1993-07-26 | 6:46 | |
| Acoustic Series (edit) | Mayonaise | Mayonaise | Acoustic Series | 1 | No | 4 | The Smashing Pumpkins 1993-07-26 | 5:06 | |
| Acoustic Series (edit) | Rocket | Rocket | Acoustic Series | 1 | No | 6 | The Smashing Pumpkins 1993-07-26 | 4:48 | |
| Acoustic Series (edit) | Spaceboy | Spaceboy | Acoustic Series | 1 | No | 5 | The Smashing Pumpkins 1993-06-30 | 4:02 | |
| Acoustic Series (edit) | Sunshine of Your Love | Sunshine of Your Love | Acoustic Series | 1 | No | 11 | |||
| Acoustic Series (edit) | Today | Today | Acoustic Series | 1 | No | 10 | The Smashing Pumpkins 1993-12-12 | 3:14 | |
| Acoustic Series (edit) | Today | Today | Acoustic Series | 1 | No | 2 | The Smashing Pumpkins 1993-07-26 | 3:25 | |
| Adore (edit) | 17 | 17 | Adore | 2014 Reissue CD 1: ''Adore'' Stereo Remastered | 3 | No | 16 | 0:19 | |
| Adore (edit) | 17 | 17 | Adore | Main release | 1 | Yes | 16 | 0:17 | |
| Adore (edit) | Annie-Dog | Annie-Dog | Adore | 2014 Reissue CD 1: ''Adore'' Stereo Remastered | 3 | No | 11 | 3:38 | |
| Adore (edit) | Annie-Dog | Annie-Dog | Adore | 2014 Reissue CD 2: ''Adore'' Mono Remastered | 4 | No | 11 | 3:39 | |
| Adore (edit) | Annie-Dog | Annie-Dog | Adore | 2014 Reissue CD 3: In a State of Passage | 5 | No | 12 | February 1997 – Chicago Recording Company | 3:25 |
| Adore (edit) | Annie-Dog | Annie-Dog | Adore | 2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998 | 9 | No | 7 | 4:27 | |
| Adore (edit) | Annie-Dog | Annie-Dog | Adore | Main release | 1 | Yes | 11 | 3:38 | |
| Adore (edit) | Appels + Oranjes | Appels + Oranjes | Adore | 2014 Reissue CD 1: ''Adore'' Stereo Remastered | 3 | No | 8 | 3:35 | |
| Adore (edit) | Appels + Oranjes | Appels + Oranjes | Adore | 2014 Reissue CD 2: ''Adore'' Mono Remastered | 4 | No | 8 | 3:39 | |
| Adore (edit) | Appels + Oranjes | Appels + Oranjes | Adore | Main release | 1 | Yes | 8 | 3:35 | |
| Adore (edit) | Ava Adore | Ava Adore | Adore | 2014 Reissue CD 1: ''Adore'' Stereo Remastered | 3 | No | 2 | 4:30 | |
| Adore (edit) | Ava Adore | Ava Adore | Adore | 2014 Reissue CD 2: ''Adore'' Mono Remastered | 4 | No | 2 | 4:24 | |
| Adore (edit) | Ava Adore | Ava Adore | Adore | 2014 Reissue CD 4: Chalices, Palaces and Deep Pools | 6 | No | 4 | 4:37 | |
| Adore (edit) | Ava Adore | Ava Adore | Adore | 2014 Reissue CD 6: Kissed Alive Too | 8 | No | 1 | 4:47 | |
| Adore (edit) | Ava Adore | Ava Adore | Adore | 2014 Reissue DVD: Fox Theater, Atlanta, GA – August 4, 1998 | 9 | No | 5 | 5:41 | |
| Adore (edit) | Ava Adore | Ava Adore | Adore | Main release | 1 | Yes | 2 | 4:21 | |
| Adore (edit) | Because You Are | Because You Are | Adore | 2014 Reissue CD 5: Malice, Callous and Fools | 7 | No | 4 | 3:51 | |
| Adore (edit) | Behold! The Night Mare | Behold! The Night Mare | Adore | 2014 Reissue CD 1: ''Adore'' Stereo Remastered | 3 | No | 13 | 5:12 | |
| Adore (edit) | Behold! The Night Mare | Behold! The Night Mare | Adore | 2014 Reissue CD 2: ''Adore'' Mono Remastered | 4 | No | 13 | 5:12 |