The Original Wedding Company
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=19516 or tblfeedback.strbusinessname='The Original Wedding Company' or tblfeedback.strbusinessname='The Original Wedding Company') and year(getdate())-year(dtmadded)<=15
Original and exquisite weddings.
design your day
27 Karri Way Thornlie WA 6108
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=22170 or tblfeedback.strbusinessname='design your day' or tblfeedback.strbusinessname='design your day') and year(getdate())-year(dtmadded)<=15
Pop Up Vintage
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=23828 or tblfeedback.strbusinessname='Pop Up Vintage' or tblfeedback.strbusinessname='Pop Up Vintage') and year(getdate())-year(dtmadded)<=15
wedstyle
163 Lord St 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=25113 or tblfeedback.strbusinessname='wedstyle' or tblfeedback.strbusinessname='wedstyle') and year(getdate())-year(dtmadded)<=15
The Closet Designer WA (Rachael Longwood)
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=26508 or tblfeedback.strbusinessname='The Closet Designer WA (%%semi%%Rachael Longwood)%%semi%%' or tblfeedback.strbusinessname='The Closet Designer WA (Rachael Longwood)') and year(getdate())-year(dtmadded)<=15
Blonde & Blue
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=27353 or tblfeedback.strbusinessname='Blonde &%%semi%% Blue' or tblfeedback.strbusinessname='Blonde & Blue') and year(getdate())-year(dtmadded)<=15
Kiss Weddings
Bunbury WA 6230
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=29511 or tblfeedback.strbusinessname='Kiss Weddings' or tblfeedback.strbusinessname='Kiss Weddings') and year(getdate())-year(dtmadded)<=15
Finishing Touch Function Consultants
Level 2 849 Wellington Street 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=6853 or tblfeedback.strbusinessname='Finishing Touch Function Consultants' or tblfeedback.strbusinessname='Finishing Touch Function Consultants') and year(getdate())-year(dtmadded)<=15
Independent Wedding Professionals
34 Aster Avenue 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=6854 or tblfeedback.strbusinessname='Independent Wedding Professionals' or tblfeedback.strbusinessname='Independent Wedding Professionals') and year(getdate())-year(dtmadded)<=15
Jacqui Jordan Events
Cottesloe WA 6011
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=6855 or tblfeedback.strbusinessname='Jacqui Jordan Events' or tblfeedback.strbusinessname='Jacqui Jordan Events') and year(getdate())-year(dtmadded)<=15
MFX
13 Morgan Street 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=6856 or tblfeedback.strbusinessname='MFX' or tblfeedback.strbusinessname='MFX') and year(getdate())-year(dtmadded)<=15
Rings Wedding & Party Co-Ordinating
128 Apsley Road 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=6857 or tblfeedback.strbusinessname='Rings Wedding &%%semi%% Party Co-Ordinating' or tblfeedback.strbusinessname='Rings Wedding & Party Co-Ordinating') and year(getdate())-year(dtmadded)<=15
Bridal Creations
75 Scarborough Beach Road Mt Hawthorn WA 6016
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=7085 or tblfeedback.strbusinessname='Bridal Creations' or tblfeedback.strbusinessname='Bridal Creations') and year(getdate())-year(dtmadded)<=15
Absolute Weddings
3/6 Norton Street South Perth WA 6151
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=17175 or tblfeedback.strbusinessname='Absolute Weddings' or tblfeedback.strbusinessname='Absolute Weddings') and year(getdate())-year(dtmadded)<=15
