Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted by AlexandrKupris ( 13 years ago )
SELECT
"self"."id"
FROM
"travelrealty"."vw_tr_realty_with_price" AS "self"
ORDER BY
( self.price_rub / ( CASE WHEN substring( self.square from E'^(\\d+)' )::integer = 0 THEN 1 ELSE substring( self.square from E'^(\\d+)' )::integer END) > 300 AND self.price_rub / ( CASE WHEN substring( self.square from E'^(\\d+)' )::integer = 0 THEN 1 ELSE substring( self.square from E'^(\\d+)' )::integer END) IS NOT NULL) DESC,
"self"."price_rub" ASC
LIMIT 50
OFFSET 0
Revise this Paste
Children: 61431