Rating Sarahmonies
Sarahmonies
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=19930 or tblfeedback.strbusinessname='Sarahmonies' or tblfeedback.strbusinessname='Sarahmonies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Traditional or different, happy to go with the flow.

Rating
Carla Paterson
Dunsborough WA 6280
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=41652 or tblfeedback.strbusinessname='Carla Paterson' or tblfeedback.strbusinessname='Carla Paterson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Meant For You
Mandurah WA 6210
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=27330 or tblfeedback.strbusinessname='Meant For You' or tblfeedback.strbusinessname='Meant For You') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Great Southern Celebrants - Margie Ward
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=29259 or tblfeedback.strbusinessname='Great Southern Celebrants - Margie Ward' or tblfeedback.strbusinessname='Great Southern Celebrants - Margie Ward') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jenny Fisher Wedding
Busselton WA 6280
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=46714 or tblfeedback.strbusinessname='Jenny Fisher Wedding' or tblfeedback.strbusinessname='Jenny Fisher Wedding') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Unity Celebrancy - Rebecca Atkinson Registered Marriage Celebrant
York WA 6302
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=43609 or tblfeedback.strbusinessname='Unity Celebrancy - Rebecca Atkinson Registered Marriage Celebrant' or tblfeedback.strbusinessname='Unity Celebrancy - Rebecca Atkinson Registered Marriage Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
South West Weddings with Nikki
Bunbury WA 6223
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=43216 or tblfeedback.strbusinessname='South West Weddings with Nikki' or tblfeedback.strbusinessname='South West Weddings with Nikki') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Josie Arnold Wedding Celebrant
Reinscourt WA 6280
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=22077 or tblfeedback.strbusinessname='Josie Arnold Wedding Celebrant' or tblfeedback.strbusinessname='Josie Arnold Wedding Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Naomi Mowbray Celebrant
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=46248 or tblfeedback.strbusinessname='Naomi Mowbray Celebrant' or tblfeedback.strbusinessname='Naomi Mowbray Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Michelle Cooke
Margaret River WA 6285
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=37633 or tblfeedback.strbusinessname='Michelle Cooke' or tblfeedback.strbusinessname='Michelle Cooke') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Margaret River Elopements
Dunsborough WA 6281
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=27728 or tblfeedback.strbusinessname='Margaret River Elopements' or tblfeedback.strbusinessname='Margaret River Elopements') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Alexis Woolhead
Bunbury WA 6230
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=29230 or tblfeedback.strbusinessname='Alexis Woolhead' or tblfeedback.strbusinessname='Alexis Woolhead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Emma Dickson Celebrant
Busselton VIC 6280
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=43407 or tblfeedback.strbusinessname='Emma Dickson Celebrant' or tblfeedback.strbusinessname='Emma Dickson Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Marry Me Josh
Perth WA 6060
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=44287 or tblfeedback.strbusinessname='Marry Me Josh' or tblfeedback.strbusinessname='Marry Me Josh') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sayers Daphne
Busselton WA 6280
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=4594 or tblfeedback.strbusinessname='Sayers Daphne' or tblfeedback.strbusinessname='Sayers Daphne') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Johnstone Peg
Manjimup WA 6258
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=4548 or tblfeedback.strbusinessname='Johnstone Peg' or tblfeedback.strbusinessname='Johnstone Peg') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Joan Kent J.P
Busselton WA 6280
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=4546 or tblfeedback.strbusinessname='Joan Kent J.P' or tblfeedback.strbusinessname='Joan Kent J.P') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wignall Olga
Mundaring WA 6073
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=4613 or tblfeedback.strbusinessname='Wignall Olga' or tblfeedback.strbusinessname='Wignall Olga') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Payton Coral
Bunbury WA 6230
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=4585 or tblfeedback.strbusinessname='Payton Coral' or tblfeedback.strbusinessname='Payton Coral') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Smith Joy
Dunsborough WA 6281
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=4597 or tblfeedback.strbusinessname='Smith Joy' or tblfeedback.strbusinessname='Smith Joy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lawrence Lockyear JP
Gooseberry Hill WA 6076
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=4561 or tblfeedback.strbusinessname='Lawrence Lockyear JP' or tblfeedback.strbusinessname='Lawrence Lockyear JP') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lawrence (Larry) Lockyear JP
Kalamunda WA 6076
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=4560 or tblfeedback.strbusinessname='Lawrence (%%semi%%Larry)%%semi%% Lockyear JP' or tblfeedback.strbusinessname='Lawrence (Larry) Lockyear JP') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Besley Dawn
Safety BAy WA 6169
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=4465 or tblfeedback.strbusinessname='Besley Dawn' or tblfeedback.strbusinessname='Besley Dawn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
O'Hara Tony
York WA 6302
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=4581 or tblfeedback.strbusinessname='O'%%semi%%Hara Tony' or tblfeedback.strbusinessname='O'Hara Tony') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Shepherd Bill
Safety Bay WA 6169
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=4595 or tblfeedback.strbusinessname='Shepherd Bill' or tblfeedback.strbusinessname='Shepherd Bill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
McCleary Gwen
Brunswick Junction WA 6224
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=4574 or tblfeedback.strbusinessname='McCleary Gwen' or tblfeedback.strbusinessname='McCleary Gwen') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Owen Davies
Kelmscot WA 6111
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=4583 or tblfeedback.strbusinessname='Owen Davies' or tblfeedback.strbusinessname='Owen Davies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ewers-Ferge
Albany WA 6330
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=4511 or tblfeedback.strbusinessname='Ewers-Ferge' or tblfeedback.strbusinessname='Ewers-Ferge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brady Colleen
Wooroloo WA 6558
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=4469 or tblfeedback.strbusinessname='Brady Colleen' or tblfeedback.strbusinessname='Brady Colleen') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ellson, Peter Jeffrey
Pelican Point WA 6230
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=4506 or tblfeedback.strbusinessname='Ellson, Peter Jeffrey' or tblfeedback.strbusinessname='Ellson, Peter Jeffrey') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cole Marjorie
Denmark WA 6333
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=4487 or tblfeedback.strbusinessname='Cole Marjorie' or tblfeedback.strbusinessname='Cole Marjorie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sayers
Busselton WA 6280
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=6833 or tblfeedback.strbusinessname='Sayers' or tblfeedback.strbusinessname='Sayers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jennifer Etherington
Dunsborough WA 6281
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=17582 or tblfeedback.strbusinessname='Jennifer Etherington' or tblfeedback.strbusinessname='Jennifer Etherington') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Owen Davies
Kelmscott WA 6111
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=6824 or tblfeedback.strbusinessname='Owen Davies' or tblfeedback.strbusinessname='Owen Davies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tieleman Wiebe & Associates
Bickley WA 6076
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=4605 or tblfeedback.strbusinessname='Tieleman Wiebe &%%semi%% Associates' or tblfeedback.strbusinessname='Tieleman Wiebe & Associates') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Munn Jeff
Armadale WA 6112
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=4578 or tblfeedback.strbusinessname='Munn Jeff' or tblfeedback.strbusinessname='Munn Jeff') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mills Arthur
Mandurah WA 6210
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=4577 or tblfeedback.strbusinessname='Mills Arthur' or tblfeedback.strbusinessname='Mills Arthur') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dobbin Meryl G
Nannup WA 6275
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=4499 or tblfeedback.strbusinessname='Dobbin Meryl G' or tblfeedback.strbusinessname='Dobbin Meryl G') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Noakes Eileen
Margaret River WA 6285
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=4579 or tblfeedback.strbusinessname='Noakes Eileen' or tblfeedback.strbusinessname='Noakes Eileen') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gurney Gloria
Glen Forrest WA 6071
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=4519 or tblfeedback.strbusinessname='Gurney Gloria' or tblfeedback.strbusinessname='Gurney Gloria') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Besley Elizabeth
Narrogin WA 6312
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=4466 or tblfeedback.strbusinessname='Besley Elizabeth' or tblfeedback.strbusinessname='Besley Elizabeth') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wignall
Mundaring WA 6073
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=6849 or tblfeedback.strbusinessname='Wignall' or tblfeedback.strbusinessname='Wignall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Terri Kinsella
Mandurah WA 6210
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=17586 or tblfeedback.strbusinessname='Terri Kinsella' or tblfeedback.strbusinessname='Terri Kinsella') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dent Maggie
Albany WA 6330
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=4497 or tblfeedback.strbusinessname='Dent Maggie' or tblfeedback.strbusinessname='Dent Maggie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Smith
Dunsborough WA 6281
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=6837 or tblfeedback.strbusinessname='Smith' or tblfeedback.strbusinessname='Smith') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Loughton Peter
Kinross WA 6028
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=4566 or tblfeedback.strbusinessname='Loughton Peter' or tblfeedback.strbusinessname='Loughton Peter') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Briegel Elza
York WA 6302
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=4472 or tblfeedback.strbusinessname='Briegel Elza' or tblfeedback.strbusinessname='Briegel Elza') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kate Joyce
Mandurah WA 6210
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=4551 or tblfeedback.strbusinessname='Kate Joyce' or tblfeedback.strbusinessname='Kate Joyce') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Margaret Kay Cole
Albany WA 6330
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=4571 or tblfeedback.strbusinessname='Margaret Kay Cole' or tblfeedback.strbusinessname='Margaret Kay Cole') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jeff Munn
Armadale WA 6112
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=4544 or tblfeedback.strbusinessname='Jeff Munn' or tblfeedback.strbusinessname='Jeff Munn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 60 Sort search results alphabetically