SELECT 
    ls.id,
    ls.product_id,
    ls.lot_number,
    ls.serial_number,
    p.name as product_name,
    p.sku as product_sku,
    l.name as location_name,
    ls.manufacture_date,
    ls.expiration_date,
    ls.quantity,
    ls.status,
    ls.created_at
  FROM lot_serial_numbers ls
  LEFT JOIN products p ON ls.product_id = p.id
  LEFT JOIN locations l ON ls.location_id = l.id