SELECT as id, CONCAT('?lop=conteudo&op=',md5(l.arvore_id),'&id=',md5( 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 AND a.activo='S' AND AND md5('1700002963a49da13542e0726b7bb758' GROUP BY ORDER BY a.ordem DESC, a.hotel_stars DESC, a.titulo_en ASC