WordPress-Datenbank-Fehler: [Unknown column 'TREE_140' in 'where clause']
SELECT distinct(mo.id_media_objects) as id_media_object,mo.id_object_type, mo.name, mo.code, mo.tags, ( SELECT `data` FROM `wp_pm_media_objects` WHERE `id_media_objects` = mo.`id_media_objects` LIMIT 1 ) as data, mo.id_pool, mo.visibility, mo.valid_from, mo.valid_to, mo.url, mo.min_price as sortprice, mo.next_departure as sortdate FROM wp_pm_search mo WHERE 1=1 AND ( NOW() >= valid_from AND NOW() <= valid_to OR valid_from = '0000-00-00 00:00:00' AND valid_to = '0000-00-00 00:00:00' OR valid_from = '1970-01-01 00:00:00' AND valid_to = '1970-01-01 00:00:00' ) /*page_vars_where*/ and mo.visibility = 30 and mo.id_pool = 829 and mo.id_object_type in(165,2595) /*query_vars_where*/ and mo.`min_price` > 0 and mo.`min_price_date` >= NOW() and ( ( SELECT COUNT(DISTINCT(id_item)) FROM `wp_pm_media_object_tree_items` WHERE id_media_object = mo.id_media_objects AND id_tree = 139 AND id_item IN("a7fef4e37456effd34d6461275c1dad6","297c02479cb8dbffd725ab679ab18b84","0775286dc904436cd8654dba7472e8d4","1c5558dd4ec5b8193329c29d5ae04511") ) > 0 and ( SELECT COUNT(DISTINCT(id_item)) FROM `wp_pm_media_object_tree_items` WHERE id_media_object = mo.id_media_objects AND id_tree = TREE_140 AND id_item IN("") ) > 0 ) /*query_vars_where / touristic */ and mo.`min_price` >= '1' order by mo.`min_price` asc limit 1

WordPress-Datenbank-Fehler: [Unknown column 'TREE_140' in 'where clause']
SELECT distinct(mo.id_media_objects) as id_media_object FROM wp_pm_search mo WHERE 1=1 AND ( NOW() >= valid_from AND NOW() <= valid_to OR valid_from = '0000-00-00 00:00:00' AND valid_to = '0000-00-00 00:00:00' OR valid_from = '1970-01-01 00:00:00' AND valid_to = '1970-01-01 00:00:00' ) /*page_vars_where*/ and mo.visibility = 30 and mo.id_pool = 829 and mo.id_object_type in(165,2595) /*query_vars_where*/ and mo.`min_price` > 0 and mo.`min_price_date` >= NOW() and ( ( SELECT COUNT(DISTINCT(id_item)) FROM `wp_pm_media_object_tree_items` WHERE id_media_object = mo.id_media_objects AND id_tree = 139 AND id_item IN("a7fef4e37456effd34d6461275c1dad6","297c02479cb8dbffd725ab679ab18b84","0775286dc904436cd8654dba7472e8d4","1c5558dd4ec5b8193329c29d5ae04511") ) > 0 and ( SELECT COUNT(DISTINCT(id_item)) FROM `wp_pm_media_object_tree_items` WHERE id_media_object = mo.id_media_objects AND id_tree = TREE_140 AND id_item IN("") ) > 0 ) /*query_vars_where / touristic */ and mo.`min_price` >= '1'

WordPress-Datenbank-Fehler: [Unknown column 'TREE_140' in 'where clause']
SELECT distinct(mo.id_media_objects) as id_media_object,mo.id_object_type, mo.name, mo.code, mo.tags, ( SELECT `data` FROM `wp_pm_media_objects` WHERE `id_media_objects` = mo.`id_media_objects` LIMIT 1 ) as data, mo.id_pool, mo.visibility, mo.valid_from, mo.valid_to, mo.url, mo.min_price as sortprice, mo.next_departure as sortdate, tbpT.`duration` FROM wp_pm_search mo left join wp_pm_touristic_dates td on (mo.id_media_objects = td.id_media_object) left join wp_pm_touristic_booking_packages tbpT on (mo.id_media_objects = tbpT.id_media_object) WHERE 1=1 AND ( NOW() >= valid_from AND NOW() <= valid_to OR valid_from = '0000-00-00 00:00:00' AND valid_to = '0000-00-00 00:00:00' OR valid_from = '1970-01-01 00:00:00' AND valid_to = '1970-01-01 00:00:00' ) /*page_vars_where*/ and mo.visibility = 30 and mo.id_pool = 829 and mo.id_object_type in(165,2595) /*query_vars_where*/ and mo.`min_price` > 0 and mo.`min_price_date` >= NOW() and ( ( SELECT COUNT(DISTINCT(id_item)) FROM `wp_pm_media_object_tree_items` WHERE id_media_object = mo.id_media_objects AND id_tree = 139 AND id_item IN("a7fef4e37456effd34d6461275c1dad6","297c02479cb8dbffd725ab679ab18b84","0775286dc904436cd8654dba7472e8d4","1c5558dd4ec5b8193329c29d5ae04511") ) > 0 and ( SELECT COUNT(DISTINCT(id_item)) FROM `wp_pm_media_object_tree_items` WHERE id_media_object = mo.id_media_objects AND id_tree = TREE_140 AND id_item IN("") ) > 0 ) /*query_vars_where / touristic */ and tbpT.`duration` >= 1 order by tbpT.duration asc limit 1

WordPress-Datenbank-Fehler: [Unknown column 'TREE_140' in 'where clause']
SELECT distinct(mo.id_media_objects) as id_media_object, tbpT.`duration` FROM wp_pm_search mo left join wp_pm_touristic_dates td on (mo.id_media_objects = td.id_media_object) left join wp_pm_touristic_booking_packages tbpT on (mo.id_media_objects = tbpT.id_media_object) WHERE 1=1 AND ( NOW() >= valid_from AND NOW() <= valid_to OR valid_from = '0000-00-00 00:00:00' AND valid_to = '0000-00-00 00:00:00' OR valid_from = '1970-01-01 00:00:00' AND valid_to = '1970-01-01 00:00:00' ) /*page_vars_where*/ and mo.visibility = 30 and mo.id_pool = 829 and mo.id_object_type in(165,2595) /*query_vars_where*/ and mo.`min_price` > 0 and mo.`min_price_date` >= NOW() and ( ( SELECT COUNT(DISTINCT(id_item)) FROM `wp_pm_media_object_tree_items` WHERE id_media_object = mo.id_media_objects AND id_tree = 139 AND id_item IN("a7fef4e37456effd34d6461275c1dad6","297c02479cb8dbffd725ab679ab18b84","0775286dc904436cd8654dba7472e8d4","1c5558dd4ec5b8193329c29d5ae04511") ) > 0 and ( SELECT COUNT(DISTINCT(id_item)) FROM `wp_pm_media_object_tree_items` WHERE id_media_object = mo.id_media_objects AND id_tree = TREE_140 AND id_item IN("") ) > 0 ) /*query_vars_where / touristic */ and tbpT.`duration` >= 1

WordPress-Datenbank-Fehler: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1,1' at line 57]
SELECT distinct(mo.id_media_objects) as id_media_object,mo.id_object_type, mo.name, mo.code, mo.tags, ( SELECT `data` FROM `wp_pm_media_objects` WHERE `id_media_objects` = mo.`id_media_objects` LIMIT 1 ) as data, mo.id_pool, mo.visibility, mo.valid_from, mo.valid_to, mo.url, mo.min_price as sortprice, mo.next_departure as sortdate, tbpT.`duration` FROM wp_pm_search mo left join wp_pm_touristic_dates td on (mo.id_media_objects = td.id_media_object) left join wp_pm_touristic_booking_packages tbpT on (mo.id_media_objects = tbpT.id_media_object) WHERE 1=1 AND ( NOW() >= valid_from AND NOW() <= valid_to OR valid_from = '0000-00-00 00:00:00' AND valid_to = '0000-00-00 00:00:00' OR valid_from = '1970-01-01 00:00:00' AND valid_to = '1970-01-01 00:00:00' ) /*page_vars_where*/ and mo.visibility = 30 and mo.id_pool = 829 and mo.id_object_type in(165,2595) /*query_vars_where*/ and mo.`min_price` > 0 and mo.`min_price_date` >= NOW() and ( ( SELECT COUNT(DISTINCT(id_item)) FROM `wp_pm_media_object_tree_items` WHERE id_media_object = mo.id_media_objects AND id_tree = 139 AND id_item IN("a7fef4e37456effd34d6461275c1dad6","297c02479cb8dbffd725ab679ab18b84","0775286dc904436cd8654dba7472e8d4","1c5558dd4ec5b8193329c29d5ae04511") ) > 0 and ( SELECT COUNT(DISTINCT(id_item)) FROM `wp_pm_media_object_tree_items` WHERE id_media_object = mo.id_media_objects AND id_tree = TREE_140 AND id_item IN("") ) > 0 ) /*query_vars_where / touristic */ and tbpT.`duration` >= 1 order by tbpT.duration asc limit -1,1