Read more

153 result(s) found. RatingView Your Favorites List

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
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
Baileys Limousines
Adelaide 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=43955 or tblfeedback.strbusinessname='Baileys Limousines' or tblfeedback.strbusinessname='Baileys 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
Classic Jags
Marino SA 5049
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=4850 or tblfeedback.strbusinessname='Classic Jags' or tblfeedback.strbusinessname='Classic Jags') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jaguar classic hire
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=44339 or tblfeedback.strbusinessname='Jaguar classic hire' or tblfeedback.strbusinessname='Jaguar classic hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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 Gondola
Dover Gardens 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=6618 or tblfeedback.strbusinessname='Adelaide Gondola' or tblfeedback.strbusinessname='Adelaide Gondola') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mirror Image Chauffeured Chevrolets
Bowden SA 5007
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=6626 or tblfeedback.strbusinessname='Mirror Image Chauffeured Chevrolets' or tblfeedback.strbusinessname='Mirror Image Chauffeured Chevrolets') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dennis Maiden
One Tree Hill SA 5114
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=4858 or tblfeedback.strbusinessname='Dennis Maiden' or tblfeedback.strbusinessname='Dennis Maiden') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A 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=6613 or tblfeedback.strbusinessname='A Ritz Limousine Service' or tblfeedback.strbusinessname='A Ritz Limousine Service') 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
Adelaide Wedding & Hire Cars
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=4807 or tblfeedback.strbusinessname='Adelaide Wedding &%%semi%% Hire Cars' or tblfeedback.strbusinessname='Adelaide Wedding & Hire Cars') 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
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
Cholmondeley Chauffeur Cars
Happy Valley SA 5159
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=4843 or tblfeedback.strbusinessname='Cholmondeley Chauffeur Cars' or tblfeedback.strbusinessname='Cholmondeley Chauffeur Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hot Rod Wedding Cars
Hope Valley SA 5090
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=4871 or tblfeedback.strbusinessname='Hot Rod Wedding Cars' or tblfeedback.strbusinessname='Hot Rod Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Citi Car
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=4844 or tblfeedback.strbusinessname='Citi Car' or tblfeedback.strbusinessname='Citi Car') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Krystal Koach
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=6611 or tblfeedback.strbusinessname='A Krystal Koach' or tblfeedback.strbusinessname='A Krystal Koach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gold Star Chauffeured Vehicles
Nuriootpa SA 5355
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=4865 or tblfeedback.strbusinessname='Gold Star Chauffeured Vehicles' or tblfeedback.strbusinessname='Gold Star Chauffeured Vehicles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bayside Limousines
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=4823 or tblfeedback.strbusinessname='Bayside Limousines' or tblfeedback.strbusinessname='Bayside 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
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
Rating
Prestige Chauffeur Cars
Rostrevor 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=4902 or tblfeedback.strbusinessname='Prestige Chauffeur Cars' or tblfeedback.strbusinessname='Prestige Chauffeur Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic Chauffeur Cars
Mitcham SA 5062
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=4847 or tblfeedback.strbusinessname='Classic Chauffeur Cars' or tblfeedback.strbusinessname='Classic Chauffeur Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Moonlight Stretch Limousines
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=4891 or tblfeedback.strbusinessname='Moonlight Stretch Limousines' or tblfeedback.strbusinessname='Moonlight Stretch Limousines') 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
Alpine Chauffeured Limousines
Plympton South 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=4815 or tblfeedback.strbusinessname='Alpine Chauffeured Limousines' or tblfeedback.strbusinessname='Alpine Chauffeured Limousines') 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
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
JR Limousines
Hope Valley SA 5090
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=4875 or tblfeedback.strbusinessname='JR Limousines' or tblfeedback.strbusinessname='JR Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Adelaide Prestige Cadillacs
Kings Park SA 5034
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=4804 or tblfeedback.strbusinessname='Adelaide Prestige Cadillacs' or tblfeedback.strbusinessname='Adelaide Prestige Cadillacs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Arrive In Style
Lonsdale SA 5160
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=4820 or tblfeedback.strbusinessname='Arrive In Style' or tblfeedback.strbusinessname='Arrive In Style') 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
Cars of Class
Gawler East SA 5118
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=4838 or tblfeedback.strbusinessname='Cars of Class' or tblfeedback.strbusinessname='Cars of Class') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Black Spirit Limousines
Woodville SA 5011
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=4827 or tblfeedback.strbusinessname='Black Spirit Limousines' or tblfeedback.strbusinessname='Black Spirit Limousines') 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
Tours for You
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=4925 or tblfeedback.strbusinessname='Tours for You' or tblfeedback.strbusinessname='Tours for You') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Corporate Cadillac Limousines
Cumberland Park SA 5041
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=4855 or tblfeedback.strbusinessname='Corporate Cadillac Limousines' or tblfeedback.strbusinessname='Corporate Cadillac Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Regency Limousines
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=4906 or tblfeedback.strbusinessname='Regency Limousines' or tblfeedback.strbusinessname='Regency Limousines') 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
Meander Horsedrawn Coaches & Vintage Cars
Camden Park 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=4889 or tblfeedback.strbusinessname='Meander Horsedrawn Coaches &%%semi%% Vintage Cars' or tblfeedback.strbusinessname='Meander Horsedrawn Coaches & Vintage Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Peglar
Evanston Park SA 5116
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=4897 or tblfeedback.strbusinessname='Peglar' or tblfeedback.strbusinessname='Peglar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
White 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=4930 or tblfeedback.strbusinessname='White Orchid Limousines' or tblfeedback.strbusinessname='White Orchid Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hills Car Hire
Macclesfield SA 5153
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=4870 or tblfeedback.strbusinessname='Hills Car Hire' or tblfeedback.strbusinessname='Hills Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Marks Stretch Limousines
Ingle Farm SA 5098
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=4887 or tblfeedback.strbusinessname='Marks Stretch Limousines' or tblfeedback.strbusinessname='Marks Stretch 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
1 - 50 of 153 Sort search results alphabetically