Why does my stackexchange post not produce all rows?

All we need is an easy explanation of the problem, so here it is.

Here is my code that I use over here – https://data.stackexchange.com/stackoverflow/query/edit/1603630

SELECT title,concat('https://stackoverflow.com/questions/',id), tags, score, 
creationDate From Posts
where (tags like '%<pymc3>%')

This tag has 697 questions (https://stackoverflow.com/questions/tagged/pymc3) but I only get 693 rows.

Please let me know if any more information needs to be included. I have absolutely no background in writing queries and got the above code from a colleague.

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

From the help FAQ:

How often is the Stack Exchange Data Explorer updated?

The data is updated early every Sunday morning around 3:00 UTC. The last update was Jun 5 at 11:58.

You’re seeing a view of the database as it was on 5 June 2022.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply