Query editor
WITH nosana AS (SELECT DISTINCT wallet_address as addressFROM query_4448997),ore AS (SELECT DISTINCT wallet_address as addressFROM query_4449016),ionet AS (SELECT DISTINCT node_owner_address as addressFROM query_4449045),render AS (SELECT DISTINCT node_operator_address as addressFROM query_4449078)SELECTCOALESCE(n.address, o.address, i.address, r.address) as wallet_address,CONCAT('<a href="https://solscan.io/account/', COALESCE(n.address, o.address, i.address, r.address), '">', COALESCE(n.address, o.address, i.address, r.address), '</a>') AS wallet_link,CASE WHEN n.address IS NOT NULL THEN true ELSE false END as is_nosana,CASE WHEN o.address IS NOT NULL THEN true ELSE false END as is_ore,CASE WHEN i.address IS NOT NULL THEN true ELSE false END as is_ionet,CASE WHEN r.address IS NOT NULL THEN true ELSE false END as is_render,(CASE WHEN n.address IS NOT NULL THEN 1 ELSE 0 END +CASE WHEN o.address IS NOT NULL THEN 1 ELSE 0 END +CASE WHEN i.address IS NOT NULL THEN 1 ELSE 0 END +CASE WHEN r.address IS NOT NULL THEN 1 ELSE 0 END) as num_projectsFROM nosana nFULL OUTER JOIN ore o ON n.address = o.addressFULL OUTER JOIN ionet i ON COALESCE(n.address, o.address) = i.addressFULL OUTER JOIN render r ON COALESCE(n.address, o.address, i.address) = r.addressORDER BY num_projects DESC, wallet_address