Rating
Love and Other Things - Wendy Francis Celebrant
Midway Point TAS 7171
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=25396 or tblfeedback.strbusinessname='Love and Other Things - Wendy Francis Celebrant' or tblfeedback.strbusinessname='Love and Other Things - Wendy Francis Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Merren Wilkinson - Civil Celebrant
Hobart 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=24167 or tblfeedback.strbusinessname='Merren Wilkinson - Civil Celebrant' or tblfeedback.strbusinessname='Merren Wilkinson - Civil Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Maura Kerr
Sandy Bay TAS 7005
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=29674 or tblfeedback.strbusinessname='Maura Kerr' or tblfeedback.strbusinessname='Maura Kerr') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Vivien Ride
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=27404 or tblfeedback.strbusinessname='Vivien Ride' or tblfeedback.strbusinessname='Vivien Ride') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rachael Calvert
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=29765 or tblfeedback.strbusinessname='Rachael Calvert' or tblfeedback.strbusinessname='Rachael Calvert') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Leanne Orr Celebrant
Tranmere TAS 7018
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=35823 or tblfeedback.strbusinessname='Leanne Orr Celebrant' or tblfeedback.strbusinessname='Leanne Orr Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
I Do - Teresa Brinton
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=27840 or tblfeedback.strbusinessname='I Do - Teresa Brinton' or tblfeedback.strbusinessname='I Do - Teresa Brinton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Leanne Orr Marriage Celebrant
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=25009 or tblfeedback.strbusinessname='Leanne Orr Marriage Celebrant' or tblfeedback.strbusinessname='Leanne Orr Marriage Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Diane Burrows
New Town TAS 7008
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=26716 or tblfeedback.strbusinessname='Diane Burrows' or tblfeedback.strbusinessname='Diane Burrows') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Souris Mea
Tinderbox 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=3469 or tblfeedback.strbusinessname='Souris Mea' or tblfeedback.strbusinessname='Souris Mea') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Venn Kath O.A.M. JP
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=3471 or tblfeedback.strbusinessname='Venn Kath O.A.M. JP' or tblfeedback.strbusinessname='Venn Kath O.A.M. JP') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wilson Peter J
Port Arthur TAS 7182
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=3474 or tblfeedback.strbusinessname='Wilson Peter J' or tblfeedback.strbusinessname='Wilson Peter J') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jameson John JP
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=3456 or tblfeedback.strbusinessname='Jameson John JP' or tblfeedback.strbusinessname='Jameson John JP') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Venn
Mount 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=5243 or tblfeedback.strbusinessname='Venn' or tblfeedback.strbusinessname='Venn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jean Walker
Mount 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=5233 or tblfeedback.strbusinessname='Jean Walker' or tblfeedback.strbusinessname='Jean Walker') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Woolley
Judbury TAS 7109
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=5248 or tblfeedback.strbusinessname='Woolley' or tblfeedback.strbusinessname='Woolley') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fay Thompson
Primrose Sands TAS 7173
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=5227 or tblfeedback.strbusinessname='Fay Thompson' or tblfeedback.strbusinessname='Fay Thompson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bonner Chapman
Nubeena TAS 7184
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=3447 or tblfeedback.strbusinessname='Bonner Chapman' or tblfeedback.strbusinessname='Bonner Chapman') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Howard Max
Lindisfarne TAS 7015
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=3453 or tblfeedback.strbusinessname='Howard Max' or tblfeedback.strbusinessname='Howard Max') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Powell Mike
Springfield TAS 7009
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=3466 or tblfeedback.strbusinessname='Powell Mike' or tblfeedback.strbusinessname='Powell Mike') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Maxine Lowry
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=3462 or tblfeedback.strbusinessname='Maxine Lowry' or tblfeedback.strbusinessname='Maxine Lowry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Celia Hooker
New Norfolk TAS 7140
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=3448 or tblfeedback.strbusinessname='Celia Hooker' or tblfeedback.strbusinessname='Celia Hooker') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fay Thompson
New Town TAS 7008
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=3451 or tblfeedback.strbusinessname='Fay Thompson' or tblfeedback.strbusinessname='Fay Thompson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Underwood
Geilston Bay TAS 7015
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=5241 or tblfeedback.strbusinessname='Underwood' or tblfeedback.strbusinessname='Underwood') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Woolley Enid
Judbury TAS 7109
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=3476 or tblfeedback.strbusinessname='Woolley Enid' or tblfeedback.strbusinessname='Woolley Enid') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Underwood Karle
Geilston Bay TAS 7015
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=3470 or tblfeedback.strbusinessname='Underwood Karle' or tblfeedback.strbusinessname='Underwood Karle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rev Dr Jason Betts
Sandy Bay TAS 7006
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=3467 or tblfeedback.strbusinessname='Rev Dr Jason Betts' or tblfeedback.strbusinessname='Rev Dr Jason Betts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Betty C Jackson
Lenah Valley TAS 7008
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=3446 or tblfeedback.strbusinessname='Betty C Jackson' or tblfeedback.strbusinessname='Betty C Jackson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Maxine Lowry
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=5235 or tblfeedback.strbusinessname='Maxine Lowry' or tblfeedback.strbusinessname='Maxine Lowry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Barton Dave
Geilston Bay TAS 7015
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=5223 or tblfeedback.strbusinessname='Barton Dave' or tblfeedback.strbusinessname='Barton Dave') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Walker
Mount 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=5244 or tblfeedback.strbusinessname='Walker' or tblfeedback.strbusinessname='Walker') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Anthony Boden
South Hobart TAS 7004
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=3443 or tblfeedback.strbusinessname='Anthony Boden' or tblfeedback.strbusinessname='Anthony Boden') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wilson
Taranna TAS 7180
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=5246 or tblfeedback.strbusinessname='Wilson' or tblfeedback.strbusinessname='Wilson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jean Walker
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=3457 or tblfeedback.strbusinessname='Jean Walker' or tblfeedback.strbusinessname='Jean Walker') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Donnet - Jones Stephen
Lymington TAS 7109
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=3450 or tblfeedback.strbusinessname='Donnet - Jones Stephen' or tblfeedback.strbusinessname='Donnet - Jones Stephen') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
John Jameson
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=19138 or tblfeedback.strbusinessname='John Jameson' or tblfeedback.strbusinessname='John Jameson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Webster
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=5245 or tblfeedback.strbusinessname='Webster' or tblfeedback.strbusinessname='Webster') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
King E W J.P
Bonnet Hill TAS 7035
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=3460 or tblfeedback.strbusinessname='King E W J.P' or tblfeedback.strbusinessname='King E W J.P') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
King
Bonnet Hill 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=5234 or tblfeedback.strbusinessname='King' or tblfeedback.strbusinessname='King') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Donnet-Jones
Lymington TAS 7109
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=5226 or tblfeedback.strbusinessname='Donnet-Jones' or tblfeedback.strbusinessname='Donnet-Jones') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Walker Jean
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=3472 or tblfeedback.strbusinessname='Walker Jean' or tblfeedback.strbusinessname='Walker Jean') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Max Howard
Lindisfarne TAS 7015
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=3461 or tblfeedback.strbusinessname='Max Howard' or tblfeedback.strbusinessname='Max Howard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Souris
Tinderbox 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=5240 or tblfeedback.strbusinessname='Souris' or tblfeedback.strbusinessname='Souris') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Best Maggie
Koonya TAS 7187
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=3445 or tblfeedback.strbusinessname='Best Maggie' or tblfeedback.strbusinessname='Best Maggie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jameson
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=5232 or tblfeedback.strbusinessname='Jameson' or tblfeedback.strbusinessname='Jameson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Howard
Lindisfarne TAS 7015
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=5229 or tblfeedback.strbusinessname='Howard' or tblfeedback.strbusinessname='Howard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Best
Koonya TAS 7187
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=5224 or tblfeedback.strbusinessname='Best' or tblfeedback.strbusinessname='Best') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dawn Parr
Richmond TAS 7025
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=3449 or tblfeedback.strbusinessname='Dawn Parr' or tblfeedback.strbusinessname='Dawn Parr') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jill Webster
New Town TAS 7008
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=3458 or tblfeedback.strbusinessname='Jill Webster' or tblfeedback.strbusinessname='Jill Webster') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Webster Jill
New Town TAS 7008
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=3473 or tblfeedback.strbusinessname='Webster Jill' or tblfeedback.strbusinessname='Webster Jill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15