Warning: mysql_query() expects parameter 2 to be resource, boolean given in /var/www/sdb/d/5/museedelabiere/class/DB.class.php on line 51
SELECT biere.id
, biere.name
, abv
, brasserie.countryid
, country.name AS pays
, typeid
, type_biere.name AS type
, C_INDEX
, robeid
, robe.name AS robe
, brasserieid
, brasserie.name AS brasserie
, CC_TYPE
, CC_DONATEUR
, d.fullname
, ibu
, ebc
, brasserie.keyword
, brasserie.url
, brasserie.city
, brasserie.description AS brasserie_description
FROM biere
LEFT OUTER JOIN type_biere ON biere.typeid = type_biere.id
LEFT OUTER JOIN robe ON biere.robeid = robe.id
LEFT OUTER JOIN (brasserie
INNER JOIN country ON brasserie.countryid = country.id)
ON brasserieid = brasserie.id
LEFT OUTER JOIN donateur d ON d.c_donateur = biere.CC_DONATEUR
WHERE biere.id = '43'