Ошибка базы данных при выполнении запроса: SELECT e.rent_id, e.input_phone, date_trunc('second', e.rent_date) AS rent_date, date_trunc('second', e.rent_userdate) AS rent_userdate, e.rent_catalogname, e.with_background, e.rent_name, e.rent_clientname, e.rent_description, e.rent_clientanother, e.rent_year, e.rent_price, e.rent_placevector, e.rent_address, e.rent_catalogvector, e.rent_payed, e.country_id, e.run, e.operating_time, e.country_object, e.city_object, e.rent_location_object, e.currency_id, cr.currency_kurs, date_trunc('second', e.rent_enddate) AS rent_enddate, cr.currency_name, bc.place_id, c.catalog_name, c.catalog_dir, c.catalog_single_fr, c.catalog_single_de, c.catalog_single_en, bc.bc_firm, bc.bc_id, bc.bc_contactface, bc.bc_phone, bc.additional_region, bc.additional_country, bc.additional_town, bc.bc_logo_id, bc.bc_mobphone, bc.bc_placevector AS placevector, bc.town, bc.bc_www, bc.bc_login, bc.bc_password, ( (bc.bc_openenddate IS NOT NULL) AND (date_trunc('second', bc.bc_openenddate) > current_timestamp) AND (bc.bc_open = 1)) as bc_vipdealer FROM rent e INNER JOIN catalog c ON e.catalog_id=c.catalog_id LEFT OUTER JOIN bclients bc ON e.bc_id = bc.bc_id LEFT OUTER JOIN currency cr ON cr.currency_id = e.currency_id WHERE e.rent_deleted!=1 AND c.catalog_israise=1 AND e.rent_modstatus=1 AND e.rent_catalogvector LIKE '00000080000056%' AND e.rent_visible=1 AND e.priority = '1' AND bc.bc_blocked <> 1 ORDER BY CASE WHEN e.place_id = 19 OR e.place_id = 21 OR e.place_id = 39 OR e.place_id = 22 OR e.place_id = 73 OR e.place_id = 60 OR e.place_id = 23 OR e.place_id = 61 OR e.place_id = 62 OR e.place_id = 24 OR e.place_id = 40 OR e.place_id = 25 OR e.place_id = 42 OR e.place_id = 43 OR e.place_id = 50 OR e.place_id = 2 OR e.place_id = 3 OR e.place_id = 4 OR e.place_id = 5 OR e.place_id = 6 OR e.place_id = 7 OR e.place_id = 8 OR e.place_id = 9 OR e.place_id = 10 OR e.place_id = 12 OR e.place_id = 13 OR e.place_id = 14 OR e.place_id = 15 OR e.place_id = 11 OR e.place_id = 32 OR e.place_id = 30 OR e.place_id = 26 OR e.place_id = 27 OR e.place_id = 44 OR e.place_id = 28 OR e.place_id = 45 OR e.place_id = 46 OR e.place_id = 47 OR e.place_id = 29 OR e.place_id = 48 OR e.place_id = 33 OR e.place_id = 16 OR e.place_id = 17 OR e.place_id = 34 OR e.place_id = 35 OR e.place_id = 36 OR e.place_id = 37 OR e.place_id = 18 OR e.place_id = 41 OR e.place_id = 69 OR e.place_id = 78 OR e.place_id = 81 OR e.place_id = 84 OR e.place_id = 89 OR e.place_id = 55 OR e.place_id = 70 OR e.place_id = 71 OR e.place_id = 86 OR e.place_id = 56 OR e.place_id = 72 OR e.place_id = 57 OR e.place_id = 58 OR e.place_id = 87 OR e.place_id = 83 OR e.place_id = 59 OR e.place_id = 88 OR e.place_id = 74 OR e.place_id = 63 OR e.place_id = 75 OR e.place_id = 90 OR e.place_id = 76 OR e.place_id = 77 OR e.place_id = 91 OR e.place_id = 92 OR e.place_id = 64 OR e.place_id = 49 OR e.place_id = 93 OR e.place_id = 65 OR e.place_id = 66 OR e.place_id = 79 OR e.place_id = 80 OR e.place_id = 51 OR e.place_id = 52 OR e.place_id = 94 OR e.place_id = 82 OR e.place_id = 67 OR e.place_id = 53 OR e.place_id = 95 OR e.place_id = 111 OR e.place_id = 121 OR e.place_id = 0 OR e.place_id = 112 OR e.place_id = 103 OR e.place_id = 100 OR e.place_id = 101 OR e.place_id = 106 OR e.place_id = 104 OR e.place_id = 105 OR e.place_id = 102 OR e.place_id = 107 OR e.place_id = 108 OR e.place_id = 109 OR e.place_id = 110 OR e.place_id = 113 OR e.place_id = 114 OR e.place_id = 115 OR e.place_id = 116 OR e.place_id = 117 OR e.place_id = 118 OR e.place_id = 119 OR e.place_id = 120 OR e.place_id = 122 OR e.place_id = 124 OR e.place_id = 123 THEN -1 ELSE e.place_id END, e.priority_date_po, e.used_ranking DESC LIMIT 20 OFFSET 0
PostgreSQL: ERROR: column e.used_ranking does not exist СТРОКА 60: ... ELSE e.place_id END, e.priority_date_po, e.used_ran... ^