ORDER BY and LIMIT can be attached to a subexpression if it is enclosed in parentheses.
The subexpression must entirely precede the back reference in the RE.
