Rating
P&O Cruises Jewel
Sydney NSW 2000
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=25820 or tblfeedback.strbusinessname='P&%%semi%%O Cruises Jewel' or tblfeedback.strbusinessname='P&O Cruises Jewel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lakeside Golf Club Camden
Catherine Field NSW 2557
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27792 or tblfeedback.strbusinessname='Lakeside Golf Club Camden' or tblfeedback.strbusinessname='Lakeside Golf Club Camden') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tattersalls on Elizabeth Street
Sydney NSW 2000
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=20114 or tblfeedback.strbusinessname='Tattersalls on Elizabeth Street' or tblfeedback.strbusinessname='Tattersalls on Elizabeth Street') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Oatlands House
Oatlands NSW 2117
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=2038 or tblfeedback.strbusinessname='Oatlands House' or tblfeedback.strbusinessname='Oatlands House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kangaroo Valley Bush Retreat
Kangaroo Valley NSW 2577
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=25182 or tblfeedback.strbusinessname='Kangaroo Valley Bush Retreat' or tblfeedback.strbusinessname='Kangaroo Valley Bush Retreat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Metro Mirage Hotel Newport
Newport NSW 2106
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=36141 or tblfeedback.strbusinessname='Metro Mirage Hotel Newport' or tblfeedback.strbusinessname='Metro Mirage Hotel Newport') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gledswood Homestead
Catherine Fields NSW 2557
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26081 or tblfeedback.strbusinessname='Gledswood Homestead' or tblfeedback.strbusinessname='Gledswood Homestead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Secret Creek Cafe
Lithgow NSW 2790
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26069 or tblfeedback.strbusinessname='Secret Creek Cafe' or tblfeedback.strbusinessname='Secret Creek Cafe') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Madison Function Centre
Dural NSW 2158
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=29271 or tblfeedback.strbusinessname='The Madison Function Centre' or tblfeedback.strbusinessname='The Madison Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Coogee Surf Life Saving Club
Coogee NSW 2034
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=38219 or tblfeedback.strbusinessname='Coogee Surf Life Saving Club' or tblfeedback.strbusinessname='Coogee Surf Life Saving Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sergeants' Mess
Mosman NSW 2088
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=23182 or tblfeedback.strbusinessname='Sergeants'%%semi%% Mess' or tblfeedback.strbusinessname='Sergeants' Mess') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Colebee Centre
Doonside NSW 2767
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=18258 or tblfeedback.strbusinessname='Colebee Centre' or tblfeedback.strbusinessname='Colebee Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Springfield Function Centre
Dural NSW 2158
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=1972 or tblfeedback.strbusinessname='Springfield Function Centre' or tblfeedback.strbusinessname='Springfield Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Q Station Manly
Manly NSW 2095
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26119 or tblfeedback.strbusinessname='Q Station Manly' or tblfeedback.strbusinessname='Q Station Manly') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mulgoa Valley Reception
Mulgoa NSW 2745
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27194 or tblfeedback.strbusinessname='Mulgoa Valley Reception' or tblfeedback.strbusinessname='Mulgoa Valley Reception') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Starship Sydney
Darling Habour NSW 2041
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=36335 or tblfeedback.strbusinessname='Starship Sydney' or tblfeedback.strbusinessname='Starship Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Skyview Reception Lounge
Liverpool NSW 2170
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=22940 or tblfeedback.strbusinessname='Skyview Reception Lounge' or tblfeedback.strbusinessname='Skyview Reception Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Seclusions
Rydal NSW 2790
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26965 or tblfeedback.strbusinessname='Seclusions' or tblfeedback.strbusinessname='Seclusions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Burnham Grove Estate
Camden NSW 2570
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=29194 or tblfeedback.strbusinessname='Burnham Grove Estate' or tblfeedback.strbusinessname='Burnham Grove Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hazelhurst Regional Gallery and Arts Centre
Gymea NSW 2277
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26587 or tblfeedback.strbusinessname='Hazelhurst Regional Gallery and Arts Centre' or tblfeedback.strbusinessname='Hazelhurst Regional Gallery and Arts Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gardens of Forest
Peakhurst NSW 2210
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27318 or tblfeedback.strbusinessname='Gardens of Forest' or tblfeedback.strbusinessname='Gardens of Forest') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Watsons Bay Boutique Hotel
Watsons Bay NSW 2030
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27213 or tblfeedback.strbusinessname='Watsons Bay Boutique Hotel' or tblfeedback.strbusinessname='Watsons Bay Boutique Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Liverpool Catholic Club
Prestons NSW 2170
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26513 or tblfeedback.strbusinessname='Liverpool Catholic Club' or tblfeedback.strbusinessname='Liverpool Catholic Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Elim Function Centre
Burwood NSW 2134
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=1902 or tblfeedback.strbusinessname='Elim Function Centre' or tblfeedback.strbusinessname='Elim Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Valentino's Reception Centre
Fairfield NSW 2165
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=11846 or tblfeedback.strbusinessname='Valentino'%%semi%%s Reception Centre' or tblfeedback.strbusinessname='Valentino's Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Miramare Function Centre
Dee Why NSW 2099
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=10516 or tblfeedback.strbusinessname='Miramare Function Centre' or tblfeedback.strbusinessname='Miramare Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Waitara Function Centre
Waitara NSW 2077
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=11928 or tblfeedback.strbusinessname='Waitara Function Centre' or tblfeedback.strbusinessname='Waitara Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Canterbury-Hurlstone Park RSL Club Ltd
Hurlstone Park NSW 2193
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=1935 or tblfeedback.strbusinessname='Canterbury-Hurlstone Park RSL Club Ltd' or tblfeedback.strbusinessname='Canterbury-Hurlstone Park RSL Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Clarence House
Belmore NSW 2192
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=18257 or tblfeedback.strbusinessname='Clarence House' or tblfeedback.strbusinessname='Clarence House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ambrosia Seafood Restaurant
Lansvale NSW 2166
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=2160 or tblfeedback.strbusinessname='Ambrosia Seafood Restaurant' or tblfeedback.strbusinessname='Ambrosia Seafood Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pittwater RSL Club Ltd
Mona Vale NSW 2103
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=11001 or tblfeedback.strbusinessname='Pittwater RSL Club Ltd' or tblfeedback.strbusinessname='Pittwater RSL Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bass & Flinders Cruises
Sans Souci NSW 2219
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=2202 or tblfeedback.strbusinessname='Bass &%%semi%% Flinders Cruises' or tblfeedback.strbusinessname='Bass & Flinders Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Aboard
Rose Bay NSW 2029
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=2113 or tblfeedback.strbusinessname='Aboard' or tblfeedback.strbusinessname='Aboard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tudor Lodge
Greystanes NSW 2145
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=11796 or tblfeedback.strbusinessname='Tudor Lodge' or tblfeedback.strbusinessname='Tudor Lodge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Imax Star Room
Darling Harbour NSW 2000
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=9801 or tblfeedback.strbusinessname='Imax Star Room' or tblfeedback.strbusinessname='Imax Star Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roslyn Gardens & Rosebowl
Peakhurst NSW 2210
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=11239 or tblfeedback.strbusinessname='Roslyn Gardens &%%semi%% Rosebowl' or tblfeedback.strbusinessname='Roslyn Gardens & Rosebowl') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Gables
Lidcombe NSW 2141
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=1940 or tblfeedback.strbusinessname='The Gables' or tblfeedback.strbusinessname='The Gables') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blacktown R S L Club
Blacktown NSW 2148
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=8228 or tblfeedback.strbusinessname='Blacktown R S L Club' or tblfeedback.strbusinessname='Blacktown R S L Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A. Aquablue Charters
Mosman NSW 2088
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=2126 or tblfeedback.strbusinessname='A. Aquablue Charters' or tblfeedback.strbusinessname='A. Aquablue Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
James Craig
Sydney NSW 2000
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=9871 or tblfeedback.strbusinessname='James Craig' or tblfeedback.strbusinessname='James Craig') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lauriston House
Dundas NSW 2117
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=18275 or tblfeedback.strbusinessname='Lauriston House' or tblfeedback.strbusinessname='Lauriston House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kandles Reception Centre
Merrylands NSW 2160
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=10006 or tblfeedback.strbusinessname='Kandles Reception Centre' or tblfeedback.strbusinessname='Kandles Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Araluen Catering Pty Ltd
Epping NSW 2121
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=2171 or tblfeedback.strbusinessname='Araluen Catering Pty Ltd' or tblfeedback.strbusinessname='Araluen Catering Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Red Rose Reception Lounge
Rockdale NSW 2216
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=1985 or tblfeedback.strbusinessname='Red Rose Reception Lounge' or tblfeedback.strbusinessname='Red Rose Reception Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Venue Collection The
Sydney NSW 2000
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=11860 or tblfeedback.strbusinessname='Venue Collection The' or tblfeedback.strbusinessname='Venue Collection The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mercure Hotel Lawson
Ultimo NSW 2007
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=10463 or tblfeedback.strbusinessname='Mercure Hotel Lawson' or tblfeedback.strbusinessname='Mercure Hotel Lawson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mary Elizabeth House
Lakemba NSW 2195
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=2025 or tblfeedback.strbusinessname='Mary Elizabeth House' or tblfeedback.strbusinessname='Mary Elizabeth House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Little Mykonos The
Cronulla NSW 2230
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=10251 or tblfeedback.strbusinessname='Little Mykonos The' or tblfeedback.strbusinessname='Little Mykonos The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sydney Tower Sky Lounge
Sydney NSW 2000
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=2078 or tblfeedback.strbusinessname='Sydney Tower Sky Lounge' or tblfeedback.strbusinessname='Sydney Tower Sky Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Killara Inn Boutique Hotel
Killara NSW 2071
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=10073 or tblfeedback.strbusinessname='Killara Inn Boutique Hotel' or tblfeedback.strbusinessname='Killara Inn Boutique Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 444 Sort search results alphabetically