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 yn_comments WHERE status=1 GROUP BY source_id ORDER BY flag DESC) AS c LEFT JOIN yn_comments AS v ON v.id=c.flag LEFT JOIN yn_articles AS a ON a.id=c.source_id WHERE a.title!="" AND a.desc LIKE "http://" ORDER BY v.`date` DESC