SELECT wo.id, wo.wo_number, p.name as product_name, wo.quantity, wo.start_date, wo.end_date,
   wo.status, wo.priority, wo.created_at
   FROM work_orders wo
   LEFT JOIN products p ON wo.product_id = p.id