app/Services/SearchService.php

45 use Illuminate\Database\Query\JoinClause;  alias
116             ->leftJoin('name AS husb_name', static function (JoinClause $join): void {
122             ->leftJoin('name AS wife_name', static function (JoinClause $join): void {
151             ->join('placelinks', static function (JoinClause $query) {
199             ->join('name', static function (JoinClause $join): void {
221             ->join('placelinks', static function (JoinClause $join) {
558             $query->join('link AS l1', static function (JoinClause $join): void {
566                 $query->join('link AS l2', static function (JoinClause $join): void {
572                 $query->join('name AS father_name', static function (JoinClause $join): void {
580                 $query->join('link AS l3', static function (JoinClause $join): void {
586                 $query->join('name AS mother_name', static function (JoinClause $join): void {
595             $query->join('link AS l4', static function (JoinClause $join): void {
601             $query->join('families AS spouse_families', static function (JoinClause $join): void {
609             $query->join('name AS individual_name', static function (JoinClause $join): void {
617 …$query->join('dates AS date_' . $indi_date, static function (JoinClause $join) use ($indi_date): v…
625 …$query->join('dates AS date_' . $fam_date, static function (JoinClause $join) use ($fam_date): voi…
633 …     $query->join('placelinks AS individual_placelinks', static function (JoinClause $join): void {
638             $query->join('places AS individual_places', static function (JoinClause $join): void {
646 …         $query->join('placelinks AS family_placelinks', static function (JoinClause $join): void {
651             $query->join('places AS family_places', static function (JoinClause $join): void {
990             $query->join('placelinks', static function (JoinClause $join): void {
995             $query->join('places', static function (JoinClause $join): void {
1005             $query->join('name', static function (JoinClause $join): void {
1119             ->join('media_file', static function (JoinClause $join): void {