Rating PJs Invitations and Illustrations
PJs Invitations and Illustrations
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=20910 or tblfeedback.strbusinessname='PJs Invitations and Illustrations' or tblfeedback.strbusinessname='PJs Invitations and Illustrations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Beautiful designs using illustrated portraits. An invitation with an illustrated portrait of the couple to be.

Rating
Officeworks
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=27947 or tblfeedback.strbusinessname='Officeworks' or tblfeedback.strbusinessname='Officeworks') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Officeworks
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=27947 or tblfeedback.strbusinessname='Officeworks' or tblfeedback.strbusinessname='Officeworks') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Minted
SA
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=37927 or tblfeedback.strbusinessname='Minted' or tblfeedback.strbusinessname='Minted') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Deja10
Melbourne VIC 3000
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=44789 or tblfeedback.strbusinessname='Deja10' or tblfeedback.strbusinessname='Deja10') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
KC Times Co
Brisbane QLD 4000
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=44432 or tblfeedback.strbusinessname='KC Times Co' or tblfeedback.strbusinessname='KC Times Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Deciduous Press
Margate TAS 7054
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=23596 or tblfeedback.strbusinessname='Deciduous Press' or tblfeedback.strbusinessname='Deciduous Press') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Luxe Boutique Invitations
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=27705 or tblfeedback.strbusinessname='Luxe Boutique Invitations' or tblfeedback.strbusinessname='Luxe Boutique Invitations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Minted
SA
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=37927 or tblfeedback.strbusinessname='Minted' or tblfeedback.strbusinessname='Minted') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Madelyn Holmes Photographics
Frenchville QLD 4701
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=26616 or tblfeedback.strbusinessname='Madelyn Holmes Photographics' or tblfeedback.strbusinessname='Madelyn Holmes Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
GHB PTY LTD - Paper Concepts
Mt Nelson TAS 7007
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=3483 or tblfeedback.strbusinessname='GHB PTY LTD - Paper Concepts' or tblfeedback.strbusinessname='GHB PTY LTD - Paper Concepts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Big Event
Kingston TAS 7050
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=3478 or tblfeedback.strbusinessname='The Big Event' or tblfeedback.strbusinessname='The Big Event') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Personalised Stamps
Hobart TAS 7000
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=5380 or tblfeedback.strbusinessname='Personalised Stamps' or tblfeedback.strbusinessname='Personalised Stamps') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Papers of Distinction
Hobart TAS 7000
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=5379 or tblfeedback.strbusinessname='Papers of Distinction' or tblfeedback.strbusinessname='Papers of Distinction') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Plane Tree Studio
Hobart TAS 7000
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=3486 or tblfeedback.strbusinessname='Plane Tree Studio' or tblfeedback.strbusinessname='Plane Tree Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elegant Ink Calligraphy
Taroona TAS 7053
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=3482 or tblfeedback.strbusinessname='Elegant Ink Calligraphy' or tblfeedback.strbusinessname='Elegant Ink Calligraphy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Imagine It
South Arm TAS 7022
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=5377 or tblfeedback.strbusinessname='Imagine It' or tblfeedback.strbusinessname='Imagine It') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Christine Farmer
Mt Stuart TAS 7000
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=3477 or tblfeedback.strbusinessname='Christine Farmer' or tblfeedback.strbusinessname='Christine Farmer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
GHB Pty Ltd-Paper Concepts
Mount Nelson TAS 7007
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=5371 or tblfeedback.strbusinessname='GHB Pty Ltd-Paper Concepts' or tblfeedback.strbusinessname='GHB Pty Ltd-Paper Concepts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dobson Sales
Hobart TAS 7000
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=3480 or tblfeedback.strbusinessname='Dobson Sales' or tblfeedback.strbusinessname='Dobson Sales') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15