BEGIN
    DROP TABLE IF EXISTS tmp, tmp2, tmp3;

    CREATE TEMPORARY TABLE tmp (KEY (similarity))
        SELECT
            id, similarity
        FROM (
            SELECT
                id,
                PHRASE_SIMILARITY(pure_phrase, question) AS similarity
            FROM
                phrases_ids
        ) AS t
        WHERE
            similarity >= trashold;

    CREATE TEMPORARY TABLE tmp2 (KEY (similarity))
    SELECT
        *
    FROM
        tmp;


    SELECT
        GROUP_CONCAT(phrases.id SEPARATOR '$SEP;') AS answers,
        tmp3.id AS q_id
    FROM
        phrases_ids AS phrases,
        (
            SELECT
                id
            FROM
                tmp
            WHERE (
                similarity = (
                    SELECT
                        MAX(similarity)
                    FROM
                        tmp2
                )
            )
        ) AS tmp3
    WHERE
        phrases.id IN (
            SELECT
                answer_id
            FROM
                question_answer
            WHERE
                question_id = tmp3.id
        );

END