Query editor
WITH ns_create AS (SELECTtx_id,block_time,data,account_argumentsFROM solana.instruction_callsWHERE executing_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX' -- Name Service programAND tx_success = TRUE-- discriminator 0 = NameRegistryCreateAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 0),registered_sol AS (SELECTtx_id,block_time,element_at(account_arguments, 3) AS name_account, -- created name accountelement_at(account_arguments, 6) AS parent_account -- parent (root for forward .sol)FROM ns_create)SELECTCOUNT(DISTINCT name_account) AS total_registered_sol_domainsFROM registered_solWHERE parent_account = '58PwtjSDuFHuUkYjH9BYnnQKHfwo9reZhC2zMJv9JPkx';