Read more

151 result(s) found. RatingView Your Favorites List

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
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
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
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
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
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
Elite Harley Tours
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=4860 or tblfeedback.strbusinessname='Elite Harley Tours' or tblfeedback.strbusinessname='Elite Harley Tours') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chauffeured Vehicle Association of SA Inc
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=4841 or tblfeedback.strbusinessname='Chauffeured Vehicle Association of SA Inc' or tblfeedback.strbusinessname='Chauffeured Vehicle Association of SA Inc') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mustangs
Waterloo Corner SA 5110
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=4892 or tblfeedback.strbusinessname='Mustangs' or tblfeedback.strbusinessname='Mustangs') 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
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
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
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
Liebich Limousines
St Morris 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=4880 or tblfeedback.strbusinessname='Liebich Limousines' or tblfeedback.strbusinessname='Liebich Limousines') 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
SA Hot Rod Tours
Belair SA 5052
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=4912 or tblfeedback.strbusinessname='SA Hot Rod Tours' or tblfeedback.strbusinessname='SA Hot Rod Tours') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Plymouths of Adelaide
Felixstow SA 5070
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=4899 or tblfeedback.strbusinessname='Plymouths of Adelaide' or tblfeedback.strbusinessname='Plymouths of Adelaide') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Adelaide Classic Hire Cars
Daw 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=4796 or tblfeedback.strbusinessname='Adelaide Classic Hire Cars' or tblfeedback.strbusinessname='Adelaide Classic Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Classic American Limo Hire
Seaton SA 5023
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=4845 or tblfeedback.strbusinessname='Classic American Limo Hire' or tblfeedback.strbusinessname='Classic American Limo Hire') 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
American Classic Convertibles & Chauffeur Driven Vehicles for Sp
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=6619 or tblfeedback.strbusinessname='American Classic Convertibles &%%semi%% Chauffeur Driven Vehicles for Sp' or tblfeedback.strbusinessname='American Classic Convertibles & Chauffeur Driven Vehicles for Sp') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A All Exclusive Jaguars
Bellevue Heights SA 5050
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=6608 or tblfeedback.strbusinessname='A All Exclusive Jaguars' or tblfeedback.strbusinessname='A All Exclusive Jaguars') 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
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
Royal Blue Limousines
Novar Gardens SA 5040
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=4911 or tblfeedback.strbusinessname='Royal Blue Limousines' or tblfeedback.strbusinessname='Royal Blue 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
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
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
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
Little Legend Limos
Aldinga SA 5173
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=4881 or tblfeedback.strbusinessname='Little Legend Limos' or tblfeedback.strbusinessname='Little Legend Limos') 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
Vintage Chauffeur Services
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=4927 or tblfeedback.strbusinessname='Vintage Chauffeur Services' or tblfeedback.strbusinessname='Vintage Chauffeur Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Baron Limousines
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=4821 or tblfeedback.strbusinessname='Baron Limousines' or tblfeedback.strbusinessname='Baron Limousines') 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
Wild Weddings Pty Ltd
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=4931 or tblfeedback.strbusinessname='Wild Weddings Pty Ltd' or tblfeedback.strbusinessname='Wild Weddings Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ambassador 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=4816 or tblfeedback.strbusinessname='Ambassador Limousine Service' or tblfeedback.strbusinessname='Ambassador Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Blackwood Hire Cars
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=4828 or tblfeedback.strbusinessname='Blackwood Hire Cars' or tblfeedback.strbusinessname='Blackwood Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Princess Wedding Cars
Edwardstown SA 5039
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=4903 or tblfeedback.strbusinessname='Princess Wedding Cars' or tblfeedback.strbusinessname='Princess Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Grand Regal Limousines
Dulwich SA 5065
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=4868 or tblfeedback.strbusinessname='Grand Regal Limousines' or tblfeedback.strbusinessname='Grand Regal Limousines') 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
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
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
Central Stretch Limousines
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=4840 or tblfeedback.strbusinessname='Central Stretch Limousines' or tblfeedback.strbusinessname='Central 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
Rating
AAA Budget Discount Wedding
Broadview SA 5083
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=6616 or tblfeedback.strbusinessname='AAA Budget Discount Wedding' or tblfeedback.strbusinessname='AAA Budget Discount Wedding') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lords & Ladys Limousines
Hillbank 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=4883 or tblfeedback.strbusinessname='Lords &%%semi%% Ladys Limousines' or tblfeedback.strbusinessname='Lords & Ladys Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Black Beauty & RT Classic 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=4826 or tblfeedback.strbusinessname='Black Beauty &%%semi%% RT Classic Limousines' or tblfeedback.strbusinessname='Black Beauty & RT Classic Limousines') 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
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
1 - 50 of 151 Sort search results alphabetically