Erro: Unknown column 'minrate' in 'order clause'
------------------------------------
SELECT ht_stt, ht_ctg, ht_id, ht_nome, (SELECT hatr_atr_vlr FROM sys_hoteis_atrib WHERE hatr_atr_id = 1 AND hatr_ht_id = ht_id) AS ht_anter, (SELECT COUNT(*) FROM sys_hoteis_atrib WHERE hatr_atr_id = 54 AND hatr_ht_id = ht_id) AS adaptado, cid_id, cid_nome, cid_distritode, cid_uf, ht_bok_cod, ht_bok_url FROM qry_hoteis_resultado HTL WHERE HTL.ht_id > 0 AND HTL.ht_stt IN ('A', 'F') ORDER BY ht_stt, IFNULL(minrate, 0) DESC LIMIT 10 OFFSET 50