Lines Matching refs:DB

22 use Fisharebest\Webtrees\DB;  alias
65         $subquery1 = DB::table('individuals')
68             ->union(DB::table('families')
71             ->union(DB::table('sources')
74             ->union(DB::table('media')
77             ->union(DB::table('other')
82         $subquery2 = DB::table('change')
85             ->union(DB::table('individuals')
88             ->union(DB::table('families')
91             ->union(DB::table('sources')
94             ->union(DB::table('media')
97             ->union(DB::table('other')
102         return DB::table(new Expression('(' . $subquery1->toSql() . ') AS sub1'))
119         $sources = DB::table('sources')
123             ->select([new Expression(DB::groupConcat('s_id') . ' AS xrefs')])
137         $individuals = DB::table('dates')
147             ->select([new Expression(DB::groupConcat('d_gid') . ' AS xrefs')])
155         $families = DB::table('families')
160             ->select([new Expression(DB::groupConcat('f_id') . ' AS xrefs')])
166         $media = DB::table('media_file')
171             ->select([new Expression(DB::groupConcat('m_id') . ' AS xrefs')])
195         $subquery1 = DB::table('individuals')
198             ->union(DB::table('families')
201             ->union(DB::table('sources')
204             ->union(DB::table('media')
207             ->union(DB::table('other')
212         $subquery2 = DB::table('change')
215             ->union(DB::table('individuals')
218             ->union(DB::table('families')
221             ->union(DB::table('sources')
224             ->union(DB::table('media')
227             ->union(DB::table('other')
232         return DB::query()