Discovery Travel EgyptDiscovery Travel Egypt
Forgot password?

Warning: Use of undefined constant WPLANG - assumed 'WPLANG' (this will throw an Error in a future version of PHP) in /var/www/discoverytravel/wp-content/themes/rrrr/inc/functions/wpml.php on line 183

Warning: Use of undefined constant WPLANG - assumed 'WPLANG' (this will throw an Error in a future version of PHP) in /var/www/discoverytravel/wp-content/themes/rrrr/inc/functions/wpml.php on line 183

WordPress database error: [Table 'discovery2.wp_icl_translations' doesn't exist]
CREATE TEMPORARY TABLE IF NOT EXISTS Searchbuv96kfgscjiv4m2oa8qvm8qk8 AS SELECT available_schedules.tour_id, MIN(available_schedules.check_date) as min_date, MAX(available_schedules.check_date) as max_date FROM ( SELECT schedules.*, check_dates.check_date, schedules.max_people - SUM( IFNULL(bookings.adults,0) ) - SUM( IFNULL(bookings.kids,0) ) AS available_seat FROM (SELECT DISTINCT it2.element_id AS tour_id FROM (SELECT post_s1.ID AS tour_id FROM wp_posts AS post_s1 WHERE (post_s1.post_status = 'publish') AND (post_s1.post_type = 'tour')) AS t0 INNER JOIN wp_icl_translations it1 ON (it1.element_type = 'post_tour') AND it1.element_id = t0.tour_id INNER JOIN wp_icl_translations it2 ON (it2.element_type = 'post_tour') AND it2.language_code='en' AND it2.trid = it1.trid ) AS tours INNER JOIN wp_trav_tour_schedule AS schedules ON tours.tour_id = schedules.tour_id INNER JOIN (SELECT '2020-11-28' AS check_date UNION SELECT '2020-11-29' AS check_date UNION SELECT '2020-11-30' AS check_date UNION SELECT '2020-12-01' AS check_date UNION SELECT '2020-12-02' AS check_date UNION SELECT '2020-12-03' AS check_date UNION SELECT '2020-12-04' AS check_date UNION SELECT '2020-12-05' AS check_date UNION SELECT '2020-12-06' AS check_date UNION SELECT '2020-12-07' AS check_date UNION SELECT '2020-12-08' AS check_date UNION SELECT '2020-12-09' AS check_date UNION SELECT '2020-12-10' AS check_date UNION SELECT '2020-12-11' AS check_date UNION SELECT '2020-12-12' AS check_date UNION SELECT '2020-12-13' AS check_date UNION SELECT '2020-12-14' AS check_date UNION SELECT '2020-12-15' AS check_date UNION SELECT '2020-12-16' AS check_date UNION SELECT '2020-12-17' AS check_date UNION SELECT '2020-12-18' AS check_date UNION SELECT '2020-12-19' AS check_date UNION SELECT '2020-12-20' AS check_date UNION SELECT '2020-12-21' AS check_date UNION SELECT '2020-12-22' AS check_date UNION SELECT '2020-12-23' AS check_date UNION SELECT '2020-12-24' AS check_date UNION SELECT '2020-12-25' AS check_date UNION SELECT '2020-12-26' AS check_date UNION SELECT '2020-12-27' AS check_date UNION SELECT '2020-12-28' AS check_date) AS check_dates ON ( schedules.is_daily = 0 AND check_dates.check_date = schedules.tour_date ) OR ( schedules.is_daily = 1 AND check_dates.check_date >= schedules.tour_date AND check_dates.check_date <= schedules.date_to ) LEFT JOIN wp_trav_tour_bookings AS bookings ON bookings.tour_id = schedules.tour_id AND bookings.st_id = schedules.st_id AND bookings.tour_date = check_dates.check_date AND bookings.status<>0 GROUP BY schedules.tour_id, schedules.st_id, check_dates.check_date HAVING available_seat > 0 ORDER BY st_id ASC, tour_date ASC ) AS available_schedules GROUP BY available_schedules.tour_id

WordPress database error: [Table 'discovery2.Searchbuv96kfgscjiv4m2oa8qvm8qk8' doesn't exist]
SELECT DISTINCT t1.*, post_l1.post_title as tour_title, meta_price.meta_value as min_price FROM Searchbuv96kfgscjiv4m2oa8qvm8qk8 as t1 INNER JOIN wp_posts post_l1 ON (t1.tour_id = post_l1.ID) AND (post_l1.post_status = 'publish') AND (post_l1.post_type = 'tour') LEFT JOIN wp_postmeta AS meta_price ON (t1.tour_id = meta_price.post_id) AND (meta_price.meta_key = 'trav_tour_min_price') WHERE 1=1 ORDER BY tour_title ASC LIMIT 0, 24;

WordPress database error: [Table 'discovery2.Searchbuv96kfgscjiv4m2oa8qvm8qk8' doesn't exist]
SELECT COUNT( DISTINCT t1.tour_id ) FROM Searchbuv96kfgscjiv4m2oa8qvm8qk8 as t1 WHERE 1=1

Sort results by:

  • tours
No available tours