SilverStripe\UserForms\Task\RecoverUploadLocationsHelper::getQuery
Returns SQLQuery instance
select SubmittedFileField.UploadedFileID, EditableFileField_Versions.RecordID as FieldID, MAX(EditableFileField_Versions.Version) as FieldVersion from SubmittedFileField left join SubmittedFormField on SubmittedFormField.ID = SubmittedFileField.ID left join SubmittedForm on SubmittedForm.ID = SubmittedFormField.ParentID left join EditableFormField_Versions on EditableFormField_Versions.ParentID = SubmittedForm.ParentID and EditableFormField_Versions.Name = SubmittedFormField.Name and EditableFormField_Versions.LastEdited < SubmittedForm.Created inner join EditableFileField_Versions on EditableFileField_Versions.RecordID = EditableFormField_Versions.RecordID and EditableFileField_Versions.Version = EditableFormField_Versions.Version where SubmittedFileField.UploadedFileID != 0 group by SubmittedFileField.UploadedFileID, EditableFileField_Versions.RecordID order by SubmittedFileField.UploadedFileID limit 100
Signature
private function getQuery()