GVA Needs as SQL requests
Blockchain
SELECT parameters FROM block WHERE number = 0 AND NOT fork
SELECT hash FROM i_index WHERE pub = '' ORDER BY writtenOn ASC
SELECT max(number) FROM block WHERE NOT fork
SELECT number, medianTime, time, joiners, actives, leavers, revoked, excluded, certifications FROM block WHERE NOT fork AND number >= ORDER BY number ASC
Sandbox
SELECT hash, pubkey, uid, buid, revocation_sig, expires_on FROM idty
SELECT fork FROM block WHERE hash = ''
SELECT idtyHash, membership, expires_on FROM membership INNER JOIN block ON membership.blockHash = block.hash WHERE NOT block.fork ORDER BY blockNumber ASC
SELECT [from], [to], target, expires_on FROM cert INNER JOIN block ON cert.block_hash = block.hash WHERE NOT block.fork