SELECT `a`.`id`, `a`.`request`, sum(if(b.status=0, 1, 0)) as statusLike, sum(if(b.status=1, 1, 0)) as statusDislike
FROM `mgs__feature_request` `a`
LEFT OUTER JOIN `mgs_feature_request_voter` `b` ON `b`.`featureID` = `a`.`id`
GROUP BY `a`.`id`, `b`.`featureID`