ZF2 - subconsultas

Subconsulta en Zend Framework 2

Mi consulta requerida:

SELECT `comment`.`id` AS `commentId`, `comment`.`comment` AS `comment`, 
        (SELECT COUNT(`comment_vote`.`id`) AS `negativeVote` 
        FROM `comment_vote` 
        WHERE vote = -1 
        AND `comment_vote`.`commentId` = `comment`.`id`) AS `nagetiveVoteCount` 
FROM `comment`

Por favor ayuda.

Gracias anjith

Respuestas a la pregunta(3)

Su respuesta a la pregunta