Rating
Waterview Restaurant
Berowra Waters NSW 2082
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=14968 or tblfeedback.strbusinessname='Waterview Restaurant' or tblfeedback.strbusinessname='Waterview Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Manor House Boutique Hotel
Darlinghurst NSW 2010
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=10356 or tblfeedback.strbusinessname='Manor House Boutique Hotel' or tblfeedback.strbusinessname='Manor House Boutique Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
WatersEdge
Walsh Bay 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=1934 or tblfeedback.strbusinessname='WatersEdge' or tblfeedback.strbusinessname='WatersEdge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bosphorus Reception Lounge
Auburn NSW 2144
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=8295 or tblfeedback.strbusinessname='Bosphorus Reception Lounge' or tblfeedback.strbusinessname='Bosphorus Reception Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Allegro Function Centre
Kenthurst NSW 2156
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=18244 or tblfeedback.strbusinessname='Allegro Function Centre' or tblfeedback.strbusinessname='Allegro Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Belhaven Manor
Wentworthville 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=18249 or tblfeedback.strbusinessname='Belhaven Manor' or tblfeedback.strbusinessname='Belhaven Manor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Royal Prince Alfred Yacht Club
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=11252 or tblfeedback.strbusinessname='Royal Prince Alfred Yacht Club' or tblfeedback.strbusinessname='Royal Prince Alfred Yacht Club') 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
Duxton Hotel North Sydney
Milsons Point NSW 2061
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=1964 or tblfeedback.strbusinessname='Duxton Hotel North Sydney' or tblfeedback.strbusinessname='Duxton Hotel North Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gazebo
Elizabeth Bay NSW 2011
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=9426 or tblfeedback.strbusinessname='Gazebo' or tblfeedback.strbusinessname='Gazebo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sydney Tower Restaurants
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=11658 or tblfeedback.strbusinessname='Sydney Tower Restaurants' or tblfeedback.strbusinessname='Sydney Tower Restaurants') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Carnarvon Golf Club
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=18254 or tblfeedback.strbusinessname='Carnarvon Golf Club' or tblfeedback.strbusinessname='Carnarvon Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ainslee Lodge
Bexley NSW 2207
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=2144 or tblfeedback.strbusinessname='Ainslee Lodge' or tblfeedback.strbusinessname='Ainslee Lodge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Valintines Lounge & Reception
Brookvale NSW 2100
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=11847 or tblfeedback.strbusinessname='Valintines Lounge &%%semi%% Reception' or tblfeedback.strbusinessname='Valintines Lounge & Reception') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Victoria House Function Centre
Bexley NSW 2207
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=11875 or tblfeedback.strbusinessname='Victoria House Function Centre' or tblfeedback.strbusinessname='Victoria House Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Arristo Pty Ltd
Dundas Valley 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=2178 or tblfeedback.strbusinessname='Arristo Pty Ltd' or tblfeedback.strbusinessname='Arristo Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Botanic Gardens Restaurant
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=8299 or tblfeedback.strbusinessname='Botanic Gardens Restaurant' or tblfeedback.strbusinessname='Botanic Gardens Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pennant Hills Bowling Club
Pennant Hills NSW 2120
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=10892 or tblfeedback.strbusinessname='Pennant Hills Bowling Club' or tblfeedback.strbusinessname='Pennant Hills Bowling Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tie the Knot Wedding Co-Ordinators
Rozelle NSW 2039
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=11722 or tblfeedback.strbusinessname='Tie the Knot Wedding Co-Ordinators' or tblfeedback.strbusinessname='Tie the Knot Wedding Co-Ordinators') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
Star Room
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=18292 or tblfeedback.strbusinessname='Star Room' or tblfeedback.strbusinessname='Star Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Events With Panache
Castle Hill NSW 2154
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=7984 or tblfeedback.strbusinessname='Events With Panache' or tblfeedback.strbusinessname='Events With Panache') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Macquarie Princess Charter Ferry Pty Ltd
Castle Hill NSW 2154
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=10315 or tblfeedback.strbusinessname='Macquarie Princess Charter Ferry Pty Ltd' or tblfeedback.strbusinessname='Macquarie Princess Charter Ferry Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Edessa Reception & Function Centre
Greenfield Park NSW 2176
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=9116 or tblfeedback.strbusinessname='Edessa Reception &%%semi%% Function Centre' or tblfeedback.strbusinessname='Edessa Reception & Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sutherland District Trade Union Club Ltd-The Tradies
Gymea NSW 2227
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=11624 or tblfeedback.strbusinessname='Sutherland District Trade Union Club Ltd-The Tradies' or tblfeedback.strbusinessname='Sutherland District Trade Union Club Ltd-The Tradies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lachlan's Old Government House
Parramatta NSW 2150
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=1967 or tblfeedback.strbusinessname='Lachlan'%%semi%%s Old Government House' or tblfeedback.strbusinessname='Lachlan's Old Government House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Georges River Cruises
East Hills NSW 2213
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=9446 or tblfeedback.strbusinessname='Georges River Cruises' or tblfeedback.strbusinessname='Georges River Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Villa Rosa Reception Lounge
Leichhardt NSW 2048
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=18302 or tblfeedback.strbusinessname='Villa Rosa Reception Lounge' or tblfeedback.strbusinessname='Villa Rosa Reception Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bounty Cruises
The Rocks 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=8302 or tblfeedback.strbusinessname='Bounty Cruises' or tblfeedback.strbusinessname='Bounty Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Venues AT Macquarie
North Ryde NSW 2113
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=11861 or tblfeedback.strbusinessname='Venues AT Macquarie' or tblfeedback.strbusinessname='Venues AT Macquarie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rydges Cronulla Beach
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=11267 or tblfeedback.strbusinessname='Rydges Cronulla Beach' or tblfeedback.strbusinessname='Rydges Cronulla Beach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Dresden 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=9077 or tblfeedback.strbusinessname='Dresden Lounge' or tblfeedback.strbusinessname='Dresden Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elizabeth Farm
Rosehill NSW 2142
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=9146 or tblfeedback.strbusinessname='Elizabeth Farm' or tblfeedback.strbusinessname='Elizabeth Farm') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gables The
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=9391 or tblfeedback.strbusinessname='Gables The' or tblfeedback.strbusinessname='Gables The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
212 Riley Street
Surry Hills NSW 2010
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=2110 or tblfeedback.strbusinessname='212 Riley Street' or tblfeedback.strbusinessname='212 Riley Street') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pacific International Suites
Parramatta NSW 2150
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=10802 or tblfeedback.strbusinessname='Pacific International Suites' or tblfeedback.strbusinessname='Pacific International Suites') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Newport Mirage
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=10672 or tblfeedback.strbusinessname='Newport Mirage' or tblfeedback.strbusinessname='Newport Mirage') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Dural Country Club Ltd
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=9095 or tblfeedback.strbusinessname='Dural Country Club Ltd' or tblfeedback.strbusinessname='Dural Country Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Little Mykonos
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=10250 or tblfeedback.strbusinessname='Little Mykonos' or tblfeedback.strbusinessname='Little Mykonos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Royal Motor Yacht Club
Point Piper NSW 2027
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=11251 or tblfeedback.strbusinessname='Royal Motor Yacht Club' or tblfeedback.strbusinessname='Royal Motor Yacht Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Country Comfort Inn Pennant Hills
Pennant Hills NSW 2120
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=8807 or tblfeedback.strbusinessname='Country Comfort Inn Pennant Hills' or tblfeedback.strbusinessname='Country Comfort Inn Pennant Hills') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abcot Garden Function Centre
Sylvania NSW 2224
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=2131 or tblfeedback.strbusinessname='Abcot Garden Function Centre' or tblfeedback.strbusinessname='Abcot Garden Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
AJC Convention & Exhibition Centre
Randwick NSW 2031
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=2147 or tblfeedback.strbusinessname='AJC Convention &%%semi%% Exhibition Centre' or tblfeedback.strbusinessname='AJC Convention & Exhibition Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barnaby's Waterfront Restaurants
Lansdowne NSW 2163
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=8091 or tblfeedback.strbusinessname='Barnaby'%%semi%%s Waterfront Restaurants' or tblfeedback.strbusinessname='Barnaby's Waterfront Restaurants') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Italian Village The Rocks
The Rocks 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=18273 or tblfeedback.strbusinessname='Italian Village The Rocks' or tblfeedback.strbusinessname='Italian Village The Rocks') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Harbour Watch The
The Rocks 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=1975 or tblfeedback.strbusinessname='Harbour Watch The' or tblfeedback.strbusinessname='Harbour Watch The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Venus Reception Centre
Punchbowl NSW 2196
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=11862 or tblfeedback.strbusinessname='Venus Reception Centre' or tblfeedback.strbusinessname='Venus Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sydney Turf Club
Canterbury 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=1901 or tblfeedback.strbusinessname='Sydney Turf Club' or tblfeedback.strbusinessname='Sydney Turf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Silver Spirit
Drummoyne NSW 2047
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=11408 or tblfeedback.strbusinessname='Silver Spirit' or tblfeedback.strbusinessname='Silver Spirit') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 444 Sort search results alphabetically