How to find out the most active wishlist users in your store?

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

05

See also: