SELECT DISTINCT ON ( lower(f_unaccent(orders_view.metadata->>'poNumber')) , lower(f_unaccent(metadata->>'poNumber'))) jsonb FROM diku_mod_orders_storage.orders_view  WHERE (lower(f_unaccent(orders_view.metadata->>'workflowStatus')) LIKE lower(f_unaccent('Open'))) OR (lower(f_unaccent(orders_view.metadata->>'workflowStatus')) LIKE lower(f_unaccent('Pending'))) ORDER BY lower(f_unaccent(orders_view.metadata->>'poNumber')) DESC LIMIT 10 OFFSET 0