DB was unable to successfully run a query.
Unknown column 'v.date' in 'field list'

SELECT c.*,a.*,v.id,v.source_id,v.`date`,v.`name`,v.country FROM (SELECT *,MAX(id) AS flag,COUNT(*) AS cCount FROM ac_comments WHERE status=1 GROUP BY source_id ORDER BY flag DESC) AS c LEFT JOIN ac_comments AS v ON v.id=c.flag LEFT JOIN ac_articles AS a ON a.id=c.source_id WHERE a.title!="" ORDER BY v.`date` DESC