Database driver error

Hello, make a request to the database:

PHP Code:

// $this->db->last_query()
SELECT COUNT(*) AS `numrows`
FROM `lids`
WHERE   (
`lids`.`date_inspection` >= '2018-07-08 00:00:00'
AND `lids`.`date_inspection` <= '2018-08-08 23:59:59'
 ) 


Show results: 0
   

When performing the same query directly in the database get:
Show results: 1558