| public getRecentsByTagId ( $tag_id ) : Illuminate\Database\Eloquent\Model | ||
| Результат | Illuminate\Database\Eloquent\Model | |
public function getRecentsByTagId($tag_id)
{
return \DB::table('items')->join('users', 'items.user_id', '=', 'users.id')->join('tags', 'tags.id', '=', 'item_tag.tag_id')->join('item_tag', 'items.id', '=', 'item_tag.item_id')->where('tags.id', $tag_id)->where('published', '2')->select('users.email', 'users.username', 'items.open_item_id', 'items.updated_at', 'items.title')->orderBy('items.id', 'desc')->paginate(10);
}