You are viewing a single comment's thread from:
RE: [STEEMSQL.COM] A public SQL server database with all Steemit blockchain data
How did you populate the database to begin with? If you're using the RPC mechanism, after 30 days some data is no longer returned. For example, active_votes
is empty for all posts after their second payout. You can even see this on steemit.com where old posts have zero upvotes.
All votes are in transactions and stored in the TxVotes table, even first votes ever :