'TemplateVarResources.value:NOT LIKE' => '%valuetest%'

<?php

$q = $modx->newQuery('modResource');
$q->where(array(
    "pagetitle:not like"    => 'sdf',
));

$q->prepare();
print $q->toSQL();