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
 LEFT JOIN `engine4_core_tagmaps` ON engine4_core_tagmaps.resource_id = engine4_album_photos.photo_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) AND (engine4_core_tagmaps.resource_type = 'album_photo') AND (engine4_core_tagmaps.tag_id = 13901)