Quering date from date and time field
From DDL:

`date_created` varchar(250) COLLATE utf8_unicode_ci DEFAULT '',


First question - why? Why not DATETIME?

From query:

AND date_created = '2018-08-23'


Second question - are you sure there are records containing '2018-08-23' value in this field DIRECTLY? without timepart?



Recommendations:


Alter datatype of the field to DATETIME and use proper condition for this datatype.

AND date_created BETWEEN '2018-08-23 00:00:00' AND  '2018-08-23 23:59:59'

If not, replace the condition with 

AND date_created LIKE '2018-08-23%'