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
Isabelles Reception Centre
Eastwood NSW 2122
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=9842 or tblfeedback.strbusinessname='Isabelles Reception Centre' or tblfeedback.strbusinessname='Isabelles Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sydneyside Cruises
Pyrmont NSW 2009
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=11663 or tblfeedback.strbusinessname='Sydneyside Cruises' or tblfeedback.strbusinessname='Sydneyside Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abcot Inn
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=2132 or tblfeedback.strbusinessname='Abcot Inn' or tblfeedback.strbusinessname='Abcot Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sydney Opera House
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=11653 or tblfeedback.strbusinessname='Sydney Opera House' or tblfeedback.strbusinessname='Sydney Opera House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Frank Oliveri Room
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=9363 or tblfeedback.strbusinessname='Frank Oliveri Room' or tblfeedback.strbusinessname='Frank Oliveri Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ainslee Lodge 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=2145 or tblfeedback.strbusinessname='Ainslee Lodge Function Centre' or tblfeedback.strbusinessname='Ainslee Lodge Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sydney Glass Island
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=4632 or tblfeedback.strbusinessname='Sydney Glass Island' or tblfeedback.strbusinessname='Sydney Glass Island') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sunnybrook Function Centre The
Warwick Farm 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=11604 or tblfeedback.strbusinessname='Sunnybrook Function Centre The' or tblfeedback.strbusinessname='Sunnybrook Function Centre The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bankstown Paceway
Bankstown NSW 2200
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=18247 or tblfeedback.strbusinessname='Bankstown Paceway' or tblfeedback.strbusinessname='Bankstown Paceway') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Sunnybrook Hotel
Warwick Farm 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=18299 or tblfeedback.strbusinessname='The Sunnybrook Hotel' or tblfeedback.strbusinessname='The Sunnybrook Hotel') 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
Palais Function Centre
Leichhardt NSW 2040
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=2039 or tblfeedback.strbusinessname='Palais Function Centre' or tblfeedback.strbusinessname='Palais Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Maxims
Bankstown NSW 2200
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=10423 or tblfeedback.strbusinessname='Maxims' or tblfeedback.strbusinessname='Maxims') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bayview Conference & Function Centre
Miranda NSW 2228
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=2210 or tblfeedback.strbusinessname='Bayview Conference &%%semi%% Function Centre' or tblfeedback.strbusinessname='Bayview Conference & Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Italian Village 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=9845 or tblfeedback.strbusinessname='Italian Village Restaurant' or tblfeedback.strbusinessname='Italian Village Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Stamford Grand North Ryde
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=18291 or tblfeedback.strbusinessname='Stamford Grand North Ryde' or tblfeedback.strbusinessname='Stamford Grand North Ryde') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
DA Florentino Ristorante
North Sydney NSW 2060
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=8892 or tblfeedback.strbusinessname='DA Florentino Ristorante' or tblfeedback.strbusinessname='DA Florentino Ristorante') 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
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
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
Villa Caprese Italian Restaurant
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=11893 or tblfeedback.strbusinessname='Villa Caprese Italian Restaurant' or tblfeedback.strbusinessname='Villa Caprese Italian Restaurant') 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
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
Sydney Showboats
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=11656 or tblfeedback.strbusinessname='Sydney Showboats' or tblfeedback.strbusinessname='Sydney Showboats') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gledswood Country Weddings
Catherine Field NSW 2171
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=9468 or tblfeedback.strbusinessname='Gledswood Country Weddings' or tblfeedback.strbusinessname='Gledswood Country Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian Jockey Club
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=2183 or tblfeedback.strbusinessname='Australian Jockey Club' or tblfeedback.strbusinessname='Australian Jockey Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
KMP Wedding Coordination
Gladesville NSW 2111
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=10093 or tblfeedback.strbusinessname='KMP Wedding Coordination' or tblfeedback.strbusinessname='KMP Wedding Coordination') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Renaissance Sydney Hotel
Circular Quay 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=11130 or tblfeedback.strbusinessname='Renaissance Sydney Hotel' or tblfeedback.strbusinessname='Renaissance Sydney Hotel') 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
North Sydney Club Ltd
North Sydney NSW 2060
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=10727 or tblfeedback.strbusinessname='North Sydney Club Ltd' or tblfeedback.strbusinessname='North Sydney Club Ltd') 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
Choice Charters
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=8649 or tblfeedback.strbusinessname='Choice Charters' or tblfeedback.strbusinessname='Choice Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Spot Lounge & Chinese Restaurant
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=11489 or tblfeedback.strbusinessname='Spot Lounge &%%semi%% Chinese Restaurant' or tblfeedback.strbusinessname='Spot Lounge & Chinese Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Macquarie Graduate School of Management (Mgsm)
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=10314 or tblfeedback.strbusinessname='Macquarie Graduate School of Management (%%semi%%Mgsm)%%semi%%' or tblfeedback.strbusinessname='Macquarie Graduate School of Management (Mgsm)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Aboard N T W Allan
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=7710 or tblfeedback.strbusinessname='Aboard N T W Allan' or tblfeedback.strbusinessname='Aboard N T W Allan') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fontana DI Trevi Pty Ltd
Bankstown NSW 2200
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=9326 or tblfeedback.strbusinessname='Fontana DI Trevi Pty Ltd' or tblfeedback.strbusinessname='Fontana DI Trevi Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fontainebleau Inn The
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=9325 or tblfeedback.strbusinessname='Fontainebleau Inn The' or tblfeedback.strbusinessname='Fontainebleau Inn The') 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
Quay Grand Suites Sydney
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=11088 or tblfeedback.strbusinessname='Quay Grand Suites Sydney' or tblfeedback.strbusinessname='Quay Grand Suites Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elizabeth Bay House
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=9144 or tblfeedback.strbusinessname='Elizabeth Bay House' or tblfeedback.strbusinessname='Elizabeth Bay House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Palais The
Leichhardt NSW 2040
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=10809 or tblfeedback.strbusinessname='Palais The' or tblfeedback.strbusinessname='Palais The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Falls Function Centre The
Oxford Falls 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=9245 or tblfeedback.strbusinessname='Falls Function Centre The' or tblfeedback.strbusinessname='Falls Function Centre The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Nirimba Room
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=10698 or tblfeedback.strbusinessname='Nirimba Room' or tblfeedback.strbusinessname='Nirimba Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abcot Int Motor Inn
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=2133 or tblfeedback.strbusinessname='Abcot Int Motor Inn' or tblfeedback.strbusinessname='Abcot Int Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Absolutely Fabulous Harbour Trek
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=2138 or tblfeedback.strbusinessname='Absolutely Fabulous Harbour Trek' or tblfeedback.strbusinessname='Absolutely Fabulous Harbour Trek') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Emerald Function Centre The
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=9168 or tblfeedback.strbusinessname='Emerald Function Centre The' or tblfeedback.strbusinessname='Emerald Function Centre The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Westside & Astra Reception Lounges
Marrickville NSW 2204
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=12015 or tblfeedback.strbusinessname='Westside &%%semi%% Astra Reception Lounges' or tblfeedback.strbusinessname='Westside & Astra Reception Lounges') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abbey Restaurant The
Glebe NSW 2037
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=2130 or tblfeedback.strbusinessname='Abbey Restaurant The' or tblfeedback.strbusinessname='Abbey Restaurant The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 444 Sort search results alphabetically