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
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
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
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
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
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
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
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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
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
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
Bj's Vintage Wedding Cars
Mount Hutton 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=8217 or tblfeedback.strbusinessname='Bj'%%semi%%s Vintage Wedding Cars' or tblfeedback.strbusinessname='Bj's Vintage Wedding Cars') 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
BJ's Vintage Wedding Cars
Mt Hutton 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=1112 or tblfeedback.strbusinessname='BJ'%%semi%%s Vintage Wedding Cars' or tblfeedback.strbusinessname='BJ's Vintage Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Newcastle Limousines
Macquarie Hills 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=1211 or tblfeedback.strbusinessname='Newcastle Limousines' or tblfeedback.strbusinessname='Newcastle Limousines') 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
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
A Taylor Made Classic
Rathmines 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=1306 or tblfeedback.strbusinessname='A Taylor Made Classic' or tblfeedback.strbusinessname='A Taylor Made Classic') 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
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
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
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
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
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
Crane's Classic Cadillac Hire
Croudace Bay 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=8832 or tblfeedback.strbusinessname='Crane'%%semi%%s Classic Cadillac Hire' or tblfeedback.strbusinessname='Crane's Classic Cadillac Hire') 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
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
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
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
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
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
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
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
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
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
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
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
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
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
Nelson Bay Superior Hire Cars
Nelson Bay NSW 2315
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=10645 or tblfeedback.strbusinessname='Nelson Bay Superior Hire Cars' or tblfeedback.strbusinessname='Nelson Bay Superior Hire Cars') 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
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
Paxton-Brown 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=10872 or tblfeedback.strbusinessname='Paxton-Brown Carriages' or tblfeedback.strbusinessname='Paxton-Brown Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 57 Sort search results alphabetically