Untitled

SELECT 
    t2.orderdate,
    invoice,
    productcode,
    option1, shippingOption, shippingcountry,
    t1.status,
    itemlocation,
    replace(serialnumber,'s','') as serial,
    t1.notes
FROM
    shipment t1
    join orders t2 on invoice = invoicenum
WHERE
    itemlocation = '10'
       AND LOCATE('transitory_preorder_serial', t1.notes)