# 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 ); ```