SELECT C.*, (DATE_ADD(C.DateIn, INTERVAL 30 DAY) > NOW()) as IsNew, B.Name BName, BC.NameEng BCName, BC.PicFlag BCPicFlag, CC.NameEng CCName, CC.PicFlag CCPicFlag, LB.Name LBName, LC.NameEng LCName, LC.PicFlag LCPicFlag FROM Coaster C LEFT JOIN Brewery B ON (C.BreweryID=B.ID) LEFT JOIN Country BC ON (B.CountryID=BC.ID) LEFT JOIN Country CC ON (C.CountryID=CC.ID) LEFT JOIN Brewery LB ON (C.LicBreweryID=LB.ID) LEFT JOIN Country LC ON (LC.ID=LB.CountryID)WHERE (C.ID=4028)
Podstawki pod piwo, beermat, coaster, bierdeckel, pasavasos
