SELECT SQL_CALC_FOUND_ROWS SQL_NO_CACHE I.*, S.Description AS StatusDescription, J.IdOwner
FROM users
STRAIGHT_JOIN rights R USE INDEX (IdUsers) ON R.IdUsers = U.id
STRAIGHT_JOIN owners O ON R.IdOwners = O.Id AND U.ClientId = O.IdClients
STRAIGHT_JOIN jobs J USE INDEX (IdOwner) ON O.Id = J.IdOwner
STRAIGHT_JOIN items I USE INDEX (IdJobs) ON J.Id = I.IdJobs
INNER JOIN sendingtypes St ON St.Id = I.IdSendingTypes
INNER JOIN status S ON S.Id = I.IdStatus
WHERE U.id = 1
AND I.FirstEndUserViewTime IS NULL OR I.FirstEndUserViewTime = O
AND I.CreationDate >= 2018-2-19
ORDER BY I.Date DESC, I.CreationDate DESC, I.Id DESC
LIMIT 10 OFFSET 0