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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Balloon Advertising
Jane Brook 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=6881 or tblfeedback.strbusinessname='Balloon Advertising' or tblfeedback.strbusinessname='Balloon Advertising') 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
Party Heaven
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=6945 or tblfeedback.strbusinessname='Party Heaven' or tblfeedback.strbusinessname='Party Heaven') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Anytime Party Hire
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=6878 or tblfeedback.strbusinessname='Anytime Party Hire' or tblfeedback.strbusinessname='Anytime Party Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Linencare Australia
Murdoch WA 6150
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=6937 or tblfeedback.strbusinessname='Linencare Australia' or tblfeedback.strbusinessname='Linencare Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Swan Hills Party Hire
Bellevue 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=6978 or tblfeedback.strbusinessname='Swan Hills Party Hire' or tblfeedback.strbusinessname='Swan Hills Party Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Party Plus
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=6951 or tblfeedback.strbusinessname='Party Plus' or tblfeedback.strbusinessname='Party Plus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elysium Wedding Decor & Co-Ordinators
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=6915 or tblfeedback.strbusinessname='Elysium Wedding Decor &%%semi%% Co-Ordinators' or tblfeedback.strbusinessname='Elysium Wedding Decor & Co-Ordinators') 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
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
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
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
Able Candelabra Hire
White Gum Valley WA 6162
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=6869 or tblfeedback.strbusinessname='Able Candelabra Hire' or tblfeedback.strbusinessname='Able Candelabra Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lena's Candelabra Hire
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=6934 or tblfeedback.strbusinessname='Lena'%%semi%%s Candelabra Hire' or tblfeedback.strbusinessname='Lena's Candelabra Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
AAA One Stop Party Shop
Cannington WA 6107
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=6868 or tblfeedback.strbusinessname='AAA One Stop Party Shop' or tblfeedback.strbusinessname='AAA One Stop Party Shop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bungaree Laundry Services
Canning Vale 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=6903 or tblfeedback.strbusinessname='Bungaree Laundry Services' or tblfeedback.strbusinessname='Bungaree Laundry Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Party Paradise
Fremantle WA 6160
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=6948 or tblfeedback.strbusinessname='Party Paradise' or tblfeedback.strbusinessname='Party Paradise') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Black Cat Florist & Gifts
Fremantle WA 6160
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=6866 or tblfeedback.strbusinessname='A Black Cat Florist &%%semi%% Gifts' or tblfeedback.strbusinessname='A Black Cat Florist & Gifts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Propagander Theme Hire
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=6962 or tblfeedback.strbusinessname='Propagander Theme Hire' or tblfeedback.strbusinessname='Propagander Theme Hire') 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
Pedersens Hire
Canning Vale 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=6955 or tblfeedback.strbusinessname='Pedersens Hire' or tblfeedback.strbusinessname='Pedersens Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Aaaballoons
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=6858 or tblfeedback.strbusinessname='A Aaaballoons' or tblfeedback.strbusinessname='A Aaaballoons') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Superclean Steam Laundry
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=6977 or tblfeedback.strbusinessname='Superclean Steam Laundry' or tblfeedback.strbusinessname='Superclean Steam Laundry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 133 Sort search results alphabetically