Hello,
I have more than 200 group categories and each one has a single group. They all use the same workflow called Nations Workflow with ID 254.
Since pages are like groups, I would like to use phpmyadmin to copy all the group categories to page categories and all the groups to pages and thereby create new Page categories and Pages. Each of the group categories has an avatar which I will like the corresponding page category to have/share. Each group has an avatar and cover that I would like each corresponding page to have/share. The page workflow is called Page Workflow and has an ID of 252.
Currently only the admin user that created the groups is a member of groups that same user can be the owner of the new pages.
Can you please tell me which SQL statements to use?