Destinations & Services

SELECT title FROM category WHERE id=49

Introduce yourself with our tour offers!

Please note that the tour itineraries can be split, joined and changed regarding your wishes and the length of your stay here.

Just let us know what are you interested in!

SELECT DISTINCT k.* FROM keyword k LEFT JOIN keyword_link link ON k.id = link.keyword_id WHERE link.table_name='trip' AND link.table_id IN (SELECT id FROM trip WHERE id in (select table_id from category_link where table_name = 'trip' and category_id = 49) AND active!=0 ) AND k.lang='en' ORDER BY k.keyword<-

Latvia

^