app/Services/SearchService.php

118                     ->on('husb_name.n_file', '=', 'families.f_file')
119                     ->on('husb_name.n_id', '=', 'families.f_husb')
124                     ->on('wife_name.n_file', '=', 'families.f_file')
125                     ->on('wife_name.n_id', '=', 'families.f_wife')
153                     ->on('families.f_file', '=', 'placelinks.pl_file')
154                     ->on('families.f_id', '=', 'placelinks.pl_gid');
201                     ->on('name.n_file', '=', 'individuals.i_file')
202                     ->on('name.n_id', '=', 'individuals.i_id');
223                     ->on('i_file', '=', 'pl_file')
224                     ->on('i_id', '=', 'pl_gid');
560                     ->on('l1.l_file', '=', 'individuals.i_file')
561                     ->on('l1.l_from', '=', 'individuals.i_id')
568                         ->on('l2.l_file', '=', 'l1.l_file')
569                         ->on('l2.l_from', '=', 'l1.l_to')
574                         ->on('father_name.n_file', '=', 'l2.l_file')
575                         ->on('father_name.n_id', '=', 'l2.l_to');
582                         ->on('l3.l_file', '=', 'l1.l_file')
583                         ->on('l3.l_from', '=', 'l1.l_to')
588                         ->on('mother_name.n_file', '=', 'l3.l_file')
589                         ->on('mother_name.n_id', '=', 'l3.l_to');
597                     ->on('l4.l_file', '=', 'individuals.i_file')
598                     ->on('l4.l_from', '=', 'individuals.i_id')
603                     ->on('spouse_families.f_file', '=', 'l4.l_file')
604                     ->on('spouse_families.f_id', '=', 'l4.l_to');
611                     ->on('individual_name.n_file', '=', 'individuals.i_file')
612                     ->on('individual_name.n_id', '=', 'individuals.i_id');
619                     ->on('date_' . $indi_date . '.d_file', '=', 'individuals.i_file')
620                     ->on('date_' . $indi_date . '.d_gid', '=', 'individuals.i_id');
627                     ->on('date_' . $fam_date . '.d_file', '=', 'spouse_families.f_file')
628                     ->on('date_' . $fam_date . '.d_gid', '=', 'spouse_families.f_id');
635                     ->on('individual_placelinks.pl_file', '=', 'individuals.i_file')
636                     ->on('individual_placelinks.pl_gid', '=', 'individuals.i_id');
640                     ->on('individual_places.p_file', '=', 'individual_placelinks.pl_file')
641                     ->on('individual_places.p_id', '=', 'individual_placelinks.pl_p_id');
648                     ->on('family_placelinks.pl_file', '=', 'spouse_families.f_file')
649                     ->on('family_placelinks.pl_gid', '=', 'spouse_families.f_id');
653                     ->on('family_places.p_file', '=', 'family_placelinks.pl_file')
654                     ->on('family_places.p_id', '=', 'family_placelinks.pl_p_id');
992                     ->on('placelinks.pl_file', '=', 'individuals.i_file')
993                     ->on('placelinks.pl_gid', '=', 'individuals.i_id');
997                     ->on('places.p_file', '=', 'placelinks.pl_file')
998                     ->on('places.p_id', '=', 'placelinks.pl_p_id');
1007                     ->on('name.n_file', '=', 'individuals.i_file')
1008                     ->on('name.n_id', '=', 'individuals.i_id');
1121                     ->on('media_file.m_file', '=', 'media.m_file')
1122                     ->on('media_file.m_id', '=', 'media.m_id');