How to optimize this query
2017-06-09 06:42:30
This query is very slow.I have tried to optimize this query but still its very slow