Home > Wedding Formal Wear and Hire Devonport & North West

Wedding Formal Wear and Hire Devonport & North West

9 result(s) found. View Your Favorites List

Devonport TAS 7310

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=41163 or tblfeedback.strbusinessname='Torque Gear for Guys' or tblfeedback.strbusinessname='Torque Gear for Guys') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
1 review

Ed Harry

Hindmarsh SA 5007

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=26719 or tblfeedback.strbusinessname='Ed Harry' or tblfeedback.strbusinessname='Ed Harry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

5 stars
2 reviews

A & J Formal Suit Hire

Ulverstone TAS 7315

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=5452 or tblfeedback.strbusinessname='A &%%semi%% J Formal Suit Hire' or tblfeedback.strbusinessname='A & J Formal Suit Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Fashion Folkus

Burnie TAS 7320

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=3856 or tblfeedback.strbusinessname='Fashion Folkus' or tblfeedback.strbusinessname='Fashion Folkus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Harris' of Tasmania

Latrobe TAS 7307

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=5429 or tblfeedback.strbusinessname='Harris'%%semi%% of Tasmania' or tblfeedback.strbusinessname='Harris' of Tasmania') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Frank's Bridal Salon

Devonport TAS 7310

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=3857 or tblfeedback.strbusinessname='Frank'%%semi%%s Bridal Salon' or tblfeedback.strbusinessname='Frank's Bridal Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

His Nibbs Mensland

Devonport TAS 7310

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=3859 or tblfeedback.strbusinessname='His Nibbs Mensland' or tblfeedback.strbusinessname='His Nibbs Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Brides of Burnie

Upper Burnie TAS 7320

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=3844 or tblfeedback.strbusinessname='Brides of Burnie' or tblfeedback.strbusinessname='Brides of Burnie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Anna-Christina Bridal

Devonport TAS 7310

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=3850 or tblfeedback.strbusinessname='Anna-Christina Bridal' or tblfeedback.strbusinessname='Anna-Christina Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

1 - 9 of 9 Sort search results alphabetically