ksenijakuc

<IfModule mod_rewrite.c>
    RewriteCond %{HTTP:Authorization} ^Basic.*
    RewriteRule (.*) 1c_exchange.php?authorization=%{HTTP:Authorization} [QSA,L]
</IfModule>

ksenijakuc

<php
// table authors: id, name
// table films: id, name, general(boolean), author_id

Authors::leftJoin('films as general_film', function ($q) {
    $q->on('authors.id', '=', 'general_film.author_id')
        ->on('general_film.id', '=',
            DB::raw('(select id from films WHERE author_id = authors.id ORDER BY general DESC LIMIT 1)'));
});