MYSQL

SELECT t.semtype, s.semtype AS supersemtype FROM fn_semtypes_supers LEFT JOIN fn_semtypes AS t USING (semtypeid) LEFT JOIN fn_semtypes AS s ON (supersemtypeid = s.semtypeid) ORDER BY t.semtype LIMIT 20

semtype	supersemtype
Absolute_direction_orientation	Axis_specified
Accomplishment	Event
Achievement	Event
Activity	Event
Affect_describing	Pragmatic_function
After	Back
Agentive_noun	Biframal_LU
Ahead	Front
Animate_being	Living_thing
Artifact	Physical_object
Attribute	Ontological_type
Auditory_modality	Sensory_modality
Axis_specified	LU_with_FE_specified
Back	Front_back
Biframal_LU	Lexical_type
Body_of_water	Region
Body_part	Physical_object
Bottom	Landmark_based_orientation
Bound_dependent_LU	Bound_LU
Bound_LU	Lexical_type

SELECT s.semtype, GROUP_CONCAT(t.semtype) AS subsemtypes FROM fn_semtypes_supers LEFT JOIN fn_semtypes AS t USING (semtypeid) LEFT JOIN fn_semtypes AS s ON (supersemtypeid = s.semtypeid) GROUP BY s.semtype ORDER BY s.semtype LIMIT 20

semtype	subsemtypes
Absolute_direction_orientation	Downward,Upward,Not_up_or_down,Cardinal
Affect_describing	Negative_judgment,Positive_judgment
Animate_being	Sentient
Artifact	Structure
Attribute	Manner,Temperature,Speed,Quantity,Degree,Duration,Shape
Axis_specified	Motion_based_orientation,Absolute_direction_orientation,Near_absolute_orientation,Viewpoint_based_orientation,Flexible_orientation
Back	Landmark_back,After
Biframal_LU	Tendency_grading_LU,Agentive_noun,Guest_LU,Participating_entity,End_state_LU
Body_of_water	Running-water
Bound_LU	Support,Bound_dependent_LU
Cardinal	North,South,East,West
Event	Accomplishment,Intentional_act,Achievement,Activity
Flexible_orientation	Landmark_based_orientation,Front_back,Vertical,Lateral
Framal_type	Non-Lexical Frame,Non-perspectivalized_frame
Front	Landmark_front,Ahead
Front_back	Back,Front
Group	Organization
Intentional_act	Human_act
Landmark_based_orientation	Bottom
Lateral	Rightish,Leftish

SELECT semtype, COUNT(*) FROM fn_frames_semtypes LEFT JOIN fn_semtypes USING (semtypeid) GROUP BY semtypeid ORDER BY semtype

semtype	COUNT(*)
Activity	1
Artifact	5
End_of_scale	1
Event	1
Human	1
Locative_relation	8
Negative	3
Non-Lexical Frame	135
Non-perspectivalized_frame	38
Physical_object	1
State	2
Transparent Noun	16
Visual_modality	1

SELECT frame,GROUP_CONCAT(semtype) FROM fn_frames_semtypes LEFT JOIN fn_frames USING (frameid) LEFT JOIN fn_semtypes USING (semtypeid) WHERE semtypeid IS NOT NULL GROUP BY frame ORDER BY frame LIMIT 32,20

frame	GROUP_CONCAT(semtype)
Chatting	Human
Chemical_potency	Non-Lexical Frame
Clothing	Artifact
Clothing_parts	Artifact
Collocation_image_schema	Non-Lexical Frame
Commerce_goods-transfer	Non-Lexical Frame
Commerce_money-transfer	Non-Lexical Frame
Commerce_scenario	Non-perspectivalized_frame
Condition_symptom_relation	Non-perspectivalized_frame
Conditional_scenario	Non-Lexical Frame
Connecting_architecture	Transparent Noun
Connectors	Artifact
Contact_image_schema	Non-Lexical Frame
Container_focused_placing	Non-Lexical Frame
Container_focused_removing	Non-Lexical Frame
Containers	Artifact
Containment_scenario	Non-Lexical Frame,Non-perspectivalized_frame
Crime_scenario	Non-Lexical Frame
Criminal_process	Non-Lexical Frame
Cycle_of_existence_scenario	Non-Lexical Frame

SELECT semtype, COUNT(*) FROM fn_fes_semtypes LEFT JOIN fn_semtypes USING (semtypeid) GROUP BY semtypeid ORDER BY semtype

semtype	COUNT(*)
Activity	1
Animate_being	1
Artifact	23
Body_part	21
Container	3
Content	26
Degree	375
Duration	186
Event	10
Goal	93
Group	8
Human	53
Human_act	14
Living_thing	4
Location	68
Locative_relation	577
Manner	543
Message	23
Organization	1
Path	5
Physical_entity	118
Physical_object	81
Quantity	13
Sentient	612
Source	108
Speed	50
State	5
State_of_affairs	975
Temperature	6
Time	626

SELECT frame,fetype,semtype FROM fn_frames LEFT JOIN fn_fes USING (frameid) LEFT JOIN fn_fetypes USING (fetypeid) LEFT JOIN fn_fes_semtypes USING (feid) LEFT JOIN fn_semtypes USING (semtypeid) WHERE frame='Causation' ORDER BY feid

frame	fetype	semtype
Causation	Cause
Causation	Affected
Causation	Effect
Causation	Place	Locative_relation
Causation	Time	Time
Causation	Actor	Sentient
Causation	Circumstances
Causation	Manner
Causation	Explanation	State_of_affairs
Causation	Means
Causation	Frequency
Causation	Concessive

SELECT frame,fetype,GROUP_CONCAT(semtype) FROM fn_fes LEFT JOIN fn_frames USING(frameid) LEFT JOIN fn_fetypes USING(fetypeid) LEFT JOIN fn_fes_semtypes USING(feid) LEFT JOIN fn_semtypes USING (semtypeid) WHERE feid IN (SELECT feid FROM fn_fes_semtypes GROUP BY feid HAVING COUNT(*) > 1) GROUP BY frameid,feid

frame	fetype	GROUP_CONCAT(semtype)
Arranging	Location	Location,Goal
Defending	Assailant	Sentient,Source

SELECT frame,fetype,semtype FROM fn_fes LEFT JOIN fn_frames USING(frameid) LEFT JOIN fn_fetypes USING(fetypeid) LEFT JOIN fn_fes_semtypes USING(feid) LEFT JOIN fn_semtypes USING (semtypeid) WHERE semtype = 'Sentient' LIMIT 20

frame	fetype	semtype
Communication	Communicator	Sentient
Communication	Addressee	Sentient
Perception	Perceiver	Sentient
Transitive_action	Agent	Sentient
Duplication	Creator	Sentient
Feigning	Agent	Sentient
Cause_to_amalgamate	Agent	Sentient
Separating	Agent	Sentient
Body_movement	Agent	Sentient
Body_movement	Addressee	Sentient
Manipulation	Agent	Sentient
Posture	Agent	Sentient
Awareness	Cognizer	Sentient
Becoming_aware	Cognizer	Sentient
Categorization	Cognizer	Sentient
Cogitation	Cognizer	Sentient
Coming_to_believe	Cognizer	Sentient
Differentiation	Cognizer	Sentient
Expectation	Cognizer	Sentient
Coming_up_with	Cognizer	Sentient

SELECT frame,fetype,semtype FROM fn_fes LEFT JOIN fn_frames USING(frameid) LEFT JOIN fn_fetypes USING(fetypeid) LEFT JOIN fn_fes_semtypes USING(feid) LEFT JOIN fn_semtypes USING (semtypeid) WHERE semtype = 'Human' LIMIT 20

frame	fetype	semtype
Wealthiness	Person	Human
Examination	Examiner	Human
Body_description_holistic	Individual	Human
People	Person	Human
Body_decoration	Decorated_individual	Human
Body_description_part	Individual	Human
Employment_scenario	Employee	Human
Social_interaction_evaluation	Evaluee	Human
Social_behavior_evaluation	Individual	Human
Collaboration	Partner_1	Human
Collaboration	Partner_2	Human
Collaboration	Partners	Human
Forming_relationships	Partner_1	Human
Forming_relationships	Partner_2	Human
Forming_relationships	Partners	Human
People_by_age	Person	Human
People_by_origin	Person	Human
People_by_religion	Person	Human
People_by_jurisdiction	Person	Human
Heralding	Individual	Human