Ошибка, запрос не может выполниться:
ERROR: SELECT items.*, users.login AS author, categories.title AS category,
categories.seo_name AS category_seo_name, iblocks.iblock_name
FROM `pa_iblock_items` AS items
LEFT JOIN `pa_users` AS users ON users.id = items.user_id
LEFT JOIN `pa_iblock_categories` AS categories ON categories.id = items.category_id
LEFT JOIN `pa_iblocks` AS iblocks ON iblocks.id = items.iblock_id
LEFT JOIN `pa_iblock_item_properties` AS p ON items.id = p.item_id
AND p.property_name = 'company_id'
LEFT JOIN `pa_iblock_items` AS ci ON ci.id = p.property_value
LEFT JOIN `pa_iblock_item_properties` AS cp ON ci.id = cp.item_id
AND cp.property_name = 'active'
WHERE items.iblock_id = 3 AND ERROR: EXISTS(SELECT * FROM `pa_iblock_item_properties` AS properties
WHERE properties.property_value = UNKNOWN_PLACEHOLDER_0 AND properties.property_name = UNKNOWN_PLACEHOLDER_0 AND properties.item_id = items.id) AND (cp.property_value = 1 OR cp.property_value IS NULL) ORDER BY id DESC LIMIT 0, 3Ошибка, запрос не может выполниться:
ERROR: SELECT items.*, users.login AS author, categories.title AS category,
categories.seo_name AS category_seo_name, iblocks.iblock_name
FROM `pa_iblock_items` AS items
LEFT JOIN `pa_users` AS users ON users.id = items.user_id
LEFT JOIN `pa_iblock_categories` AS categories ON categories.id = items.category_id
LEFT JOIN `pa_iblocks` AS iblocks ON iblocks.id = items.iblock_id
WHERE items.iblock_id = 5 AND ERROR: EXISTS(SELECT * FROM `pa_iblock_item_properties` AS properties
WHERE properties.property_value = UNKNOWN_PLACEHOLDER_0 AND properties.property_name = UNKNOWN_PLACEHOLDER_0 AND properties.item_id = items.id) ORDER BY id DESC LIMIT 0, 3Ошибка, запрос не может выполниться:
ERROR: SELECT COUNT(*) FROM `pa_iblock_items` AS items
LEFT JOIN `pa_iblock_item_properties` AS properties ON properties.item_id = items.id
WHERE items.iblock_id = ? AND properties.property_name = ? AND properties.property_value = UNKNOWN_PLACEHOLDER_2 AND items.active = 1Ошибка, запрос не может выполниться:
ERROR: SELECT COUNT(*) FROM `pa_iblock_items` AS items
LEFT JOIN `pa_iblock_item_properties` AS properties ON properties.item_id = items.id
WHERE items.iblock_id = ? AND properties.property_name = ? AND properties.property_value = UNKNOWN_PLACEHOLDER_2 AND items.active = 1