Top Rated Lager Beers in ES
- user warning: Unknown column 'ln.nid' in 'on clause'
query:
SELECT COUNT(*)
FROM node n
LEFT JOIN votingapi_cache va ON va.content_id=n.nid
AND va.content_type="node"
AND va.function="average"
LEFT JOIN votingapi_cache vc ON vc.content_id=n.nid
AND vc.content_type="node"
AND vc.function="count"
JOIN location_instance li ON li.nid=ln.nid
JOIN location l ON li.lid=l.lid AND l.country="es"
JOIN content_type_bbeer ctbe ON ctbe.nid=n.nid
JOIN node ln ON ctbe.field_brewery_nid=ln.nid
JOIN term_node tn ON tn.nid=n.nid AND tid=2
WHERE n.status="1"
AND n.type="bbeer"
in /var/www/vhosts/beerati.com/httpdocs/sites/all/modules/beerati/btop_beers/btop_beers.module on line 76.
- user warning: Unknown column 'ln.nid' in 'on clause'
query:
SELECT n.nid, va.value as rating_avg, vc.value as rating_cnt
FROM node n
LEFT JOIN votingapi_cache va ON va.content_id=n.nid
AND va.content_type="node"
AND va.function="average"
LEFT JOIN votingapi_cache vc ON vc.content_id=n.nid
AND vc.content_type="node"
AND vc.function="count"
JOIN location_instance li ON li.nid=ln.nid
JOIN location l ON li.lid=l.lid AND l.country="es"
JOIN content_type_bbeer ctbe ON ctbe.nid=n.nid
JOIN node ln ON ctbe.field_brewery_nid=ln.nid
JOIN term_node tn ON tn.nid=n.nid AND tid=2
WHERE n.status="1"
AND n.type="bbeer"
ORDER BY va.value desc,vc.value desc LIMIT 0, 25 in /var/www/vhosts/beerati.com/httpdocs/sites/all/modules/beerati/btop_beers/btop_beers.module on line 76.
There are no lager beers in ES to view.
Beers by Style
Javascript is required to view this map.
Beers by Location
