Query editor
SELECTp.call_tx_hash AS tx_hash,p.chain AS blockchain,p.referralCode,call_success,p.route,'rp11' AS rp_versionFROM sushiswap_multichain.routeprocessor11_call_processroute AS pWHERE p.chain = '{{blockchain}}'AND p.call_block_time >= date_add('hour', -CAST('{{hours}}' AS integer), current_timestamp)AND (CAST('{{referrer}}' AS integer) < 0 OR p.referralCode = CAST('{{referrer}}' AS integer))UNION ALLSELECTp.call_tx_hash AS tx_hash,p.chain AS blockchain,p.referralCode,call_success,p.route,'rp11' AS rp_versionFROM sushiswap_multichain.routeprocessor11_call_processroutewithtransfervalueinput AS pWHERE p.chain = '{{blockchain}}'AND p.call_block_time >= date_add('hour', -CAST('{{hours}}' AS integer), current_timestamp)AND (CAST('{{referrer}}' AS integer) < 0 OR p.referralCode = CAST('{{referrer}}' AS integer))UNION ALLSELECTp.call_tx_hash AS tx_hash,p.chain AS blockchain,p.referralCode,call_success,p.route,'rp11' AS rp_versionFROM sushiswap_multichain.routeprocessor11_call_processroutewithtransfervalueoutput AS pWHERE p.chain = '{{blockchain}}'AND p.call_block_time >= date_add('hour', -CAST('{{hours}}' AS integer), current_timestamp)AND (CAST('{{referrer}}' AS integer) < 0 OR p.referralCode = CAST('{{referrer}}' AS integer))UNION ALLSELECTp.call_tx_hash AS tx_hash,p.chain AS blockchain,p.referralCode,call_success,p.route,'rp12' AS rp_versionFROM sushiswap_multichain.routeprocessor12_call_processroute AS pWHERE p.chain = '{{blockchain}}'AND p.call_block_time >= date_add('hour', -CAST('{{hours}}' AS integer), current_timestamp)AND (CAST('{{referrer}}' AS integer) < 0 OR p.referralCode = CAST('{{referrer}}' AS integer))AND p.contract_address = 0xB36599414542F6630d411485d968f25592cA9091 -- RP12 prod (table also holds pre-release 0x2e98...)UNION ALLSELECTp.call_tx_hash AS tx_hash,p.chain AS blockchain,