Rating
Julie Hebert Millinery
Orange NSW 2800
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=27584 or tblfeedback.strbusinessname='Julie Hebert Millinery' or tblfeedback.strbusinessname='Julie Hebert Millinery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Absolute Weddings & Events
Mackay QLD 4740
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=26721 or tblfeedback.strbusinessname='Absolute Weddings &%%semi%% Events' or tblfeedback.strbusinessname='Absolute Weddings & Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kai Aloha Hut
Townsville QLD 4811
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=29464 or tblfeedback.strbusinessname='Kai Aloha Hut' or tblfeedback.strbusinessname='Kai Aloha Hut') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
E-Male Lifestyle
Gladstone QLD 4680
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=15089 or tblfeedback.strbusinessname='E-Male Lifestyle' or tblfeedback.strbusinessname='E-Male Lifestyle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Accessories for Weddings & Special Occasions
Rockhampton QLD 4700
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=1648 or tblfeedback.strbusinessname='Accessories for Weddings &%%semi%% Special Occasions' or tblfeedback.strbusinessname='Accessories for Weddings & Special Occasions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mur-Lyn Fashion Accessories
Maryborough QLD 4650
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=15098 or tblfeedback.strbusinessname='Mur-Lyn Fashion Accessories' or tblfeedback.strbusinessname='Mur-Lyn Fashion Accessories') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Centre De Danse Boutique
North Rockhampton QLD 4701
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=17972 or tblfeedback.strbusinessname='Centre De Danse Boutique' or tblfeedback.strbusinessname='Centre De Danse Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15