Rating
Loxley on Bellbird Hill
Kurrajong Hills NSW 2758
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=10281 or tblfeedback.strbusinessname='Loxley on Bellbird Hill' or tblfeedback.strbusinessname='Loxley on Bellbird Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Castle D'Oro
Five Dock NSW 2046
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=18255 or tblfeedback.strbusinessname='Castle D'%%semi%%Oro' or tblfeedback.strbusinessname='Castle D'Oro') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Harbord Diggers Memorial 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=18267 or tblfeedback.strbusinessname='Harbord Diggers Memorial Club' or tblfeedback.strbusinessname='Harbord Diggers Memorial Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Vaudeville The
Revesby NSW 2212
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=11856 or tblfeedback.strbusinessname='Vaudeville The' or tblfeedback.strbusinessname='Vaudeville The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Lincoln Room
WestGuildford NSW 2161
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=18278 or tblfeedback.strbusinessname='Lincoln Room' or tblfeedback.strbusinessname='Lincoln Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Sydney Crystal Boat Charters
Neutral Bay NSW 2089
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=11643 or tblfeedback.strbusinessname='Sydney Crystal Boat Charters' or tblfeedback.strbusinessname='Sydney Crystal Boat Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Five Dock RSL Community Club
Five Dock NSW 2046
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=9288 or tblfeedback.strbusinessname='Five Dock RSL Community Club' or tblfeedback.strbusinessname='Five Dock RSL Community 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
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
Danny's Seafood Restaurant LA Perouse
La Perouse NSW 2036
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=8904 or tblfeedback.strbusinessname='Danny'%%semi%%s Seafood Restaurant LA Perouse' or tblfeedback.strbusinessname='Danny's Seafood Restaurant LA Perouse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Allegro
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=2157 or tblfeedback.strbusinessname='Allegro' or tblfeedback.strbusinessname='Allegro') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Swiss Grand Resort Bondi
Bondi Beach NSW 2026
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=18294 or tblfeedback.strbusinessname='Swiss Grand Resort Bondi' or tblfeedback.strbusinessname='Swiss Grand Resort Bondi') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian Cruise Events Pty Ltd
Lane Cove NSW 2066
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=2182 or tblfeedback.strbusinessname='Australian Cruise Events Pty Ltd' or tblfeedback.strbusinessname='Australian Cruise Events Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
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
Sydney Sundancer
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=11657 or tblfeedback.strbusinessname='Sydney Sundancer' or tblfeedback.strbusinessname='Sydney Sundancer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Banjo Paterson Cottage Restaurant
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=1990 or tblfeedback.strbusinessname='Banjo Paterson Cottage Restaurant' or tblfeedback.strbusinessname='Banjo Paterson Cottage Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Audley Historic Dance Hall R N P
Sutherland NSW 2232
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=7935 or tblfeedback.strbusinessname='Audley Historic Dance Hall R N P' or tblfeedback.strbusinessname='Audley Historic Dance Hall R N P') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Festival House
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=9274 or tblfeedback.strbusinessname='Festival House' or tblfeedback.strbusinessname='Festival House') 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
Castle Hill RSL Club 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=8556 or tblfeedback.strbusinessname='Castle Hill RSL Club Ltd' or tblfeedback.strbusinessname='Castle Hill RSL Club Ltd') 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
Botany Bay Cruises
Carlingford NSW 2118
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=8300 or tblfeedback.strbusinessname='Botany Bay Cruises' or tblfeedback.strbusinessname='Botany Bay Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pavilion on the Park
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=17181 or tblfeedback.strbusinessname='Pavilion on the Park' or tblfeedback.strbusinessname='Pavilion on the Park') 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
Parra Villa Function Lounge
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=2045 or tblfeedback.strbusinessname='Parra Villa Function Lounge' or tblfeedback.strbusinessname='Parra Villa Function Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Le Kiosk
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=18276 or tblfeedback.strbusinessname='Le Kiosk' or tblfeedback.strbusinessname='Le Kiosk') 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
Parkroyal at Darling Harbour
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=2042 or tblfeedback.strbusinessname='Parkroyal at Darling Harbour' or tblfeedback.strbusinessname='Parkroyal at Darling Harbour') 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
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
The Argyle
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=18296 or tblfeedback.strbusinessname='The Argyle' or tblfeedback.strbusinessname='The Argyle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wedding Receptions
Brooklyn NSW 2083
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=11991 or tblfeedback.strbusinessname='Wedding Receptions' or tblfeedback.strbusinessname='Wedding Receptions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
L'Incontro Restaurant
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=10221 or tblfeedback.strbusinessname='L'%%semi%%Incontro Restaurant' or tblfeedback.strbusinessname='L'Incontro Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
New Westella Reception Centre
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=10667 or tblfeedback.strbusinessname='New Westella Reception Centre' or tblfeedback.strbusinessname='New Westella Reception Centre') 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
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
Rydges North Sydney
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=11268 or tblfeedback.strbusinessname='Rydges North Sydney' or tblfeedback.strbusinessname='Rydges North Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Maddison Grove Reception Centre 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=10317 or tblfeedback.strbusinessname='Maddison Grove Reception Centre The' or tblfeedback.strbusinessname='Maddison Grove Reception Centre The') 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
Ocean Spirit 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=10760 or tblfeedback.strbusinessname='Ocean Spirit Cruises' or tblfeedback.strbusinessname='Ocean Spirit Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
LA Palma Restaurant
Palm Beach NSW 2108
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=10135 or tblfeedback.strbusinessname='LA Palma Restaurant' or tblfeedback.strbusinessname='LA Palma Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Villa Caprese
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=11892 or tblfeedback.strbusinessname='Villa Caprese' or tblfeedback.strbusinessname='Villa Caprese') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dimitri's Bar & Restaurant
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=9026 or tblfeedback.strbusinessname='Dimitri'%%semi%%s Bar &%%semi%% Restaurant' or tblfeedback.strbusinessname='Dimitri's Bar & Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A 1 Caterers
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=2112 or tblfeedback.strbusinessname='A 1 Caterers' or tblfeedback.strbusinessname='A 1 Caterers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 444 Sort search results alphabetically