I'd like to delete our custom System Saved query "Open + Subscribed" on https://phabricator.wikimedia.org/maniphest/query/edit/ because it duplicates the default built-in "Subscribed" query (T392332 made me realize).
However, that would also break a bunch of Dashboard query Panels which display the results of this query I want to delete:
SELECT CONCAT("W",dp.id) AS id, dp.name, dp.properties, u.userName AS author FROM phabricator_dashboard.dashboard_panel dp INNER JOIN phabricator_user.user u ON dp.authorPHID = u.phid WHERE dp.panelType = "query" AND dp.properties LIKE "%\"key\":\"gd6mG.hk3..e\"%" LIMIT 100;And some of those panels are embedded in Dashboards:
SELECT CONCAT("https://phabricator.wikimedia.org/dashboard/view/", d.id) AS dashboardId, CONCAT("https://phabricator.wikimedia.org/W", dp.id) AS panelId, dp.name AS panelName, dp.properties AS panelProperties, u.userName AS panelAuthor FROM phabricator_dashboard.edge e INNER JOIN phabricator_dashboard.dashboard d ON d.phid = e.src INNER JOIN phabricator_dashboard.dashboard_panel dp ON dp.phid = e.dst INNER JOIN phabricator_user.user u ON dp.authorPHID = u.phid WHERE e.dst IN (SELECT phid FROM phabricator_dashboard.dashboard_panel WHERE panelType = "query" AND properties LIKE "%\"key\":\"gd6mG.hk3..e\"%");Sigh, software.