Crowne Plaza Coogee Beach
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=19672 or tblfeedback.strbusinessname='Crowne Plaza Coogee Beach' or tblfeedback.strbusinessname='Crowne Plaza Coogee Beach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Vibe Hotels
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=19557 or tblfeedback.strbusinessname='Vibe Hotels' or tblfeedback.strbusinessname='Vibe Hotels') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Vibe Hotels offer fresh & vibrant venues for your reception & are perfectly located. We work with you to create your dream event from "will you marry me" to "I do". At Vibe, we want your wedding to be all about you, your family & friends. And lots of fun!
Manly Yacht Club
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=20803 or tblfeedback.strbusinessname='Manly Yacht Club' or tblfeedback.strbusinessname='Manly Yacht Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The perfect waterfront venue.
Parramatta Waldorf Apartment Hotel
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=19882 or tblfeedback.strbusinessname='Parramatta Waldorf Apartment Hotel' or tblfeedback.strbusinessname='Parramatta Waldorf Apartment Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Extensive facilities for Weddings, up to 400 guests.
Pennant Hills Function Centre
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=19880 or tblfeedback.strbusinessname='Pennant Hills Function Centre' or tblfeedback.strbusinessname='Pennant Hills Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Extensive function facilities for weddings, all individualised.
Monash Country Club
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=19713 or tblfeedback.strbusinessname='Monash Country Club' or tblfeedback.strbusinessname='Monash Country Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Unique bushland setting & superb ocean views.
Ovolo Woolloomooloo
Woolloomooloo 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=35920 or tblfeedback.strbusinessname='Ovolo Woolloomooloo' or tblfeedback.strbusinessname='Ovolo Woolloomooloo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Le Montage
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=18277 or tblfeedback.strbusinessname='Le Montage' or tblfeedback.strbusinessname='Le Montage') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Zest at the Spit
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=22868 or tblfeedback.strbusinessname='Zest at the Spit' or tblfeedback.strbusinessname='Zest at the Spit') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Paradiso Weddings & Events (Macquarie 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=26783 or tblfeedback.strbusinessname='Paradiso Weddings &%%semi%% Events (%%semi%%Macquarie Room)%%semi%%' or tblfeedback.strbusinessname='Paradiso Weddings & Events (Macquarie Room)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Shangri-La 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=43287 or tblfeedback.strbusinessname='Shangri-La Sydney' or tblfeedback.strbusinessname='Shangri-La Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Madison Function Centre
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=29271 or tblfeedback.strbusinessname='The Madison Function Centre' or tblfeedback.strbusinessname='The Madison Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Nepean Rowing Club
Penrith NSW 2750
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=10649 or tblfeedback.strbusinessname='Nepean Rowing Club' or tblfeedback.strbusinessname='Nepean Rowing Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Splash Restaurant
Terrigal NSW 2260
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=25740 or tblfeedback.strbusinessname='Splash Restaurant' or tblfeedback.strbusinessname='Splash Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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=23080 or tblfeedback.strbusinessname='Clarence House' or tblfeedback.strbusinessname='Clarence House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Royal Botanic Gardens 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=11250 or tblfeedback.strbusinessname='Royal Botanic Gardens Sydney' or tblfeedback.strbusinessname='Royal Botanic Gardens Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Tea 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=18300 or tblfeedback.strbusinessname='The Tea Room' or tblfeedback.strbusinessname='The Tea Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mayfield Gardens
Oberon NSW 2787
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=36079 or tblfeedback.strbusinessname='Mayfield Gardens' or tblfeedback.strbusinessname='Mayfield Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Seclusions
Rydal NSW 2790
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=26965 or tblfeedback.strbusinessname='Seclusions' or tblfeedback.strbusinessname='Seclusions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tattersalls on Elizabeth Street
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=20114 or tblfeedback.strbusinessname='Tattersalls on Elizabeth Street' or tblfeedback.strbusinessname='Tattersalls on Elizabeth Street') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sergeants Mess
Chowder Bay 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=40994 or tblfeedback.strbusinessname='Sergeants Mess' or tblfeedback.strbusinessname='Sergeants Mess') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Conca D'Oro
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=45854 or tblfeedback.strbusinessname='Conca D'%%semi%%Oro' or tblfeedback.strbusinessname='Conca D'Oro') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Springfield Function Centre
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=1972 or tblfeedback.strbusinessname='Springfield Function Centre' or tblfeedback.strbusinessname='Springfield Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wildwood Kangaroo Valley
Kangaroo Valley NSW 2577
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=24919 or tblfeedback.strbusinessname='Wildwood Kangaroo Valley' or tblfeedback.strbusinessname='Wildwood Kangaroo Valley') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Long Reef Golf Club
Collaroy NSW 2097
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=10267 or tblfeedback.strbusinessname='Long Reef Golf Club' or tblfeedback.strbusinessname='Long Reef Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Seclusions Blue Mountains
Rydal NSW 2790
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=41143 or tblfeedback.strbusinessname='Seclusions Blue Mountains' or tblfeedback.strbusinessname='Seclusions Blue Mountains') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Colebee Centre
Doonside NSW 2767
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=18258 or tblfeedback.strbusinessname='Colebee Centre' or tblfeedback.strbusinessname='Colebee Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Robertson Public House
Robertson NSW 2577
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=44762 or tblfeedback.strbusinessname='Robertson Public House' or tblfeedback.strbusinessname='Robertson Public House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sergeants' Mess
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=23182 or tblfeedback.strbusinessname='Sergeants'%%semi%% Mess' or tblfeedback.strbusinessname='Sergeants' Mess') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Metro Mirage Hotel Newport
Newport NSW 2106
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=36141 or tblfeedback.strbusinessname='Metro Mirage Hotel Newport' or tblfeedback.strbusinessname='Metro Mirage Hotel Newport') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Gledswood Homestead
Catherine Fields NSW 2557
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=26081 or tblfeedback.strbusinessname='Gledswood Homestead' or tblfeedback.strbusinessname='Gledswood Homestead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Starship Sydney & The Pontoon
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=23229 or tblfeedback.strbusinessname='Starship Sydney &%%semi%% The Pontoon' or tblfeedback.strbusinessname='Starship Sydney & The Pontoon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lachlan's Old Government House
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=44178 or tblfeedback.strbusinessname='Lachlan'%%semi%%s Old Government House' or tblfeedback.strbusinessname='Lachlan's Old Government House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Luna Park Sydney
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=25873 or tblfeedback.strbusinessname='Luna Park Sydney' or tblfeedback.strbusinessname='Luna Park Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tap House
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=41127 or tblfeedback.strbusinessname='Tap House' or tblfeedback.strbusinessname='Tap House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
EPICURE at State Library SA
Adelaide SA 5000
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=29656 or tblfeedback.strbusinessname='EPICURE at State Library SA' or tblfeedback.strbusinessname='EPICURE at State Library SA') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Dockside
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=1946 or tblfeedback.strbusinessname='Dockside' or tblfeedback.strbusinessname='Dockside') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Starship Sydney
Darling Habour 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=36335 or tblfeedback.strbusinessname='Starship Sydney' or tblfeedback.strbusinessname='Starship Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Emporium 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=9170 or tblfeedback.strbusinessname='Emporium Function Centre' or tblfeedback.strbusinessname='Emporium Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Watsons Bay Boutique Hotel
Watsons Bay NSW 2030
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=27213 or tblfeedback.strbusinessname='Watsons Bay Boutique Hotel' or tblfeedback.strbusinessname='Watsons Bay Boutique Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Italian Food Project
Camden NSW 2570
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=39894 or tblfeedback.strbusinessname='The Italian Food Project' or tblfeedback.strbusinessname='The Italian Food Project') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
St Aubyn's on Clairvaux
Bathurst NSW 2795
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=27217 or tblfeedback.strbusinessname='St Aubyn'%%semi%%s on Clairvaux' or tblfeedback.strbusinessname='St Aubyn's on Clairvaux') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Curzon Hall
Marsfield 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=1948 or tblfeedback.strbusinessname='Curzon Hall' or tblfeedback.strbusinessname='Curzon Hall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Cropley House
Baulkham Hills NSW 2153
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=2000 or tblfeedback.strbusinessname='Cropley House' or tblfeedback.strbusinessname='Cropley House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Beekeepers Inn Cafe
Vittoria NSW 2799
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=44665 or tblfeedback.strbusinessname='Beekeepers Inn Cafe' or tblfeedback.strbusinessname='Beekeepers Inn Cafe') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
P&O Cruises Jewel
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=25820 or tblfeedback.strbusinessname='P&%%semi%%O Cruises Jewel' or tblfeedback.strbusinessname='P&O Cruises Jewel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Eat Your Greens
Eugowra NSW 2806
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=18262 or tblfeedback.strbusinessname='Eat Your Greens' or tblfeedback.strbusinessname='Eat Your Greens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Himalaya Emporium Function Centre
Bankstown NSW 9708
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=23511 or tblfeedback.strbusinessname='Himalaya Emporium Function Centre' or tblfeedback.strbusinessname='Himalaya Emporium Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
