Может кто может помочь с запросом?

{var $conf = [
	'groups' => 'buyer',
	'tpl' => 'tplChatName'
	'leftJoin' => '{
	    "View": {
            "class": "TicketView",
            "on": "modUserProfile.internalKey = View.uid"
        },
        "Thread": {
            "class": "TicketThread",
            "on": "View.thread = Thread.id AND Thread.name = \'chat-23\'"
        },
        "Comment": {
            "class": "TicketComment",
            "on": "Thread.id = Comment.thread AND Comment.createdon > View.timestamp AND Comment.email != modUserProfile.email"
        }
    }',
    'select' => '{
        "modUser":"modUser.id",
        "modUserProfile":"modUserProfile.fullname",
        "Comment": "COUNT(Comment.id) as count"
    }'
]}
{$_modx->runSnippet('!pdoUsers', $conf)}