select * from NEWS_UPDATE a, (select b.aid,image from NEWS_UPDATE_IMAGE b, (SELECT aid, min(id) as imgid FROM `NEWS_UPDATE_IMAGE`GROUP BY aid) as c where c.imgid=b.id) D where a.id=D.aid AND status='Published' and branch_id like '%20,%' ORDER BY date desc, pid DESC LIMIT 0, 6
