[Monrezz]

SELECT item FROM merchantlist WHERE merchantid = <your_merchant_id>;

I think he was asking for a complete list of items on Merchants in EQLive, not an SQL statement to list the items on merchants on his Emu server.

Monrezz