SELECT 
    'P' AS orderid1,
    orders.orderid AS orderid2, 
    orders.orderid AS orderid3, 
    'M' AS quantity, 
    'M' AS qtyonhold, 
    '0' AS qtyshipped, 
    CONCAT(orders.ShipFirstName, ' ', orders.ShipLastName) AS toname, 
    CONCAT('*', orders.orderid, '*') AS barcode, 
    orders.shippingmethodid, 
    CONCAT(orders.ShipFirstName, ' ', orders.ShipLastName) AS toname2, 
    NOW() AS shipdate, 
    orders.orderid AS orderid4,
    orders.orderid AS orderid5, 
    'M' AS multi
FROM 
    orders
WHERE 
    orders.BatchNumber = 23078
ORDER BY 
    orders.orderid