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