So items are in the table named

item

. Here's a simple query:

SELECT id, itemid, fullname, displayname, description, isinactive FROM item