select
*
FROM
algorand.transfers
WHERE
amount = 1 and
asset_id in (
select
asset_id
from algorand.asset
where ASSET_NAME like '%Rapid chess game%'
and ASSET_DELETED= false
and total_supply = 1
and creator_address= 'PAPA23PAWOROGLHBAL3DNHEFI76JNIET4N32OOJLJGQRKR4PMD4EE5M7PQ'
order by asset_name
)
order by block_timestamp