Rating
A All L.A. Limousines
Leeming WA 6149
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=1516 or tblfeedback.strbusinessname='A All L.A. Limousines' or tblfeedback.strbusinessname='A All L.A. Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
L. A. First Class Limousines
Leeming WA 6149
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=1503 or tblfeedback.strbusinessname='L. A. First Class Limousines' or tblfeedback.strbusinessname='L. A. First Class Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A All L.A. Taxi Limousines
Leeming WA 6149
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=1517 or tblfeedback.strbusinessname='A All L.A. Taxi Limousines' or tblfeedback.strbusinessname='A All L.A. Taxi Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Broome Broome Car Rentals
Broome WA 6725
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=17957 or tblfeedback.strbusinessname='Broome Broome Car Rentals' or tblfeedback.strbusinessname='Broome Broome Car Rentals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15