public function Autocomplit2() { $products = Product::leftjoin('variants', 'products.id', '=', 'variants.product_id')->leftjoin("detAtr", "variants.id", "=", "detAtr.variant_id")->leftjoin('brands', 'products.brand_id', '=', 'brands.id')->leftjoin('types', 'products.type_id', '=', 'types.id')->leftjoin('materials', 'materials.id', '=', 'products.material_id')->select(\DB::raw('products.id as proId,brands.nombre as BraName,types.nombre as TName,products.codigo as proCodigo,products.nombre as proNombre,products.modelo as modelo, variants.id as varid,variants.sku as varcode,variants.suppPri as varPrice,variants.price as precioProducto, products.hasVariants as TieneVariante,products.created_at as proCreado,brands.id as BraID,materials.id as MId ,materials.nombre as Mnombre,variants.codigo as varCodigo,detAtr.descripcion as descripcion,products.quantVar as proQuantvar,(SELECT GROUP_CONCAT(CONCAT(atributes.shortname,":",detAtr.descripcion) SEPARATOR "/") FROM variants INNER JOIN detAtr ON detAtr.variant_id = variants.id INNER JOIN atributes ON atributes.id = detAtr.atribute_id where variants.id=varid GROUP BY variants.id) as NombreAtributos'))->groupBy('variants.id')->paginate(); return $products; }