FROM dataorder
ORDER BY 
    CASE 
        WHEN status = 'complete' THEN 2
        ELSE 1
    END,
    CASE 
        WHEN status = 'pending' THEN eta
        WHEN status = 'complete' THEN eta
        ELSE eta
    END;