app/Http/Controllers/Admin/ImportThumbnailsController.php
private function findMediaObjectsForMediaFile(string $file): array
    {
        return DB::table('media')
            ->join('media_file', static function (JoinClause $join): void {
                $join
                    ->on('media_file.m_file', '=', 'media.m_file')
                    ->on('media_file.m_id', '=', 'media.m_id');
            })
            ->join('gedcom_setting', 'media.m_file', '=', 'gedcom_setting.gedcom_id')
            ->where(DB::raw('setting_value || multimedia_file_refn'), '=', $file)
            ->select(['media.*'])
            ->distinct()
            ->get()
            ->map(Media::rowMapper())
            ->all();
    }
private function findMediaObjectsForMediaFile(string $file): array
    {
        return DB::table('media')
            ->join('media_file', static function (JoinClause $join): void {
                $join
                    ->on('media_file.m_file', '=', 'media.m_file')
                    ->on('media_file.m_id', '=', 'media.m_id');
            })
            ->join('gedcom_setting', 'media.m_file', '=', 'gedcom_setting.gedcom_id')
            ->where(DB::raw('setting_value || multimedia_file_refn'), '=', $file)
            ->select(['media.*'])
            ->distinct()
            ->get()
            ->map(Media::rowMapper())
            ->all();
    }
private function findMediaObjectsForMediaFile ( string $ file ) : array { return DB :: table ( 'media' ) -> join ( 'media_file' , static function ( JoinClause $ join ) : void { $ join -> on ( 'media_file.m_file' , '=' , 'media.m_file' ) -> on ( 'media_file.m_id' , '=' , 'media.m_id' ) ; } ) -> join ( 'gedcom_setting' , 'media.m_file' , '=' , 'gedcom_setting.gedcom_id' ) -> where ( DB :: raw ( 'setting_value || multimedia_file_refn' ) , '=' , $ file ) -> select ( [ 'media.*' ] ) -> distinct ( ) -> get ( ) -> map ( Media :: rowMapper ( ) ) -> all ( ) ; }
Find the media object that uses a particular media file.

@param string $file

@return Media[]
Find the media object that uses a particular media file .