SELECT * FROM Companies WHERE Status>0 and AreaCode = 'ema' ORDER BY LZi