name; $title = "Best " . $t . " Beers"; $cData = mysql_query("SELECT beers.*,COUNT(beerreel.beer) AS c,SUM(beerreel.rating) AS r FROM beers LEFT JOIN beerreel ON beerreel.beer = beers.id WHERE beers.maker = \"$t\" AND beerreel.rating != 0"); if (isset($_GET['order']) && $_GET['order'] == 'highest') { $data = mysql_query("SELECT beers.*,COUNT(beerreel.beer) AS c,SUM(beerreel.rating) AS r,(SUM(beerreel.rating)/(5*COUNT(beerreel.beer)))*COUNT(beerreel.beer) AS o, (SUM(beerreel.rating)/(COUNT(beerreel.beer))) AS average FROM beers LEFT JOIN beerreel ON beerreel.beer = beers.id WHERE beers.maker = \"$t\" AND beerreel.rating != 0 GROUP BY beers.id ORDER BY average DESC, beers.id DESC LIMIT 100"); } else { $data = mysql_query("SELECT beers.*,COUNT(beerreel.beer) AS c,SUM(beerreel.rating) AS r,(SUM(beerreel.rating)/(5*COUNT(beerreel.beer)))*COUNT(beerreel.beer) AS o FROM beers LEFT JOIN beerreel ON beerreel.beer = beers.id WHERE beers.maker = \"$t\" AND beerreel.rating != 0 GROUP BY beers.id ORDER BY o DESC LIMIT 100"); } $pData = mysql_query("SELECT beers.type,beerreel.picName,beerreel.rating FROM beers LEFT JOIN beerreel ON beerreel.beer = beers.id WHERE beers.maker = \"$t\" AND beerreel.picName != '' AND beerreel.rating > 3 ORDER BY beerreel.id DESC"); $picData = mysql_fetch_object($pData); $ogImage = "https://brewzeit.com/images/thumbs_lg/" . $picData->picName; $reviewCount = mysql_fetch_object($cData); $meta = "Here are the best beers by " . $t . " based on " . number_format($reviewCount->c) . " reviews on Brewzeit. Download the Brewzeit app and start rating beers."; $smallCard = true; include('../includes/header.php'); ?>

Best Beers

r / $reviewCount->c) / 5 * 100; ?>

r / $reviewCount->c, 2) ?> out of 5 with c ?> reviews

Here are the best beers by based on c) ?> reviews on Brewzeit. View all other breweries here. Order these beers by highest rating or average rating. Download the Brewzeit app and start rating beers.

Formula used: (sum of ratings/total possible points)*number of ratings.