2 JOIN nodes ON nodes.id = node_data.node_id
\r
3 SET external = JSON_REMOVE(external, JSON_UNQUOTE(JSON_SEARCH(external, 'one', 'hpm-api', NULL, '$.export_portals')))
\r
5 JSON_CONTAINS(external, '["hpm-api"]', '$.export_portals')
\r
6 AND nodes.available_for_rent = 1;
\r
9 JOIN nodes ON nodes.id = node_data.node_id
\r
10 SET external = JSON_REMOVE(external, '$.export_portals')
\r
12 external->'$.export_portals' = JSON_ARRAY()
\r
13 AND nodes.available_for_rent = 1;
\r
16 JOIN nodes ON nodes.id = node_data.node_id
\r
19 external = JSON_OBJECT()
\r
20 AND nodes.available_for_rent = 1;
\r