Василий Наумкин

<?php
$q = $modx->newQuery('modResource');
$q->select('id,pagetitle');
$q->where(array('id:!=' => 0, 'pagetitle:!=' => 0));
$q->prepare();
echo $q->toSQL();

SELECT `id`, `pagetitle` FROM `modx_site_content` AS `modResource` WHERE ( `modResource`.`id` != 0 AND `modResource`.`pagetitle` != '0' )

[[pdoSitemap?
    &showLog=`1`
    &forceXML=`0`
]]

[[pdoSitemap]]

&filters=`
	msoption|size,
	msoption|tags
`

@session_write_close();
exit();

root@bezumkin:~# sudo hdparm -Tt /dev/xvda

/dev/xvda:
 Timing cached reads:   19956 MB in  1.98 seconds = 10074.75 MB/sec
 Timing buffered disk reads: 2122 MB in  3.00 seconds = 707.25 MB/sec

[[!pdoResources?
	&parents=`0`
	&includeTVs=`trade_day`
	&where=`["DATE(trade_day) LIKE CURDATE()"]`
	&showLog=`1`
]]