Obernai: Alsace Charm & Wine Escape

Secured payments

Easy cancellation

Trusted reviews

SELECT * FROM `ophorus_products` `a` JOIN `ophorus_products_liaison_destinations` `c` ON `c`.`product_id` = `a`.`product_id` JOIN `ophorus_destinations` `d` ON `d`.`destination_id` = `c`.`destination_id` WHERE `a`.`productType` != 'TRANSFER' AND `a`.`product_activ` = 'Y' AND `a`.`product_force_desactiv` = 'N' AND `a`.`product_from` = 'PROD' AND `c`.`destination_id` IN('50') GROUP BY `a`.`product_id` ?>

SELECT * FROM `ophorus_products_comments` `a` JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`product_id` = `a`.`product_id` JOIN `ophorus_products` `c` ON `c`.`product_id` = `a`.`product_id` WHERE `b`.`destination_id` = '50' AND `c`.`product_activ` = 'Y' AND `c`.`product_force_desactiv` = 'N' AND `c`.`product_from` = 'PROD' ORDER BY `a`.`comment_date` DESC LIMIT 4 ?>

SELECT MAX(a.tag_value) AS tag_value, `a`.`tag_slug` FROM `ophorus_products_tags` `a` JOIN `ophorus_tags` `b` ON `b`.`tag_id` = `a`.`tag_id` WHERE `a`.`tag_slug` != '' AND `b`.`tag_label` = 'INTENSITY' GROUP BY `a`.`tag_slug` ORDER BY `a`.`tag_value` ASC ?>

SELECT c.categorie_id, c.categorie_icon, c.categorie_description, c.categorie_short_description, c.categorie_img, c.categorie_label, COUNT(DISTINCT p.product_id) AS nb_produits FROM `ophorus_products_categories` `c` LEFT JOIN `ophorus_products_liaison_categories` `lc` ON `lc`.`categorie_id` = `c`.`categorie_id` LEFT JOIN ophorus_products p ON p.product_id = lc.product_id AND p.product_activ = 'Y' WHERE `c`.`categorie_activ` = 'Y' GROUP BY `c`.`categorie_id` HAVING COUNT(DISTINCT p.product_id) > 0 ORDER BY `c`.`categorie_order` DESC ?>

SELECT a.destination_id, a.destination_label, a.destination_background, a.destination_phare, a.destination_short_description, a.destination_description, a.destination_accueil, c.region_label, c.region_ss_label, c.region_id, COUNT(DISTINCT e.product_id) AS nb_produits, SUM(CASE WHEN e.product_id IS NOT NULL AND e.product_activ = 'Y' AND e.product_shore_excursion = 'N' AND e.productType <> 'TRANSFER' AND e.product_from = 'PROD' THEN 1 ELSE 0 END ) AS has_non_shore, SUM(CASE WHEN e.product_id IS NOT NULL AND e.product_activ = 'Y' AND e.product_shore_excursion = 'Y' THEN 1 ELSE 0 END ) AS has_shore FROM `ophorus_destinations` `a` INNER JOIN `location_cities` `b` ON `b`.`id` = `a`.`destination_ville` INNER JOIN `ophorus_destinations_regions` `c` ON `c`.`region_id` = `a`.`region_id` LEFT JOIN `ophorus_products_liaison_destinations` `d` ON `d`.`destination_id` = `a`.`destination_id` LEFT JOIN ophorus_products e ON e.product_id = d.product_id GROUP BY `a`.`destination_id` HAVING COUNT(DISTINCT e.product_id) > 0 ORDER BY `c`.`region_order` DESC, `a`.`destination_label` ASC ?>

SELECT * FROM `ophorus_destinations` `a` JOIN `location_cities` `b` ON `b`.`id` = `a`.`destination_ville` JOIN `ophorus_products_liaison_destinations` `d` ON `d`.`destination_id` = `a`.`destination_id` JOIN `ophorus_products` `e` ON `e`.`product_id` = `d`.`product_id` JOIN `ophorus_destinations_regions` `c` ON `c`.`region_id` = `a`.`region_id` GROUP BY `a`.`destination_id` ORDER BY `c`.`region_order` DESC, `a`.`destination_label` ASC ?>

Loading Time: Base Classes	0.0058
Controller Execution Time ( Controller Ophorus Results / Show Results )	0.0791
Total Execution Time	0.0858

0.0003	SELECT * FROM `ophorus_rezdy` ?>
0.0008	INSERT INTO `ophorus_history` (`session_id`, `session_ip`, `session_date`) VALUES ('3e86644a62415057b9478abb8b8a1cf2', '216.73.216.219', '2026-03-13 20:36:16') ?>
0.0006	SELECT * FROM `ophorus_products` `a` JOIN `ophorus_products_liaison_destinations` `c` ON `c`.`product_id` = `a`.`product_id` JOIN `ophorus_destinations` `d` ON `d`.`destination_id` = `c`.`destination_id` WHERE `a`.`productType` != 'TRANSFER' AND `a`.`product_activ` = 'Y' AND `a`.`product_force_desactiv` = 'N' AND `a`.`product_from` = 'PROD' AND `c`.`destination_id` IN('50') GROUP BY `a`.`product_id` ?>
0.0003	SELECT * FROM `ophorus_destinations` WHERE `destination_id` = '50' ?>
0.0018	SELECT * FROM `ophorus_products_comments` `a` JOIN `ophorus_products_liaison_destinations` `b` ON `b`.`product_id` = `a`.`product_id` JOIN `ophorus_products` `c` ON `c`.`product_id` = `a`.`product_id` WHERE `b`.`destination_id` = '50' AND `c`.`product_activ` = 'Y' AND `c`.`product_force_desactiv` = 'N' AND `c`.`product_from` = 'PROD' ORDER BY `a`.`comment_date` DESC LIMIT 4 ?>
0.0006	SELECT * FROM `ophorus_destinations_faq` `a` WHERE `a`.`destination_id` = '50' ?>
0.0026	SELECT MAX(a.tag_value) AS tag_value, `a`.`tag_slug` FROM `ophorus_products_tags` `a` JOIN `ophorus_tags` `b` ON `b`.`tag_id` = `a`.`tag_id` WHERE `a`.`tag_slug` != '' AND `b`.`tag_label` = 'INTENSITY' GROUP BY `a`.`tag_slug` ORDER BY `a`.`tag_value` ASC ?>
0.0003	SELECT * FROM `ophorus_infos` ?>
0.0008	SELECT * FROM `ophorus_contents` ?>
0.0036	SELECT c.categorie_id, c.categorie_icon, c.categorie_description, c.categorie_short_description, c.categorie_img, c.categorie_label, COUNT(DISTINCT p.product_id) AS nb_produits FROM `ophorus_products_categories` `c` LEFT JOIN `ophorus_products_liaison_categories` `lc` ON `lc`.`categorie_id` = `c`.`categorie_id` LEFT JOIN ophorus_products p ON p.product_id = lc.product_id AND p.product_activ = 'Y' WHERE `c`.`categorie_activ` = 'Y' GROUP BY `c`.`categorie_id` HAVING COUNT(DISTINCT p.product_id) > 0 ORDER BY `c`.`categorie_order` DESC ?>
0.0114	SELECT a.destination_id, a.destination_label, a.destination_background, a.destination_phare, a.destination_short_description, a.destination_description, a.destination_accueil, c.region_label, c.region_ss_label, c.region_id, COUNT(DISTINCT e.product_id) AS nb_produits, SUM(CASE WHEN e.product_id IS NOT NULL AND e.product_activ = 'Y' AND e.product_shore_excursion = 'N' AND e.productType <> 'TRANSFER' AND e.product_from = 'PROD' THEN 1 ELSE 0 END ) AS has_non_shore, SUM(CASE WHEN e.product_id IS NOT NULL AND e.product_activ = 'Y' AND e.product_shore_excursion = 'Y' THEN 1 ELSE 0 END ) AS has_shore FROM `ophorus_destinations` `a` INNER JOIN `location_cities` `b` ON `b`.`id` = `a`.`destination_ville` INNER JOIN `ophorus_destinations_regions` `c` ON `c`.`region_id` = `a`.`region_id` LEFT JOIN `ophorus_products_liaison_destinations` `d` ON `d`.`destination_id` = `a`.`destination_id` LEFT JOIN ophorus_products e ON e.product_id = d.product_id GROUP BY `a`.`destination_id` HAVING COUNT(DISTINCT e.product_id) > 0 ORDER BY `c`.`region_order` DESC, `a`.`destination_label` ASC ?>
0.0102	SELECT * FROM `ophorus_destinations` `a` JOIN `location_cities` `b` ON `b`.`id` = `a`.`destination_ville` JOIN `ophorus_products_liaison_destinations` `d` ON `d`.`destination_id` = `a`.`destination_id` JOIN `ophorus_products` `e` ON `e`.`product_id` = `d`.`product_id` JOIN `ophorus_destinations_regions` `c` ON `c`.`region_id` = `a`.`region_id` GROUP BY `a`.`destination_id` ORDER BY `c`.`region_order` DESC, `a`.`destination_label` ASC ?>
0.0004	SELECT * FROM `ophorus_destinations_shore` ORDER BY `shore_order` DESC ?>
0.0003	SELECT * FROM `ophorus_footer_links` ORDER BY `link_order` DESC ?>
0.0003	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '41' ?>
0.0003	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '36' ?>
0.0003	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '5' ?>
0.0002	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '43' ?>
0.0003	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '30' ?>
0.0003	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '7' ?>
0.0003	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '13' ?>
0.0003	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '29' ?>
0.0003	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '31' ?>
0.0003	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '38' ?>
0.0002	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '8' ?>
0.0003	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '25' ?>
0.0003	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '26' ?>
0.0003	SELECT * FROM `ophorus_custom_search` WHERE `custom_id` = '4' ?>
0.0002	SELECT * FROM `ophorus_rezdy` ?>
0.0003	SELECT * FROM `ophorus_modal` WHERE `modal_activ` = 'Y' ?>
0.0003	SELECT * FROM `ophorus_brochures` ORDER BY `brochure_order` DESC ?>
0.0003	SELECT * FROM `ophorus_footer_bg` ORDER BY RAND() ?>
0.0003	SELECT * FROM `ophorus_destinations_regions` WHERE `region_id` = '4' ?>

HTTP_ACCEPT	/
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_CONNECTION
SERVER_PORT	443
SERVER_NAME	dev.ophorus.com
REMOTE_ADDR	216.73.216.219
SERVER_SOFTWARE	Apache
HTTP_ACCEPT_LANGUAGE
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/1.1
QUERY_STRING
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_X_FORWARDED_FOR	216.73.216.219
HTTP_DNT

__ci_last_regenerate	1773430576
device	computer
is_mobile	false
save_sess	3e86644a62415057b9478abb8b8a1cf2
search_session	Array ( [id] => cQPnRwYa0eDFsi3umI4S [request] => Array ( [date_deb] => 2026-03-13 [date_end] => 2027-01-13 [destinations] => Array ( [0] => 50 ) [destination_id] => 50 [destination_type] => VI ) [nb_results] => 0 [result] => Array ( ) )
cache_page	false
nb_view_results	21

base_url	https://dev.ophorus.com/
index_page	index.php
uri_protocol	REQUEST_URI
url_suffix
language	english
charset	UTF-8
enable_hooks	1
subclass_prefix	MY_
composer_autoload	1
permitted_uri_chars	a-z 0-9~%.:_\-
enable_query_strings
controller_trigger	c
function_trigger	m
directory_trigger	d
log_threshold	1
log_path
log_filename
log_file_permissions	420
log_date_format	Y-m-d H:i:s
error_views_path
cache_path
cache_query_string
encryption_key	7s9d8f7sd9f7s9d8f7sd9f87sd9f87sd9f
sess_driver	files
sess_cookie_name	ci_session
sess_samesite	Lax
sess_expiration	7200
sess_save_path	/home/iqeakxb/dev/application/cache/sessions
sess_match_ip
sess_time_to_update	300
sess_regenerate_destroy
cookie_prefix
cookie_domain
cookie_path	/
cookie_secure
cookie_httponly
cookie_samesite	Lax
csrf_protection
csrf_token_name	csrf_test_name
csrf_cookie_name	csrf_cookie_name
csrf_expire	7200
csrf_regenerate	1
csrf_exclude_uris	Array ( )
compress_output
time_reference	local
proxy_ips

Bayeux

Marseille

Aquitaine

Alsace

Burgundy

Champagne

Dordogne

French Riviera

Hauts de France

Île-de-France

Loire Valley

Normandy

Occitanie

Provence

Rhône-Alpes

River Cruises

Walking Tours

Packages

Multi-regional

Shore Excursions

River Cruises

Exclusive Travel

Luxury

Honeymoon

Food & Wine

Arts & Crafts

Battlefields

Day Trips

Cultural

Special Offers

Family

Christmas Markets

Sightseeing

Walking Tours

Tickets

Normandy

Atlantic Coast

Mediterranean

French Riviera

Alsace

Obernai

0 activities found

Filters

Best Obernai experiences

Learn more about Obernai

Obernai: Where History Meets Charm.

Secured payments

Easy cancellation

Trusted reviews