I would like to use OR in magento mysql query, I am looking for an equivalent in magento 

`where (is_in_stock=0 and show_in_front=1) and (is_in_stock=1 and show_in_front=1)`

I know following can be used for 'OR', but am not sure how to produce an equiavlent query as above;

```
 ->addAttributeToFilter(
     array(
          'attribute' => 'is_in_stock',
          'eq'      => '0',
     ),

```