SELECT 
  item.itemid AS itemidRAW /*{itemid#RAW}*/
FROM 
  item
WHERE 
  UPPER(item.itemtype) IN ('INVTPART')
ORDER BY 
  item.itemid ASC NULLS LAST