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)='06eb61b839a0cefee4967c67ccb099dc'
    GROUP BY
      a.id
    ORDER BY
      a.ordem DESC,
      a.hotel_stars DESC,
      a.titulo_en ASC