SQL error!

SELECT * FROM `smoo_brand` WHERE `delete`= 0 order by pos, id