a.id, b.newsid, b.cate, b.title, b.photo, b.content FROM bengkulu_index_khusus a LEFT JOIN bengkulu_news b ON (a.id=b.id) WHERE (a.subcate = '22') AND status = '1' ORDER BY newsid DESC LIMIT 10;