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('0e01938fc48a2cfb5f2217fbfb00722d' GROUP BY ORDER BY a.ordem DESC, a.hotel_stars DESC, a.titulo_en ASC