Lines Matching refs:query

1894                     ->whereIn('change_id', function (Builder $query): void {
1895                         $query->select([new Expression('MAX(change_id)')])
1908                 $query = DB::table('individuals')
1918 …           $query->join('dates AS ' . $attr, static function (JoinClause $join) use ($attr): void {
1924                             $query->where($attr . '.d_fact', '=', $match[1]);
1929 …                           $query->where($attr . '.d_julianday2', '<=', $date->maximumJulianDay());
1931 …                           $query->where($attr . '.d_julianday1', '>=', $date->minimumJulianDay());
1937 …            $query->join('name AS ' . $attr, static function (JoinClause $join) use ($attr): void {
1945 …                  $query->where($attr . '.n_full', 'LIKE', '%' . addcslashes($name, '\\%_') . '%');
1954                             $query->where('i_gedcom', 'LIKE', $match[1]);
1960                             $query
1976                             $query->where('i_gedcom', 'LIKE', $like);
1981                             $query->where('i_gedcom', 'LIKE', $like);
1988                 foreach ($query->get() as $row) {
1994                 $query = DB::table('families')
2004 …           $query->join('dates AS ' . $attr, static function (JoinClause $join) use ($attr): void {
2010                             $query->where($attr . '.d_fact', '=', $match[1]);
2015 …                           $query->where($attr . '.d_julianday2', '<=', $date->maximumJulianDay());
2017 …                           $query->where($attr . '.d_julianday1', '>=', $date->minimumJulianDay());
2026                             $query->where('f_gedcom', 'LIKE', $match[1]);
2032 …            $query->join('name AS ' . $attr, static function (JoinClause $join) use ($attr): void {
2035                                         ->where(static function (Builder $query): void {
2036                                             $query
2045 …                  $query->where($attr . '.n_full', 'LIKE', '%' . addcslashes($name, '\\%_') . '%');
2054                             $query
2070                             $query->where('f_gedcom', 'LIKE', $like);
2075                             $query->where('f_gedcom', 'LIKE', $like);
2082                 foreach ($query->get() as $row) {