github.com/status-im/status-go@v1.1.0/services/wallet/activity/get_collectibles.sql (about)

     1  -- Query for getting collectibles from transfers
     2  -- It can be filtered by owner addresses and networks
     3  WITH filter_conditions AS (
     4  		SELECT 
     5  			? AS filterAllAddresses,
     6  			? AS includeAllNetworks
     7  	),
     8  	owner_addresses(address) AS (
     9  		VALUES 
    10  			%s
    11  	),
    12  	filter_networks(network_id) AS (
    13  		VALUES
    14  			%s
    15  	)
    16  SELECT network_id, token_address, token_id 
    17  FROM 
    18  	transfers, filter_conditions
    19  WHERE 
    20  token_id IS NOT NULL
    21  AND token_address IS NOT NULL 
    22  AND (
    23  	filterAllAddresses 
    24  	OR tx_from_address IN owner_addresses 
    25  	OR tx_to_address IN owner_addresses
    26  ) 
    27  AND (
    28  	includeAllNetworks 
    29  	OR network_id IN filter_networks
    30  )
    31  GROUP BY
    32  	token_id, token_address
    33  LIMIT ? OFFSET ?