Rating
Bryan Was Here Furniture
Perth WA 6000
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=24950 or tblfeedback.strbusinessname='Bryan Was Here Furniture' or tblfeedback.strbusinessname='Bryan Was Here Furniture') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Grand Scene Wedding and Event Hire
Landsdale WA 6065
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=25147 or tblfeedback.strbusinessname='Grand Scene Wedding and Event Hire' or tblfeedback.strbusinessname='Grand Scene Wedding and Event Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tie The Knot
Mandurah WA 6210
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=27203 or tblfeedback.strbusinessname='Tie The Knot' or tblfeedback.strbusinessname='Tie The Knot') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Forever After Weddings
Madeley WA 6065
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=39640 or tblfeedback.strbusinessname='Forever After Weddings' or tblfeedback.strbusinessname='Forever After Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bella weddings and events
Joondalup WA 6927
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=43148 or tblfeedback.strbusinessname='Bella weddings and events' or tblfeedback.strbusinessname='Bella weddings and events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Black Label Events
Midvale WA 6009
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=27325 or tblfeedback.strbusinessname='Black Label Events' or tblfeedback.strbusinessname='Black Label Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wedding World Bayswater
Bayswater WA 6053
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=7025 or tblfeedback.strbusinessname='Wedding World Bayswater' or tblfeedback.strbusinessname='Wedding World Bayswater') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
A Flamingo Surprise
East Victoria Park WA 6101
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=6867 or tblfeedback.strbusinessname='A Flamingo Surprise' or tblfeedback.strbusinessname='A Flamingo Surprise') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Michelle Mok
Perth WA 6000
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=36016 or tblfeedback.strbusinessname='Michelle Mok' or tblfeedback.strbusinessname='Michelle Mok') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Mighty Booths
Maddington WA 6109
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=26333 or tblfeedback.strbusinessname='The Mighty Booths' or tblfeedback.strbusinessname='The Mighty Booths') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hire Creations Store
Huntingdale 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=26011 or tblfeedback.strbusinessname='Hire Creations Store' or tblfeedback.strbusinessname='Hire Creations Store') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Styled by Kath
Perth WA 6000
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=38596 or tblfeedback.strbusinessname='Styled by Kath' or tblfeedback.strbusinessname='Styled by Kath') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
House of Primrose
Two Rocks WA 6037
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=29177 or tblfeedback.strbusinessname='House of Primrose' or tblfeedback.strbusinessname='House of Primrose') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sweet Orange Productions
Geraldton WA 6530
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=42944 or tblfeedback.strbusinessname='Sweet Orange Productions' or tblfeedback.strbusinessname='Sweet Orange Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Marielle Studio
Perth WA 6000
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=37464 or tblfeedback.strbusinessname='Marielle Studio' or tblfeedback.strbusinessname='Marielle Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wish Sydney
Sydney NSW 2000
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=36174 or tblfeedback.strbusinessname='Wish Sydney' or tblfeedback.strbusinessname='Wish Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Remember Neons
Ballarat VIC 3350
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=43452 or tblfeedback.strbusinessname='Remember Neons' or tblfeedback.strbusinessname='Remember Neons') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Clara Belle Wedding Styling
Perth WA 6000
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=41330 or tblfeedback.strbusinessname='Clara Belle Wedding Styling' or tblfeedback.strbusinessname='Clara Belle Wedding Styling') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Maisey Collections
Kewdale WA 6105
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=21649 or tblfeedback.strbusinessname='Maisey Collections' or tblfeedback.strbusinessname='Maisey Collections') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Affair with Flair
Midvale WA 6056
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=26359 or tblfeedback.strbusinessname='Affair with Flair' or tblfeedback.strbusinessname='Affair with Flair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Geraldton Vintage Hire
Geraldton WA 6530
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=41472 or tblfeedback.strbusinessname='Geraldton Vintage Hire' or tblfeedback.strbusinessname='Geraldton Vintage Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wood You Marry Me
Perth WA 6000
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=27392 or tblfeedback.strbusinessname='Wood You Marry Me' or tblfeedback.strbusinessname='Wood You Marry Me') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bella wedding and events
Joondalup WA 6027
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=42934 or tblfeedback.strbusinessname='Bella wedding and events' or tblfeedback.strbusinessname='Bella wedding and events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Edge Event Furniture Hire
Perth WA 6000
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=36251 or tblfeedback.strbusinessname='Edge Event Furniture Hire' or tblfeedback.strbusinessname='Edge Event Furniture Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hire Society
Shenton Park WA 6008
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=26643 or tblfeedback.strbusinessname='Hire Society' or tblfeedback.strbusinessname='Hire Society') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Stylish Soirees
Duncraig WA 6023
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=29095 or tblfeedback.strbusinessname='Stylish Soirees' or tblfeedback.strbusinessname='Stylish Soirees') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Covet Collect
Perth WA 6000
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=29362 or tblfeedback.strbusinessname='Covet Collect' or tblfeedback.strbusinessname='Covet Collect') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Circle of Love Weddings
Pennant Hills NSW 2120
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=21992 or tblfeedback.strbusinessname='Circle of Love Weddings' or tblfeedback.strbusinessname='Circle of Love Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Choice Weddings and Events
Wangara WA 6065
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=26443 or tblfeedback.strbusinessname='Choice Weddings and Events' or tblfeedback.strbusinessname='Choice Weddings and Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Luxe Events Perth
Belmont WA 6104
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=39937 or tblfeedback.strbusinessname='Luxe Events Perth' or tblfeedback.strbusinessname='Luxe Events Perth') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wish Sydney
Sydney NSW 2000
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=36174 or tblfeedback.strbusinessname='Wish Sydney' or tblfeedback.strbusinessname='Wish Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Heart Strings Hire & Style
Perth WA 6000
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=25841 or tblfeedback.strbusinessname='Heart Strings Hire &%%semi%% Style' or tblfeedback.strbusinessname='Heart Strings Hire & Style') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
A Flamingo Suprise
Perth WA 6101
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=38601 or tblfeedback.strbusinessname='A Flamingo Suprise' or tblfeedback.strbusinessname='A Flamingo Suprise') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Northern Lights
Joondalup WA 6027
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=25204 or tblfeedback.strbusinessname='Northern Lights' or tblfeedback.strbusinessname='Northern Lights') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Heart Strings Hire and Style
Perth WA 6065
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=21218 or tblfeedback.strbusinessname='Heart Strings Hire and Style' or tblfeedback.strbusinessname='Heart Strings Hire and Style') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bride and beau
Rockingham WA 6168
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=24613 or tblfeedback.strbusinessname='Bride and beau' or tblfeedback.strbusinessname='Bride and beau') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Just The Look
Perth WA 6000
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=26075 or tblfeedback.strbusinessname='Just The Look' or tblfeedback.strbusinessname='Just The Look') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lace & Roses Wedding & Event Hire
Harrisdale 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=29577 or tblfeedback.strbusinessname='Lace &%%semi%% Roses Wedding &%%semi%% Event Hire' or tblfeedback.strbusinessname='Lace & Roses Wedding & Event Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Creative Elegance Wedding Deco
Karnup WA 6176
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=17599 or tblfeedback.strbusinessname='Creative Elegance Wedding Deco' or tblfeedback.strbusinessname='Creative Elegance Wedding Deco') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
A Perfect Beginning
Kardinya WA 6163
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=4029 or tblfeedback.strbusinessname='A Perfect Beginning' or tblfeedback.strbusinessname='A Perfect Beginning') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ice Occasions
Morley WA 6062
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=17601 or tblfeedback.strbusinessname='Ice Occasions' or tblfeedback.strbusinessname='Ice Occasions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elysium
West Leederville WA 6007
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=17600 or tblfeedback.strbusinessname='Elysium' or tblfeedback.strbusinessname='Elysium') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Aabacus Party Hire
Subiaco WA 6008
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=6862 or tblfeedback.strbusinessname='Aabacus Party Hire' or tblfeedback.strbusinessname='Aabacus Party Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Simply Different
Ballajura WA 6066
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=17602 or tblfeedback.strbusinessname='Simply Different' or tblfeedback.strbusinessname='Simply Different') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
U-Hire
Willetton WA 6155
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=6980 or tblfeedback.strbusinessname='U-Hire' or tblfeedback.strbusinessname='U-Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Touched by Angels
Nedlands WA 6009
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=17603 or tblfeedback.strbusinessname='Touched by Angels' or tblfeedback.strbusinessname='Touched by Angels') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Big Day Accessories
Noranda WA 6062
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=6659 or tblfeedback.strbusinessname='Big Day Accessories' or tblfeedback.strbusinessname='Big Day Accessories') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15