SELECT COUNT(1) AS `zend_paginator_row_count` FROM `engine4_album_photos`
 LEFT JOIN `engine4_album_albums` ON engine4_album_albums.album_id = engine4_album_photos.album_id WHERE (SELECT COUNT(*) > 0 FROM `engine4_album_albums` WHERE (engine4_album_albums.album_id = engine4_album_photos.album_id) AND (type NOT IN ('group','event') OR type IS NULL)) AND (engine4_album_albums.approved =1)