Find hotel offers -

  1. SELECT c.id as offerID, wt.translation as offerType FROM categories c JOIN wordtranslation wt ON wt.docid = c.id AND wt.LanguageName = 'Arabic' WHERE c.pid = '109' ORDER BY wt.translation ASC