SELECT a.id as id, CONCAT('?lop=conteudo&op=',md5(l.arvore_id),'&id=',md5(a.id)) as link, a.bin_imagem_jpeg as imagem_src, a.titulo_en as titulo, a.SEO_titulo_en as SEO_titulo, a.hotel_stars as hotel_stars, a.hotel_city as hotel_city, a.hotel_country as hotel_country, a.hotel_address as address, a.hotel_price_single as hotel_single, a.hotel_price_double as hotel_double, a.hotel_price_suite as hotel_suite, a.allow_booking as allow_booking, a.pais_en as pais, a.hotel_lat as h_latitude, a.hotel_long as h_longitude FROM artigos a, arvore2artigo l, arvore t WHERE a.id=l.art_id AND a.activo='S' AND l.arvore_id=t.id AND md5(t.id)='1700002963a49da13542e0726b7bb758' GROUP BY a.id ORDER BY a.ordem DESC, a.hotel_stars DESC, a.titulo_en ASC