Condicionais do addAttributeToFilter
<?php
// Equals:
$_products->addAttributeToFilter('status', array('eq' => 1));
// Not Equals
$_products->addAttributeToFilter('sku', array('neq' => 'test-product'));
// Like
$_products->addAttributeToFilter('sku', array('like' => 'UX%'));
// Not Like
$_products->addAttributeToFilter('sku', array('nlike' => 'err-prod%'));
// In
$_products->addAttributeToFilter('id', array('in' => array(1,4,98)));
//When using in, the value parameter accepts an array of values.
// Not In
$_products->addAttributeToFilter('id', array('nin' => array(1,4,98)));
// NULL
$_products->addAttributeToFilter('description', 'null');
// Not NULL
$_products->addAttributeToFilter('description', 'notnull');
// Greater Than
$_products->addAttributeToFilter('id', array('gt' => 5));
// Less Than
$_products->addAttributeToFilter('id', array('lt' => 5));
// Greater Than or Equals To
$_products->addAttributeToFilter('id', array('gteq' => 5));
// Less Than or Equals To
$_products->addAttributeToFilter('id', array('lteq' => 5));