qwe

SELECT DISTINCT COUNT(DISTINCT `questionnaire_answer_set_answers`.`id`) 
FROM `questionnaire_answer_set_answers` 
  INNER JOIN `questionnaire_answer_set_answers_question_answer_options` 
    ON `questionnaire_answer_set_answers_question_answer_options`.`answer_id` = `questionnaire_answer_set_answers`.`id` 
  INNER JOIN `questionnaire_question_answer_options` 
    ON `questionnaire_question_answer_options`.`id` = `questionnaire_answer_set_answers_question_answer_options`.`answer_option_id` 
  LEFT OUTER JOIN `questionnaire_question_answer_option_translations` 
    ON `questionnaire_question_answer_option_translations`.`questionnaire_question_answer_option_id` = `questionnaire_question_answer_options`.`id` 
WHERE `questionnaire_answer_set_answers`.`question_id` = 23 
  AND `questionnaire_answer_set_answers`.`answer_set_id` IN (

    SELECT `questionnaire_answer_sets`.`id` 
    FROM `questionnaire_answer_sets` 
      JOIN questionnaires q 
        ON questionnaire_answer_sets.questionnaire_id = q.id 
      LEFT JOIN product_variants pv 
        ON pv.id = q.product_variant_id 
    WHERE (pv.product_id = 1 OR questionnaire_answer_sets.questionnaire_id IN (4)) 
    AND (`questionnaire_answer_sets`.`questionnaire_id` NOT IN (

      SELECT `questionnaires`.`id` 
      FROM `questionnaires`
        WHERE `questionnaires`.`questionnairable_type` = 'Account' 
        AND `questionnaires`.`questionnairable_id` IN (
          SELECT `accounts`.`id` 
          FROM `accounts` 
            WHERE (id IN (5) OR root_id IN (5))) 
            AND `questionnaires`.`product_variant_id` = 2)) 
            AND (questionnaire_answer_sets.created_at <= '2016-06-30')) 
            AND (questionnaire_question_answer_option_translations.locale = 'de') 
            AND (CAST(label AS UNSIGNED) >= 9)