Skip to content
This repository has been archived by the owner on Jul 1, 2024. It is now read-only.

Issue with cache #166

Open
vikiival opened this issue Mar 20, 2023 · 0 comments
Open

Issue with cache #166

vikiival opened this issue Mar 20, 2023 · 0 comments

Comments

@vikiival
Copy link
Member

invalid input syntax for type bigint: "" {"state_code":"22P02","statement":"SELECT\n      ce.id,\n      COALESCE(ce.name, '')              as name,\n      ce.meta_id                         as metadata,\n      me.image,\n      ce.issuer,\n      COUNT(distinct ne.meta_id)         as unique,\n      COUNT(distinct ne.current_owner)   as unique_collectors,\n      COUNT(distinct ne.current_owner)   as sold,\n      COUNT(ne.*)                        as total,\n      AVG(ne.price)                      as average_price,\n      MIN(NULLIF(ne.price, 0))           as floor_price,\n      COALESCE(MAX(e.meta :: bigint), 0) as highest_sale,\n      COALESCE(SUM(e.meta::bigint), 0)   as volume,\n      COUNT(e.*)                         as buys,\n      0                                  as emote_count\n  FROM collection_entity ce\n      LEFT JOIN metadata_entity me on ce.meta_id = me.id\n      LEFT JOIN nft_entity ne on ce.id = ne.collection_id\n      JOIN event e on ne.id = e.nft_id\n  WHERE e.interaction = 'BUY'\n  GROUP BY ce.id, me.image, ce.name\n  ORDER BY volume DESC\n
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant