Read more

153 result(s) found. RatingView Your Favorites List

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
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
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
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
Golden Rolls
Stirling SA 5152
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=4867 or tblfeedback.strbusinessname='Golden Rolls' or tblfeedback.strbusinessname='Golden Rolls') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Belvedere Wedding Cars
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=4824 or tblfeedback.strbusinessname='Belvedere Wedding Cars' or tblfeedback.strbusinessname='Belvedere Wedding Cars') 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 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
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
Classic Touch Harleys
Campbelltown 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=4853 or tblfeedback.strbusinessname='Classic Touch Harleys' or tblfeedback.strbusinessname='Classic Touch Harleys') 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
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
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
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
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
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
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
Aristocrat Limousines
Colonel Light Gardens 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=4819 or tblfeedback.strbusinessname='Aristocrat Limousines' or tblfeedback.strbusinessname='Aristocrat Limousines') 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
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
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
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
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
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
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=4834 or tblfeedback.strbusinessname='Budget Discount Wedding' or tblfeedback.strbusinessname='Budget Discount Wedding') 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
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=4795 or tblfeedback.strbusinessname='Adelaide Chevy Hire' or tblfeedback.strbusinessname='Adelaide Chevy Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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=4802 or tblfeedback.strbusinessname='Adelaide Park Lane Chauffeur Cars' or tblfeedback.strbusinessname='Adelaide Park Lane Chauffeur Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Boss 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=4830 or tblfeedback.strbusinessname='Boss Limousines' or tblfeedback.strbusinessname='Boss Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Anthony's Classics
Medindie SA 5081
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=4818 or tblfeedback.strbusinessname='Anthony'%%semi%%s Classics' or tblfeedback.strbusinessname='Anthony's Classics') 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
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
Harley Safari
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=6622 or tblfeedback.strbusinessname='Harley Safari' or tblfeedback.strbusinessname='Harley Safari') 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
Adelaide Regent Hire Cars
Port Adelaide 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=4805 or tblfeedback.strbusinessname='Adelaide Regent Hire Cars' or tblfeedback.strbusinessname='Adelaide Regent Hire Cars') 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
Cr Limousines
Pennington 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=4856 or tblfeedback.strbusinessname='Cr Limousines' or tblfeedback.strbusinessname='Cr Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All American 57 Chevy Services
Torrensville SA 5031
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=4811 or tblfeedback.strbusinessname='All American 57 Chevy Services' or tblfeedback.strbusinessname='All American 57 Chevy Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
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
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
Spirit of Extacy Chauffeured Driven Vehicles & Wedding 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=4920 or tblfeedback.strbusinessname='Spirit of Extacy Chauffeured Driven Vehicles &%%semi%% Wedding Cars' or tblfeedback.strbusinessname='Spirit of Extacy Chauffeured Driven Vehicles & Wedding Cars') 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
1 - 50 of 153 Sort search results alphabetically