SELECT FLD_SELLWHO AS FLD_CHARACTER,
FLD_ITEM_MAKEINDEX AS FLD_MAKEINDEX, FLD_ITEM_INDEX AS FLD_INDEX,
FLD_ITEM_DURA AS FLD_DURA, FLD_ITEM_DURAMAX AS FLD_DURAMAX,
FLD_ITEM_DESC0 AS FLD_DESC0, FLD_ITEM_DESC1 AS FLD_DESC1,
FLD_ITEM_DESC2 AS FLD_DESC2, FLD_ITEM_DESC3 AS FLD_DESC3,
FLD_ITEM_DESC4 AS FLD_DESC4, FLD_ITEM_DESC5 AS FLD_DESC5,
FLD_ITEM_DESC6 AS FLD_DESC6, FLD_ITEM_DESC7 AS FLD_DESC7,
FLD_ITEM_DESC8 AS FLD_DESC8, FLD_ITEM_DESC9 AS FLD_DESC9,
FLD_ITEM_DESC10 AS FLD_DESC10, FLD_ITEM_DESC11 AS FLD_DESC11,
FLD_ITEM_DESC12 AS FLD_DESC12, FLD_ITEM_DESC13 AS FLD_DESC13,
FLD_ITEM_LEVELR AS FLD_COLORR,
FLD_ITEM_AMOUNTGB % 256 AS FLD_COLORG,
FLD_ITEM_AMOUNTGB / 256 AS FLD_COLORB,
FLD_ITEM_PREFIX AS FLD_NAMEPREFIX, 3 AS TYPE
FROM TBL_ITEMMARKET
WHERE FLD_SELLOK = 0