-- กลุ่มที่ 33
SELECT sub.lab_items_sub_group_code AS group_id, item.lab_items_name, item.display_order
FROM lab_items_sub_group_list sub
INNER JOIN lab_items item ON item.lab_items_code = sub.lab_items_code
WHERE sub.lab_items_sub_group_code = '33'

UNION ALL

-- กลุ่มที่ 43
SELECT sub.lab_items_sub_group_code AS group_id, item.lab_items_name, item.display_order
FROM lab_items_sub_group_list sub
INNER JOIN lab_items item ON item.lab_items_code = sub.lab_items_code
WHERE sub.lab_items_sub_group_code = '43'

UNION ALL

-- กลุ่มที่ 98
SELECT sub.lab_items_sub_group_code AS group_id, item.lab_items_name, item.display_order
FROM lab_items_sub_group_list sub
INNER JOIN lab_items item ON item.lab_items_code = sub.lab_items_code
WHERE sub.lab_items_sub_group_code = '98'

ORDER BY group_id, display_order;