select h.*,c.kategori_en,c.kategori_id,c.kategori_jp from hotels h , cathotel c where h.idkat = c.idkat order by idhtl desc limit 0, 10