Post 11 --- Code 2

/* With the item name: */
SELECT id, name, displayid FROM item_template WHERE entry = putItemEntryIDHere;
SELECT id, name, displayid FROM item_template WHERE entry BETWEEN putLowerItemEntryIDHere AND putHigherItemEntryIDHere;
/* Without the item name: */
SELECT id, displayid FROM item_template WHERE entry = putItemEntryIDHere;
SELECT id, displayid FROM item_template WHERE entry BETWEEN putLowerItemEntryIDHere AND putHigherItemEntryIDHere;