SELECT ...
FROM ...
LEFT JOIN ...
...
WHERE ...
    AND ...
ORDER BY
    EXISTS(
        SELECT 1
        FROM season_products sp
        LEFT JOIN season_dok_razdel sdr ON sdr.season_id = sp.season_id
        WHERE sdr.dr_id = :DR_ID
            AND sp.pa_id = :PA_ID
            AND sdr.start_date <= NOW()
            AND NOW() <= sdr.finish_date
    ) DESC
    , ...