Code:
SELECT a.id,
		a.news_title,
		a.published_date ,
		b.thumb_name
FROM news a
LEFT OUTER
JOIN news_image b
ON b.id = a.id
WHERE news_type= 1 AND region = 2 
ORDER BY a.id 
DESC LIMIT 4
this is my current query. I want to limit the number of row of thumb_name to 1 and it has to be ACS. How can i put it ?