Discovery Travel EgyptDiscovery Travel Egypt
Forgot password?

WordPress database error: [Table 'discovery2.wp_icl_translations' doesn't exist]
CREATE TEMPORARY TABLE IF NOT EXISTS Searchhi9qutuprkon3cbalebsip8qv7 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 '2022-05-29' AS check_date UNION SELECT '2022-05-30' AS check_date UNION SELECT '2022-05-31' AS check_date UNION SELECT '2022-06-01' AS check_date UNION SELECT '2022-06-02' AS check_date UNION SELECT '2022-06-03' AS check_date UNION SELECT '2022-06-04' AS check_date UNION SELECT '2022-06-05' AS check_date UNION SELECT '2022-06-06' AS check_date UNION SELECT '2022-06-07' AS check_date UNION SELECT '2022-06-08' AS check_date UNION SELECT '2022-06-09' AS check_date UNION SELECT '2022-06-10' AS check_date UNION SELECT '2022-06-11' AS check_date UNION SELECT '2022-06-12' AS check_date UNION SELECT '2022-06-13' AS check_date UNION SELECT '2022-06-14' AS check_date UNION SELECT '2022-06-15' AS check_date UNION SELECT '2022-06-16' AS check_date UNION SELECT '2022-06-17' AS check_date UNION SELECT '2022-06-18' AS check_date UNION SELECT '2022-06-19' AS check_date UNION SELECT '2022-06-20' AS check_date UNION SELECT '2022-06-21' AS check_date UNION SELECT '2022-06-22' AS check_date UNION SELECT '2022-06-23' AS check_date UNION SELECT '2022-06-24' AS check_date UNION SELECT '2022-06-25' AS check_date UNION SELECT '2022-06-26' AS check_date UNION SELECT '2022-06-27' AS check_date UNION SELECT '2022-06-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.Searchhi9qutuprkon3cbalebsip8qv7' doesn't exist]
SELECT DISTINCT t1.*, post_l1.post_title as tour_title, meta_price.meta_value as min_price FROM Searchhi9qutuprkon3cbalebsip8qv7 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') INNER JOIN wp_term_relationships AS tr ON tr.object_id = t1.tour_id INNER JOIN wp_term_taxonomy AS tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND tt.taxonomy = 'tour_type' AND tt.term_id IN (18) ORDER BY tour_title ASC LIMIT 0, 24;

WordPress database error: [Table 'discovery2.Searchhi9qutuprkon3cbalebsip8qv7' doesn't exist]
SELECT COUNT( DISTINCT t1.tour_id ) FROM Searchhi9qutuprkon3cbalebsip8qv7 as t1 INNER JOIN wp_term_relationships AS tr ON tr.object_id = t1.tour_id INNER JOIN wp_term_taxonomy AS tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND tt.taxonomy = 'tour_type' AND tt.term_id IN (18)

Sort results by:

  • tours
No available tours