SELECT feeds.id, feeds.title, feeds.url,
(SELECT COUNT(item_id) FROM feeds_items
WHERE feeds_items.item_id NOT IN (SELECT item FROM users_items_read WHERE user = users_to_feeds.user AND feed = feeds.id) AND feeds_items.feed_id = feeds.id
GROUP BY feed_id) AS 'unread'
FROM users_to_feeds
INNER JOIN feeds ON feeds.id = users_to_feeds.feed
WHERE users_to_feeds.user = '1'
GROUP BY feeds.id ORDER BY feeds.title ASC