addTag('node_access');
$query
->join('uc_products', 'p', 'n.vid = p.vid');
$query
->fields('n', array('nid'))
->orderBy('n.changed', 'DESC')
->condition('n.status', '1')
->condition('p.sell_price', '1', '>')
->range(0, 9);
$result = $query->execute();
//$result = db_query_range(db_rewrite_sql('SELECT n.nid FROM {node} n INNER JOIN {uc_products} p ON n.vid = p.vid WHERE n.status = 1 AND p.sell_price > 1 AND NOT EXISTS(SELECT * FROM {term_node} tn WHERE tn.nid = n.nid AND tn.tid = 421) ORDER BY changed DESC'),0,9);
global $in_view;
$in_view = TRUE;
$output = '';
//for ($i = 0; $node = db_fetch_object($result); $i++) {
while($node = $result->fetchAssoc()) {
//$output .= node_view(node_load($node['nid']),TRUE);
$output .= drupal_render(node_view(node_load($node['nid']),'teaser'));
}
print $output . '';
$in_view = FALSE;
?>
