Hello i got the same result in an easier way. Im just transfering it to zend_db now. If i get any problem i reply this message.
SELECT `ms`.*, (SELECT COUNT(mi.id) FROM mailingItem as mi WHERE mi.mailingSchedule__id__FK=ms.id) AS `mailingItemCount`, SUM(IF(msr.bounce=0,1,0)) AS `sentTotal`, SUM(msr.view) AS `viewTotal`, SUM(msr.click) AS `clickTotal` FROM `mailingSchedule` AS `ms` LEFT JOIN `mailingScheduleResult` AS `msr` ON msr.mailingSchedule__id__FK=ms.id GROUP BY `id` Thanks.
