| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 95605 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 95605) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2846251'))))) OR (((`item_id2` = 95605) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2846251'))))) OR (((`item_id3` = 95605) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2846251')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Item`.* FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` INNER JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`QuestionnaireItem`.`item_id`=`Item`.`id`) WHERE `QuestionnaireItem`.`questionnaire_id` = 51253 | 1 | 1 | 0 | |
| SELECT `Campaign`.`id`, `Campaign`.`item_id`, `Campaign`.`campaign_price`, `Campaign`.`created`, `Campaign`.`modified` FROM `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` WHERE `item_id` = 92550 ORDER BY `Campaign`.`created` desc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92550) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25326G9'))))) OR (((`item_id2` = 92550) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25326G9'))))) OR (((`item_id3` = 92550) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25326G9')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 92550 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 92550) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = '25326G9'))))) OR (((`item_id2` = 92550) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = '25326G9'))))) OR (((`item_id3` = 92550) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = '25326G9')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Item`.* FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` INNER JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`QuestionnaireItem`.`item_id`=`Item`.`id`) WHERE `QuestionnaireItem`.`questionnaire_id` = 51217 | 1 | 1 | 0 | |
| SELECT `Campaign`.`id`, `Campaign`.`item_id`, `Campaign`.`campaign_price`, `Campaign`.`created`, `Campaign`.`modified` FROM `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` WHERE `item_id` = 97808 ORDER BY `Campaign`.`created` desc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97808) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2375031'))))) OR (((`item_id2` = 97808) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2375031'))))) OR (((`item_id3` = 97808) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2375031')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 97808 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 97808) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2375031'))))) OR (((`item_id2` = 97808) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2375031'))))) OR (((`item_id3` = 97808) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2375031')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Item`.* FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` INNER JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`QuestionnaireItem`.`item_id`=`Item`.`id`) WHERE `QuestionnaireItem`.`questionnaire_id` = 51174 | 1 | 1 | 0 | |
| SELECT `Campaign`.`id`, `Campaign`.`item_id`, `Campaign`.`campaign_price`, `Campaign`.`created`, `Campaign`.`modified` FROM `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` WHERE `item_id` = 91405 ORDER BY `Campaign`.`created` desc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91405) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1204-009'))))) OR (((`item_id2` = 91405) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1204-009'))))) OR (((`item_id3` = 91405) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1204-009')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaire_items` AS `QuestionnaireItem` LEFT JOIN `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` ON (`QuestionnaireItem`.`questionnaire_id` = `Questionnaire`.`id`) WHERE `QuestionnaireItem`.`item_id` = 91405 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 91405) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'TR-1204-009'))))) OR (((`item_id2` = 91405) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'TR-1204-009'))))) OR (((`item_id3` = 91405) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'TR-1204-009')))))) ORDER BY `issue_date` desc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Category`.`id`, `Category`.`category_name` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2025-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2025-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2025-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2025-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2025-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2025-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2025-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2025-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2025-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2025-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2025-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2025-02-28 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2025-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2025-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2024-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2024-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2024-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2024-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2024-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2024-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2024-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2024-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2024-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2024-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2024-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2024-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2024-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2024-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2024-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2024-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2024-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2024-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2024-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2024-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2024-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2024-02-29 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2024-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2024-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2023-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2023-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2023-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2023-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2023-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2023-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2023-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2023-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2023-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2023-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2023-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2023-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2023-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2023-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2023-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2023-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2023-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2023-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2023-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2023-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2023-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2023-02-28 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2023-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2023-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2022-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2022-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2022-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2022-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2022-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2022-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2022-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2022-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2022-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2022-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2022-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2022-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2022-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2022-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2022-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2022-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2022-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2022-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2022-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2022-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2022-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2022-02-28 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2022-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2022-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2021-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2021-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2021-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2021-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2021-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2021-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2021-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2021-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2021-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2021-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2021-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2021-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2021-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2021-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2021-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2021-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2021-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2021-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2021-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2021-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2021-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2021-02-28 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2021-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2021-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2020-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2020-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2020-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2020-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2020-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2020-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2020-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2020-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2020-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2020-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2020-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2020-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2020-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2020-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2020-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2020-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2020-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2020-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2020-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2020-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2020-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2020-02-29 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2020-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2020-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2019-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2019-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2019-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2019-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2019-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2019-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2019-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2019-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2019-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2019-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2019-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2019-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2019-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2019-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2019-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2019-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2019-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2019-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2019-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2019-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2019-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2019-02-28 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2019-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2019-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2018-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2018-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2018-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2018-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2018-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2018-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2018-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2018-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2018-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2018-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2018-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2018-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2018-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2018-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2018-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2018-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2018-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2018-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2018-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2018-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2018-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2018-02-28 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2018-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2018-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2017-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2017-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2017-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2017-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2017-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2017-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2017-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2017-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2017-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2017-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2017-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2017-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2017-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2017-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2017-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2017-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2017-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2017-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2017-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2017-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2017-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2017-02-28 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2017-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2017-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2016-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2016-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2016-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2016-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2016-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2016-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2016-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2016-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2016-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2016-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2016-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2016-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2016-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2016-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2016-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2016-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2016-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2016-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2016-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2016-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2016-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2016-02-29 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2016-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2016-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2015-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2015-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2015-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2015-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2015-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2015-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2015-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2015-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2015-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2015-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2015-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2015-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2015-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2015-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2015-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2015-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2015-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2015-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2015-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2015-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2015-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2015-02-28 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2015-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2015-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2014-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2014-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2014-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2014-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2014-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2014-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2014-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2014-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2014-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2014-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2014-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2014-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2014-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2014-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2014-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2014-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2014-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2014-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2014-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2014-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2014-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2014-02-28 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2014-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2014-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2013-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2013-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2013-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2013-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2013-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2013-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2013-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2013-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2013-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2013-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2013-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2013-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2013-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2013-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2013-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2013-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2013-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2013-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2013-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2013-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2013-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2013-02-28 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2013-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2013-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2012-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2012-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2012-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2012-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2012-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2012-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2012-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2012-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2012-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2012-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2012-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2012-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2012-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2012-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2012-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2012-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2012-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2012-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2012-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2012-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2012-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2012-02-29 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2012-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2012-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2011-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2011-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2011-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2011-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2011-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2011-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2011-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2011-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2011-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2011-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2011-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2011-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2011-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2011-06-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2011-05-01 00:00:00') AND (`Questionnaire`.`answered` <= '2011-05-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2011-04-01 00:00:00') AND (`Questionnaire`.`answered` <= '2011-04-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2011-03-01 00:00:00') AND (`Questionnaire`.`answered` <= '2011-03-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2011-02-01 00:00:00') AND (`Questionnaire`.`answered` <= '2011-02-28 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2011-01-01 00:00:00') AND (`Questionnaire`.`answered` <= '2011-01-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2010-12-01 00:00:00') AND (`Questionnaire`.`answered` <= '2010-12-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2010-11-01 00:00:00') AND (`Questionnaire`.`answered` <= '2010-11-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2010-10-01 00:00:00') AND (`Questionnaire`.`answered` <= '2010-10-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2010-09-01 00:00:00') AND (`Questionnaire`.`answered` <= '2010-09-30 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2010-08-01 00:00:00') AND (`Questionnaire`.`answered` <= '2010-08-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2010-07-01 00:00:00') AND (`Questionnaire`.`answered` <= '2010-07-31 23:59:59')) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`regdate` IS NOT NULL AND `Questionnaire`.`publish_flg` = 1 AND ((`Questionnaire`.`answered` >= '2010-06-01 00:00:00') AND (`Questionnaire`.`answered` <= '2010-06-30 23:59:59')) | 1 | 1 | 0 | |
3 duplicate queries run.
