select distinct gyms_topics.gym_id as gym_id,
                                  question_history_data.uuid,
                                  question_history_data.knowledge_points_acquired,
                                  question.score_points,
                                  question_history_data.last_date
                  from learning.question question
                           join learning.topic topic on topic.id = question.topic_id
                           join learning.gyms_topics gyms_topics
                                on gyms_topics.topic_id = topic.id
                           left join
                       (select question_last_answer.uuid, question_last_answer.last_date, question_last_answer.knowledge_points_acquired, question_last_answer.topic_id_2
                        from learning.question question_with_history
                                 join (select question.uuid, max(answer_history.end_date) as last_date,topic_id_result.topic_id as topic_id_2,answer_history.knowledge_points_acquired
                                       from learning.question question
                                                join learning.answer_history answer_history
                                                     on answer_history.question_id = question.id
                                                join
                                            (SELECT distinct topic.id as topic_id
                                             from learning.gyms_topics gyms_topics
                                                      left join learning.topic topic on topic.id = gyms_topics.topic_id
                                             where (topic.parent_id is not null or topic.id not in
                                                                                   (select topic.id
                                                                                    from learning.topic topic
                                                                                             left join learning.topic subtopic on subtopic.parent_id = topic.id
                                                                                             left join learning.gyms_topics gyms_topics on gyms_topics.topic_id = topic.id
                                                                                    where gyms_topics.gym_id in (:gymIds)
                                                                                    group by topic.id
                                                                                    having count(subtopic.id) > 0)
                                                 )
                                               and topic.status in (:topicStatuses)
                                               and gyms_topics.gym_id in (:gymIds)) as topic_id_result on question.topic_id = topic_id_result.topic_id
                                       where answer_history.account_id = :accountId
                                         and answer_history.state in (:historyStates)
                                         and answer_history.end_date >= :forgettingDate
                                       group by question.uuid, topic_id_2,knowledge_points_acquired) as question_last_answer
                                      on question_with_history.uuid = question_last_answer.uuid
                       ) as question_history_data on question_history_data.uuid = question.uuid
                  where question.topic_id = question_history_data.topic_id_2
                    and question.status in (:questionStatuses)
                    and gyms_topics.gym_id in (:gymIds) order by question_history_data.uuid