Read more

151 result(s) found. RatingView Your Favorites List

Rating
P & K Limousines
Golden Grove SA 5125
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=25102 or tblfeedback.strbusinessname='P & K Limousines' or tblfeedback.strbusinessname='P & K Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hummer SA
Wingfield SA 5013
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=35910 or tblfeedback.strbusinessname='Hummer SA' or tblfeedback.strbusinessname='Hummer SA') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kombis4U
Newton SA 5074
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=29068 or tblfeedback.strbusinessname='Kombis4U' or tblfeedback.strbusinessname='Kombis4U') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
London Cars
Newton SA 5074
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=4882 or tblfeedback.strbusinessname='London Cars' or tblfeedback.strbusinessname='London Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Allens Classic Wedding Cars
St Agnes SA 5097
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=4814 or tblfeedback.strbusinessname='Allens Classic Wedding Cars' or tblfeedback.strbusinessname='Allens Classic Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Adelaide Performance Limousines
St Agnes SA 5097
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=4803 or tblfeedback.strbusinessname='Adelaide Performance Limousines' or tblfeedback.strbusinessname='Adelaide Performance Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
VIP Wedding & Hire Cars
O'Halloran Hill SA 5158
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=4928 or tblfeedback.strbusinessname='VIP Wedding &%%semi%% Hire Cars' or tblfeedback.strbusinessname='VIP Wedding & Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Adelaide Chevy Hire
Klemzig SA 5087
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=6605 or tblfeedback.strbusinessname='A Adelaide Chevy Hire' or tblfeedback.strbusinessname='A Adelaide Chevy Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bowtie Classics
Tranmere SA 5073
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=4831 or tblfeedback.strbusinessname='Bowtie Classics' or tblfeedback.strbusinessname='Bowtie Classics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Adelaide Mayfair Chauffeured Limousines
Prospect SA 5082
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=4801 or tblfeedback.strbusinessname='Adelaide Mayfair Chauffeured Limousines' or tblfeedback.strbusinessname='Adelaide Mayfair Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Advanced Mini Bus
North Haven SA 5018
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=4808 or tblfeedback.strbusinessname='Advanced Mini Bus' or tblfeedback.strbusinessname='Advanced Mini Bus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cadillac Dreams Hire Cars S A
Mclaren Vale SA 5171
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=4835 or tblfeedback.strbusinessname='Cadillac Dreams Hire Cars S A' or tblfeedback.strbusinessname='Cadillac Dreams Hire Cars S A') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Exclusive Jaguars
Seaford Rise SA 5169
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=4813 or tblfeedback.strbusinessname='All Exclusive Jaguars' or tblfeedback.strbusinessname='All Exclusive Jaguars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Smartcar Australia Pty Ltd
Salisbury Heights SA 5109
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=4917 or tblfeedback.strbusinessname='Smartcar Australia Pty Ltd' or tblfeedback.strbusinessname='Smartcar Australia Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Broadway Cadillac Hire
Woodcroft SA 5162
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=19053 or tblfeedback.strbusinessname='Broadway Cadillac Hire' or tblfeedback.strbusinessname='Broadway Cadillac Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Just Cruisin Chauffeur Car
Mclaren Vale SA 5171
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=4876 or tblfeedback.strbusinessname='Just Cruisin Chauffeur Car' or tblfeedback.strbusinessname='Just Cruisin Chauffeur Car') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Black & White 57 Chevrolet Services
Enfield SA 5085
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=4825 or tblfeedback.strbusinessname='Black &%%semi%% White 57 Chevrolet Services' or tblfeedback.strbusinessname='Black & White 57 Chevrolet Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Daimler Hire Car
Newton SA 5074
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=4857 or tblfeedback.strbusinessname='Daimler Hire Car' or tblfeedback.strbusinessname='Daimler Hire Car') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Red Rose Limousines
Paralowie SA 5108
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=4904 or tblfeedback.strbusinessname='Red Rose Limousines' or tblfeedback.strbusinessname='Red Rose Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Harley White Wedding Escorts
Cavan SA 5094
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=4869 or tblfeedback.strbusinessname='Harley White Wedding Escorts' or tblfeedback.strbusinessname='Harley White Wedding Escorts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kars for Kats
Salisbury Downs SA 5108
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=4878 or tblfeedback.strbusinessname='Kars for Kats' or tblfeedback.strbusinessname='Kars for Kats') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Golden Classic Fairlanes
Para Hills SA 5096
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=4866 or tblfeedback.strbusinessname='Golden Classic Fairlanes' or tblfeedback.strbusinessname='Golden Classic Fairlanes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roger's Limousine Service
Paradise SA 5075
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=4910 or tblfeedback.strbusinessname='Roger'%%semi%%s Limousine Service' or tblfeedback.strbusinessname='Roger's Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Starlight Limousines
Kensington Gardens SA 5068
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=4921 or tblfeedback.strbusinessname='Starlight Limousines' or tblfeedback.strbusinessname='Starlight Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cavalier Classic Cars
Clearview SA 5085
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=4839 or tblfeedback.strbusinessname='Cavalier Classic Cars' or tblfeedback.strbusinessname='Cavalier Classic Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Orchid Limousines
Holden Hill SA 5088
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=4893 or tblfeedback.strbusinessname='Orchid Limousines' or tblfeedback.strbusinessname='Orchid Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Presley Limousines
Plympton SA 5038
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=4901 or tblfeedback.strbusinessname='Presley Limousines' or tblfeedback.strbusinessname='Presley Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cloud Seven
Wynn Vale SA 5127
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=4854 or tblfeedback.strbusinessname='Cloud Seven' or tblfeedback.strbusinessname='Cloud Seven') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
SA Limousine Booking Centre
St Peters SA 5069
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=4913 or tblfeedback.strbusinessname='SA Limousine Booking Centre' or tblfeedback.strbusinessname='SA Limousine Booking Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Unique Hire Cars
Lockleys SA 5032
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=4926 or tblfeedback.strbusinessname='Unique Hire Cars' or tblfeedback.strbusinessname='Unique Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ACE of Spades Limousines
Birkenhead SA 5015
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=4792 or tblfeedback.strbusinessname='ACE of Spades Limousines' or tblfeedback.strbusinessname='ACE of Spades Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Brougham Limousines
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=6610 or tblfeedback.strbusinessname='A Brougham Limousines' or tblfeedback.strbusinessname='A Brougham Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Silk Ribbon Limousines
Elizabeth North SA 5113
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=4916 or tblfeedback.strbusinessname='Silk Ribbon Limousines' or tblfeedback.strbusinessname='Silk Ribbon Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Majestic Limousines
Prospect SA 5082
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=4886 or tblfeedback.strbusinessname='Majestic Limousines' or tblfeedback.strbusinessname='Majestic Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hughes Chauffuered Cars Limousines-Coaches
Richmond SA 5033
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=4872 or tblfeedback.strbusinessname='Hughes Chauffuered Cars Limousines-Coaches' or tblfeedback.strbusinessname='Hughes Chauffuered Cars Limousines-Coaches') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Home James Chauffeured Limousines
Brighton SA 5048
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=6625 or tblfeedback.strbusinessname='Home James Chauffeured Limousines' or tblfeedback.strbusinessname='Home James Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Adelaide Park Lane Chauffeur Cars
Fairview Park SA 5126
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=6607 or tblfeedback.strbusinessname='A Adelaide Park Lane Chauffeur Cars' or tblfeedback.strbusinessname='A Adelaide Park Lane Chauffeur Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ritz Limousine Service
Salisbury SA 5108
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=4909 or tblfeedback.strbusinessname='Ritz Limousine Service' or tblfeedback.strbusinessname='Ritz Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Top Class Classic Cars
Hendon SA 5014
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=4923 or tblfeedback.strbusinessname='Top Class Classic Cars' or tblfeedback.strbusinessname='Top Class Classic Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Regent Rolls Royce
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=4907 or tblfeedback.strbusinessname='Regent Rolls Royce' or tblfeedback.strbusinessname='Regent Rolls Royce') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cloud Seven Limousines
Wynn Vale SA 5127
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=19068 or tblfeedback.strbusinessname='Cloud Seven Limousines' or tblfeedback.strbusinessname='Cloud Seven Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brown
Salisbury East SA 5109
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=4833 or tblfeedback.strbusinessname='Brown' or tblfeedback.strbusinessname='Brown') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Benson's Limousine's
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=6620 or tblfeedback.strbusinessname='Benson'%%semi%%s Limousine'%%semi%%s' or tblfeedback.strbusinessname='Benson's Limousine's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Shiralee Limousines Pty Ltd
Henley Beach SA 5022
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=4914 or tblfeedback.strbusinessname='Shiralee Limousines Pty Ltd' or tblfeedback.strbusinessname='Shiralee Limousines Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Adelaide Elite Chauffeured Vehicles
Elizabeth East SA 5112
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=4797 or tblfeedback.strbusinessname='Adelaide Elite Chauffeured Vehicles' or tblfeedback.strbusinessname='Adelaide Elite Chauffeured Vehicles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Glenelg Limousine Services
Glenelg SA 5045
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=4863 or tblfeedback.strbusinessname='Glenelg Limousine Services' or tblfeedback.strbusinessname='Glenelg Limousine Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Parker In Style
Unley SA 5061
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=4896 or tblfeedback.strbusinessname='Parker In Style' or tblfeedback.strbusinessname='Parker In Style') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic Mustangs
Plympton North SA 5037
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=4852 or tblfeedback.strbusinessname='Classic Mustangs' or tblfeedback.strbusinessname='Classic Mustangs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Alfred's Chauffeured Limousines
Kensington Gardens SA 5068
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=4810 or tblfeedback.strbusinessname='Alfred'%%semi%%s Chauffeured Limousines' or tblfeedback.strbusinessname='Alfred's Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
AAA Classic Convertibles
Prospect SA 5082
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=6617 or tblfeedback.strbusinessname='AAA Classic Convertibles' or tblfeedback.strbusinessname='AAA Classic Convertibles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 151 Sort search results alphabetically