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 'AND moti.`id_item` IN("304E15ED-302F-CD33-9153-14B8C6F955BD"))) as t1
' at line 57]
select * from (SELECT cti_0.name as tree_item_0_name,
cti_0.id as tree_item_0_id,
cti_0.code as tree_item_0_code,
cti_0.id_media_object as tree_item_0_id_media_object,
cti_0.dynamic_values as tree_item_0_dynamic_values,
cti_0.`sort` as tree_item_0_sort,
cti_1.name as tree_item_1_name,
cti_1.id as tree_item_1_id,
cti_1.code as tree_item_1_code,
cti_1.id_media_object as tree_item_1_id_media_object,
cti_1.dynamic_values as tree_item_1_dynamic_values,
cti_1.`sort` as tree_item_1_sort,
cti_2.name as tree_item_2_name,
cti_2.code as tree_item_2_code,
cti_2.id as tree_item_2_id,
cti_2.id_media_object as tree_item_2_id_media_object,
cti_2.dynamic_values as tree_item_2_dynamic_values,
cti_2.`sort` as tree_item_2_sort
FROM wp_pm_search mo
LEFT JOIN wp_pm_media_object_tree_items moti ON (
moti.id_media_object = mo.id_media_objects
)
LEFT JOIN wp_pm_category_tree_items cti_0 ON (
moti.id_item = cti_0.id and cti_0.id_parent = ''
)
LEFT JOIN wp_pm_category_tree_items cti_1 ON (
cti_1.`id_parent` = cti_0.id AND
(
SELECT
COUNT(*)
FROM
`wp_pm_media_object_tree_items`
WHERE
`id_media_object` = mo.`id_media_objects` AND
id_item = cti_1.id
) > 0
AND
cti_1.`id` IN("304E15ED-302F-CD33-9153-14B8C6F955BD","304E15ED-302F-CD33-9153-14B8C6F955BD","k01258F95-206D-2058-C76B-B417F2AF2BA3","638D281D-CDD6-B8D8-3D3C-14B76DC75B35","k069D8E77-68F9-39B1-4D9B-B3C7FD3A3D57","k9884FF66-4BD7-F8BD-EC65-B40AC2759284","304E15ED-302F-CD33-9153-14B8C6F955BD","k7CE34CE4-FC80-F18D-D375-B34CFB4D8079","304E15ED-302F-CD33-9153-14B8C6F955BD","k9079D48E-9309-7C12-8817-B39ECA6BAE0A","k78817C94-364A-3659-014F-B39EF41734D5","kC5D870D6-7483-83C6-E120-B39EE0E250A2","304E15ED-302F-CD33-9153-14B8C6F955BD","k7A99680B-11E4-1915-27AB-B33E91EEAE9F","304E15ED-302F-CD33-9153-14B8C6F955BD","k74DE7CFA-BE09-6E45-A95B-B3C817EA7E50","kFC3FB302-6539-E2DB-1E68-B3C84D498CE2","k38717A57-8A8E-D5E9-8F9B-B3C7DCA81496","638D281D-CDD6-B8D8-3D3C-14B76DC75B35","k069D8E77-68F9-39B1-4D9B-B3C7FD3A3D57","304E15ED-302F-CD33-9153-14B8C6F955BD","k7A99680B-11E4-1915-27AB-B33E91EEAE9F","k8A141383-A270-B9BD-A9E9-E0910A679CA9","k0CC74062-5FFA-989C-28F7-E019881201A1","kC035D276-AAD4-0917-787E-B2FEEF377365","k389F2C1C-6F1F-957D-09AC-B2FF03791992","kFAEAC87C-4D31-DCD5-8477-B2F864877A53","304E15ED-302F-CD33-9153-14B8C6F955BD","k8A141383-A270-B9BD-A9E9-E0910A679CA9","k4FB4B59D-3396-E091-41BB-B2F8E204D8BF","k56A90E78-C944-A226-0B9E-B2F8D71BA88E","k7B4A14D4-275E-1D5F-1F10-B395F0B19491","kFAEAC87C-4D31-DCD5-8477-B2F864877A53","304E15ED-302F-CD33-9153-14B8C6F955BD","kFBF8E323-D880-EA81-5BFC-B3FE2DB4E87D","304E15ED-302F-CD33-9153-14B8C6F955BD","k5C0E53D6-56B1-4A9B-CE1A-B405269B18EC","304E15ED-302F-CD33-9153-14B8C6F955BD","k8B0D256C-87F6-41EB-74F8-B40ACDAE7D2F","304E15ED-302F-CD33-9153-14B8C6F955BD","k0CC74062-5FFA-989C-28F7-E019881201A1","304E15ED-302F-CD33-9153-14B8C6F955BD","k8A141383-A270-B9BD-A9E9-E0910A679CA9","304E15ED-302F-CD33-9153-14B8C6F955BD","k7A99680B-11E4-1915-27AB-B33E91EEAE9F","304E15ED-302F-CD33-9153-14B8C6F955BD","k389F2C1C-6F1F-957D-09AC-B2FF03791992","k0CC74062-5FFA-989C-28F7-E019881201A1","kC035D276-AAD4-0917-787E-B2FEEF377365","304E15ED-302F-CD33-9153-14B8C6F955BD","k389F2C1C-6F1F-957D-09AC-B2FF03791992","kEA285418-4B34-EDA7-43F0-B326C9CA8F5F","kC035D276-AAD4-0917-787E-B2FEEF377365","304E15ED-302F-CD33-9153-14B8C6F955BD","k44436423-9F4D-8B24-4D01-B2F947BDB7D2","k8A141383-A270-B9BD-A9E9-E0910A679CA9","k56A90E78-C944-A226-0B9E-B2F8D71BA88E","kFAEAC87C-4D31-DCD5-8477-B2F864877A53","k4FB4B59D-3396-E091-41BB-B2F8E204D8BF","304E15ED-302F-CD33-9153-14B8C6F955BD","k8A141383-A270-B9BD-A9E9-E0910A679CA9","304E15ED-302F-CD33-9153-14B8C6F955BD","k44436423-9F4D-8B24-4D01-B2F947BDB7D2","304E15ED-302F-CD33-9153-14B8C6F955BD","k8A141383-A270-B9BD-A9E9-E0910A679CA9","k4FB4B59D-3396-E091-41BB-B2F8E204D8BF","kFAEAC87C-4D31-DCD5-8477-B2F864877A53","k56A90E78-C944-A226-0B9E-B2F8D71BA88E","304E15ED-302F-CD33-9153-14B8C6F955BD","k738C22B8-F47D-3D92-851D-B38A19F2F08C","304E15ED-302F-CD33-9153-14B8C6F955BD","k7B4A14D4-275E-1D5F-1F10-B395F0B19491","304E15ED-302F-CD33-9153-14B8C6F955BD","304E15ED-302F-CD33-9153-14B8C6F955BD","304E15ED-302F-CD33-9153-14B8C6F955BD","304E15ED-302F-CD33-9153-14B8C6F955BD","kBA6384EE-CA96-D59C-EB2C-E4AFAADBB032")
)
LEFT JOIN wp_pm_category_tree_items cti_2 ON (
cti_2.id_parent = cti_1.id AND
(SELECT COUNT(*) FROM `wp_pm_media_object_tree_items` WHERE `id_media_object` = mo.id_media_objects AND id_item = cti_2.id) > 0
) 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 = 1587 and mo.id_object_type in(1588,1589,1590) and moti.id_tree=1207 AND ( AND moti.`id_item` IN("304E15ED-302F-CD33-9153-14B8C6F955BD"))) as t1
/*where
(tree_item_0_id in (select id_item from wp_pm_media_object_tree_items) or tree_item_0_id is null)
and (tree_item_1_id in (select id_item from wp_pm_media_object_tree_items) or tree_item_1_id is null)
and (tree_item_2_id in (select id_item from wp_pm_media_object_tree_items) or tree_item_2_id is null)*/
order by
tree_item_0_name ASC,
tree_item_1_name ASC,
tree_item_2_name ASC