Rating
Blue Lake Limousine
Mount Gambier SA 5290
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=4829 or tblfeedback.strbusinessname='Blue Lake Limousine' or tblfeedback.strbusinessname='Blue Lake Limousine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Baron's Chauffeur & Driver Hire The
Mount Gambier SA 5290
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=4822 or tblfeedback.strbusinessname='Baron'%%semi%%s Chauffeur &%%semi%% Driver Hire The' or tblfeedback.strbusinessname='Baron's Chauffeur & Driver Hire The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
South East Limousines
Penola SA 5277
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=4918 or tblfeedback.strbusinessname='South East Limousines' or tblfeedback.strbusinessname='South East Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Four Seasons Carriages
Penola SA 5277
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=4862 or tblfeedback.strbusinessname='Four Seasons Carriages' or tblfeedback.strbusinessname='Four Seasons Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15