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
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
Wish
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' or tblfeedback.strbusinessname='Wish') 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
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
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
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
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
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
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
Wish
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' or tblfeedback.strbusinessname='Wish') 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Premier Goodwill Products
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=6959 or tblfeedback.strbusinessname='Premier Goodwill Products' or tblfeedback.strbusinessname='Premier Goodwill Products') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Snowco
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=6972 or tblfeedback.strbusinessname='Snowco' or tblfeedback.strbusinessname='Snowco') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Alakazam
Bassendean WA 6054
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=6872 or tblfeedback.strbusinessname='Alakazam' or tblfeedback.strbusinessname='Alakazam') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rooftop Balloons (W A)
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=6969 or tblfeedback.strbusinessname='Rooftop Balloons (%%semi%%W A)%%semi%%' or tblfeedback.strbusinessname='Rooftop Balloons (W A)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Party Animals W A
Joondanna WA 6060
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=6943 or tblfeedback.strbusinessname='Party Animals W A' or tblfeedback.strbusinessname='Party Animals W A') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pink Flamingo Celebrations
West Perth WA 6005
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=6957 or tblfeedback.strbusinessname='Pink Flamingo Celebrations' or tblfeedback.strbusinessname='Pink Flamingo Celebrations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Crackajack Party Hire
Midland 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=6911 or tblfeedback.strbusinessname='Crackajack Party Hire' or tblfeedback.strbusinessname='Crackajack Party Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Balloon Impressions
Warnbro WA 6169
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=6885 or tblfeedback.strbusinessname='Balloon Impressions' or tblfeedback.strbusinessname='Balloon Impressions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Party Plus
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=6952 or tblfeedback.strbusinessname='Party Plus' or tblfeedback.strbusinessname='Party Plus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Balloons Abuzz
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=6891 or tblfeedback.strbusinessname='Balloons Abuzz' or tblfeedback.strbusinessname='Balloons Abuzz') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Rating
I Do-The Wedding Shop
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=6929 or tblfeedback.strbusinessname='I Do-The Wedding Shop' or tblfeedback.strbusinessname='I Do-The Wedding Shop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Prime
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=6961 or tblfeedback.strbusinessname='Prime' or tblfeedback.strbusinessname='Prime') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Glorious Gardens
Woodlands WA 6018
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=6919 or tblfeedback.strbusinessname='Glorious Gardens' or tblfeedback.strbusinessname='Glorious Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Higher Iron
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=6926 or tblfeedback.strbusinessname='Higher Iron' or tblfeedback.strbusinessname='Higher Iron') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Balloons on Rokeby
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=6893 or tblfeedback.strbusinessname='Balloons on Rokeby' or tblfeedback.strbusinessname='Balloons on Rokeby') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Perth Novelty Co
Victoria Park WA 6100
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=6956 or tblfeedback.strbusinessname='Perth Novelty Co' or tblfeedback.strbusinessname='Perth Novelty Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 117 Sort search results alphabetically