search

kodadot / rubick

Implementation SubSquid indexer for Kusama NFTs
https://github.com/kodadot/rubick
9 stars 15 forks source link

syntax error at or near "M_SEEN" #270

Closed vikiival closed 1 year ago

vikiival commented 1 year ago 
ERROR syntax error at or near "M_SEEN"
  SELECT COUNT(DISTINCT current_owner) AS distribution,
       COUNT(current_owner) AS owner_count

  ,(SELECT max(CASE
                  WHEN current_owner = 'CuHWHNcBt3ASMVSJmcJyiBWGxxiWLyjYoYbGjfhL4ovoeSd' THEN 0
                  ELSE 1
              END)
   FROM nft_entity) AS adjustment

  FROM nft_entity
  WHERE collection_id = '0E76E3AC15B4C1FA1E-I'M_SEEN'