Page 3
titlewinner:
WINNER TOP SQL : SELECT '' as CONTENTS, * FROM tbl_Winners WHERE 1=1 AND WinnerCategoryID=862 AND CompetitionID=83 AND Type='Design' AND WinnerLevel=3 ORDER BY WinnerTitle
WINNER TOP SQL : SELECT '' as CONTENTS, * FROM tbl_Winners AS W INNER JOIN tbl_Competition AS C ON C.id= W.CompetitionID WHERE 1=1 AND WinnerCategoryID=862 AND WinnerLevel=5 AND CountryID=0 AND CompetitionID=83 AND Type='Design' AND WinnerMedal='Gold' ORDER BY WinnerTitle
WINNER TOP SQL : SELECT '' as CONTENTS, * FROM tbl_Winners AS W INNER JOIN tbl_Competition AS C ON C.id= W.CompetitionID WHERE 1=1 AND WinnerCategoryID=862 AND WinnerLevel=5 AND CountryID=0 AND CompetitionID=83 AND Type='Design' AND WinnerMedal='Silver' ORDER BY WinnerTitle
WINNER TOP SQL : SELECT '' as CONTENTS, * FROM tbl_Winners AS W INNER JOIN tbl_Competition AS C ON C.id= W.CompetitionID WHERE 1=1 AND WinnerCategoryID=862 AND WinnerLevel=5 AND CountryID=0 AND CompetitionID=83 AND Type='Design' AND WinnerMedal='Bronze' ORDER BY WinnerTitle