Read more

151 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
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
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
James Bentley 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=4874 or tblfeedback.strbusinessname='James Bentley Limousines' or tblfeedback.strbusinessname='James Bentley Limousines') 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
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
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
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
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
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
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
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
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 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
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
Adelaide Supreme Limousines
Highbury SA 5089
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=4806 or tblfeedback.strbusinessname='Adelaide Supreme Limousines' or tblfeedback.strbusinessname='Adelaide Supreme Limousines') 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
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
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
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
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
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
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
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
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
Mirror Image Vintage Touring Co
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=4890 or tblfeedback.strbusinessname='Mirror Image Vintage Touring Co' or tblfeedback.strbusinessname='Mirror Image Vintage Touring Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hills Horse Drawn Carriages
Ironbank 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=6624 or tblfeedback.strbusinessname='Hills Horse Drawn Carriages' or tblfeedback.strbusinessname='Hills Horse Drawn Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cavallino Car Hire
Burnside SA 5066
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=19061 or tblfeedback.strbusinessname='Cavallino Car Hire' or tblfeedback.strbusinessname='Cavallino Car Hire') 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
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
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
Adelaide Chauffered Chevrolets
Flagstaff Hill 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=4794 or tblfeedback.strbusinessname='Adelaide Chauffered Chevrolets' or tblfeedback.strbusinessname='Adelaide Chauffered Chevrolets') 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
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
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
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 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
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
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
Rating
Chevron Limousines
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=4842 or tblfeedback.strbusinessname='Chevron Limousines' or tblfeedback.strbusinessname='Chevron Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Festival Limousines
Blackwood SA 5051
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=4861 or tblfeedback.strbusinessname='Festival Limousines' or tblfeedback.strbusinessname='Festival Limousines') 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
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
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
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
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
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
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
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
1 - 50 of 151 Sort search results alphabetically