FuelPHP Forums

how can i build this query with DB :
select a.title, a.lead, a.date, a.uri, c.name, (select image from articles_images where article_id = a.id limit 0,1)
from articles as a inner join articles_category as c on c.id = a.category_id
where a.confirm_by > 0
limit 10
(
$articles_query = \DB::select(array('a.id', 'id'), array('a.title', 'title'), array('a.lead', 'lead'), array('a.date', 'date'), array('a.uri', 'uri'), array('c.name', 'category'), Model_Article_Images::query()->select('image')->where('article_id', 'a.id')->limit(1)->get_query(false))
                ->from(array(Model_Article::table(), 'a'))
                ->join(array(Model_Category::table(), 'c'), 'INNER')
                ->on('c.id', '=', 'a.category_id')
                ->where('a.confirm_by', '>', 0)
                ->limit(10)
                ->offset(0)
                ->execute();
) not work