World Rum Awards 2015

Winners

Page 3

titlewinner:

WINNER TOP SQL : SELECT '' as CONTENTS, * FROM tbl_Winners_OLD WHERE 1=1 AND WinnerCategoryID=510 AND CompetitionID=29 AND Type='Taste' AND WinnerLevel=3 ORDER BY WinnerTitle

WINNER TOP SQL : SELECT '' as CONTENTS, * FROM tbl_Winners_OLD AS W INNER JOIN tbl_Competition_OLD AS C ON C.id= W.CompetitionID WHERE 1=1 AND WinnerCategoryID=510 AND CompetitionID=29 AND Type='Taste' AND WinnerMedal='Gold' ORDER BY WinnerTitle

WINNER TOP SQL : SELECT '' as CONTENTS, * FROM tbl_Winners_OLD AS W INNER JOIN tbl_Competition_OLD AS C ON C.id= W.CompetitionID WHERE 1=1 AND WinnerCategoryID=510 AND CompetitionID=29 AND Type='Taste' AND WinnerMedal='Silver' ORDER BY WinnerTitle

WINNER TOP SQL : SELECT '' as CONTENTS, * FROM tbl_Winners_OLD AS W INNER JOIN tbl_Competition_OLD AS C ON C.id= W.CompetitionID WHERE 1=1 AND WinnerCategoryID=510 AND CompetitionID=29 AND Type='Taste' AND WinnerMedal='Bronze' ORDER BY WinnerTitle