Here is the breakdown of the posts table in the database that Fappy linked to:
Here is the sql I used to pull it with:
select post_status, post_type,
case
when post_type='attachment' and guid like '%.mp4' then 'video-mp4'
when post_type='attachment' and (guid like '%.jpg' or guid like '%jpeg') then 'image-jpg'
when post_type='attachment' and guid like '%.gif' then 'image-gif'
when post_type='attachment' and guid like '%.png' then 'image-png'
else ' '
end as attachment_type,
count(*) as reccnt
from edited_out_posts group by post_status, post_type, attachment_type
So, unless I missed something there are 46 published posts in the table, 4 videos and 277 image attachments in there.
Is there another table I should be looking at?
So, there is a disparity between what was expected and what was received. I am not implying that anyone did anything sneaky or that anyone purposely did anything wrong. But there definitely looks to be a disparity. Unless I am missing something here.
.