$yazar2 = mysql_query("SELECT authors.name,article.article_id,article.title,auth ors.image,authors.authors_id FROM authors LEFT JOIN article ON article.article_id IN(SELECT MAX(article_id) FROM article WHERE authors.authors_id = article.authors_id) WHERE authors.anasayfa=1 ORDER BY authors.sira"