The difference between crdate and tstamp in TYPO3 database tables is crdate = when was the data record createdtstamp = when was it last edited
This command will disable all restrictions and force the queryBuilder to return all items including the deleted ones. A nice example would be the recycler, where you can restore deleted items.
Ignore the PID settings by setting setRespectStoragePage to false.
Query object Standard-Repository-Methods „Matching“-Methods for constraints Query-Settings Force the repository to do the database stuff From: http://lbrmedia.net/codebase/Eintrag/extbase-query-methods/