Сергей Шлоков

[[*pagetitle:declension=`{"gender":"men", "padej":"rod", "chislo":"edin"}`]]

Всю ночь на это убил. Ничего не получается.

if (empty($timestamp)) {
	$query = $modx->newQuery('TicketThread', array('resource' => $page));
	$query->select('comments');
	return $modx->getValue($query->prepare());
} else {
	$q = $modx->newQuery('TicketComment');
	$q->innerJoin('TicketThread','Thread', "TicketComment.thread = Thread.id AND Thread.resource = {$page}");
	$q->select('TicketComment.id');
	$q->where('TicketComment.createdon > Thread.comment_time');
	if ($q->prepare() && $q->stmt->execute()) {
		return $q->stmt->rowCount();
	}
}

вылаживаю мой рабочий вариант

$q = $modx->prepare("SELECT * FROM modx_tickets_comments WHERE thread = '{$thread}' AND createdon > '{$timestamp}' AND published = 1");
$q->execute();
$r = $q->fetchAll(PDO::FETCH_ASSOC);
return count($r);

return $modx->getCount('TicketComment', array('thread'=>$thread, 'createdon:>'=>$timestamp, 'published'=>1));