Where does sitecore store product statistics data in a database ..?

Question

I just want to know where sitecore stores statistics data. Using an SQL query, I want to get recently updated items. I write a query for the Sitecore_Master database in the Items table, there I also found the created, updated fields, while these columns contain different values ​​with the statistics values ​​for the sitecore position my sql query:

select name,created,updated from items where id='{EFDC1A0B-C40D-42B9-880B-0A09D4686E60}' 

It works for me, while I need statistics data.

Does anyone have an idea which sitecore table is used to store statistics for the sitecore element.

thanks

Answer 1

Sitecore stores Created and Updated values ​​for each specific version of the item. Therefore, it is stored in the VersionedFields table.

You can use this query to update items after 2015-10-27 :

 SELECT vf.Value AS Updated, item.ID AS ItemId, item.Name AS ItemName FROM VersionedFields vf JOIN Items item ON item.ID = vf.ItemId WHERE vf.FieldId = 'D9CF14B1-FA16-4BA6-9288-E8A174D4D522' -- id of the __updated field -- vf.FieldId = '25BED78C-4957-4165-998A-CA1B52F67497' -- id of the __created field AND vf.Value > '20151027' 

Please keep in mind that Sitecore stores dates in UTC in a table.