I have been searching for a while now, and can not figure the issue with this query,
SELECT articles.id AS aid, articles.author AS aauth FROM articles WHERE find_in_set(articles.category, '1,2,3') AND DATE_FORMAT(FROM_UNIXTIME(articles.date), '%Y-%m-%d') = '2015-06-10' ORDER BY articles.id DESC LIMIT 1
The query returns empty, the issue is with the date condition, because it works without it.