MySQL error in file: /engine/modules/programs.php at line 535

Error Number: 1146

The Error returned was:
Table 'booking_health.xle_post' doesn't exist

SQL query:

SELECT cat_date, priority, cid, recommend, children_department, certificates, certificate_names, certificate_icons, top, id, title, category, alt_name, clinic_name, clinic_icon, clinic_short_story, country_name, country_id, country_alt_name, city_name, city_id, city_alt_name, cat_approve, post_approve, duration, price, type, manual_price, price_surcharge, is_action, custom_order, no_package, custom_package_price, only_for_children, drg_factor, basic_factor, price_on_request, price_on_request_program, disease_name, disease_id, rating, rating_count, basic_program, prepayment_to_clinic, paket_type, first_appointment, clinic_department_title, clinic_department_post_id, clinic_department_post_category, clinic_department_post_alt_name, clinic_department_post_short_story, department_title, department_id, department_desc_short, recommend_priority, recommended_clinics_for_program_id, is_ambulant, doctor_photo, doctor_name, doctor_title, doctor_disease, c_vitae, publications, doctor_certificat FROM ( SELECT clinic_department.cat_date, program_diagnostic.priority, clinic_data.cid, clinic_department.recommend, clinic_department.children_department, cer1.certificates, cer1.certificate_names, cer1.certificate_icons, cer1.top, p.id, p.category, cat2.icon AS clinic_icon, countries.id as country_id, countries.alt_name as country_alt_name, cities.id as city_id, cities.alt_name as city_alt_name, cat2.approve as cat_approve, p.approve as post_approve, program_diagnostic.duration, program_diagnostic.only_for_children, program_diagnostic.price_on_request AS price_on_request_program, program_diagnostic.price, program_diagnostic.type, program_diagnostic.paket_type, department_program_diagnostic.manual_price, department_program_diagnostic.price_surcharge, department_program_diagnostic.is_action, department_program_diagnostic.custom_order, department_program_diagnostic.department_id, department_program_diagnostic.no_package, department_program_diagnostic.custom_package_price, IF(translation_department_program.department_title IS NULL OR translation_department_program.department_title='', department_program_diagnostic.department_title, translation_department_program.department_title) AS department_title, IF(translation_department_program.department_desc_short IS NULL OR translation_department_program.department_desc_short='', department_program_diagnostic.department_desc_short, translation_department_program.department_desc_short) AS department_desc_short, drg.factor AS drg_factor, clinic_data.basic_factor, clinic_data.price_on_request, clinic_data.basic_program, clinic_data.prepayment_to_clinic, disease.id as disease_id, clinic_department.rating, clinic_data.rating_count, clinic_department.recommend_priority, (clinic_department.first_appointment*7-4+clinic_department.id%7) AS first_appointment, clinic_department_posts.id as clinic_department_post_id, clinic_department_posts.category as clinic_department_post_category, program_diagnostic.is_ambulant, recommended_clinics_for_program.id as recommended_clinics_for_program_id, head_doctors_diseases.description as doctor_disease, head_doctors_certificates.id AS doctor_certificat, translation_clinic_department_posts.alt_name AS clinic_department_post_alt_name, translation_post.alt_name as alt_name, IF(translation_clinic_department_posts.title IS NULL OR translation_clinic_department_posts.title='', clinic_department_posts.title, translation_clinic_department_posts.title) AS clinic_department_title, IF(translation_clinic_department_posts.short_story IS NULL OR translation_clinic_department_posts.short_story='', clinic_department_posts.short_story, translation_clinic_department_posts.short_story) AS clinic_department_post_short_story, IF(translation_category.name IS NULL OR translation_category.name='', cat2.name, translation_category.name) AS clinic_name, IF(translation_category.short_story IS NULL OR translation_category.short_story='', cat2.short_story, translation_category.short_story ) AS clinic_short_story, IF(translation_disease.name IS NULL OR translation_disease.name='', disease.name, translation_disease.name) AS disease_name, IF(translation_post.title IS NULL or translation_post.title = '', p.title, translation_post.title) as title, IF(translation_countries.name IS NULL OR translation_countries.name='', countries.name, translation_countries.name) AS country_name, IF(translation_cities.name IS NULL OR translation_cities.name='', cities.name, translation_cities.name) AS city_name, head_doctors.photo as doctor_photo, IF(translation_head_doctors.doctor_name IS NULL or translation_head_doctors.doctor_name = '', head_doctors.doctor_name, translation_head_doctors.doctor_name) as doctor_name, IF(translation_head_doctors.doctor_title IS NULL or translation_head_doctors.doctor_title = '', head_doctors.doctor_title, translation_head_doctors.doctor_title) as doctor_title, IF(translation_head_doctors.c_vitae IS NULL or translation_head_doctors.c_vitae = '', head_doctors.c_vitae, translation_head_doctors.c_vitae) as c_vitae, IF(translation_head_doctors.publications IS NULL or translation_head_doctors.publications = '', head_doctors.publications, translation_head_doctors.publications) as publications FROM department_program_diagnostic LEFT JOIN program_diagnostic ON (department_program_diagnostic.program_id = program_diagnostic.id) LEFT JOIN disease ON(disease.id = program_diagnostic.disease_id) LEFT JOIN direction_diagnostic ON(direction_diagnostic.id = program_diagnostic.direction_id) LEFT JOIN drg ON(drg.id = program_diagnostic.drg_id) LEFT JOIN xle_post p ON (p.id = department_program_diagnostic.post_id) LEFT JOIN clinic_department ON (clinic_department.id = department_program_diagnostic.department_id) LEFT JOIN xle_post clinic_department_posts ON (clinic_department.post_id = clinic_department_posts.id) LEFT JOIN ( SELECT department_id, GROUP_CONCAT(CASE WHEN certificates.top <> 0 THEN 1 END) AS top, GROUP_CONCAT( IF(translation_certificates.name IS NULL OR translation_certificates.name = '', certificates.name, translation_certificates.name) ORDER BY certificates_departments.certificate_id ASC ) AS certificate_names, GROUP_CONCAT(certificates.icon ORDER BY certificates_departments.certificate_id ASC) AS certificate_icons, GROUP_CONCAT(certificates_departments.certificate_id ORDER BY certificates_departments.certificate_id ASC) AS certificates FROM certificates_departments LEFT JOIN certificates ON (certificates.id = certificates_departments.certificate_id) LEFT JOIN translation_certificates ON (translation_certificates.certificate_id = certificates.id AND translation_certificates.lang = 'ar') GROUP BY certificates_departments.department_id ) cer1 ON cer1.department_id = clinic_department.id LEFT JOIN recommended_clinics_for_program ON (recommended_clinics_for_program.program_id = program_diagnostic.id AND clinic_department.clinic_id = recommended_clinics_for_program.clinic_id ) LEFT JOIN clinic_data ON (clinic_data.cid = clinic_department.clinic_id) LEFT JOIN xle_category cat2 ON (cat2.id = clinic_data.cid) LEFT JOIN cities ON (cities.id = clinic_data.city_id) LEFT JOIN countries ON (countries.id = cities.country_id) LEFT JOIN head_doctors ON (head_doctors.department_id = clinic_department.id) LEFT JOIN translation_head_doctors ON (translation_head_doctors.head_doctor_id=head_doctors.id AND translation_head_doctors.lang='ar') LEFT JOIN head_doctors_diseases ON (head_doctors_diseases.head_doctor_id = head_doctors.id AND head_doctors_diseases.disease_id = disease.id AND head_doctors_diseases.lang = 'ar') LEFT JOIN head_doctors_certificates ON head_doctors_certificates.id = ( SELECT id from head_doctors_certificates WHERE head_doctors_certificates.head_doctor_id = head_doctors.id LIMIT 1 ) LEFT JOIN translation_department_program ON (translation_department_program.department_program_id = department_program_diagnostic.id AND translation_department_program.lang='ar') LEFT JOIN translation_category ON (translation_category.category_id = cat2.id AND translation_category.lang='ar') LEFT JOIN translation_disease ON (translation_disease.disease_id = disease.id AND translation_disease.lang='ar') LEFT JOIN translation_post ON (translation_post.post_id=p.id AND translation_post.lang='ar') LEFT JOIN translation_countries ON (countries.id = translation_countries.country_id AND translation_countries.lang='ar') LEFT JOIN translation_cities ON (cities.id = translation_cities.city_id AND translation_cities.lang='ar') LEFT JOIN translation_post translation_clinic_department_posts ON (translation_clinic_department_posts.post_id=clinic_department_posts.id AND translation_clinic_department_posts.lang='ar') WHERE clinic_department_posts.approve <> 0 AND p.approve <> 0 AND cat2.approve <> 0 AND cat2.approve <> 2 AND program_diagnostic.priority < 3 AND clinic_department.id != '' AND clinic_data.noindex != 1 AND program_diagnostic.type = "treatment" AND program_diagnostic.direction_id="97" AND countries.alt_name="germany" AND cities.alt_name="marburg" AND clinic_department.children_department != 2 AND program_diagnostic.only_for_children != 1 ORDER BY program_diagnostic.priority ASC, is_action DESC, custom_order ASC, clinic_department.recommend DESC, clinic_department.recommend_priority ASC, length(cer1.top) DESC, -cer1.certificates DESC , p.id DESC LIMIT 1000) v GROUP BY v.cid ORDER BY v.priority ASC, is_action DESC, custom_order ASC, v.recommend DESC, v.recommend_priority ASC, length(v.top) DESC, -v.certificates DESC LIMIT 0,3