I eventually did it by adding a Function (if anyone would like to)...
<pre lang="sql">DELIMITER $$
DROP FUNCTION IF EXISTS `videostreamer`.`countReported` $$
CREATE FUNCTION `videostreamer`.`countReported` (aembed_ID int) RETURNS INTEGER
DECLARE Temp INTEGER;
SELECT count(id) INTO Temp FROM reported where embed_id = aembed_ID;
RETURN IFNULL(Temp, 0);
Then the sql was....
SELECT *, countReported(e.id) cReported
FROM embed e
where e.video_id = 368 and e.enabled = 1 and e.Parent_ID = 0 order by cReported;