Николай

$sql = "SELECT * FROM {$modx->getTableName('tablename')} LIMIT 1000";
$q = $modx->prepare($sql);
$q->execute();
$res = $q->fetchAll(PDO::FETCH_ASSOC);

foreach ($res as $v) {
    echo $v['createdon'];
}

$q = $modx->newQuery('modResource');
$q->where(array('id:>' => 0));
$q->limit('100');
if ($q->prepare() && $q->stmt->execute()) {
    $arr = $q->stmt->fetchAll(PDO::FETCH_ASSOC);
}
getStatus('Выборка '.count($arr).' ресурсов через xPDO');

$mass = explode(',', $idsx);

$result = array();

for ($i=0; $i<count($mass); $i++) {
$page = $modx->getObject('modResource', $mass[$i]);
array_push($result, $page->getTVValue('goodsx')); }

$result = array_values(array_unique($result));

for ($i = 0; $i<count($result); $i++) {
echo '<option value="'.$result[$i].'">'.$result[$i].' см</option>'; }

&excludeTVList=`4,2`
					&includeTVs=`1`
					&includeMS=`1`
&tpl=`goods-item`
                    &includeTVList=`goods.x,goods.y,goods.z,goodimage`

[[[[*id:isnot=`[[++site_start]]`:then=`$Breadcrumb`:else=`--`]]]]

[[$Content]]