SELECT w.wishlist_id, count(i.wishlist_item_id) as _count, c.firstname, c.lastname, c.updated_at
FROM wishlist w
INNER JOIN wishlist_item i ON w.wishlist_id = i.wishlist_id
INNER JOIN customer_entity c ON c.entity_id = w.customer_id
GROUP BY w.wishlist_id
ORDER BY _count DESC
