[wp-hackers] phpmyadmin post count vs wordpress dashboard's own post count

[Brian Layman]

It's probably the sample Page that came in with the initial WordPress 
install.

You need to include `post_type`='post' if you are just looking at posts. 
Then after that you'll need to do things like filter out     
`post_status`='inherit'.

The days are gone when you can expect a 1 to 1 relationship between any 
part of the UI and a WP table.  There's always something more to 
consider. But if you spend some time looking at each of the columns, 
you'll be able to understand what's going on.  everything except for the 
terms structure is pretty straight forward.

Brian Layman

On 6/22/2012 1:37 PM, Mika A Epstein wrote:
> Post revisions? Drafts? CPTs?
>
> ----
> Mika A Epstein (aka Ipstenu)
> http://ipstenu.org | http://halfelf.org
>
> On 22 Jun 2012, at 12:35:59PM, Haluk Karamete wrote:
>
>> php myadmin view:
>> Showing rows 0 - 29 (10,223 total, Query took 0.0022 sec) SQL query:
>> SELECT * FROM wp_posts LIMIT 0 , 30
>>
>> vs
>> wordpress dashboard view:
>> All (10,222) | Published (10,222) Search Posts: 10,222 items « ‹ of 512 › »
>>
>> Why is there a disconnect? Does anyone know why phpmyadmin reports
>> 10223 on an unconditional SQL query while admin dashboard reports one
>> less?
>> _______________________________________________
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
>> http://lists.automattic.com/mailman/listinfo/wp-hackers
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers