🔧 Filter Users Table

This script will create a filtered Users table with users from groups 4, 5, 7, 10, 12 and users with 'Admin' in their name.

📋 Executing SQL Commands

Executing: Drop existing filtered table if it exists

✅ Success

Executing: Create new filtered table structure

✅ Success

Executing: Insert filtered users

✅ Success

📊 Results Summary

Total users in filtered table: 425

Users by Group:

GroupCount
Group 4 users:62
Group 5 users:303
Group 7 users:180
Group 10 users:75
Group 12 users:129

Users with 'Admin' in name: 14

Users in groups 4,5,7,10,12 AND have 'Admin' in name: 6

👥 Sample of Filtered Users (First 10)

IDMember IDNameEmailPrivileges
6630123987AAAbarry@namic.noUser
542590265AARNES, PERper@yonc.comUser
35764ADAMS, DAWNdawnros.adams@gmail.comUser
7280999910Admin ACLepacl@scala4.comAdmin
7255999914Admin Boardepevents@scala4.comAdmin
7264999916Admin Committeebarry@namic.noAdmin
6618999915Admin Dinnerepeventsdinner@scala4.comAdmin
7270999920Admin Externaladmin20@elparaiso.comAdmin
7310999908Admin LadiesCompsepladies@elparaiso.comAdmin
7281999930Admin LadiesFriendliesepladiesfriendlies@scala4.comAdmin

📈 Summary

✅ Successful operations: 3

❌ Failed operations: 0

🎯 Next Steps:

1. Review the results above to make sure the filtered table looks correct

2. If you want to replace the original Users table, run these commands in phpMyAdmin:

-- Create backup
CREATE TABLE Users_Backup_20260417_122153 AS SELECT * FROM Users;

-- Replace original table
DROP TABLE Users;
RENAME TABLE Users_Filtered TO Users;

⚠️ Important: Make sure to backup your original Users table before replacing it!