use ForestAdmin\LaravelForestAdmin\Services\Concerns\ForestCollection;
use ForestAdmin\LaravelForestAdmin\Services\SmartFeatures\SmartSegment;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Product extends Model
public function bestSellers(): SmartSegment
return $this->smartSegment(
fn(Builder $query) => $query->whereIn('products.id', function($q) {
$q->select('products.id')
->join('order_product', 'order_product.product_id', '=', 'products.id')
->orderByRaw('COUNT(order_product.order_id) DESC')