01.
$articles
=Article:: join(
'article_descriptions'
,
'article_descriptions.article_id'
,
'='
,
'articles.id'
)
02.
->where(
'article_descriptions.language'
,Session::get(
'language'
))
03.
->where(
'article_descriptions.name'
,
'like'
,
'%'
.
$request
->keyword.
'%'
)
04.
->where(
'articles.status'
,
'on'
)
05.
->orderBy(
'articles.id'
,
'desc'
)
06.
->where(
'articles.id'
,
'<'
,
$request
->id)
07.
->select(
'articles.*'
)
08.
->limit(5)
09.
->get();