Rating Northern Beaches Limousines
Northern Beaches Limousines
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=17347 or tblfeedback.strbusinessname='Northern Beaches Limousines' or tblfeedback.strbusinessname='Northern Beaches Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Committed to providing a luxury standard of old fashioned service at excellent rates.
Rating Classic Bridal Cars
Classic Bridal Cars
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=19474 or tblfeedback.strbusinessname='Classic Bridal Cars' or tblfeedback.strbusinessname='Classic Bridal Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sydney's most awarded wedding car operators understand that wedding cars are all about quality, reliability and service. With Sydney's largest exclusively silver collecti
Rating 7th Heaven Wedding Cars
7th Heaven Wedding Cars
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=18359 or tblfeedback.strbusinessname='7th Heaven Wedding Cars' or tblfeedback.strbusinessname='7th Heaven Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Twenty years of champagne heaven - the start of your fairytale!

Rating
Roll Up In A Rolls
Taren Point NSW 2229
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=11210 or tblfeedback.strbusinessname='Roll Up In A Rolls' or tblfeedback.strbusinessname='Roll Up In A Rolls') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sydney Eleanor Hire
Ryde NSW 2112
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=36353 or tblfeedback.strbusinessname='Sydney Eleanor Hire' or tblfeedback.strbusinessname='Sydney Eleanor Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Variety Wedding Cars
Cammeray NSW 2062
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=11853 or tblfeedback.strbusinessname='Variety Wedding Cars' or tblfeedback.strbusinessname='Variety Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sydney Mustangs
Carlton NSW 2218
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=23148 or tblfeedback.strbusinessname='Sydney Mustangs' or tblfeedback.strbusinessname='Sydney Mustangs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Castlereagh Wedding Carriages
Badgerys Creek NSW 2555
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=29604 or tblfeedback.strbusinessname='Castlereagh Wedding Carriages' or tblfeedback.strbusinessname='Castlereagh Wedding Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
A1 Limousines
Bass Hill NSW 2197
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=21905 or tblfeedback.strbusinessname='A1 Limousines' or tblfeedback.strbusinessname='A1 Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
HF Wedding & Hire Cars
Haberfield NSW 2045
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=21437 or tblfeedback.strbusinessname='HF Wedding &%%semi%% Hire Cars' or tblfeedback.strbusinessname='HF Wedding & Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tuf 57 Chevy's
Rooty Hill NSW 2766
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=1229 or tblfeedback.strbusinessname='Tuf 57 Chevy'%%semi%%s' or tblfeedback.strbusinessname='Tuf 57 Chevy's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ashdown & Bee
Summer Hill NSW 2130
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=23256 or tblfeedback.strbusinessname='Ashdown &%%semi%% Bee' or tblfeedback.strbusinessname='Ashdown & Bee') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
WOW Limos
Wetherill 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=38364 or tblfeedback.strbusinessname='WOW Limos' or tblfeedback.strbusinessname='WOW Limos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
ACE American Convertibles
Berkshire Park NSW 2765
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=2657 or tblfeedback.strbusinessname='ACE American Convertibles' or tblfeedback.strbusinessname='ACE American Convertibles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sydney Brock Hire
Strathfield NSW 2135
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=26489 or tblfeedback.strbusinessname='Sydney Brock Hire' or tblfeedback.strbusinessname='Sydney Brock Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
NBL limousines
Sydney & Hunter Valley 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=44740 or tblfeedback.strbusinessname='NBL limousines' or tblfeedback.strbusinessname='NBL limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Oz Limo Hire
Guildford 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=26215 or tblfeedback.strbusinessname='Oz Limo Hire' or tblfeedback.strbusinessname='Oz Limo Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kombi Weddings
Mona Vale NSW 2103
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=29138 or tblfeedback.strbusinessname='Kombi Weddings' or tblfeedback.strbusinessname='Kombi Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Entice Wedding Cars
Cecil Hills 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=20130 or tblfeedback.strbusinessname='Entice Wedding Cars' or tblfeedback.strbusinessname='Entice Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Queen St Car Hire
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=23839 or tblfeedback.strbusinessname='Queen St Car Hire' or tblfeedback.strbusinessname='Queen St Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sydney seaplanes
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=25944 or tblfeedback.strbusinessname='Sydney seaplanes' or tblfeedback.strbusinessname='Sydney seaplanes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Show Limousines
Wattle Grove NSW 2173
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=27793 or tblfeedback.strbusinessname='Show Limousines' or tblfeedback.strbusinessname='Show Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roll up in style
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=24777 or tblfeedback.strbusinessname='Roll up in style' or tblfeedback.strbusinessname='Roll up in style') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Klassic Kombiz
Woolooware 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=23288 or tblfeedback.strbusinessname='Klassic Kombiz' or tblfeedback.strbusinessname='Klassic Kombiz') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Castlereagh Wedding Carriages
Badgerys Creek 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=8558 or tblfeedback.strbusinessname='Castlereagh Wedding Carriages' or tblfeedback.strbusinessname='Castlereagh Wedding Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Castlecrest Wedding Carriages
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=27151 or tblfeedback.strbusinessname='Castlecrest Wedding Carriages' or tblfeedback.strbusinessname='Castlecrest Wedding Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Broadway limousines
Sydney 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=21884 or tblfeedback.strbusinessname='Broadway limousines' or tblfeedback.strbusinessname='Broadway limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Astra Chauffeur Drive Limousines of Australia
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=7924 or tblfeedback.strbusinessname='Astra Chauffeur Drive Limousines of Australia' or tblfeedback.strbusinessname='Astra Chauffeur Drive Limousines of Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
About Town Bridal Cars
Greystanes NSW 2145
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=2643 or tblfeedback.strbusinessname='About Town Bridal Cars' or tblfeedback.strbusinessname='About Town Bridal Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Excel Wedding Limousines
Canterbury NSW 2193
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=9216 or tblfeedback.strbusinessname='Excel Wedding Limousines' or tblfeedback.strbusinessname='Excel Wedding Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hughes Chauffeured Cars Limousines-Coaches
Mascot NSW 2020
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=9754 or tblfeedback.strbusinessname='Hughes Chauffeured Cars Limousines-Coaches' or tblfeedback.strbusinessname='Hughes Chauffeured Cars Limousines-Coaches') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
American Hot Rods
Girraween NSW 2145
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=7833 or tblfeedback.strbusinessname='American Hot Rods' or tblfeedback.strbusinessname='American Hot Rods') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Imperial Limousines & Hire Cars
Monterey NSW 2217
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=9804 or tblfeedback.strbusinessname='Imperial Limousines &%%semi%% Hire Cars' or tblfeedback.strbusinessname='Imperial Limousines & Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
HSV Wedding Classics
Casula 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=9749 or tblfeedback.strbusinessname='HSV Wedding Classics' or tblfeedback.strbusinessname='HSV Wedding Classics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cloud 9 Rolls Royce Wedding Cars
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=8730 or tblfeedback.strbusinessname='Cloud 9 Rolls Royce Wedding Cars' or tblfeedback.strbusinessname='Cloud 9 Rolls Royce Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cadillac Convertibles
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=8451 or tblfeedback.strbusinessname='Cadillac Convertibles' or tblfeedback.strbusinessname='Cadillac Convertibles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A TM European Limousines
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=1307 or tblfeedback.strbusinessname='A TM European Limousines' or tblfeedback.strbusinessname='A TM European Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jags 4 US
West Ryde NSW 2114
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=9866 or tblfeedback.strbusinessname='Jags 4 US' or tblfeedback.strbusinessname='Jags 4 US') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Regal Rolls
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=11121 or tblfeedback.strbusinessname='Regal Rolls' or tblfeedback.strbusinessname='Regal Rolls') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Flair Wedding Cars
Ryde NSW 2112
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=7796 or tblfeedback.strbusinessname='All Flair Wedding Cars' or tblfeedback.strbusinessname='All Flair Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cadillac Limousine Connection 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=8455 or tblfeedback.strbusinessname='Cadillac Limousine Connection The' or tblfeedback.strbusinessname='Cadillac Limousine Connection The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
FJ Holden Wedding Cars 1954
Wentworthville NSW 2145
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=9290 or tblfeedback.strbusinessname='FJ Holden Wedding Cars 1954' or tblfeedback.strbusinessname='FJ Holden Wedding Cars 1954') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mustang Sally's Wedding Cars
West Pennant Hills NSW 2125
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=10607 or tblfeedback.strbusinessname='Mustang Sally'%%semi%%s Wedding Cars' or tblfeedback.strbusinessname='Mustang Sally's Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Angel's Own Wedding Car Hire
Hinchinbrook NSW 2168
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=7852 or tblfeedback.strbusinessname='Angel'%%semi%%s Own Wedding Car Hire' or tblfeedback.strbusinessname='Angel's Own Wedding Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Limousines 2000 Pty Ltd
Smithfield 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=1210 or tblfeedback.strbusinessname='Limousines 2000 Pty Ltd' or tblfeedback.strbusinessname='Limousines 2000 Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic Limousines
Concord West NSW 2138
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=8707 or tblfeedback.strbusinessname='Classic Limousines' or tblfeedback.strbusinessname='Classic Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Genuine Wedding Cars
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=9437 or tblfeedback.strbusinessname='Genuine Wedding Cars' or tblfeedback.strbusinessname='Genuine Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Benz 4 Babies
Normanhurst NSW 2076
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=8176 or tblfeedback.strbusinessname='Benz 4 Babies' or tblfeedback.strbusinessname='Benz 4 Babies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
MIB Limousines
Mascot NSW 2020
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=10478 or tblfeedback.strbusinessname='MIB Limousines' or tblfeedback.strbusinessname='MIB Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A & B City Metro Wedding Cars
Beverly Hills NSW 2209
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=1238 or tblfeedback.strbusinessname='A &%%semi%% B City Metro Wedding Cars' or tblfeedback.strbusinessname='A & B City Metro Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 350 Sort search results alphabetically