SELECT * 
  FROM ( SELECT * 
  FROM prefix_redj_redirects 
  WHERE ( ( ('/horses/29-aa-aa' REGEXP BINARY fromurl)>0 
  AND (case_sensitive<>0) 
  AND (decode_url<>0) 
  AND (request_only<>0) ) OR ( ('/horses/29-aa-aa' REGEXP BINARY fromurl)>0 
  AND (case_sensitive<>0) 
  AND (decode_url=0) 
  AND (request_only<>0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP BINARY fromurl)>0 
  AND (case_sensitive<>0) 
  AND (decode_url<>0) 
  AND (request_only=0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP BINARY fromurl)>0 
  AND (case_sensitive<>0) 
  AND (decode_url=0) 
  AND (request_only=0) ) OR ( ('/horses/29-aa-aa' REGEXP fromurl)>0 
  AND (case_sensitive=0) 
  AND (decode_url<>0) 
  AND (request_only<>0) ) OR ( ('/horses/29-aa-aa' REGEXP fromurl)>0 
  AND (case_sensitive=0) 
  AND (decode_url=0) 
  AND (request_only<>0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP fromurl)>0 
  AND (case_sensitive=0) 
  AND (decode_url<>0) 
  AND (request_only=0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP fromurl)>0 
  AND (case_sensitive=0) 
  AND (decode_url=0) 
  AND (request_only=0) ) ) 
  AND published=1 
  ORDER BY ordering ) AS A 
  WHERE A.skip='' OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP BINARY A.skip)=0 
  AND (case_sensitive<>0) 
  AND (decode_url<>0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP BINARY A.skip)=0 
  AND (case_sensitive<>0) 
  AND (decode_url=0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP A.skip)=0 
  AND (case_sensitive=0) 
  AND (decode_url<>0) ) OR ( ('http://www.mysite.com/horses/29-aa-aa' REGEXP A.skip)=0 
  AND (case_sensitive=0) 
  AND (decode_url=0) )