Untitled

SELECT 
    serialnumber,
    product,
    size,
    bin,
    location,
    lastscandate,
    SUBSTRING_INDEX(locationhistory, ']', 1) lasttouch
FROM
    inventoryitem
WHERE
    serialnumber IN ('216882243' , '247262756',
        '198532103',
        '198532091',
        '176855675',
        '243953521',
        '243310336',
        '243314361',
        '243310411',
        '243310376')
        order by lastscandate desc