Rating
Clarence House Function Centre
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=1999 or tblfeedback.strbusinessname='Clarence House Function Centre' or tblfeedback.strbusinessname='Clarence House Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Broadway Function 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=8397 or tblfeedback.strbusinessname='Broadway Function Centre' or tblfeedback.strbusinessname='Broadway Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bel Paese 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=8143 or tblfeedback.strbusinessname='Bel Paese Ristorante' or tblfeedback.strbusinessname='Bel Paese Ristorante') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Parramatta Leagues Club
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=2047 or tblfeedback.strbusinessname='Parramatta Leagues Club' or tblfeedback.strbusinessname='Parramatta Leagues Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Trethaway Gardens
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=11782 or tblfeedback.strbusinessname='Trethaway Gardens' or tblfeedback.strbusinessname='Trethaway Gardens') 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
Imperial Peking Afloat Rosebay
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=9805 or tblfeedback.strbusinessname='Imperial Peking Afloat Rosebay' or tblfeedback.strbusinessname='Imperial Peking Afloat Rosebay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Haldon Function Centre
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=9595 or tblfeedback.strbusinessname='Haldon Function Centre' or tblfeedback.strbusinessname='Haldon Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gledswood Homestead 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=9469 or tblfeedback.strbusinessname='Gledswood Homestead Country Weddings' or tblfeedback.strbusinessname='Gledswood Homestead Country Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Harbord Diggers Club
Harbord NSW 2096
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=9606 or tblfeedback.strbusinessname='Harbord Diggers Club' or tblfeedback.strbusinessname='Harbord Diggers Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mandavilla Function Centre
Horsley Park NSW 2164
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=10347 or tblfeedback.strbusinessname='Mandavilla Function Centre' or tblfeedback.strbusinessname='Mandavilla Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bankstown Paceway Function Centre
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=2198 or tblfeedback.strbusinessname='Bankstown Paceway Function Centre' or tblfeedback.strbusinessname='Bankstown Paceway Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lansdowne Motor Inn
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=10149 or tblfeedback.strbusinessname='Lansdowne Motor Inn' or tblfeedback.strbusinessname='Lansdowne Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rockdale Reception Centre
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=2066 or tblfeedback.strbusinessname='Rockdale Reception Centre' or tblfeedback.strbusinessname='Rockdale Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Water Transport
Balmain 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=11956 or tblfeedback.strbusinessname='Water Transport' or tblfeedback.strbusinessname='Water Transport') 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
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
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
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
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
Trade Winds Hotel
Maroubra NSW 2035
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=11773 or tblfeedback.strbusinessname='Trade Winds Hotel' or tblfeedback.strbusinessname='Trade Winds Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Blacktown Workers 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=18250 or tblfeedback.strbusinessname='Blacktown Workers Club' or tblfeedback.strbusinessname='Blacktown Workers Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bankstown Sports Club 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=1942 or tblfeedback.strbusinessname='Bankstown Sports Club Ltd' or tblfeedback.strbusinessname='Bankstown Sports Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
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
Sebel Of Sydney The
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=2072 or tblfeedback.strbusinessname='Sebel Of Sydney The' or tblfeedback.strbusinessname='Sebel Of Sydney The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Penelope Cay's Ballroom
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=10888 or tblfeedback.strbusinessname='Penelope Cay'%%semi%%s Ballroom' or tblfeedback.strbusinessname='Penelope Cay's Ballroom') 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
Rating
Moore Park Golf Club
Moore Park NSW 2021
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=10549 or tblfeedback.strbusinessname='Moore Park Golf Club' or tblfeedback.strbusinessname='Moore Park Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
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
MCA
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=18280 or tblfeedback.strbusinessname='MCA' or tblfeedback.strbusinessname='MCA') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Coronation 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=8790 or tblfeedback.strbusinessname='Coronation Function Centre' or tblfeedback.strbusinessname='Coronation Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roundtable Catering & Conferences
Kensington NSW 2033
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=11243 or tblfeedback.strbusinessname='Roundtable Catering &%%semi%% Conferences' or tblfeedback.strbusinessname='Roundtable Catering & Conferences') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coogee Bay Hotel Function Venue
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=8780 or tblfeedback.strbusinessname='Coogee Bay Hotel Function Venue' or tblfeedback.strbusinessname='Coogee Bay Hotel Function Venue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Villa Rosa Lounge
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=11895 or tblfeedback.strbusinessname='Villa Rosa Lounge' or tblfeedback.strbusinessname='Villa Rosa Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Whale Beach Restaurant
Whale Beach NSW 2107
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=18305 or tblfeedback.strbusinessname='Whale Beach Restaurant' or tblfeedback.strbusinessname='Whale Beach Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Twin Reception Centre
Alexandria NSW 2015
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=11813 or tblfeedback.strbusinessname='Twin Reception Centre' or tblfeedback.strbusinessname='Twin Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
Galston Community Centre
Galston NSW 2159
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=9403 or tblfeedback.strbusinessname='Galston Community Centre' or tblfeedback.strbusinessname='Galston Community Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Island Paradise Weddings
Cremorne NSW 2090
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=9843 or tblfeedback.strbusinessname='Island Paradise Weddings' or tblfeedback.strbusinessname='Island Paradise Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Marriott Hotel
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=10401 or tblfeedback.strbusinessname='Marriott Hotel' or tblfeedback.strbusinessname='Marriott Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Manly Pacific Parkroyal
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=2018 or tblfeedback.strbusinessname='Manly Pacific Parkroyal' or tblfeedback.strbusinessname='Manly Pacific Parkroyal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A LA Gondola Reception Lounge
Earlwood NSW 2206
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=2119 or tblfeedback.strbusinessname='A LA Gondola Reception Lounge' or tblfeedback.strbusinessname='A LA Gondola Reception Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chatties Reception Centre
Chatswood NSW 2067
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=8620 or tblfeedback.strbusinessname='Chatties Reception Centre' or tblfeedback.strbusinessname='Chatties Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 443 Sort search results alphabetically