Home > wedding cars > A All Areas Austral Limousine & Coach Charters
A All Areas Austral Limousine & Coach Charters
select count(intrating) as reviews,round(avg(cast(intrating as float)),2) as rating from tblfeedback inner join tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID where (lngsupplierID=7542 or strbusinessname='A All Areas Austral Limousine &%%semi%% Coach Charters' or strbusinessname='A All Areas Austral Limousine &%%semi%% Coach Charters') and year(getdate())-year(dtmadded)<=15 and tblfeedback.active = 1