$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');

<?php
$tvid = 1; // id нужного ТВ параметра
$res = array(); // Сюда забиваем результаты

$q = $modx->newQuery('modTemplateVarResource', array('tmplvarid' => $tvid));
$q->select('contentid,value');
if ($q->prepare() && $q->stmt->execute()) {
	while ($row = $q->stmt->fetch(PDO::FETCH_ASSOC)) {
		$res[$row['contentid']] = $row['value'];
	}
}
print_r($res);

$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>'; }

/*
	Ext.apply(this, {
		activeTab: 0
		,stateful: true
		,stateId: \'modx-user-tabs\'
		,stateEvents: [\'tabchange\']
		,getState: function() {
			return {
				activeTab:this.items.indexOf(this.getActiveTab())
			};
		}
	});
*/

if ($modx->event->name == 'OnManagerPageBeforeRender') {

	$controller->Extras = $Extras = $modx->getService('extras','Extras', MODX_CORE_PATH . 'components/extras/model/extras/', array());

	$controller->addLexiconTopic('extras:default');
	//$controller->addJavascript($this->modx->getOption('manager_url',null,MODX_MANAGER_URL).'assets/modext/util/datetime.js');
	$controller->addJavascript($Extras->config['jsUrl'].'mgr/extras.js');
	$controller->addJavascript($Extras->config['jsUrl'].'misc/extras.combo.js');
	$controller->addJavascript($Extras->config['jsUrl'].'mgr/widgets/key/keys.grid.js');
	$controller->addJavascript($Extras->config['jsUrl'].'mgr/widgets/extras.tree.js');
	$controller->addCss($Extras->config['cssUrl'].'mgr/main.css');

	$scripts = array(
		'head' => '
			Extras.config = '.$modx->toJSON($Extras->config).';
			Extras.config.connector_url = "'.$Extras->config['connectorUrl'].'";
		'
		,'tree' => $modx->hasPermission('extras_tree')
			? '
			Ext.ComponentMgr.onAvailable(\'modx-leftbar-tabpanel\', function() {
				this.on(\'beforerender\', function() {
					this.add({
						title: _(\'extras_packages\')
						,xtype: \'extras-tree-extras\'
						,id: \'extras-tree-extras\'
					});
				});
			});
			'
			: ''
		,'user' => '
			Ext.ComponentMgr.onAvailable(\'modx-user-tabs\', function() {
			/*
				Ext.apply(this, {
					activeTab: 0
					,stateful: true
					,stateId: \'modx-user-tabs\'
					,stateEvents: [\'tabchange\']
					,getState: function() {
						return {
							activeTab:this.items.indexOf(this.getActiveTab())
						};
					}
				});
			*/
				this.on(\'beforerender\', function() {
					this.add({
						title: _(\'extras_keys\')
						,xtype: \'extras-panel-keys\'
						,id: \'extras-panel-keys\'
					});
				});
			});
		'
		,'permissions' => $modx->hasPermission('extras_repository_new')
			? 'MODx.perm.extras_repository_new = true;'
			: ''
	);

	$controller->addHtml('<script type="text/javascript">'.implode("\n", $scripts).'</script>');
}