Rating
All about you
Strathalbyn SA 5255
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=24607 or tblfeedback.strbusinessname='All about you' or tblfeedback.strbusinessname='All about you') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Vicky Flanegan - Celebrant
Woodcroft SA 5162
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=24110 or tblfeedback.strbusinessname='Vicky Flanegan - Celebrant' or tblfeedback.strbusinessname='Vicky Flanegan - Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lauren Khabbaz Duncan Celebrant
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=25401 or tblfeedback.strbusinessname='Lauren Khabbaz Duncan Celebrant' or tblfeedback.strbusinessname='Lauren Khabbaz Duncan Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Amy Harrison
Adelaide SA 5000
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=29347 or tblfeedback.strbusinessname='Amy Harrison' or tblfeedback.strbusinessname='Amy Harrison') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Married by Ariel
Adelaide SA 5000
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=27401 or tblfeedback.strbusinessname='Married by Ariel' or tblfeedback.strbusinessname='Married by Ariel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gerrelyn Glico
Adelaide SA 5000
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=26902 or tblfeedback.strbusinessname='Gerrelyn Glico' or tblfeedback.strbusinessname='Gerrelyn Glico') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Nicole Hancox
Port Lincoln SA 5606
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=26067 or tblfeedback.strbusinessname='Nicole Hancox' or tblfeedback.strbusinessname='Nicole Hancox') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Marisa Wilson Barossa Marriage Celebrant
Williamstown SA 5351
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=27454 or tblfeedback.strbusinessname='Marisa Wilson Barossa Marriage Celebrant' or tblfeedback.strbusinessname='Marisa Wilson Barossa Marriage Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Victoria Edwards
Golden Grove SA 5125
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=23810 or tblfeedback.strbusinessname='Victoria Edwards' or tblfeedback.strbusinessname='Victoria Edwards') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Patricia Lawton
Valley View SA 5093
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=27477 or tblfeedback.strbusinessname='Patricia Lawton' or tblfeedback.strbusinessname='Patricia Lawton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Amanda Schenk
North Haven SA 5018
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=26668 or tblfeedback.strbusinessname='Amanda Schenk' or tblfeedback.strbusinessname='Amanda Schenk') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Suzanne Price
Ingle Farm SA 5098
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=22203 or tblfeedback.strbusinessname='Suzanne Price' or tblfeedback.strbusinessname='Suzanne Price') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tarlee Life Celebrations
Tarlee SA 5411
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=23968 or tblfeedback.strbusinessname='Tarlee Life Celebrations' or tblfeedback.strbusinessname='Tarlee Life Celebrations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Belinda Nation
KLEMZIG SA 5087
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=26274 or tblfeedback.strbusinessname='Belinda Nation' or tblfeedback.strbusinessname='Belinda Nation') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tina Stockley Civil Marriage Celebrant
Hove SA 5048
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=26447 or tblfeedback.strbusinessname='Tina Stockley Civil Marriage Celebrant' or tblfeedback.strbusinessname='Tina Stockley Civil Marriage Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jacqui Leopardi
Norton Summit SA 5137
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=38209 or tblfeedback.strbusinessname='Jacqui Leopardi' or tblfeedback.strbusinessname='Jacqui Leopardi') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ceremonies for Life and Love
Greenwith SA 5125
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=20047 or tblfeedback.strbusinessname='Ceremonies for Life and Love' or tblfeedback.strbusinessname='Ceremonies for Life and Love ') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bradbury
Hallett Cove SA 5158
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=5797 or tblfeedback.strbusinessname='Bradbury' or tblfeedback.strbusinessname='Bradbury') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wissell
Coromandel Valley SA 5051
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=5899 or tblfeedback.strbusinessname='Wissell' or tblfeedback.strbusinessname='Wissell') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Densley
Glenside SA 5065
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=5809 or tblfeedback.strbusinessname='Densley' or tblfeedback.strbusinessname='Densley') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kidney
Magill SA 5072
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=5842 or tblfeedback.strbusinessname='Kidney' or tblfeedback.strbusinessname='Kidney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barker
Cheltenham SA 5014
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=5789 or tblfeedback.strbusinessname='Barker' or tblfeedback.strbusinessname='Barker') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Basnec
Malvern SA 5061
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=5790 or tblfeedback.strbusinessname='Basnec' or tblfeedback.strbusinessname='Basnec') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coastal Ceremonies
Adelaide SA 5169
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=19070 or tblfeedback.strbusinessname='Coastal Ceremonies' or tblfeedback.strbusinessname='Coastal Ceremonies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hunt
Blackwood SA 5051
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=5827 or tblfeedback.strbusinessname='Hunt' or tblfeedback.strbusinessname='Hunt') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Curtis
Blakeview SA 5114
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=5804 or tblfeedback.strbusinessname='Curtis' or tblfeedback.strbusinessname='Curtis') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Artis
Holden Hill SA 5088
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=5769 or tblfeedback.strbusinessname='Artis' or tblfeedback.strbusinessname='Artis') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mc Govern
Burnside SA 5066
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=5851 or tblfeedback.strbusinessname='Mc Govern' or tblfeedback.strbusinessname='Mc Govern') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bill Mc Govern
Burnside SA 5066
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=5793 or tblfeedback.strbusinessname='Bill Mc Govern' or tblfeedback.strbusinessname='Bill Mc Govern') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fopp
West Beach SA 5024
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=5820 or tblfeedback.strbusinessname='Fopp' or tblfeedback.strbusinessname='Fopp') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Acmc of South Australia
Melrose Park SA 5039
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=5762 or tblfeedback.strbusinessname='Acmc of South Australia' or tblfeedback.strbusinessname='Acmc of South Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Celebrations
Hyde Park SA 5061
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=5765 or tblfeedback.strbusinessname='All Celebrations' or tblfeedback.strbusinessname='All Celebrations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Malin
Darlington SA 5047
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=5848 or tblfeedback.strbusinessname='Malin' or tblfeedback.strbusinessname='Malin') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mills
Marino SA 5049
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=5856 or tblfeedback.strbusinessname='Mills' or tblfeedback.strbusinessname='Mills') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ashby
Gawler East SA 5118
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=5770 or tblfeedback.strbusinessname='Ashby' or tblfeedback.strbusinessname='Ashby') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lisa Camac Celebrant
Woodcroft SA 5162
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=19147 or tblfeedback.strbusinessname='Lisa Camac Celebrant' or tblfeedback.strbusinessname='Lisa Camac Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lawrie
Aldinga Beach SA 5173
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=5843 or tblfeedback.strbusinessname='Lawrie' or tblfeedback.strbusinessname='Lawrie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Deirdre Tipper
Para Hills SA 5096
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=19088 or tblfeedback.strbusinessname='Deirdre Tipper' or tblfeedback.strbusinessname='Deirdre Tipper') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barke
Para Hills West SA 5096
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=5788 or tblfeedback.strbusinessname='Barke' or tblfeedback.strbusinessname='Barke') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Miller
Woodcroft SA 5162
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=5854 or tblfeedback.strbusinessname='Miller' or tblfeedback.strbusinessname='Miller') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tipper Deirdre
Para Hills SA 5096
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=5888 or tblfeedback.strbusinessname='Tipper Deirdre' or tblfeedback.strbusinessname='Tipper Deirdre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Joe IENCO
Fulham SA 5024
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=5834 or tblfeedback.strbusinessname='Joe IENCO' or tblfeedback.strbusinessname='Joe IENCO') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
JA Vella J P C M C
Fullarton SA 5063
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=5829 or tblfeedback.strbusinessname='JA Vella J P C M C' or tblfeedback.strbusinessname='JA Vella J P C M C') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kermode
Brighton SA 5048
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=5841 or tblfeedback.strbusinessname='Kermode' or tblfeedback.strbusinessname='Kermode') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Triplow Lenore
Plympton SA 5038
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=5890 or tblfeedback.strbusinessname='Triplow Lenore' or tblfeedback.strbusinessname='Triplow Lenore') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Alexander Mari
Henley Beach South SA 5022
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=5764 or tblfeedback.strbusinessname='Alexander Mari' or tblfeedback.strbusinessname='Alexander Mari') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Liesl Meuris
Unley SA 5061
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=5846 or tblfeedback.strbusinessname='Liesl Meuris' or tblfeedback.strbusinessname='Liesl Meuris') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Joe Vella J P C M C
Norwood SA 5067
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=5835 or tblfeedback.strbusinessname='Joe Vella J P C M C' or tblfeedback.strbusinessname='Joe Vella J P C M C') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mc Creanor
Hawthorn SA 5062
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=5850 or tblfeedback.strbusinessname='Mc Creanor' or tblfeedback.strbusinessname='Mc Creanor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Glastonbury Meredith
Glenelg East SA 5045
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=5822 or tblfeedback.strbusinessname='Glastonbury Meredith' or tblfeedback.strbusinessname='Glastonbury Meredith') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 103 Sort search results alphabetically