Copyrigth © 2000, 2004, Nederlandse Taalunie and
R.J.J.H. van Son
All materials presented here are licensed under the
GNU General Public License (GPL) unless explicitely stated
otherwise. Please note that these materials are presented WITHOUT ANY WARRANTY.
For information or further details
see the License,
GNU.org, or contact me
at Rob.van.Son@hum.uva.nl.
Use this button to change the query | Use this button to select the speech fragments that were used |
# # COUNT # # Group (rows X columns): # WORDSPHONEME_speaker X Case1 # # Nrows: 60 # # The surfacing of underlying /n/ (N vs Schwa) in # any /@n/ not in a NOUN or VERB in Read speech. (next word does not start with /n/) # Spontaneous combines: # I: Informal # R: retold # # Read combines: # T: text Reading # S: Sentence Reading # PS: Pseudo Sentences # # Counts N Schwa Total F20N 3 7 10 F28G 1 1 2 F40L 1 4 5 F60E 5 9 14 M15R 1 7 8 M40K 0 11 11 M56H 4 5 9 M66O 1 0 1 Total 16 44 60 # # # Nrows: 60 # Table: WORDSPHONEME # Function: COUNT # # Date: Sun Feb 29 13:16:45 2004 # QUERY: # SELECT DISTINCT # WORDSPHONEME.speaker as WORDSPHONEME_speaker, # WORDSPHONEME.ID as COUNTID, # CASE # WHEN CGNPHONEME.value ~ '@n$' THEN TEXT('N') # WHEN CGNPHONEME.value ~ '@$' THEN TEXT('Schwa') # END AS Case1 # FROM # WORDSPHONEME, # TRANSLITPHONEME, # LEXCGNPHONEME, # POSPOS, # CGNPHONEME, # POSSPECPOS, # INTAS915 # WHERE # (CGNPHONEME.id = WORDSPHONEME.id AND # WORDSPHONEME.id = CGNPHONEME.id AND # LEXCGNPHONEME.id = WORDSPHONEME.id AND # WORDSPHONEME.id = LEXCGNPHONEME.id AND # TRANSLITPHONEME.id = WORDSPHONEME.sentenceid AND # WORDSPHONEME.sentenceid = TRANSLITPHONEME.id AND # TRANSLITPHONEME.id = LEXCGNPHONEME.sentenceid AND # LEXCGNPHONEME.sentenceid = TRANSLITPHONEME.id AND # TRANSLITPHONEME.id = CGNPHONEME.sentenceid AND # CGNPHONEME.sentenceid = TRANSLITPHONEME.id AND # POSPOS.id = WORDSPHONEME.id AND # WORDSPHONEME.id = POSPOS.id AND # POSSPECPOS.id = WORDSPHONEME.id AND # WORDSPHONEME.id = POSSPECPOS.id AND # INTAS915.id = TRANSLITPHONEME.id AND # TRANSLITPHONEME.id = INTAS915.id) AND # WORDSPHONEME.ID IS NOT NULL AND # ( POSPOS.value != 'TSW' AND # CGNPHONEME.value ~ '(@|@n)$' AND # WORDSPHONEME.value ~ 'en$' AND # CGNPHONEME.nextvalue !~ '^n' AND # INTAS915.style IN ('T', 'S', 'PS') AND NOT # POSPOS.value IN ('N', 'WW') # ) #