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 = 9)
AND active!=0
)
AND k.lang='en'
ORDER BY k.keyword<-