Rating
Colonial Carriages
Wirlinga NSW 2640
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=8761 or tblfeedback.strbusinessname='Colonial Carriages' or tblfeedback.strbusinessname='Colonial Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Stately Limousines
Wangaratta VIC 3677
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=1030 or tblfeedback.strbusinessname='Stately Limousines' or tblfeedback.strbusinessname='Stately Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chevrolet Weddings & Tours
Wodonga VIC 3690
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=750 or tblfeedback.strbusinessname='Chevrolet Weddings &%%semi%% Tours' or tblfeedback.strbusinessname='Chevrolet Weddings & Tours') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Budget
Lavington NSW 2641
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=8413 or tblfeedback.strbusinessname='Budget' or tblfeedback.strbusinessname='Budget') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Albury Wodonga Limousines
Albury NSW 2640
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=1110 or tblfeedback.strbusinessname='Albury Wodonga Limousines' or tblfeedback.strbusinessname='Albury Wodonga Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Albury Cadillac Limousines
Albury NSW 2640
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=7771 or tblfeedback.strbusinessname='Albury Cadillac Limousines' or tblfeedback.strbusinessname='Albury Cadillac Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15