Artist with the largest number of albums in your library?

[JJZolx]

For me, it's Santana, with 15:

Santana (1969)
Abraxas (1970)
Santana III (1971)
Caravanseri (1972)
Carlos Santana & Buddy Miles! Live! (1972)
Love Devotion Surrender w/John McLaughlin (1972)
Lotus (1974)
Amigos (1976)
Festival (1977)
Moonflower (1977)
Blues for Salvador (1987)
Spirits Dancing in the Flesh (1990)
Milagro (1992)
Supernatural (1999)
Shaman (2002)

Also

Thelonious Monk: 11
Van Morrison: 11
Steely Dan: 10

[Skunk]

Neil Young wins here with eleven.

Everybody Knows This Is Nowhere (69)
Harvest (72)
Live Rust (79)
Harvest Moon (92)
Unplugged (93)
Sleeps with Angels (94)
Mirrorball (95)
Broken Arrow (96)
Year of the Horse (97)
Silver & Gold (00)
Prairie Wind (05)

[Phil Leigh]

Wishbone Ash - 23 nope...
Elton John - 33

(oops - apparently its "various" with 312...!)

[snarlydwarf]

The Residents with 47, closely followed by Dylan with 44, though Dylan has more multi-disc sets (and that doesn't include Dylan Bootlegs...)

[Mark Lanctot]

Probably The Tragically Hip with 10 albums, although one's a double and it's also a greatest hits compilation, but with two new tracks.

The Tragically Hip (1987)
Road Apples (1991)
Day for Night (1994)
Trouble at the Henhouse (1996) - which also, incidentally, is my favourite album cover.
Phantom Power (1998)
Music @ Work (2000)
In Violet Light (2002)
In Between Evolution (2004)
Yer Favourites (Disc 1) (2005)
Yer Favourites (Disc 2) (2005)

I'm missing Up to Here (1989) and Fully Completely (1992).

BTW do you guys have some secret database searching algorithm to determine this? I just did it off the top of my head.

[snarlydwarf]

Like this (and a bit more precise, though also somewhat inaccurate for people who show up on VA albums...):

  select contributors.name, count(contributor)
  from contributor_album, contributors 
  where contributors.id = contributor_album.contributor
  group by contributor
  order by count(contributor) desc
  limit 10;

+----------------------+--------------------+
| name                 | count(contributor) |
+----------------------+--------------------+
| Bob Dylan            |                 53 |
| The Residents        |                 47 |
| Johnny Cash          |                 39 |
| Caetano Veloso       |                 27 |
| King Crimson         |                 26 |
| Johnny Cash          |                 23 |
| Philip Glass         |                 21 |
| The Rolling Stones   |                 18 |
| The Who              |                 17 |
| William S. Burroughs |                 16 |
+----------------------+--------------------+

Was close enough to make me actually look anyway (though I had a pretty good clue :P)

[snarlydwarf]

(yeah, and I know Cash shows up twice... I have to figure out why.. I think it has to do with Musicbrainz tags that I've "fixed"... SlimServer ends up getting both... so I think I have to undo my fixes...)

[Mark Lanctot]

Like this (and a bit more precise, though also somewhat inaccurate for people who show up on VA albums...):

  select contributors.name, count(contributor)
  from contributor_album, contributors 
  where contributors.id = contributor_album.contributor
  group by contributor
  order by count(contributor) desc
  limit 10;

+----------------------+--------------------+
| name                 | count(contributor) |
+----------------------+--------------------+
| Bob Dylan            |                 53 |
| The Residents        |                 47 |
| Johnny Cash          |                 39 |
| Caetano Veloso       |                 27 |
| King Crimson         |                 26 |
| Johnny Cash          |                 23 |
| Philip Glass         |                 21 |
| The Rolling Stones   |                 18 |
| The Who              |                 17 |
| William S. Burroughs |                 16 |
+----------------------+--------------------+

Was close enough to make me actually look anyway (though I had a pretty good clue :P)

Is that a MySQL script?

[snarlydwarf]

Well not sure I'd call it a script, I just typed it at the mysql client prompt.

[notanatheist]

12 Beatles
10 Pink Floyd
5 Jars of Clay but 19 albums with them on it.