WITH recursive parts_tree_0 AS
(
           SELECT     parts_4.*
           FROM       parts     AS parts_4
           INNER JOIN synrestrs AS synrestrs_5
           ON         synrestrs_5.part_id = parts_4.part_id
           WHERE      synrestrs_5.synrestr = "adjp"
), synrestrs_tree_0 AS
(
       SELECT synrestrs_8.*
       FROM   synrestrs AS synrestrs_8
       WHERE  synrestrs_8.synrestr = "genitive"
)
SELECT     words_0.word_id,
           words_0.notion_id,
           words_0.lemma_id,
           words_0.tag_count,
           words_0.POSITION,
           words_0.group_id
FROM       words  AS words_0
INNER JOIN frames AS frames_1
ON         frames_1.group_id = words_0.group_id
INNER JOIN parts AS parts_2
ON         parts_2.frame_id = frames_1.frame_id
INNER JOIN frames AS frames_3
ON         frames_3.frame_id = parts_2.frame_id
LEFT JOIN  parts_tree_0 AS parts_tree_0_4
ON         parts_tree_0_4.frame_id = frames_3.frame_id
INNER JOIN parts AS parts_6
ON         parts_6.frame_id = frames_1.frame_id
INNER JOIN parts AS parts_7
ON         parts_7.frame_id = frames_1.frame_id
LEFT JOIN  synrestrs_tree_0 AS synrestrs_tree_0_8
ON         synrestrs_tree_0_8.part_id = parts_7.part_id
INNER JOIN notions AS notions_9
ON         notions_9.notion_id = words_0.notion_id
INNER JOIN lemmas_forms AS lemmas_forms_10
ON         lemmas_forms_10.lemma_id = words_0.lemma_id
INNER JOIN forms AS forms_11
ON         forms_11.form_id = lemmas_forms_10.form_id
INNER JOIN lemmas_forms AS lemmas_forms_12
ON         lemmas_forms_12.form_id = forms_11.form_id
WHERE      words_0.tag_count >= 10
AND        frames_1.LENGTH >= 2
AND        parts_2.TYPE = 0
AND        parts_2.ROLE = "Agent"
AND        parts_tree_0_4.frame_id IS NULL
AND        parts_2.part_index = 0
AND        parts_6.TYPE = 1
AND        parts_6.part_index = 1
AND        parts_7.TYPE = 0
AND        (
                      parts_7.ROLE = "Patient"
           OR         parts_7.ROLE = "Experiencer")
AND        synrestrs_tree_0_8.part_id IS NULL
AND        parts_7.part_index = 2
AND        notions_9.part_of_speech = 3
AND        lemmas_forms_12.category = 5
ORDER BY   random() LIMIT 1