Lonesome EJ: Maybe you'd like one of these. (I'm not sure they're all still available.) Information from allmusic
*********************************************************
"An Empty Glass: A Collection of Drinkin' Songs," Hightone CD #8133, 2001.
1. An Empty Glass (That's the Way the Day Ends) - Gary Stewart
2. Lovin' the Bottle - Heather Myles
3. Hair of the Dog - Dale Watson
4. Stoned at the Jukebox - Katy Moffatt
5. Scotch and Soda - Hank Thompson
6. Tequila Calling - Big Sandy & His Fly-Rite Boys
7. Drinkin' for Two - Hollisters
8. Wine Don't Lie - Dale Watson
9. Brand New Whiskey - Gary Stewart
10. Behind Bars - Marty Brown
11. Last DUI - Randy Weeks
12. Pink Champagne - Sprague Brothers
13. Booze Party - Fly-Rite Boys
*********************************************************
"Country Drinking Songs," K-Tel Entertainment CD #3567, 2003.
1. The Bottle Let Me Down - Merle Haggard
2. Pop-A-Top - Jim Ed Brown
3. Tequila Sheila - Bobby Bare
4. Wine Me Up - Faron Young
5. I Like Beer [live] - Tom T. Hall
6. Country Bumpkin - Cal Smith
7. City Lights - Ray Price
8. Skid Row Joe - Porter Wagoner
9. Almost Persuaded - David Houston
10. Almost Persuaded, No. 2 - Ben Colder
11. There Stands the Glass - Webb Pierce
12. Dang Me - Roger Miller
13. Rednecks, White Socks and Blue Ribbon Beer - Johnny Russell
14. Lone Star Beer & Bob Wills Music - Red Steagall
15. Smokey the Bar - Hank Thompson
16. I Think I'll Just Stay Here and Drink - Merle Haggard
17. If You've Got the Money (I've Got the Time) - Lefty Frizzell
18. Rye Whiskey - Tex Ritter
*********************************************************
"Country Shots: Barroom Biggies," Rhino CD #71672, 1994.
1. What's Made Milwaukee Famous (Has Made a Loser Out of Me) - Jerry Lee Lewis
2. Stomp Them Grapes - Mel Tillis
3. If Drinkin' Don't Kill Me (Her Memory Will) - George Jones
4. On Tap, In the Can, or In the Bottle - Hank Thompson
5. Jose Cuervo - Shelly West
6. Drinkin' My Baby (Off My Mind) - Eddie Rabbitt
7. Barstool Mountain - Moe Bandy
8. The Power of Positive Drinkin' - Mickey Gilley
9. Whiskey River - Willie Nelson
10. Don't Come Home a Drinkin' (With Lovin' on Your Mind) - Loretta Lynn
*********************************************************
"Country's Greatest Drinking Songs," All Star CD #76212, 1998.
1. Wasted Days and Wasted Nights - Freddy Fender
2. Chug-A-Lug - Roger Miller
3. I Think I'll Just Stay Here and Drink - Merle Haggard
4. Hey Bartender - Johnny Lee
5. Drinkin' and Dreamin' - Waylon Jennings
6. The Bottle Let Me Down - Merle Haggard
7. Rednecks, White Socks and Blue Ribbon Beer - Johnny Russell
8. Wine Me Up - Larry Boone
9. You Must Not Be Drinking Enough - Earl Thomas Conley
10. I Can't Quit Drinking - Johnny Paycheck
*********************************************************
"Fifth of Country," Madacy CD #8454, 1997.
1. Hey Bartender - Johnny Lee
2. Whiskey, If You Were a Woman - Highway
3. Bloody Mary Morning - Willie Nelson
4. Drinkin' and Dreamin' - Waylon Jennings
5. No Way Jose - Ray Kennedy
6. (There's a) Devil in the Bottle - T. G. Sheppard
7. Pour Me Another Tequila - Eddie Rabbitt
8. She's Actin' Single (I'm Drinkin' Doubles) - Gary Stewart
9. Two More Bottles of Wine - Emmylou Harris
10. Drinkin' My Way Back Home - Gene Watson
11. Jose Cuervo - Shelly West
12. I Think I'll Just Stay Here and Drink - Merle Haggard
*********************************************************
"Honky Tonk Country: Saloon Country," Priority CD P2-53694, (no date given).
1. Jose Cuervo - Shelly West
2. I Think I'll Just Stay Here and Drink - Merle Haggard
3. Drinkin' My Baby (Off My Mind) - Eddie Rabbitt
4. She's Actin' Single (I'm Drinkin' Doubles) - Gary Stewart
5. Hard Days and Honky Tonk Nights - Earl Thomas Conley
6. Y'all Come Back Saloon - The Oak Ridge Boys
7. Black Velvet - Robin Lee
8. There's a Tear in My Beer - Hank Williams
9. A Million Light Beers Ago - David Frizzell
*********************************************************
"One Hundred Proof Hits," K-Tel CD #852, 1991.
1. Tequila - Champs
2. Chug-A-Lug - Roger Miller
3. Escape (The Piña Colada Song) - Rupert Holmes
4. I'm Gonna Hire a Wino to Decorate Our Home - David Frizzell
5. Jose Cuervo - Shelly West
6. Drinkin' Wine, Spo-Dee-O-Dee - Jerry Lee Lewis
7. One Scotch, One Bourbon, One Beer - Amos Milburn
8. I Got Loaded - Peppermint Harris
9. Million Light Beers Ago - David Frizzell
10. Scotch and Soda - Kingston Trio
*********************************************************
p.s. If you wanted to assemble a similar list of Irish drinking songs or German drinking songs, there are plenty of those albums out there, too.