$categories = Category::select(DB::raw('categories.*, count(*) as `aggregate`'))
->join('pictures', 'categories.id', '=', 'pictures.category_id')
->groupBy('category_id')
->orderBy('aggregate', 'desc')
->paginate(10);
SELECT * FROM table_1 WHERE enabled NOT IN (1,2,3,4)
SELECT * FROM table_1 WHERE enabled != 'x'