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 iconography
iconography
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=20275 or tblfeedback.strbusinessname='iconography' or tblfeedback.strbusinessname='iconography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Announce your wedding in style.

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
Ideas Ministry
Hampton Park VIC 3976
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=43498 or tblfeedback.strbusinessname='Ideas Ministry' or tblfeedback.strbusinessname='Ideas Ministry') 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
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
Armbry Creations
Narre Warren South VIC 3805
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=25318 or tblfeedback.strbusinessname='Armbry Creations' or tblfeedback.strbusinessname='Armbry Creations') 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
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
Something Peach
Carnegie VIC 3163
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=29641 or tblfeedback.strbusinessname='Something Peach' or tblfeedback.strbusinessname='Something Peach') 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
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
Mickey Loves Jacqui Letterpress
Burwood East VIC 3125
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=25365 or tblfeedback.strbusinessname='Mickey Loves Jacqui Letterpress' or tblfeedback.strbusinessname='Mickey Loves Jacqui Letterpress') 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
Sweet Phine Cards
Ringwood VIC
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=25665 or tblfeedback.strbusinessname='Sweet Phine Cards' or tblfeedback.strbusinessname='Sweet Phine Cards') 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
Giant Invitations
Brunswick VIC 3056
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=26927 or tblfeedback.strbusinessname='Giant Invitations' or tblfeedback.strbusinessname='Giant Invitations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Personally Invited
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=26792 or tblfeedback.strbusinessname='Personally Invited' or tblfeedback.strbusinessname='Personally Invited') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Professional Personalised Digital Printing
Newport VIC 3015
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=14804 or tblfeedback.strbusinessname='Professional Personalised Digital Printing' or tblfeedback.strbusinessname='Professional Personalised Digital Printing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Multi Print
Bayswater VIC 3153
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=377 or tblfeedback.strbusinessname='Multi Print' or tblfeedback.strbusinessname='Multi Print') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Wedding Stationery
Ferntree Gully VIC 3156
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=390 or tblfeedback.strbusinessname='All Wedding Stationery' or tblfeedback.strbusinessname='All Wedding Stationery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Personalised Stamps
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=14802 or tblfeedback.strbusinessname='Personalised Stamps' or tblfeedback.strbusinessname='Personalised Stamps') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Any Occasion Invitations
South Yarra VIC 3141
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=396 or tblfeedback.strbusinessname='Any Occasion Invitations' or tblfeedback.strbusinessname='Any Occasion Invitations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bridal Talk
Fairfield VIC 3078
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=409 or tblfeedback.strbusinessname='Bridal Talk' or tblfeedback.strbusinessname='Bridal Talk') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Radmel Quality Printing
Mill Park VIC 3082
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=522 or tblfeedback.strbusinessname='Radmel Quality Printing' or tblfeedback.strbusinessname='Radmel Quality Printing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Print Managers
Mooroolbark VIC 3138
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=547 or tblfeedback.strbusinessname='The Print Managers' or tblfeedback.strbusinessname='The Print Managers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Torkos Ploetz Design
Black Rock VIC 3193
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=553 or tblfeedback.strbusinessname='Torkos Ploetz Design' or tblfeedback.strbusinessname='Torkos Ploetz Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Paper Impressions
Armadale VIC 3143
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=506 or tblfeedback.strbusinessname='Paper Impressions' or tblfeedback.strbusinessname='Paper Impressions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Canterbury Calligraphy
Forest Hill VIC 3131
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=413 or tblfeedback.strbusinessname='Canterbury Calligraphy' or tblfeedback.strbusinessname='Canterbury Calligraphy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Powell
Toorak VIC 3142
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=14803 or tblfeedback.strbusinessname='Powell' or tblfeedback.strbusinessname='Powell') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Black-Tie Weddings & Craft
Wonga Park VIC 3115
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=405 or tblfeedback.strbusinessname='Black-Tie Weddings &%%semi%% Craft' or tblfeedback.strbusinessname='Black-Tie Weddings & Craft') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mayes Printing Service
Altona VIC 3018
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=486 or tblfeedback.strbusinessname='Mayes Printing Service' or tblfeedback.strbusinessname='Mayes Printing Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
D & G Printing
Frankston VIC 3199
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=434 or tblfeedback.strbusinessname='D &%%semi%% G Printing' or tblfeedback.strbusinessname='D & G Printing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
McKerr Whitefield
Heathmont VIC 3135
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=488 or tblfeedback.strbusinessname='McKerr Whitefield' or tblfeedback.strbusinessname='McKerr Whitefield') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
C & A Printers
Pascoe Vale VIC 3044
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=410 or tblfeedback.strbusinessname='C &%%semi%% A Printers' or tblfeedback.strbusinessname='C & A Printers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
E & S Wedding Invitations
Moorabbin VIC 3189
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=14776 or tblfeedback.strbusinessname='E &%%semi%% S Wedding Invitations' or tblfeedback.strbusinessname='E & S Wedding Invitations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fresh Creative
Brighton VIC 3186
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=17751 or tblfeedback.strbusinessname='Fresh Creative' or tblfeedback.strbusinessname='Fresh Creative') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
B.G.S. Printing Pty Ltd
Kilsyth VIC 3137
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=400 or tblfeedback.strbusinessname='B.G.S. Printing Pty Ltd' or tblfeedback.strbusinessname='B.G.S. Printing Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dr Printing
Diamond Creek VIC 3089
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=14775 or tblfeedback.strbusinessname='Dr Printing' or tblfeedback.strbusinessname='Dr Printing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Certificates Unlimited
Glen Waverley VIC 3150
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=418 or tblfeedback.strbusinessname='Certificates Unlimited' or tblfeedback.strbusinessname='Certificates Unlimited') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Define Visions
South Melbourne VIC 3205
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=439 or tblfeedback.strbusinessname='Define Visions' or tblfeedback.strbusinessname='Define Visions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
RSVP Stationery-The Print Managers
Mooroolbark VIC 3138
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=14807 or tblfeedback.strbusinessname='RSVP Stationery-The Print Managers' or tblfeedback.strbusinessname='RSVP Stationery-The Print Managers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Diamond Print
Bayswater VIC 3153
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=443 or tblfeedback.strbusinessname='Diamond Print' or tblfeedback.strbusinessname='Diamond Print') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
IBF Invitations
Mitcham VIC 3132
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=14783 or tblfeedback.strbusinessname='IBF Invitations' or tblfeedback.strbusinessname='IBF Invitations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Powell Nene
Toorak VIC 3142
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=520 or tblfeedback.strbusinessname='Powell Nene' or tblfeedback.strbusinessname='Powell Nene') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Card & Caboodle
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=414 or tblfeedback.strbusinessname='Card &%%semi%% Caboodle' or tblfeedback.strbusinessname='Card & Caboodle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Album Artists
Hawthorn VIC 3122
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=389 or tblfeedback.strbusinessname='Album Artists' or tblfeedback.strbusinessname='Album Artists') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wedding Cameras
Ivanhoe East VIC 3079
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=560 or tblfeedback.strbusinessname='Wedding Cameras' or tblfeedback.strbusinessname='Wedding Cameras') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Andrea Cloney
Carrum VIC 3197
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=394 or tblfeedback.strbusinessname='Andrea Cloney' or tblfeedback.strbusinessname='Andrea Cloney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Papers of Distinction
Brunswick VIC 3056
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=19529 or tblfeedback.strbusinessname='Papers of Distinction' or tblfeedback.strbusinessname='Papers of Distinction') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 193 Sort search results alphabetically