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
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
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
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
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
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
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
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=6768 or tblfeedback.strbusinessname='Davies' or tblfeedback.strbusinessname='Davies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Andrews Heather
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=4454 or tblfeedback.strbusinessname='Andrews Heather' or tblfeedback.strbusinessname='Andrews Heather') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Reg Oakes
Mahogany Creek WA 6072
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=4591 or tblfeedback.strbusinessname='Reg Oakes' or tblfeedback.strbusinessname='Reg Oakes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brady
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=6744 or tblfeedback.strbusinessname='Brady' or tblfeedback.strbusinessname='Brady') 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
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
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
Margaret Mc Kay
Darlington WA 6070
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=6814 or tblfeedback.strbusinessname='Margaret Mc Kay' or tblfeedback.strbusinessname='Margaret Mc Kay') 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
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
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
David Williams
Lesmurdie 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=4494 or tblfeedback.strbusinessname='David Williams' or tblfeedback.strbusinessname='David Williams') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mc Cleary
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=6816 or tblfeedback.strbusinessname='Mc Cleary' or tblfeedback.strbusinessname='Mc Cleary') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cole
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=6761 or tblfeedback.strbusinessname='Cole' or tblfeedback.strbusinessname='Cole') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Besley
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=6741 or tblfeedback.strbusinessname='Besley' or tblfeedback.strbusinessname='Besley') 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=6802 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
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
O'Hara
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=6822 or tblfeedback.strbusinessname='O'%%semi%%Hara' or tblfeedback.strbusinessname='O'Hara') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Harrison Dorothy
Mt Nasura ACT 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=4537 or tblfeedback.strbusinessname='Harrison Dorothy' or tblfeedback.strbusinessname='Harrison Dorothy') 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
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
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
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
Argentino Loris
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=4456 or tblfeedback.strbusinessname='Argentino Loris' or tblfeedback.strbusinessname='Argentino Loris') 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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Harrison
Mount Nasura 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=6794 or tblfeedback.strbusinessname='Harrison' or tblfeedback.strbusinessname='Harrison') 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
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
Iturbide T K
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=4543 or tblfeedback.strbusinessname='Iturbide T K' or tblfeedback.strbusinessname='Iturbide T K') 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
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
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
Hill Allan
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=4541 or tblfeedback.strbusinessname='Hill Allan' or tblfeedback.strbusinessname='Hill Allan') 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
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
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=6820 or tblfeedback.strbusinessname='Munn' or tblfeedback.strbusinessname='Munn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Iturbide
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=6800 or tblfeedback.strbusinessname='Iturbide' or tblfeedback.strbusinessname='Iturbide') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hill
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=6798 or tblfeedback.strbusinessname='Hill' or tblfeedback.strbusinessname='Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
David Nelson
Calista WA 6167
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=4493 or tblfeedback.strbusinessname='David Nelson' or tblfeedback.strbusinessname='David Nelson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Briegel
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=6747 or tblfeedback.strbusinessname='Briegel' or tblfeedback.strbusinessname='Briegel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Noakes
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=6821 or tblfeedback.strbusinessname='Noakes' or tblfeedback.strbusinessname='Noakes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dent
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=6769 or tblfeedback.strbusinessname='Dent' or tblfeedback.strbusinessname='Dent') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 81 Sort search results alphabetically