Missing transaction for receipt FEkaV4fxRTCKNBswDVRacHAXLukAB6wq1r9cRey3jugd

[eduohe]

An user mentioned that a transaction coudn't be found in the BQ dataset:
SELECT
*
FROM
bigquery-public-data.crypto_near_mainnet_us.receipt_actions ra
WHERE
ra.block_date = '2022-01-19'
and ra.receipt_id = 'FEkaV4fxRTCKNBswDVRacHAXLukAB6wq1r9cRey3jugd'

https://nearblocks.io/txns/9ioLz3jJavEiiYVVVX2pDrPPQWXSL4zoH8o8uXzMTSSB#

Cause:

Skipped Blocks - NEAR Blockchain can contain skipped blocks, e.g. block 57730443. For these cases we can find the block for the chunk data using the prev_block_hash column, e.g. SELECT * FROM chunks c JOIN blocks b ON c.chunk.header.prev_block_hash = b.header.prev_hash.

[eduohe]

near/docs#1907

[eduohe]

More info: https://near.zulipchat.com/#narrow/stream/295558-core/topic/Skip.20block.20logic.20question