SELECT * FROM JSONParser (
ON json_parser_data_2
TextColumn ('data')
Nodes ('GlossEntry/ID', 'GlossEntry/SortAs', 'GlossEntry/GlossTerm',
'GlossEntry/Acronym', '/email')
SearchPath ('/glossary/GlossDiv/GlossList')
Delimiter (' | ')
Accumulate ('id')
MaxItemNum (10)
) ORDER BY 1, 2;