Read more

151 result(s) found. RatingView Your Favorites List

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
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
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
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
Cadillac Dreams Hire Cars S A
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=4835 or tblfeedback.strbusinessname='Cadillac Dreams Hire Cars S A' or tblfeedback.strbusinessname='Cadillac Dreams Hire Cars S A') 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
Golden Classic Fairlanes
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=4866 or tblfeedback.strbusinessname='Golden Classic Fairlanes' or tblfeedback.strbusinessname='Golden Classic Fairlanes') 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
LPS Limousine Service
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=4885 or tblfeedback.strbusinessname='LPS Limousine Service' or tblfeedback.strbusinessname='LPS Limousine Service') 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
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
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
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
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
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
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
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
Statesman Tours
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=4922 or tblfeedback.strbusinessname='Statesman Tours' or tblfeedback.strbusinessname='Statesman Tours') 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
Majestic Limousines
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=4886 or tblfeedback.strbusinessname='Majestic Limousines' or tblfeedback.strbusinessname='Majestic Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A 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=6607 or tblfeedback.strbusinessname='A Adelaide Park Lane Chauffeur Cars' or tblfeedback.strbusinessname='A Adelaide Park Lane Chauffeur Cars') 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
Roger's 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=4910 or tblfeedback.strbusinessname='Roger'%%semi%%s Limousine Service' or tblfeedback.strbusinessname='Roger's 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 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
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
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
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
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
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
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
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
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
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
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
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
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
A Adelaide Mayfair Chauffeured Limousines
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=6606 or tblfeedback.strbusinessname='A Adelaide Mayfair Chauffeured Limousines' or tblfeedback.strbusinessname='A Adelaide Mayfair Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Personal Touch HSV Statesman & Harley Wedding Vehicles Pty Ltd
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=4898 or tblfeedback.strbusinessname='Personal Touch HSV Statesman &%%semi%% Harley Wedding Vehicles Pty Ltd' or tblfeedback.strbusinessname='Personal Touch HSV Statesman & Harley Wedding Vehicles Pty Ltd') 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
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
A 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=6612 or tblfeedback.strbusinessname='A Marks Stretch Limousines' or tblfeedback.strbusinessname='A Marks Stretch Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Classic Fins
Athelstone SA 5076
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=4849 or tblfeedback.strbusinessname='Classic Fins' or tblfeedback.strbusinessname='Classic Fins') 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
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
A 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=6614 or tblfeedback.strbusinessname='A Siddall'%%semi%%s Wedding Car Hire' or tblfeedback.strbusinessname='A Siddall's Wedding Car Hire') 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
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
1 - 50 of 151 Sort search results alphabetically