- $sSQL = 'SELECT word_id, class, type FROM word ';
- $sSQL .= ' WHERE word_token = \' \' || :term';
- $sSQL .= ' AND class is not null AND class not in (\'place\')';
+ $sSQL = "SELECT word_id, info->>'class' as class, info->>'type' as type ";
+ $sSQL .= ' FROM word WHERE word_token = :term and type = \'S\'';