(ошибка в связи с группами и с пользователямиидентичная разве что FROM cms_con_users i)
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 r3.child_item_id = i.id WHERE (i.is_private = '0') AND (i.is_approved = '1' at line 3
SELECT COUNT( i.id ) as count
FROM cms_con_groups i
INNER JOIN cms_content_relations_bind as r3 ON r3.parent_ctype_id = 19 AND r3.parent_item_id = 1 AND r3.child_ctype_id = AND r3.child_item_id = i.id
WHERE (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
Последние вызовы:
cmsModel->getCount() @ /system/controllers/content/model.php: 2369
modelContent->getContentItemsCount() @ /system/controllers/places/frontend.php: 0
places->getItemViewMenu() @ /system/core/action.php: 29
cmsAction->__call() @ /system/controllers/places/hooks/content_places_before_item.php: 0
onPlacesContentPlacesBeforeItem->run() @ /system/core/controller.php: 699
cmsController->runExternalHook() @ /system/core/controller.php: 658
cmsController->runHook() @ /system/core/eventsmanager.php: 66
cmsEventsManager::hook() @ /system/controllers/content/actions/item_view.php: 346
actionContentItemView->run() @ /system/core/controller.php: 563
cmsController->runExternalAction() @ /system/core/controller.php: 453
cmsController->executeAction() @ /system/core/controller.php: 429