2 JOIN nodes ON nodes.id = node_data.node_id
\r
5 node_data.external IS NULL
\r
6 AND nodes.available_for_rent = 1;
\r
9 JOIN nodes ON nodes.id = node_data.node_id
\r
10 SET external = JSON_SET(external, '$.export_portals', JSON_ARRAY())
\r
12 NOT JSON_CONTAINS_PATH(external, 'all', '$.export_portals')
\r
13 AND nodes.available_for_rent = 1;
\r
16 JOIN nodes ON nodes.id = node_data.node_id
\r
17 SET external = JSON_ARRAY_APPEND(external, '$.export_portals', 'hpm-api')
\r
19 NOT JSON_CONTAINS(external, '["hpm-api"]', '$.export_portals')
\r
20 AND nodes.available_for_rent = 1;
\r