# Remove subscriptions duplicates for users with plan fox sports super
```sql
select user_id from subscriptions where plan_id = 'fox-sports-super';
```
```sql
SELECT * FROM subscriptions where `plan_id` not in ('fox-sports-super', 'crunchyroll-monthly') and user_id in(
121405,
201110,
205684,
199715,
208358,
204214,
209434,
203542,
208944,
204178,
202519,
189063,
208829,
199739,
197872,
205158,
203875,
203687,
193241,
194563
);
```
Delete subscriptions
```sql
DELETE FROM subscriptions WHERE id in(
112803,
208407,
216574,
219882,
1282824,
225836,
228849,
228875,
230433,
231837,
232864,
233010,
233199,
233507,
233543,
1278370,
1278899,
1281602,
1282079,
1282195,
1282737
);
```