Wedding Videos Far North Queensland

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=36203 or tblfeedback.strbusinessname='Hudson Films' or tblfeedback.strbusinessname='Hudson Films') and year(getdate())-year(dtmadded)<=15

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=26336 or tblfeedback.strbusinessname='Videoticz Photography Fiji' or tblfeedback.strbusinessname='Videoticz Photography Fiji') and year(getdate())-year(dtmadded)<=15

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=22700 or tblfeedback.strbusinessname='Hudson Films' or tblfeedback.strbusinessname='Hudson Films') and year(getdate())-year(dtmadded)<=15

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=26705 or tblfeedback.strbusinessname='Hello Blue productions' or tblfeedback.strbusinessname='Hello Blue productions') and year(getdate())-year(dtmadded)<=15

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=27102 or tblfeedback.strbusinessname='Th3rd Dimension Media' or tblfeedback.strbusinessname='Th3rd Dimension Media') and year(getdate())-year(dtmadded)<=15

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=27134 or tblfeedback.strbusinessname='Eternal Films' or tblfeedback.strbusinessname='Eternal Films') and year(getdate())-year(dtmadded)<=15

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=27365 or tblfeedback.strbusinessname='Luminosity Studios' or tblfeedback.strbusinessname='Luminosity Studios') and year(getdate())-year(dtmadded)<=15

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=36246 or tblfeedback.strbusinessname='TJ Creative' or tblfeedback.strbusinessname='TJ Creative') and year(getdate())-year(dtmadded)<=15

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=17119 or tblfeedback.strbusinessname='Alan Nielsen' or tblfeedback.strbusinessname='Alan Nielsen') and year(getdate())-year(dtmadded)<=15

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=17128 or tblfeedback.strbusinessname='Chris Soan' or tblfeedback.strbusinessname='Chris Soan') and year(getdate())-year(dtmadded)<=15

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=17129 or tblfeedback.strbusinessname='Coral O'%%semi%%Connell' or tblfeedback.strbusinessname='Coral O'Connell') and year(getdate())-year(dtmadded)<=15

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=17130 or tblfeedback.strbusinessname='Coral-Video' or tblfeedback.strbusinessname='Coral-Video') and year(getdate())-year(dtmadded)<=15

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=17142 or tblfeedback.strbusinessname='Memories by Marion Wedding Videos' or tblfeedback.strbusinessname='Memories by Marion Wedding Videos') and year(getdate())-year(dtmadded)<=15

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=17143 or tblfeedback.strbusinessname='Oak Beach Productions' or tblfeedback.strbusinessname='Oak Beach Productions') and year(getdate())-year(dtmadded)<=15

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=17145 or tblfeedback.strbusinessname='Play It Again Media' or tblfeedback.strbusinessname='Play It Again Media') and year(getdate())-year(dtmadded)<=15

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=17154 or tblfeedback.strbusinessname='Visibility Video' or tblfeedback.strbusinessname='Visibility Video') and year(getdate())-year(dtmadded)<=15

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=17156 or tblfeedback.strbusinessname='White Horse Productions' or tblfeedback.strbusinessname='White Horse Productions') and year(getdate())-year(dtmadded)<=15