Query editor
WITH tx AS(SELECTto,valueFROM erc20_linea.evt_transferWHERE contract_address = 0xd83af4fbd77f3ab65c3b1dc4b38d7e67aecf599a),lxp_raw AS (SELECTto AS wallet,SUM(value)/1000000000000000000 AS lxpFROMtxGROUP BYtoHAVINGSUM(value) > 0),lxp_sybil AS (SELECTWallet as walletFROMdune.patriciaga.dataset_linea_no_poh),lam_tx AS(SELECTto,valueFROM erc20_linea.evt_transferWHERE contract_address = 0xe158cacce6f5713f5739a7d7af0db60116187687),lam_raw AS (SELECTto AS wallet,SUM(value) AS lamFROMlam_txGROUP BYtoHAVINGSUM(value) > 0),lxpl_tx AS(SELECTto,valueFROM erc20_linea.evt_transferWHERE contract_address = 0xBC8f4663470229Fd4CA3686A24792d93Dd800216),lxpl_raw AS (SELECTto AS wallet,SUM(value) / 1e18 AS lxplFROMlxpl_txGROUP BYtoHAVINGSUM(value) > 0),linea_lxp_allocate AS(SELECTlxp_raw.wallet,