Read more

153 result(s) found. RatingView Your Favorites List

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
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
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
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
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
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
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
Renaissance Limousines
Fullarton SA 5063
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=4908 or tblfeedback.strbusinessname='Renaissance Limousines' or tblfeedback.strbusinessname='Renaissance Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Adelaide Impressions
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=4800 or tblfeedback.strbusinessname='Adelaide Impressions' or tblfeedback.strbusinessname='Adelaide Impressions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
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=4832 or tblfeedback.strbusinessname='Brougham Limousines' or tblfeedback.strbusinessname='Brougham Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Southern Light 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=4919 or tblfeedback.strbusinessname='Southern Light Limousines' or tblfeedback.strbusinessname='Southern Light 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
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
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
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
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
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
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
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
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
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
Top Hat Limousines
Fullarton SA 5063
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=4924 or tblfeedback.strbusinessname='Top Hat Limousines' or tblfeedback.strbusinessname='Top Hat Limousines') 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
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
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 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
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
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
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
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
Dodge Phoenix Cruisers
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=4859 or tblfeedback.strbusinessname='Dodge Phoenix Cruisers' or tblfeedback.strbusinessname='Dodge Phoenix Cruisers') 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
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
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
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
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
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
Siddall's Wedding Car Hire
Banksia Park SA 5091
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=4915 or tblfeedback.strbusinessname='Siddall'%%semi%%s Wedding Car Hire' or tblfeedback.strbusinessname='Siddall's Wedding Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
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=4895 or tblfeedback.strbusinessname='Park Lane Chauffeur Cars' or tblfeedback.strbusinessname='Park Lane Chauffeur Cars') 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
Air Karisma
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=4809 or tblfeedback.strbusinessname='Air Karisma' or tblfeedback.strbusinessname='Air Karisma') 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
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
Gold Crown Limousines
Darlington SA 5047
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=4864 or tblfeedback.strbusinessname='Gold Crown Limousines' or tblfeedback.strbusinessname='Gold Crown Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 153 Sort search results alphabetically