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
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
Rating
A Aquablue Charters
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=7631 or tblfeedback.strbusinessname='A Aquablue Charters' or tblfeedback.strbusinessname='A Aquablue Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Comedy Cruise
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=2117 or tblfeedback.strbusinessname='A Comedy Cruise' or tblfeedback.strbusinessname='A Comedy Cruise') 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
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
A 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=2124 or tblfeedback.strbusinessname='A Villa Caprese' or tblfeedback.strbusinessname='A Villa Caprese') 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
AA All City Harbour Venue Weddings
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=2128 or tblfeedback.strbusinessname='AA All City Harbour Venue Weddings' or tblfeedback.strbusinessname='AA All City Harbour Venue Weddings') 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=2129 or tblfeedback.strbusinessname='Abbey Restaurant The' or tblfeedback.strbusinessname='Abbey Restaurant The') 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
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
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
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
Abcot International 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=2134 or tblfeedback.strbusinessname='Abcot International Motor Inn' or tblfeedback.strbusinessname='Abcot International Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abcris Holdings
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=2135 or tblfeedback.strbusinessname='Abcris Holdings' or tblfeedback.strbusinessname='Abcris Holdings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Aboard
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=2113 or tblfeedback.strbusinessname='Aboard' or tblfeedback.strbusinessname='Aboard') 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
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=2136 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
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
Addison Road Community Centre
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=2140 or tblfeedback.strbusinessname='Addison Road Community Centre' or tblfeedback.strbusinessname='Addison Road Community Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Adeel's Palace
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=2141 or tblfeedback.strbusinessname='Adeel'%%semi%%s Palace' or tblfeedback.strbusinessname='Adeel's Palace') 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
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
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
AJC Convention & Exhibition Centre
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=2148 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
All Seasons Premier Menzies 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=1941 or tblfeedback.strbusinessname='All Seasons Premier Menzies Hotel' or tblfeedback.strbusinessname='All Seasons Premier Menzies Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Sydney Harbour Boat Charters
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=2155 or tblfeedback.strbusinessname='All Sydney Harbour Boat Charters' or tblfeedback.strbusinessname='All Sydney Harbour Boat Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Allan N.T.W.
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=2156 or tblfeedback.strbusinessname='Allan N.T.W.' or tblfeedback.strbusinessname='Allan N.T.W.') 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
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
Altitude 1148
Bulli Tops NSW 2516
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=22090 or tblfeedback.strbusinessname='Altitude 1148' or tblfeedback.strbusinessname='Altitude 1148') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ambassador Lounge The
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=2159 or tblfeedback.strbusinessname='Ambassador Lounge The' or tblfeedback.strbusinessname='Ambassador Lounge The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ambrosia Seafood Restaurant
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=2160 or tblfeedback.strbusinessname='Ambrosia Seafood Restaurant' or tblfeedback.strbusinessname='Ambrosia Seafood Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ANA Harbour Grand Hotel 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=4662 or tblfeedback.strbusinessname='ANA Harbour Grand Hotel Sydney' or tblfeedback.strbusinessname='ANA Harbour Grand Hotel Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Angelo's on the Bay Restaurant
Cabarita 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=2162 or tblfeedback.strbusinessname='Angelo'%%semi%%s on the Bay Restaurant' or tblfeedback.strbusinessname='Angelo's on the Bay Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ANZ Conservation Theatre
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=2164 or tblfeedback.strbusinessname='ANZ Conservation Theatre' or tblfeedback.strbusinessname='ANZ Conservation Theatre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Aqua Princess Charters
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=2170 or tblfeedback.strbusinessname='Aqua Princess Charters' or tblfeedback.strbusinessname='Aqua Princess Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Araluen Catering Pty Ltd
Epping NSW 2121
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=2171 or tblfeedback.strbusinessname='Araluen Catering Pty Ltd' or tblfeedback.strbusinessname='Araluen Catering Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Arena Collins Wedding Videos
Granville 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=2173 or tblfeedback.strbusinessname='Arena Collins Wedding Videos' or tblfeedback.strbusinessname='Arena Collins Wedding Videos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Aristocrat Wedding & 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=2174 or tblfeedback.strbusinessname='Aristocrat Wedding &%%semi%% Function Centre' or tblfeedback.strbusinessname='Aristocrat Wedding & Function Centre') 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
As You Like It! Catering
North Narrabeen NSW 2101
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=2179 or tblfeedback.strbusinessname='As You Like It!%%semi%% Catering' or tblfeedback.strbusinessname='As You Like It! Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Asquith Rugby League Club
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=1947 or tblfeedback.strbusinessname='Asquith Rugby League Club' or tblfeedback.strbusinessname='Asquith Rugby League Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Astra & Westside Lounge
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=7923 or tblfeedback.strbusinessname='Astra &%%semi%% Westside Lounge' or tblfeedback.strbusinessname='Astra & Westside Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Athol Hall
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=18246 or tblfeedback.strbusinessname='Athol Hall' or tblfeedback.strbusinessname='Athol Hall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Atrium 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=7930 or tblfeedback.strbusinessname='Atrium The' or tblfeedback.strbusinessname='Atrium The') 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
Aussie Pub Tours
Leppington 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=7946 or tblfeedback.strbusinessname='Aussie Pub Tours' or tblfeedback.strbusinessname='Aussie Pub Tours') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 444 Random Sort