Sadržaj

/* $broj_dolazaka2 = DB::table('clan_dolazak as a')->select( 'a.clan_id as id', 'a.datum as datum', 'a.vrijeme as vrijeme', 'b.id as clan_id', 'b.clanski_broj as clan_clanski_broj', 'b.ime_prezime as ime_prezime', 'c.status_id as clanarina_status_id', 'c.datum_isteka as clanarina_datum_isteka' ) ->join('clan as b', 'b.id', '=', 'a.clan_id') ->join('clanarina as c', 'b.id', '=', 'c.clan_id') ->where('a.id', '>',0)->get(); / // broj_dolazaka 3 / $album = Albums::select( 'albums.*', DB::raw('(select photo from photos where albums_id = albums.id and status = 1 order by id asc limit 1) as photo') ) ->where('users_id',$user_id) ->where('albums.status',1)->get(); / /

                                        broj dolazaka 4
                                        DB::select(DB::raw("Select a.first_name, a.last_name, a.id as user_id, b.id, c.title, c.price, c.id from users as a INNER JOIN bookmarks as b on b.user_id = $user_id INNER JOIN Products as c on c.id = b.product_id where  user_id = c.user_id"));
                                 */

                                        /* broj dolazaka 5 */
                                        /* DB::table('products')
                                    ->whereIn('products.id',function($query) {
                                                            DB::table('product_category')
                                                            ->whereIn('category_id',['223','15'])
                                                            ->select('product_id');
                                                        })
                                    ->where('products.active',1)
                                    ->select('products.id','products.name','products.img','products.safe_name','products.sku','products.productstatusid')
                                    ->get(); */
                                
                                        /* broj dolazaka 6 */                                            
                                /*     Post::has('comments.votes')
                                    ->join('tafsir_ahbayan', function ($join) {
                                        $join->on('tafsir_ahbayan.surah_id', '=', 'quran.surah_id')
                                             ->orOn('tafsir_ahbayan.my_id', '=', 'quran.my_id');
                                    })->get(); */