TYPO3 Core

In the "DB Check" => "Full Search" when you check "Show even deleted entries (with undelete buttons)" (eg: for table witch haven't this field declared) the "deleted" statement is still present in the query :
Select ui,pid,deleted FROM table WHERE (....) LIMIT 100.

With this correction it disapear and the query work.

in class.t3lib_querygenerator.php at line 1485 (in version 4.1.7) :
$fieldlist = $this->extFieldLists['queryFields'].',pid,deleted';

replaced by :
$fieldlist = $this->extFieldLists['queryFields'].',pid';

Add line at line 1488 in if mod_setting show_deleted:
$fieldlist.= ',deleted';

(issue imported from #M9495)