Lines Matching refs:DB

23 use Fisharebest\Webtrees\DB;  alias
83         $row = DB::table('families')
150         return DB::table('families')
226         return DB::table('families')
251         $families = DB::table('families')
306         return DB::table('link AS link1')
330 …k1.l_to AS ch1', 'link2.l_to AS ch2', new Expression(DB::prefix('child2.d_julianday2') . ' - ' . D…
559         $query = DB::table('families')
597         $total = (int) DB::table('families')
611         $average = (float) DB::table('families')
627         return DB::table('families')
701         $first_child_subquery = DB::table('link')
714         $query = DB::table('link')
764         $n = DB::table('families')
780         $n = DB::table('families')
811         $row = DB::table('link AS parentfamily')
833 …          ->where('childbirth.d_julianday2', '>', new Expression(DB::prefix('birth.d_julianday1')))
834 …>select(['parentfamily.l_to AS id', new Expression(DB::prefix('childbirth.d_julianday2') . ' - ' .…
1014         $hrows = DB::table('families')
1031 …->select(['f_id AS family', new Expression('MIN(' . DB::prefix('husbdeath.d_julianday2') . ' - ' .…
1035         $wrows = DB::table('families')
1052 …->select(['f_id AS family', new Expression('MIN(' . DB::prefix('wifedeath.d_julianday2') . ' - ' .…
1056         $drows = DB::table('families')
1073 …->select(['f_id AS family', new Expression('MIN(' . DB::prefix('divorced.d_julianday2') . ' - ' . …
1265         $query = DB::table('families')
1285 …->orderBy(new Expression('MIN(' . DB::prefix('wife.d_julianday1') . ') - MIN(' . DB::prefix('husb.…
1289 …->orderBy(new Expression('MIN(' . DB::prefix('husb.d_julianday1') . ') - MIN(' . DB::prefix('wife.…
1392         $query = DB::table('dates AS married')
1410 …->select(['f_id', 'birth.d_gid', new Expression(DB::prefix('married.d_julianday2') . ' - ' . DB::p…
1459         $row = DB::table('families')
1480             ->where('married.d_julianday2', '>', new Expression(DB::prefix('birth.d_julianday1')))
1481 …->orderBy(new Expression(DB::prefix('married.d_julianday2') . ' - ' . DB::prefix('birth.d_julianda…
1482 …>select(['f_id AS famid', $sex_field, new Expression(DB::prefix('married.d_julianday2') . ' - ' . …
1661         $query = DB::table('dates')
1684         $query = DB::table('families')