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
star ratingstar ratingstar ratingstar ratingstar rating
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
French Limousines
Northbridge NSW 2063
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=9369 or tblfeedback.strbusinessname='French Limousines' or tblfeedback.strbusinessname='French Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brentwood Limousines
Milperra NSW 2214
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=8362 or tblfeedback.strbusinessname='Brentwood Limousines' or tblfeedback.strbusinessname='Brentwood Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Monterey Classic Convertibles
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=10543 or tblfeedback.strbusinessname='Monterey Classic Convertibles' or tblfeedback.strbusinessname='Monterey Classic Convertibles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wedding Car King The
Caringbah 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=11977 or tblfeedback.strbusinessname='Wedding Car King The' or tblfeedback.strbusinessname='Wedding Car King The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Arrow Services
Frenchs Forest NSW 2086
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=1245 or tblfeedback.strbusinessname='A Arrow Services' or tblfeedback.strbusinessname='A Arrow Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Victoria Wedding Carriages
Rouse Hill NSW 2155
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=11878 or tblfeedback.strbusinessname='Victoria Wedding Carriages' or tblfeedback.strbusinessname='Victoria Wedding Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Magnolia Wedding Cars
Ashfield NSW 2131
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=10329 or tblfeedback.strbusinessname='Magnolia Wedding Cars' or tblfeedback.strbusinessname='Magnolia Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wheels 4 Kids
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=12022 or tblfeedback.strbusinessname='Wheels 4 Kids' or tblfeedback.strbusinessname='Wheels 4 Kids') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Happy Day Wedding Cars
Eastwood 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=1292 or tblfeedback.strbusinessname='A Happy Day Wedding Cars' or tblfeedback.strbusinessname='A Happy Day Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Northside Hire Cars-Limousines
Westleigh NSW 2120
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=10737 or tblfeedback.strbusinessname='Northside Hire Cars-Limousines' or tblfeedback.strbusinessname='Northside Hire Cars-Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ABC Wedding Cars
West Pymble NSW 2073
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=7706 or tblfeedback.strbusinessname='ABC Wedding Cars' or tblfeedback.strbusinessname='ABC Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Attunga Sutherland Shire Limousine Service
Yowie Bay 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=7933 or tblfeedback.strbusinessname='Attunga Sutherland Shire Limousine Service' or tblfeedback.strbusinessname='Attunga Sutherland Shire Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hills District Prestige Limous
West Pennant 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=18329 or tblfeedback.strbusinessname='Hills District Prestige Limous' or tblfeedback.strbusinessname='Hills District Prestige Limous') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
All American Classic Wedding Cars & Harleys
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=7784 or tblfeedback.strbusinessname='All American Classic Wedding Cars &%%semi%% Harleys' or tblfeedback.strbusinessname='All American Classic Wedding Cars & Harleys') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Marciano Wedding Cars
Kemps 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=10364 or tblfeedback.strbusinessname='Marciano Wedding Cars' or tblfeedback.strbusinessname='Marciano Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Amex Limousines
Pymble NSW 2073
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=7834 or tblfeedback.strbusinessname='Amex Limousines' or tblfeedback.strbusinessname='Amex Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Impeccable Cars by Jaguar
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=9802 or tblfeedback.strbusinessname='Impeccable Cars by Jaguar' or tblfeedback.strbusinessname='Impeccable Cars by Jaguar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Abbey Limousines
Alfords Point NSW 2234
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=1313 or tblfeedback.strbusinessname='A Abbey Limousines' or tblfeedback.strbusinessname='A Abbey Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
European Hire Cars Pty Ltd
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=9203 or tblfeedback.strbusinessname='European Hire Cars Pty Ltd' or tblfeedback.strbusinessname='European Hire Cars Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Allstar Classic Wedding Cars
Mcmahons Point 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=7817 or tblfeedback.strbusinessname='Allstar Classic Wedding Cars' or tblfeedback.strbusinessname='Allstar Classic Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Crown Imperial Limousines
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=8853 or tblfeedback.strbusinessname='Crown Imperial Limousines' or tblfeedback.strbusinessname='Crown Imperial Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic Bowtie Chevy's
Rossmore 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=8692 or tblfeedback.strbusinessname='Classic Bowtie Chevy'%%semi%%s' or tblfeedback.strbusinessname='Classic Bowtie Chevy's') 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
VIP Harbour Transport
Waverton 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=11904 or tblfeedback.strbusinessname='VIP Harbour Transport' or tblfeedback.strbusinessname='VIP Harbour Transport') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 354 Sort search results alphabetically