need help Searching DB for loot.....

[GeorgeS]

Actually it is better to start by running this query

select * from items  where source <>  '13THFLOOR' order by created desc

That will sort the items by creation date descending order and those originally made by PEQ.
..then you run subqueries by filtering stuff out


My tools create a "CUSTOM" tag, so running this will pull out those items made with my editor by creation date

select * from items  where source =  'CUSTOM' order by created desc

GeorgeS

[tbrownmn]

i tried the created column....most of the items on the server are junk loot that's been overwritten...and that column was not updated.