SELECT DISTINCT e.rowid as e_rowid, e.ref as e_ref, p.rowid as p_rowid, p.ref as p_ref, p.label as p_label, ps.reel as ps_reel FROM llx_product as p LEFT JOIN llx_product_extrafields as extra ON extra.fk_object = p.rowid, llx_product_stock as ps, llx_entrepot as e WHERE p.rowid = ps.fk_product AND ps.fk_entrepot = e.rowid AND e.entity IN (1) and e.rowid=1 and ps.reel>0

http://dolierp.consolux.fr/htdocs/cron/list.php?status=-2&leftmenu=admintools&idmenu=8