Listing of breweries with beers reviewed

Help Discussion in 'BeerAdvocate Talk' started by tekstr1der, Feb 26, 2022.

Thread Status:
Not open for further replies.
  1. tekstr1der

    tekstr1der Grand Pooh-Bah (4,252) Nov 27, 2014 New Hampshire
    BA4LYFE Society Pooh-Bah Trader

    Hi! Is there any way to see a listing of breweries from which there are beers I've rated?

    The overall count of brewers is listed on the profile page, but is not linked to a query (this would be preferred). For all other metrics there exists a way to list them.

    [​IMG]

    Also, here is another location where Brewers could link to a list of breweries from which there are beers I've rated:

    [​IMG]

    Perhaps this functionality exists, but I'm not seeing it. I can sort my total list of reviews by brewer(y) but that is cumbersome.

    Having a list of breweries in a list format such as...

    Brewery Name (Count of rated beers)

    ...which could be sorted alphabetically, or by rated beer count, would be super handy.

    I was trying to take a look at each brewery to see if there are beers I'd overlooked from each, and such a query would certainly help.
     
  2. Todd

    Todd Founder (13,518) Aug 23, 1996 Finland
    STAFF Mod Team Society Pooh-Bah

    Although you can sort by brewery when viewing your rated beers, a flattened list of breweries with the number of beers you've rated for each one doesn't currently exist.
     
  3. BBThunderbolt

    BBThunderbolt Grand High Pooh-Bah (7,846) Sep 24, 2007 Kiribati
    Pooh-Bah Trader

    Well, if you go to your 'Beers' page, you can sort by brewery, and it lists them alphabetically. That's not quite what your looking for, but it's something.
     
    BigIronH likes this.
  4. tekstr1der

    tekstr1der Grand Pooh-Bah (4,252) Nov 27, 2014 New Hampshire
    BA4LYFE Society Pooh-Bah Trader

    Thanks for confirming I wasn't missing something. Guessing it doesn't exist for a reason, but assuming your schema is solid it should be a fairly straightforward and performant query. I'll put it on my wish-list for the next iteration of extended statistics haha

    Yes, I mentioned that. Thanks for the quick reply tho!
     
    Harrison8 and BBThunderbolt like this.
Thread Status:
Not open for further replies.