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
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
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=4893 or tblfeedback.strbusinessname='Orchid Limousines' or tblfeedback.strbusinessname='Orchid Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A1 Mini Bus Charter
Gawler 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=6615 or tblfeedback.strbusinessname='A1 Mini Bus Charter' or tblfeedback.strbusinessname='A1 Mini Bus Charter') 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
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
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=4801 or tblfeedback.strbusinessname='Adelaide Mayfair Chauffeured Limousines' or tblfeedback.strbusinessname='Adelaide Mayfair Chauffeured Limousines') 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
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
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
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
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
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
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=4888 or tblfeedback.strbusinessname='Mayfair Chauffeured Limousines' or tblfeedback.strbusinessname='Mayfair Chauffeured 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
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 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
Carrington Chauffeur 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=4837 or tblfeedback.strbusinessname='Carrington Chauffeur Cars' or tblfeedback.strbusinessname='Carrington Chauffeur Cars') 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
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
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
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
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
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
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
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
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
Black Spirit Limousines
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=4827 or tblfeedback.strbusinessname='Black Spirit Limousines' or tblfeedback.strbusinessname='Black Spirit Limousines') 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
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
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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
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
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
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
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
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
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
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
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
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
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
1 - 50 of 151 Sort search results alphabetically