All pastes #552013 Raw Edit

Mine

public text v1 · immutable
·published 2007-06-09 01:49 UTC
rendered paste body
# select artist,title,count(title) from playlist group by artist,title order by count(*) desc;
            artist            |            title             | count 
------------------------------+------------------------------+-------
 Old Crow Medicine Show       | Wagon Wheel                  |   283
 Son Volt                     | Medication                   |   254
 Reckless Kelly               | Wicked Twisted Road          |   236
 Stephen Stills               | Drivin Thunder               |   234
 William Topley               | High On The Rhythm           |   225
 Susan Tedeschi               | Tired of my tears            |   215
 John Prine                   | Crazy As A Loon              |   202
 Bruce Springsteen            | All I'm Thinking About       |   196
                              |                              |   194
 Will Ray                     | Santa Cruzin                 |   190
 Toots And The Maytals        | Still Is Still Moving To Me  |   184
 Mark Knopfler                | Postcards From Paraguay      |   184
 Shawn Mullins                | Talkin' Goin' To Alaska Blue |   182
 Rodney Crowell               | Fate's Right Hand            |   180
 Rodney Crowell               | Don't Get Me Started         |   180
 Stephen Bruton               | Bigger Wheel                 |   178
 Jack Johnson                 | Good People                  |   177
 John Prine                   | Bear Creek Blues             |   174
 Ryan Adams                   | Let It Ride                  |   173
 Bonnie Raitt                 | I Will Not Be Broken         |   173
 Cracker                      | Something You Ain't Got      |   169
 Jackie Greene                | I'm So Gone                  |   168
 Jayhawks                     | Come To The River            |   166
 Nickel Creek                 | When In Rome                 |   165
 Stephen Stills               | Feed The People              |   165
 Ben Harper                   | Gather 'Round The Stone      |   164
 Chris Hillman                | I'm Still Alive              |   164
 Reckless Kelly               | Motel Cowboy Show            |   162
 Sonia Dada                   | Diggin' On The Road          |   162
 Lowen & Navrro               | Devils In The Details        |   162
 Keb Mo                       | Whole 'Nutha Thing           |   162
 John Hiatt                   | Back On The Corner           |   160
 Madeleine Peyroux            | Don't Wait Too Long          |   160
 Laura Love                   | Freak Flag                   |   160
 Derek Trucks Band            | I Wish I Knew                |   158
 Leo Kottke                   | Living In The Country        |   157
 William Topley               | Sea Fever                    |   157
 Widespread Panic             | Ain't Life Grand             |   157
 Van Morrison                 | Keep Mediocrity At Bay       |   156
 James Mcmurtry               | Choctaw Bingo                |   155
 Los Super Seven              | Heard It On The X            |   155
 Bruce Springsteen            | Devils & Dust                |   155
 Randy Scruggs                | Passin' Thru                 |   154
 Widespread Panic             | Ribs And Whiskey             |   152
 Trout Fishing In America     | Not Fade Away                |   151
 Dave Alvin                   | Ashgrove                     |   149
 Ry Cooder                    | 3 Cool Cats                  |   149
 Little Charlie & The Nightca | Got To Have A Job            |   148
 Derek Trucks Band            | I'd Rather Be Blind, Cripple |   148
 Hayes Carll                  | Down The Road Tonight*       |   148
 Led Kaapana And The Original | Pipeline                     |   148
 Los Lonely Boys              | Diamonds                     |   148
 Jim Mills                    | I Want A Woman Who Can Mow   |   147
 Peter Wolf                   | Nothing But The Wheel        |   146
 Railroad Earth               | Long Way To Go               |   145
 Jerry Douglas                | She Makes Me Want To Sing    |   145
 Kevin Welch                  | Life Down Here On Earth      |   144
 Ry Cooder                    | Poor Man's Shangri-la        |   144
 Stephen Stills               | 'Round The bend'             |   143
 Xavier Rudd                  | Let Me Be                    |   142
 Van Morrison                 | Gypsy In My Soul             |   142
 Los Lonely Boys              | Outlaws                      |   142
 Angela Strehli               | Hello My Lover               |   142
 Blasters                     | Daddy Rollin' Stone          |   140
 Ray Wylie Hubbard            | Snake Farm                   |   140
 Notorious Cherry Bombs       | It's Hard To Kiss The Lips A |   139
 James Mcmurtry               | We Can't Make It Here        |   139
 Mark Knopfler                | Boom Like That               |   137
 Sonia Dada                   | Ain't Life For The Living    |   137
 Boz Scaggs                   | Fly Like A Bird              |   135
 Jimmy Lafave                 | Bohemian Cowboy Blues        |   134
 Steve Ripley                 | Gone Away                    |   133
 Rodney Crowell               | Say You Love Me              |   133
 Robert Randolph              | Going In The Right Direction |   133
 Madeleine Peyroux            | Dance Me To The End Of Love  |   132
 Solomon Burke                | None Of Us Are Free          |   131
 Paul Thorn                   | Everybody Looks Good         |   131
 Susan Tedeschi               | You Got The Silver           |   130
 Kevin Welch                  | Long Cold Train              |   129
 Rodney Crowell               | Dancin' Circles Round The Su |   129
 Richard Thompson             | 1952 Vincent Black Lightning |   129
 Bruce Springsteen            | All The Way Home             |   128
 John Prine                   | Some Humans Ain't Human (Edi |   127
 Stray Cats                   | Mystery Train Kept A Rollin' |   126
 Bodeans                      | Good Work                    |   125
 Dion                         | Walkin' Blues                |   125
 Ozark Mountain Daredevils    | Standin' On The Rock         |   125
 Darrell Scott                | Let's Call It A Life         |   124
 Susan Tedeschi               | Evidence                     |   124
 Seconds Flat                 | Dance On My Grave            |   124
 Robert Earl Keen             | Ride                         |   124
 Pete Anderson                | Where The Crows Go           |   124
 Black Rebel Motorcycle Club  | Ain't No Easy Way            |   124
 Trailer Park Troubadours     | Prozac Made Me Stay          |   123
 R.B. Morris                  | Hell On A Poor Boy           |   123
 Son Volt                     | Joe Citizen Blues            |   122
 John Jorgenson               | Man Of Mystery               |   122
 Bruce Springsteen            | Pay Me My Money Down         |   121
 Tracy Chapman                | Change                       |   120
 Subdudes                     | Papa Dukie And The Mud Peopl |   120
 Bruce Cockburn               | Different When It Comes To Y |   119
 Hayes Carll                  | Good Friends                 |   119
 Subdudes                     | Social Aid & Pleasure Club   |   118
 Slaid Cleaves                | Drinkin' Days                |   118
 Mark Broussard               | Home                         |   118
 Darrell Scott                | It's A Great Day To Be Alive |   118
 Elvin Bishop                 | I'll Be Glad                 |   118
 Bruce Cockburn               | Let The Bad Air Out          |   117
 Toni Price                   | Funky                        |   116
 Buddy Miller                 | Worry Too Much               |   116
 Pete Anderson                | Working Class                |   116
 Edwin Mccain                 | Lost In America - piggy edit |   116
 Michael Franti               | Yes I will                   |   115
 Blind Boys Of Alabama        | Higher Ground                |   115
 Chuck Brodsky                | No More Mr. Nice Guy         |   115
 Steve Earle                  | Copperhead Road              |   115
 Notorious Cherry Bombs       | Let It Roll Let It Ride      |   114
 Storyville                   | Good Day For The Blues       |   114
 Bruce Cockburn               | Slow Down Fast               |   114
 Kathleen Edwards             | Back To Me                   |   114
 Tim O'Brien                  | Hold On                      |   114
 Alison Krauss                | Restless                     |   114
 Tom Waits                    | Long Way Home                |   114
 Keith Greeninger             | Take You To The Mountian     |   114
 Billy Joe Shaver             | Live Forever                 |   113
 Graham Parker                | There's Nothing On The Radio |   113
 Steve Earle                  | Transcendental Blues         |   113
 Mark Knopfler and Emmy Lou H | This Is Us                   |   112
 Ray Wylie Hubbard            | Conversation With The Devil  |   112
 Hellecasters                 | Peter Gunn                   |   112
 Jackie Greene                | Hollywood                    |   112
 Keith Greeninger             | Something Worth Keeping      |   111
 Jackie Greene                | Gone Wanderin'               |   111
 Waterboys                    | Fisherman's Blues            |   110
 Bob Dylan                    | Maggie's Farm                |   110
 Robert Randolph              | Squeeze                      |   110
 Bonnie Raitt                 | Unnecessarily Mercenary      |   109
 Ray Charles                  | Busted                       |   109
 Marshall Tucker Band         | Desert Skies                 |   108
 B.B. King                    | Rock This House              |   108
 Graham Parker                | Dislocated Life              |   108
 Eliza Gilkyson               | Man Of God                   |   108
 Rodney Crowell               | Obscenity Prayer (Give It To |   108
 Los Lonely Boys              | Texican Style                |   108
 Mark Knopfler                | Our Shangri-La               |   107
 Kieran Kane                  | Everybody's Working For The  |   107
 Derek Trucks Band            | Crow Jane                    |   107
 Todd Snider                  | Enjoy Yourself               |   107
 John Cowan                   | Carla's Got A New Tattoo     |   107
 Devil Makes Three            | Never Learn                  |   107
 John Hiatt                   | Cold River                   |   106
 Jayhawks                     | Wichita                      |   106
 Taj Mahal                    | Freedom Ride                 |   106
 Blackie And The Rodeo Kings  | Swinging From The Chains Of  |   106
 John Hiatt                   | Master Of Disaster           |   106
 Jonny Lang                   | Wander This World            |   106
 Mike Beck                    | OilDale                      |   105
 Charlie Musselwhite          | Church Is Out                |   105
 Blackie And The Rodeo Kings  | Water Or Gasoline            |   105
 Sam Bush                     | New Country                  |   104
 Indigenous                   | Number Nine Train            |   104
 Waifs                        | Lighthouse                   |   104
 Jack Johnson                 | Sitting, Waiting, Wishing    |   104
 Neville Brothers             | Rivers Of Babylon            |   103
 Jimmy Lafave                 | This Glorious Day            |   103
 Ray Wylie Hubbard            | Heartaches And Grease        |   103
 K.T. Tunstall                | Black Horse and the Cherry T |   103
 Mavericks                    | Dance The Night Away         |   102
 Jackie Greene                | Mexican Girl                 |   102
 Alison Krauss                | Can't Find My Way Home       |   102
 Roy Orbison                  | Pretty Woman                 |   102
 Pops Staples                 | World In Motion              |   101
 Kieran Kane & Kevin Welch    | Postcard From Mexico         |   101
 Tom Petty                    | Saving grace                 |   101
 Charlie Musselwhite          | Que Te Parece Cholita        |   100
 James Mcmurtry               | Childish Things              |   100
 Kevin Welch                  | I Feel Fine Today            |   100
 Lucinda Williams             | Righteously                  |   100
 John Prine                   | Ain't Hurtin' Nobody         |   100
 Jimmy Cliff                  | You Can Get It If You Really |    99
 Tom Russell                  | Stealing Electricity         |    99
 String Cheese Incident       | Sometimes A River            |    99
 Stephen Stills               | Wounded World                |    99
 Van Morrison                 | Till Gain Control Again      |    99
 Johnny Cash                  | Rusty Cage                   |    99
 Junior Brown                 | Surf Medley                  |    99
 Glen Phillips                | Duck And Cover               |    99
 North Mississippi Allstars   | Freedom Highway              |    99
 Sam Bush                     | Stingray                     |    99
 Son Volt                     | Gramophone                   |    98
 Jerry Douglas                | Swing Blues                  |    98
 Little Willies               | Best of All Possible Worlds  |    98
 James Mcmurtry               | Lights Of Cheyenne           |    98
 Traveling Wilburys           | End Of The Line              |    97
 Stephen Bruton               | Ordinary Man                 |    97
 Jimmy Lafave                 | Music From The Motor Court   |    97
 Canned Heat                  | Rollin' And Tumblin'         |    97
 Mary Gauthier                | Mercy Now                    |    97
 Shawn Mullins                | Blue As You                  |    97
 Widespread Panic             | Crazy                        |    97
 Fraternity Of Man            | Don't Bogart Me              |    97
 Little Feat                  | Willin'                      |    97
 Johnny Winter                | Lone Wolf                    |    96
 Elvin Bishop                 | What The Hell Is Going On    |    96
 Little Feat                  | Let It Roll                  |    96
 De sol                       | Blanco y Negro               |    96
 Michelle Shocked             | If Love Was A Train          |    96
 Lucinda Williams             | Hot Blood                    |    95
 Peter Case                   | Blind Luck                   |    95
 Willie Nelson                | I'm A Worried Man            |    95
 Jeffery Foucault             | Mesa, Arizona                |    95
 Buddy Guy                    | Change In The Weather        |    95
 Lucinda Williams             | Can't Let Go                 |    95
 Popa Chubby                  | If The Diesel Don't Get You  |    95
 Bonnie Raitt                 | Gnawin' On It                |    94
 John Fogerty                 | Honey Do                     |    94
 Little Feat                  | Rocket In My Pocket          |    94
 Jackson Browne               | Lives In The Balance         |    94
 Leo Kottke                   | World Turning                |    94
 Charlie Musselwhite          | Clarksdale Boogie            |    93
 Stephen Bruton               | Right On Time                |    93
 Stephen Bruton               | Spirit World                 |    93
 Los Lonely Boys              | My Way                       |    93
 Widespread Panic             | Coconut                      |    93
 Anders Osborne               | Favorite Son                 |    92
 Hillman Pedersen Buffalo Ban | You Ain't Going No Where     |    92
 Cracker                      | Where Have Those Days Gone   |    92
 Elvis Costello               | Monkey To Man                |    92
 Mark Knopfler and Emmy Lou H | Beachcombing                 |    92
 Savoy Brown                  | Meat Shaking Woman           |    92
 Bruce Springsteen            | John Henry                   |    92
 Waybacks                     | Mind Your Own Business       |    92
 Todd Snider                  | Looking For A Job            |    92
 Richard Thompson             | Let It Blow                  |    92
 Sting                        | Fill Her Up                  |    92
 Delbert Mcclinton            | One Of The Fortunate Few     |    91
 Mary Gauthier                | Wheel Inside The Wheel       |    91
 Tony Joe White               | Shaking The Blues            |    91
 Rodney Crowell               | Earthbound                   |    91
 John Prine                   | In Spite Of Ourselves        |    91
 Joe Ely                      | Wind's Gonna Blow You Away   |    91
 James Hunter                 | People Gonna Talk            |    91
 Chris Isaak                  | Baby Did A Bad Bad Thing     |    91
 Natalie Merchant             | Build A Levee                |    91
 Subdudes                     | Keep My Feet Upon The Ground |    91
 Subdudes                     | Maybe You Think              |    91
 B.B. King                    | Tired Of Your Jive           |    91
 Hellecasters                 | Danger Man                   |    91
 Steve Earle                  | Hard Core Troubadour         |    91
 JJ Cale & Eric Clapton       | Ride The River               |    90
 Sherry Austin                | I Wouldn't Lie To You        |    90
 Paul Thorn                   | Rise Up                      |    90
 Indigenous                   | Things We Do                 |    90
 Butch Hancock                | Welcome To The Real World Ki |    90
 Stevie Ray Vaughn            | Life By The Drop             |    89
 Bill Kirchen                 | Hot Rod Lincoln              |    89
 Allman Brothers              | Revival                      |    89
 Bob Dylan                    | The Levee's Gonna Break      |    89
 Etta James                   | Hawg For Ya                  |    89
 Subdudes                     | All The Time In The World    |    89
 Solomon Burke                | Good Rockin' Tonight         |    89
 Madeleine Peyroux            | Careless Love                |    89
 John Fogerty                 | Nobody's Here Anymore        |    89
 Paul Thorn                   | Mission Temple Fireworks Sta |    89
 Big House                    | Buck These Haggard Blues     |    89
 John Prine                   | Long Monday                  |    89
 Whiskeytown                  | 16 Days                      |    89
 Little Richard               | Get Rhythm                   |    89
 Jerry Lee Lewis              | Pink Cadillac                |    89
 Dead Reckoners               | Workin' On It                |    89
 Jesse Colin Young            | Sugar Babe                   |    89
 Southern Culture On The Skid | Camel Walk                   |    88
 Jimmy Lafave                 | Bad Bad Girl                 |    88
 Tony Joe White               | Not One Bad Thought          |    88
 Mumbo Gumbo                  | Something In The Water       |    87
 Johnny Winter                | I Smell Smoke                |    87
 Robert Radolph               | The Thrill Of It             |    87
 John Hammond                 | Get Behind The Mule          |    87
 Keb Mo                       | Soon As I Get Paid           |    87
 Austin Lounge Lizards        | Life Is Hard But Life Is Har |    87
 Bob Marley                   | Get Up Stand Up              |    87
 George Thorogood & The Destr | Don't Let The Boss Get You D |    87
 Little Willies               | Roll On                      |    87
 Tim O'Brien                  | Less & Less                  |    87
 Roy Rogers                   | My Lost Home In Your Arms    |    87
 Rusted Root                  | Send Me On My Way            |    87
 Widespread Panic             | Time Zones                   |    87
 Michael Franti And Spearhead | I Know I'm Not Alone         |    87
 Bonnie Raitt                 | Trinkets                     |    86
 String Cheese Incident       | Joyful Sound                 |    86
 Dave Alvin                   | King Of California           |    86
 J.J. Cale                    | Call Me The Breeze           |    86
 Rory Block                   | Come On In My Kitchen        |    86
 Jim White                    | Handcuffed To A Fence In Mis |    86
 Freddy Jones Band            | In A Daydream                |    86
 Sam Bush                     | Same Ol' River               |    86
 Scott Miller                 | Wild Things                  |    86
 Bruce Cockburn               | A Dream Like Mine            |    86
 Kieran Kane                  | Cool Me Down                 |    86
 Anders Osborne               | Stoned Drunk And Naked       |    86
 Jonny Lang                   | Matchbox                     |    86
 Phish                        | Back On The Train            |    85
 John Lee Hooker              | Big Road                     |    85
 Charlie Robison              | Desperate Times              |    85
 John Eddie                   | Jesus Is Coming              |    85
 Robert Radolph               | Jesus Is Just Alright        |    85
 Dave Alvin                   | Nine Volt Heart              |    85
 Dr. John                     | Food For Thot                |    85
 Kenny Wayne Shepherd         | Blue On Black                |    85
 Jefferson Airplane           | Embryonic Journey            |    84
 Southern Culture On The Skid | Fried Chicken And Gasoline   |    84
 Travis Meyer                 | Devil Went Down To Jamaica   |    84
 Janis Joplin                 | Get It While You Can         |    84
 Elvis Costello               | Tears, Tears And More Tears  |    84
 Billy Joe Shaver             | Thunderbird                  |    84
 Delbert Mcclinton            | Same Kind Of Crazy           |    84
 Sonny Landreth               | Congo Square                 |    84
 Byrds                        | Wasn't Born To Follow        |    84
 Sam Bush                     | Mahavishnu Mountian Boys (Th |    84
 Dead Reckoners               | Rocky Road                   |    84
 Boneshakers                  | Cold Sweat                   |    84
 Mick Jagger                  | Wandering Spirit             |    84
 Paul Thorn                   | Aint Love Strange            |    84
 Lyle Lovett                  | My Baby Don't Tolerate       |    83
 John Mayall                  | Ain't No Brakeman            |    83
 Subdudes                     | Next To Me                   |    83
 Los Lonely Boys              | Crazy Dream                  |    83
 Hot Tuna                     | Water Song                   |    83
 Trailer Park Troubadours     | It's Ain't Home 'till You Ta |    83
 Devil Makes Three            | Judgement Day                |    83
 Sonny Landreth               | Juke Box Mama                |    83
 Richie Havens                | Here Comes The Sun           |    82
 Tom Petty                    | Flirting With Time           |    82
 John Mellencamp              | Joliet Bound                 |    82
 Richard Thompson             | Walking The Long Miles Home  |    82
 Allman Brothers              | Blue Sky                     |    82
 Jackie Greene                | When You're Walking Away     |    82
 Jeff Healey Band             | Stop Breakin' Down           |    82
 Robert Cray                  | I'm Walkin'                  |    82
 Jackie Greene                | Honey I Been Thinking About  |    82
 Ryan Adams                   | Easy Plateau                 |    82
 Reckless Kelly               | Rider In The Rain            |    82
 Corey Stevens                | Road To Zen                  |    82
 Los Lonely Boys              | Cisco Kid                    |    82
 Israel Kamakawiwo'ole        | Somewhere Over The Rainbow W |    82
 Buddy Guy                    | I'd Rather Be Blind, Cripple |    82
 Nick Lowe                    | Cracking Up                  |    81
 Delbert Mcclinton            | Leap Of Faith                |    81
 JJ Cale & Eric Clapton       | Dead End Road                |    81
 Emmylou Harris               | Deeper Well                  |    81
 John Mayall                  | You'll Survive               |    81
 Jimmy Lafave                 | River Road                   |    81
 Greg Brown                   | A Little Excited             |    81
 John Hiatt                   | Love's Not Where We Thought  |    81
 Dire Straits                 | Setting Me Up                |    81
 Rev. Billy C. Wirtz          | Everybody's Lips But Mine    |    81
 Shawn Colvin                 | Fearless Heart               |    81
 Tim O'Brien                  | Turning Around               |    81
 Mumbo Gumbo                  | Love Makes Me Stupid         |    80
 Terry Allen                  | Buck Naked                   |    80
 Madeleine Peyroux            | Heart Of Saturday Night (Loo |    80
 Little Village               | Do You Want My Job           |    80
 Kieran Kane & Kevin Welch    | Clean Getaway                |    80
 Jonny Lang                   | Rack 'em Up                  |    80
 Sue Foley                    | Little Things                |    80
 The Band                     | Up On Cripple Creek          |    80
 Robert Earl Keen             | Feelin' Good Again           |    80
 Darden Smith                 | Levee Song                   |    80
 Junior Brown                 | Freedom Machine              |    80
 Ozark Mountain Daredevils    | If You Wanna Get To Heaven   |    80
 Greg Brown                   | Billy From The Hills         |    80
 Fred Eaglesmith              | I Like Trains                |    80
 Stephen Stills               | Treetop Flyer                |    79
 Lyle Lovett                  | If I Had A Boat              |    79
 Subdudes                     | you'll Be Satisfied          |    79
 Ben Harper                   | Get It Like You Like It      |    79
 Devil Makes Three            | Old No. 7                    |    79
 Mary Gauthier                | Prayer Without Words         |    79
 Ryan Adams                   | When Will You Come Back Home |    79
 Bonnie Raitt                 | God Was In The Water         |    79
 Shawn Mullins                | Cold Black Heart             |    79
 Bottle Rockets               | Lucky Break                  |    79
 Peter Case                   | Paradise Etc                 |    79
 The Hombres                  | Let It  Out (Let It All Hang |    79
 Santana                      | I Don't Wanna Lose Your Love |    79
 Sonia Dada                   | Old Bones                    |    79
 John Hiatt                   | Instant Karma                |    79
 Mumbo Gumbo                  | Big Life                     |    79
 Lyle Lovett                  | Wallisville Road             |    79