magento stock sql
<pre><code>SELECT sku, qty FROM `cataloginventory_stock_item` i join `catalog_product_entity` e on i.product_id = e.entity_id where i.qty &lt;= 100 and i.is_in_stock 
</code></pre>

<p>I want a query which get the product <code>sku</code>, <code>supplier_barcode</code>, 
<code>supplier_sku</code> where stock less then 100.
<code>supplier_barcode</code>, <code>supplier_sku</code> are custom attribute.</p>

<p>above query just giving <code>sku</code>,<code>qty</code> <code>where qty &lt;=100</code></p>