Corpse blob loot items

/*
@ItemNo is zero based for this sample code.
aka first item on the corpse (95 + 1) is @ItemNo = 0
ServerLootItem_Struct
*/
SET @ItemNo = 0;
SET @ItemOffset = (@ItemNo * 29);
SELECT id,
    ASCII(SUBSTRING(DATA, (5 + 1) + 0, 1))
            + 256 * ASCII(SUBSTRING(DATA, (5 + 1) + 1, 1))
            + (256 * 256) * ASCII(SUBSTRING(DATA, (5 + 1) + 2, 1))
            + (256 * 256 * 256) * ASCII(SUBSTRING(DATA, (5 + 1) + 3, 1))  AS BlobValue_ItemCount,
    ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 0, 1))
            + 256 * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 1, 1))
            + (256 * 256) * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 2, 1))
            + (256 * 256 * 256) * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 3, 1)) AS BlobValue_item_id,
    ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 4, 1))
            + 256 * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 5, 1)) AS BlobValue_equipSlot,
    ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 6, 1)) AS BlobValue_Charges,
    ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 7, 1))
            + 256 * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 8, 1))  AS BlobValue_lootslot,
    ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 9, 1))
            + 256 * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 10, 1))
            + (256 * 256) * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 11, 1))
            + (256 * 256 * 256) * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 12, 1)) AS BlobValue_aug1,
    ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 13, 1))
            + 256 * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 14, 1))
            + (256 * 256) * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 15, 1))
            + (256 * 256 * 256) * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 16, 1)) AS BlobValue_aug2,
    ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 17, 1))
            + 256 * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 18, 1))
            + (256 * 256) * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 19, 1))
            + (256 * 256 * 256) * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 20, 1)) AS BlobValue_aug3,
    ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 21, 1))
            + 256 * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 22, 1))
            + (256 * 256) * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 23, 1))
            + (256 * 256 * 256) * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 24, 1)) AS BlobValue_aug4,
    ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 25, 1))
            + 256 * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 26, 1))
            + (256 * 256) * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 27, 1))
            + (256 * 256 * 256) * ASCII(SUBSTRING(DATA, (95 + @ItemOffset + 1) + 28, 1)) AS BlobValue_aug5
FROM player_corpses
WHERE charid = 118907
ORDER BY id;