Rating
Kuste kombis
Dunsborough WA 6281
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=26899 or tblfeedback.strbusinessname='Kuste kombis' or tblfeedback.strbusinessname='Kuste kombis') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Perth Quality Limousines
Gosnells WA 6110
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=22428 or tblfeedback.strbusinessname='Perth Quality Limousines' or tblfeedback.strbusinessname='Perth Quality Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bunbury Holden
Bunbury WA 6230
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=41272 or tblfeedback.strbusinessname='Bunbury Holden' or tblfeedback.strbusinessname='Bunbury Holden') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Dunsborough Limousines
Busselton WA 6280
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=7481 or tblfeedback.strbusinessname='Dunsborough Limousines' or tblfeedback.strbusinessname='Dunsborough Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mr Mustang Hire
Margaret River WA 6285
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=41256 or tblfeedback.strbusinessname='Mr Mustang Hire' or tblfeedback.strbusinessname='Mr Mustang Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mike Dixon's Chauffeur Service
Kelmscott WA 6111
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=17963 or tblfeedback.strbusinessname='Mike Dixon'%%semi%%s Chauffeur Service' or tblfeedback.strbusinessname='Mike Dixon's Chauffeur Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Star Hire Services
Margaret River WA 6285
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=17956 or tblfeedback.strbusinessname='All Star Hire Services' or tblfeedback.strbusinessname='All Star Hire Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
JC Classic Automobiles
Lesmurdie WA 6076
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=7496 or tblfeedback.strbusinessname='JC Classic Automobiles' or tblfeedback.strbusinessname='JC Classic Automobiles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Golden Sunset Tours
Mundijong WA 6123
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=17960 or tblfeedback.strbusinessname='Golden Sunset Tours' or tblfeedback.strbusinessname='Golden Sunset Tours') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Any Occasions Limousines
Bunbury WA 6230
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=3169 or tblfeedback.strbusinessname='Any Occasions Limousines' or tblfeedback.strbusinessname='Any Occasions Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Aristi Limousine Service
Forrestdale WA 6112
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=4295 or tblfeedback.strbusinessname='Aristi Limousine Service' or tblfeedback.strbusinessname='Aristi Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Vintage Services
Roleystone WA 6111
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=3655 or tblfeedback.strbusinessname='Vintage Services' or tblfeedback.strbusinessname='Vintage Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Albany Limousines
Albany WA 6330
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=3160 or tblfeedback.strbusinessname='Albany Limousines' or tblfeedback.strbusinessname='Albany Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15