SELECT ...
FROM ...
LEFT JOIN ...
...
WHERE ...
    AND ...
ORDER BY
    EXISTS(
        SELECT 1
        FROM season_products
        WHERE dr_id = :DR_ID
            AND pa_id = :PA_ID
    ) DESC
    , ...