Pobyty situované v zimě, létě a lázních jako poznávací zájezdy, nebo dovolené.
SELECT destination_centre.dcentre_id AS id, destination_centre.dcentre_title AS nazev,
destination_centre.dcentre_code AS seonazev, destination_centre.dcentre_desc AS popis,
destination_centre.dseason_id AS season, destination_season.season_code AS season_code
FROM destination_centre
INNER JOIN destination_season ON destination_season.season_id = destination_centre.dseason_id
WHERE dcentre_code = "matreikals" LIMIT 1