DB was unable to successfully run a query.<br/><div style="display:none">Unknown column 'v.date' in 'field list'<p>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</p></div>