WordPress database error: [Table 'discovery2.wp_icl_translations' doesn't exist]CREATE TEMPORARY TABLE IF NOT EXISTS Searchj2p5i15mndhvja8et5j2qeohvs 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 '2023-09-21' AS check_date UNION SELECT '2023-09-22' AS check_date UNION SELECT '2023-09-23' AS check_date UNION SELECT '2023-09-24' AS check_date UNION SELECT '2023-09-25' AS check_date UNION SELECT '2023-09-26' AS check_date UNION SELECT '2023-09-27' AS check_date UNION SELECT '2023-09-28' AS check_date UNION SELECT '2023-09-29' AS check_date UNION SELECT '2023-09-30' AS check_date UNION SELECT '2023-10-01' AS check_date UNION SELECT '2023-10-02' AS check_date UNION SELECT '2023-10-03' AS check_date UNION SELECT '2023-10-04' AS check_date UNION SELECT '2023-10-05' AS check_date UNION SELECT '2023-10-06' AS check_date UNION SELECT '2023-10-07' AS check_date UNION SELECT '2023-10-08' AS check_date UNION SELECT '2023-10-09' AS check_date UNION SELECT '2023-10-10' AS check_date UNION SELECT '2023-10-11' AS check_date UNION SELECT '2023-10-12' AS check_date UNION SELECT '2023-10-13' AS check_date UNION SELECT '2023-10-14' AS check_date UNION SELECT '2023-10-15' AS check_date UNION SELECT '2023-10-16' AS check_date UNION SELECT '2023-10-17' AS check_date UNION SELECT '2023-10-18' AS check_date UNION SELECT '2023-10-19' AS check_date UNION SELECT '2023-10-20' AS check_date UNION SELECT '2023-10-21' 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.Searchj2p5i15mndhvja8et5j2qeohvs' doesn't exist]SELECT DISTINCT t1.*, post_l1.post_title as tour_title, meta_price.meta_value as min_price FROM Searchj2p5i15mndhvja8et5j2qeohvs 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.Searchj2p5i15mndhvja8et5j2qeohvs' doesn't exist]SELECT COUNT( DISTINCT t1.tour_id ) FROM Searchj2p5i15mndhvja8et5j2qeohvs as t1 WHERE 1=1