Rating
Newcastle Classic Holden Wedding Cars
Redhead NSW 2290
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=26851 or tblfeedback.strbusinessname='Newcastle Classic Holden Wedding Cars' or tblfeedback.strbusinessname='Newcastle Classic Holden Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Princess Classic Cars
Nulkaba NSW 2325
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=29053 or tblfeedback.strbusinessname='Princess Classic Cars' or tblfeedback.strbusinessname='Princess Classic Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Dollface Garage
Warners Bay NSW 2282
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=26535 or tblfeedback.strbusinessname='Dollface Garage' or tblfeedback.strbusinessname='Dollface Garage') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Betty Buick Car Hire
Belmont NSW 2280
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=25793 or tblfeedback.strbusinessname='Betty Buick Car Hire' or tblfeedback.strbusinessname='Betty Buick Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blake's Wedding Cars
Salamander Bay NSW 2317
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=8233 or tblfeedback.strbusinessname='Blake'%%semi%%s Wedding Cars' or tblfeedback.strbusinessname='Blake's Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Elegant Metal
East Maitland NSW 2323
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=26224 or tblfeedback.strbusinessname='Elegant Metal' or tblfeedback.strbusinessname='Elegant Metal') 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
Newcastle's Famous Tram
Newcastle NSW 2300
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=26610 or tblfeedback.strbusinessname='Newcastle'%%semi%%s Famous Tram' or tblfeedback.strbusinessname='Newcastle's Famous Tram') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Absolute Vintage Elegance Limousines
Whitebridge NSW 2290
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=38321 or tblfeedback.strbusinessname='Absolute Vintage Elegance Limousines' or tblfeedback.strbusinessname='Absolute Vintage Elegance Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Arrive First Class
Cardiff NSW 2285
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=23210 or tblfeedback.strbusinessname='Arrive First Class' or tblfeedback.strbusinessname='Arrive First Class') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Krusin Kombis
Redhead NSW 2290
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=21467 or tblfeedback.strbusinessname='Krusin Kombis' or tblfeedback.strbusinessname='Krusin Kombis') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Carriages for Marriages
Cams Wharf NSW 2281
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=8537 or tblfeedback.strbusinessname='Carriages for Marriages' or tblfeedback.strbusinessname='Carriages for Marriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lorn Limosines
Lorn NSW 2320
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=10271 or tblfeedback.strbusinessname='Lorn Limosines' or tblfeedback.strbusinessname='Lorn Limosines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Horse & Carriage Weddings
Maitland NSW 2320
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=9726 or tblfeedback.strbusinessname='Horse &%%semi%% Carriage Weddings' or tblfeedback.strbusinessname='Horse & Carriage Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brian Mc Donagh
Edgeworth NSW 2285
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=8367 or tblfeedback.strbusinessname='Brian Mc Donagh' or tblfeedback.strbusinessname='Brian Mc Donagh') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wright's Classic Wedding Cars
Salamander Bay NSW 2317
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=12094 or tblfeedback.strbusinessname='Wright'%%semi%%s Classic Wedding Cars' or tblfeedback.strbusinessname='Wright's Classic Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pokolbin Horse Coaches
Pokolbin NSW 2320
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=11014 or tblfeedback.strbusinessname='Pokolbin Horse Coaches' or tblfeedback.strbusinessname='Pokolbin Horse Coaches') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Something Different Mustang Weddings
Newcastle NSW 2300
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=11454 or tblfeedback.strbusinessname='Something Different Mustang Weddings' or tblfeedback.strbusinessname='Something Different Mustang Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Oatfields Stud
Woodberry NSW 2322
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=10753 or tblfeedback.strbusinessname='Oatfields Stud' or tblfeedback.strbusinessname='Oatfields Stud') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Academy Wedding Cars
Salt Ash NSW 2318
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=2648 or tblfeedback.strbusinessname='Academy Wedding Cars' or tblfeedback.strbusinessname='Academy Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Marque of Excellence The
Eleebana NSW 2282
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=10399 or tblfeedback.strbusinessname='Marque of Excellence The' or tblfeedback.strbusinessname='Marque of Excellence The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Silver Classic Limousines
Jesmond NSW 2299
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=18334 or tblfeedback.strbusinessname='Silver Classic Limousines' or tblfeedback.strbusinessname='Silver Classic Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hunter Horsedrive Society the Inc
East Maitland NSW 2323
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=9763 or tblfeedback.strbusinessname='Hunter Horsedrive Society the Inc' or tblfeedback.strbusinessname='Hunter Horsedrive Society the Inc') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Eureka Harley Tours
Newcastle NSW 2300
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=9199 or tblfeedback.strbusinessname='Eureka Harley Tours' or tblfeedback.strbusinessname='Eureka Harley Tours') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Commodore Performance Vehicles
Raymond Terrace NSW 2324
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=8767 or tblfeedback.strbusinessname='Commodore Performance Vehicles' or tblfeedback.strbusinessname='Commodore Performance Vehicles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Vineyard Spirits
Pokolbin NSW 2320
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=11899 or tblfeedback.strbusinessname='Vineyard Spirits' or tblfeedback.strbusinessname='Vineyard Spirits') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hunter Valley Limousines
Kurri Kurri NSW 2327
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=9766 or tblfeedback.strbusinessname='Hunter Valley Limousines' or tblfeedback.strbusinessname='Hunter Valley Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hastings Classic Cars
Wallsend NSW 2287
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=9629 or tblfeedback.strbusinessname='Hastings Classic Cars' or tblfeedback.strbusinessname='Hastings Classic Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Princess Limousines
New Lambton Heights NSW 2305
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=1213 or tblfeedback.strbusinessname='Princess Limousines' or tblfeedback.strbusinessname='Princess Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Castle Classic Cars
Islington NSW 2296
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=8554 or tblfeedback.strbusinessname='Castle Classic Cars' or tblfeedback.strbusinessname='Castle Classic Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
HSV Wedding Classics
Toronto NSW 2283
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=9748 or tblfeedback.strbusinessname='HSV Wedding Classics' or tblfeedback.strbusinessname='HSV Wedding Classics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Newcastle Hire Cars Pty Ltd
Waratah NSW 2298
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=10670 or tblfeedback.strbusinessname='Newcastle Hire Cars Pty Ltd' or tblfeedback.strbusinessname='Newcastle Hire Cars Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Silver Classics Limousines
Jesmond NSW 2299
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=11400 or tblfeedback.strbusinessname='Silver Classics Limousines' or tblfeedback.strbusinessname='Silver Classics Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Heritage Harley Escorts
Newcastle NSW 2300
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=9679 or tblfeedback.strbusinessname='Heritage Harley Escorts' or tblfeedback.strbusinessname='Heritage Harley Escorts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cadillaction
Cessnock NSW 2325
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=8459 or tblfeedback.strbusinessname='Cadillaction' or tblfeedback.strbusinessname='Cadillaction') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Absolute Vintage Elegance
New Lambton Heights NSW 2305
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=2645 or tblfeedback.strbusinessname='Absolute Vintage Elegance' or tblfeedback.strbusinessname='Absolute Vintage Elegance') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Donna's Limousines
Adamstown NSW 2289
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=9055 or tblfeedback.strbusinessname='Donna'%%semi%%s Limousines' or tblfeedback.strbusinessname='Donna's Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dennis Smith Rentals
Charlestown NSW 2290
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=8986 or tblfeedback.strbusinessname='Dennis Smith Rentals' or tblfeedback.strbusinessname='Dennis Smith Rentals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Allen Curtis Exclusive Vintage Wedding Cars
Lambton North NSW 2299
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=7815 or tblfeedback.strbusinessname='Allen Curtis Exclusive Vintage Wedding Cars' or tblfeedback.strbusinessname='Allen Curtis Exclusive Vintage Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Combined Hunter Limousines & Hire Cars
Newcastle NSW 2300
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=8766 or tblfeedback.strbusinessname='Combined Hunter Limousines &%%semi%% Hire Cars' or tblfeedback.strbusinessname='Combined Hunter Limousines & Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Aussie Classics Car Hire
Greenhills NSW 2323
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=7945 or tblfeedback.strbusinessname='Aussie Classics Car Hire' or tblfeedback.strbusinessname='Aussie Classics Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Traditional Wedding Cars
Warners Bay NSW 2282
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=1223 or tblfeedback.strbusinessname='Traditional Wedding Cars' or tblfeedback.strbusinessname='Traditional Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Nelson Bay Limousine Service
Salamander Bay NSW 2317
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=10644 or tblfeedback.strbusinessname='Nelson Bay Limousine Service' or tblfeedback.strbusinessname='Nelson Bay Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Blakes Wedding Cars
Newcastle NSW 2300
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=8232 or tblfeedback.strbusinessname='Blakes Wedding Cars' or tblfeedback.strbusinessname='Blakes Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Carriages for Marriages
Glen Oak NSW 2320
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=1114 or tblfeedback.strbusinessname='Carriages for Marriages' or tblfeedback.strbusinessname='Carriages for Marriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dream Limousines
Newcastle NSW 2300
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=9068 or tblfeedback.strbusinessname='Dream Limousines' or tblfeedback.strbusinessname='Dream Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Classic 56-57 Chevrolet Wedding Cars
New Lambton NSW 2305
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=8686 or tblfeedback.strbusinessname='Classic 56-57 Chevrolet Wedding Cars' or tblfeedback.strbusinessname='Classic 56-57 Chevrolet Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Somerset Carriages
Pokolbin NSW 2320
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=11452 or tblfeedback.strbusinessname='Somerset Carriages' or tblfeedback.strbusinessname='Somerset Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Custom Car Hire
Newcastle NSW 2300
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=8879 or tblfeedback.strbusinessname='Custom Car Hire' or tblfeedback.strbusinessname='Custom Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Karl Hvirf Carriages
Tenambit NSW 2323
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=10013 or tblfeedback.strbusinessname='Karl Hvirf Carriages' or tblfeedback.strbusinessname='Karl Hvirf Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 58 Sort search results alphabetically