Rating
Penshurst RSL Club Co-Op
Penshurst NSW 2222
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=10899 or tblfeedback.strbusinessname='Penshurst RSL Club Co-Op' or tblfeedback.strbusinessname='Penshurst RSL Club Co-Op') 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
Blue Line Cruises
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=8248 or tblfeedback.strbusinessname='Blue Line Cruises' or tblfeedback.strbusinessname='Blue Line Cruises') 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
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
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
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
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
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
Mediterranean House Pty Ltd
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=10450 or tblfeedback.strbusinessname='Mediterranean House Pty Ltd' or tblfeedback.strbusinessname='Mediterranean House Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Orion Function Centre
Campsie NSW 2194
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=10791 or tblfeedback.strbusinessname='Orion Function Centre' or tblfeedback.strbusinessname='Orion Function Centre') 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
Rating
Northshore Charters
Taylors Point 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=10736 or tblfeedback.strbusinessname='Northshore Charters' or tblfeedback.strbusinessname='Northshore Charters') 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
Spitlers Restaurant
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=11485 or tblfeedback.strbusinessname='Spitlers Restaurant' or tblfeedback.strbusinessname='Spitlers Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Starlight Restaurant
Riverwood 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=11538 or tblfeedback.strbusinessname='Starlight Restaurant' or tblfeedback.strbusinessname='Starlight Restaurant') 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
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
Port Vista Function Centre
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=11030 or tblfeedback.strbusinessname='Port Vista Function Centre' or tblfeedback.strbusinessname='Port Vista Function Centre') 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
Astral Restaurant, Star City
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=18245 or tblfeedback.strbusinessname='Astral Restaurant, Star City' or tblfeedback.strbusinessname='Astral Restaurant, Star City') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Australian Jockey Club
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=2184 or tblfeedback.strbusinessname='Australian Jockey Club' or tblfeedback.strbusinessname='Australian Jockey 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
A Seivadis Charters
Mortlake NSW 2137
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=2123 or tblfeedback.strbusinessname='A Seivadis Charters' or tblfeedback.strbusinessname='A Seivadis Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
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
Liberte
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=10205 or tblfeedback.strbusinessname='Liberte' or tblfeedback.strbusinessname='Liberte') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Reflections Seafood Restaurant
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=11120 or tblfeedback.strbusinessname='Reflections Seafood Restaurant' or tblfeedback.strbusinessname='Reflections Seafood Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Captain Cook Cruises
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=1900 or tblfeedback.strbusinessname='Captain Cook Cruises' or tblfeedback.strbusinessname='Captain Cook Cruises') 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
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
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
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
Buoni Amici
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=8425 or tblfeedback.strbusinessname='Buoni Amici' or tblfeedback.strbusinessname='Buoni Amici') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cottage Point Inn Restaurant Pty Ltd
Cottage Point NSW 2084
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=8797 or tblfeedback.strbusinessname='Cottage Point Inn Restaurant Pty Ltd' or tblfeedback.strbusinessname='Cottage Point Inn Restaurant Pty Ltd') 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
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
Mode Group 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=10531 or tblfeedback.strbusinessname='Mode Group The' or tblfeedback.strbusinessname='Mode Group The') 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
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
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
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
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
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
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
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
Grand Barclay
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=9539 or tblfeedback.strbusinessname='Grand Barclay' or tblfeedback.strbusinessname='Grand Barclay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 444 Sort search results alphabetically