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
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
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
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
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
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
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
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
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
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
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
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