[[+publishedon:date=`%d.%m.%Y`]]

[[+publishedon:strtotime:date=`%d.%m.%Y`]]

$(document).on('click', 'a.pagin', function(e) {
	e.preventDefault();
	var url = $(this).attr('href').replace("get?page=","");
	jQuery(function($){
        $('#results').load('[[~43]]', {
            action: 'field33',
            parents: '3',
            page: url,
            limit: '10',
           });
});

if (empty($parent)) {$parent = $modx->resource->id;}

$pids = array_merge(array($parent), $modx->getChildIds($parent));
$ids = array();

$q = $modx->newQuery('msProduct');
$q->where(array('class_key' => 'msProduct','parent:IN' => $pids,'published' => 1,'deleted' => 0));
$q->select('`msProduct`.`id`');
if ($q->prepare() && $q->stmt->execute()) {
	$ids = $q->stmt->fetchAll(PDO::FETCH_COLUMN);
}

$q = $modx->newQuery('msProduct');
$q->leftJoin('msCategoryMember', 'msCategoryMember', '`msCategoryMember`.`product_id` = `msProduct`.`id`');
$q->where(array('class_key' => 'msProduct','msCategoryMember.category_id:IN' => $pids,'published' => 1,'deleted' => 0));
$q->select('`msProduct`.`id`');
if ($q->prepare() && $q->stmt->execute()) {
	$ids2 = $q->stmt->fetchAll(PDO::FETCH_COLUMN);
	if (!empty($ids2)) {
		$ids = array_unique(array_merge($ids, $ids2));
	}
}

return count($ids);

<script type="text/javascript" language="JavaScript">
jQuery(function($){
        $('#results').load('[[~43]]', {
            action: 'field33',
            parents: '3',
            limit: '3',
            offset: '3'
            //where: '{"Data.favorite":"1"}'
             });
});
</script>
           <div id="results"></div>

<?php
if ($_SERVER['HTTP_X_REQUESTED_WITH'] != 'XMLHttpRequest') {return;}
$action = $_POST['action'];
if (empty($action)) {return;}
$res = '';
switch ($action) {
      case 'field33':     
        $param = array(
        'element' => 'msProducts',
        'offset' => (int)$_POST['offset'],
        'limit' => (int)$_POST['limit'],
        'depth' => $depth,
        'parents' => (int)$_POST['parent'],
        'includeContent'=> $includeContent,
        'tpl'=> $tpl,
        'outputSeparator'=> $outputSeparator,
        'showUnpublished'=> $showUnpublished,
        'showDeleted'=> $showDeleted,
        'showHidden'=> $showHidden
         );
         $documents = $modx->runSnippet('getPageExt',$param);
         return $documents;
}