Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- series_name,
- creators,
- item_id,
- addresses,
- total_value,
- balance,
- first_active,
- redeemed_on
- FROM
- god_view
- WHERE
- creators LIKE '%Rarity Check%' AND
- redeemed_on IS NOT NULL AND
- redeemed_on IN (
- SELECT redeemed_on
- FROM god_view
- WHERE creators LIKE '%Rarity Check%' AND redeemed_on IS NOT NULL
- GROUP BY redeemed_on
- HAVING COUNT(*) >= 3
- )
Advertisement
Add Comment
Please, Sign In to add comment