Remove page assignment from many modules

Question

I have a website (not made by me, working on restyling) that manage achitect pubblications and every architect have page with own menu with Home - Bio - Project 1 - Project 2 and so on. And i have modules (bio and projects) assigned to Home. Now i have something like 580 Bio modules and i would like to remove them only from Home of architect page. Is there anyway to do that in "automatic way"? Or i have to open every single module and remove assignment from home menu item?

Joomla 3.9.2 installed

Thank you

Code that unset module assignment on page that you want

    DELETE FROM dbprefix_modules_menu
    WHERE menuid = HOME_PAGE_ID
    AND moduleid IN ( SELECT moduleid FROM (
                          SELECT mm.moduleid 
                          FROM dbprefix_modules_menu AS mm 
                          WHERE mm.moduleid = MODULE_ID ) tempTable                     
                     )

Replace dbprefix with your real database prefix. Replace HOME_PAGE_ID and MODULE_ID with their corresponding values from the ID column of the Menu Items manager, look at the attached screenshot.

Answer 1

RECOMMENDED:
BACKUP your website, and test it on the backup website doing this action to the live website.

This can be done using SQL, if you can access phpMyAdmin, or any database access to run an sql statement, try this statement:

DELETE FROM dbprefix_modules_menu
WHERE menuid = HOME_PAGE_ID
AND moduleid IN ( SELECT moduleid FROM (
                      SELECT mm.moduleid 
                      FROM dbprefix_modules_menu AS mm 
                      WHERE mm.menuid = BIO_PAGE_ID ) tempTable                     
                 )

Replace dbprefix with your real database prefix.

Replace HOME_PAGE_ID and BIO_PAGE_ID with their corresponding values from the ID column of the Menu Items manager, look at the attached screenshot.