The column 'id' is ambiguous, when preparing: SELECT [Modules\App\Models\HostingVillaItemModel].* FROM [Modules\App\Models\HostingVillaItemModel] WHERE villa_id IN (SELECT id FROM \Modules\App\Models\HostingVillaModel WHERE hosting_id = :hosting_id:) AND status = 1 AND price > 0 ORDER BY price ASC LIMIT :APL0: