Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Category`.`id`, `Category`.`category_name`, `Category`.`category_sort_order`, `Category`.`words`, `Category`.`flg_hidden`, `Category`.`created`, `Category`.`modified` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`flg_hidden` = 0 ORDER BY `Category`.`category_sort_order` ASC | 38 | 38 | 0 | |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` LEFT JOIN `witinc_pqnavi_test`.`md_items` AS `Item` ON (`ItemsCategory`.`item_id` = `Item`.`id`) WHERE `ItemsCategory`.`category_id` = 16 AND `Item`.`item_rank` < 3 ORDER BY `ItemsCategory`.`item_id` ASC | 380 | 380 | 0 | |
SELECT `Category`.`category_name`, `Category`.`words` FROM `witinc_pqnavi_test`.`md_categories` AS `Category` WHERE `Category`.`id` = 16 AND `Category`.`flg_hidden` = 0 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_unit`, `Item`.`koushinbi`, `Item`.`item_color`, `Item`.`item_rank`, `Item`.`item_naming`, `Item`.`item_note`, `Item`.`file1_name`, `Campaign`.`id`, `Campaign`.`campaign_price`, `Item`.`item_fullcolor`, `Item`.`item_speed` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`id` IN (66672, 72204, 72799, 72827, 72832, 74944, 74948, 76929, 76930, 76933, 76937, 76942, 76977, 78989, 81872, 81886, 81905, 84059, 84061, 84064, 84073, 84079, 84080, 84081, 84084, 84085, 84086, 84087, 84091, 84093, 84097, 84100, 84106, 84257, 84262, 84263, 84948, 84949, 85414, 85809, 85811, 86010, 86055, 86057, 86059, 86060, 86476, 86496, 87271, 87272, 87274, 87275, 87653, 87654, 87662, 88173, 89837, 89894, 89931, 89932, 89933, 90353, 90354, 90356, 90357, 91074, 91081, 91082, 91083, 91084, 91086, 91093, 91347, 91367, 91371, 91373, 91375, 91557, 91560, 91567, 91568, 91570, 91582, 93378, 93389, 93392, 93400, 93401, 93402, 93403, 93423, 93430, 93436, 93444, 93447, 93453, 93454, 93455, 93457, 93470, 93471, 93472, 93480, 93486, 94795, 94796, 94797, 94799, 94800, 94801, 94803, 94804, 94809, 95099, 95100, 95109, 95111, 95113, 95114, 95399, 95400, 95401, 95403, 95404, 95405, 95406, 95407, 95408, 95410, 96245, 96246, 96247, 96248, 96251, 96253, 96254, 96257, 96266, 96271, 96274, 96275, 96277, 96280, 96285, 96286, 96287, 96288, 96289, 96293, 96294, 97059, 97060, 97063, 97064, 97068, 97069, 97070, 97071, 97079, 97080, 97083, 97084, 97089, 97099, 97100, 97101, 97102, 97103, 97105, 97106, 97107, 97108, 97113, 97114, 97115, 97116, 97117, 97118, 97121, 97122, 97123, 97124, 97125, 97128, 97129, 97130, 97131, 97134, 97135, 97136, 97138, 97139, 97140, 97141, 97142, 97143, 97144, 97146, 97147, 97148, 97149, 97150, 97151, 97155, 97156, 97158, 97159, 97160, 97161, 97162, 97163, 97165, 97170, 97173, 97174, 97175, 97176, 97177, 97178, 97179, 97180, 97182, 97186, 97187, 97188, 97189, 97426, 97428, 97429, 97819, 97820, 97821, 97822, 97823, 97824, 97825, 97826, 97827, 97828, 97829, 97830, 97833, 97834, 97835, 97836, 97837, 97838, 98190, 98200, 98201, 98202, 98203, 98204, 98205, 98206, 98207, 98208, 98209, 98210, 98211, 98456, 98457, 98458, 98459, 98460, 98461, 98462, 98463, 98464, 98465, 98466, 98467, 98468, 98469, 98470, 98471, 98472, 98473, 98474, 98475, 98476, 98477, 98478, 98479, 98480, 98481, 98482, 98483, 98484, 98485, 98486, 98487, 98488, 99139, 99140, 99141, 99142, 99143, 99144, 99145, 99146, 99147, 99148, 99149, 99150, 99151, 99152, 99153, 99154, 99155, 99156, 99157, 99158, 99159, 99160, 99161, 99162, 99163, 99164, 99165, 99166, 99167, 99168, 99169, 99170, 99171, 99172, 99173, 99174, 99175, 99176, 99177, 99178, 99179, 99180, 99181, 99182, 99183, 99184, 99185, 99186, 99187, 99188, 99189, 99190, 99191, 99192, 99193, 99194, 99195, 99196, 99197, 99198, 99199, 99697, 99698, 99699, 99700, 99701, 99702, 99703, 99704, 99705, 99706, 99707, 99708, 99709, 99710, 99711, 99712, 99713, 99714, 99715, 99716, 99717, 99718, 99719, 99720, 99721, 99722) AND `item_rank` <> 3 ORDER BY `Item`.`koushinbi` desc LIMIT 20 | 20 | 20 | 0 | |
SELECT `ItemsCategory`.`id`, `ItemsCategory`.`item_id`, `ItemsCategory`.`category_id`, `ItemsCategory`.`created`, `ItemsCategory`.`modified` FROM `witinc_pqnavi_test`.`md_items_categories` AS `ItemsCategory` WHERE `ItemsCategory`.`item_id` IN (98469, 98463, 98474, 98485, 98462, 98473, 98484, 98461, 98472, 98483, 98460, 98471, 98482, 98459, 98470, 98481, 98458, 98480, 98457, 98468) | 20 | 20 | 0 | |
SELECT COUNT(*) AS `count` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`id` IN (66672, 72204, 72799, 72827, 72832, 74944, 74948, 76929, 76930, 76933, 76937, 76942, 76977, 78989, 81872, 81886, 81905, 84059, 84061, 84064, 84073, 84079, 84080, 84081, 84084, 84085, 84086, 84087, 84091, 84093, 84097, 84100, 84106, 84257, 84262, 84263, 84948, 84949, 85414, 85809, 85811, 86010, 86055, 86057, 86059, 86060, 86476, 86496, 87271, 87272, 87274, 87275, 87653, 87654, 87662, 88173, 89837, 89894, 89931, 89932, 89933, 90353, 90354, 90356, 90357, 91074, 91081, 91082, 91083, 91084, 91086, 91093, 91347, 91367, 91371, 91373, 91375, 91557, 91560, 91567, 91568, 91570, 91582, 93378, 93389, 93392, 93400, 93401, 93402, 93403, 93423, 93430, 93436, 93444, 93447, 93453, 93454, 93455, 93457, 93470, 93471, 93472, 93480, 93486, 94795, 94796, 94797, 94799, 94800, 94801, 94803, 94804, 94809, 95099, 95100, 95109, 95111, 95113, 95114, 95399, 95400, 95401, 95403, 95404, 95405, 95406, 95407, 95408, 95410, 96245, 96246, 96247, 96248, 96251, 96253, 96254, 96257, 96266, 96271, 96274, 96275, 96277, 96280, 96285, 96286, 96287, 96288, 96289, 96293, 96294, 97059, 97060, 97063, 97064, 97068, 97069, 97070, 97071, 97079, 97080, 97083, 97084, 97089, 97099, 97100, 97101, 97102, 97103, 97105, 97106, 97107, 97108, 97113, 97114, 97115, 97116, 97117, 97118, 97121, 97122, 97123, 97124, 97125, 97128, 97129, 97130, 97131, 97134, 97135, 97136, 97138, 97139, 97140, 97141, 97142, 97143, 97144, 97146, 97147, 97148, 97149, 97150, 97151, 97155, 97156, 97158, 97159, 97160, 97161, 97162, 97163, 97165, 97170, 97173, 97174, 97175, 97176, 97177, 97178, 97179, 97180, 97182, 97186, 97187, 97188, 97189, 97426, 97428, 97429, 97819, 97820, 97821, 97822, 97823, 97824, 97825, 97826, 97827, 97828, 97829, 97830, 97833, 97834, 97835, 97836, 97837, 97838, 98190, 98200, 98201, 98202, 98203, 98204, 98205, 98206, 98207, 98208, 98209, 98210, 98211, 98456, 98457, 98458, 98459, 98460, 98461, 98462, 98463, 98464, 98465, 98466, 98467, 98468, 98469, 98470, 98471, 98472, 98473, 98474, 98475, 98476, 98477, 98478, 98479, 98480, 98481, 98482, 98483, 98484, 98485, 98486, 98487, 98488, 99139, 99140, 99141, 99142, 99143, 99144, 99145, 99146, 99147, 99148, 99149, 99150, 99151, 99152, 99153, 99154, 99155, 99156, 99157, 99158, 99159, 99160, 99161, 99162, 99163, 99164, 99165, 99166, 99167, 99168, 99169, 99170, 99171, 99172, 99173, 99174, 99175, 99176, 99177, 99178, 99179, 99180, 99181, 99182, 99183, 99184, 99185, 99186, 99187, 99188, 99189, 99190, 99191, 99192, 99193, 99194, 99195, 99196, 99197, 99198, 99199, 99697, 99698, 99699, 99700, 99701, 99702, 99703, 99704, 99705, 99706, 99707, 99708, 99709, 99710, 99711, 99712, 99713, 99714, 99715, 99716, 99717, 99718, 99719, 99720, 99721, 99722) AND `item_rank` <> 3 | 1 | 1 | 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` = 98469 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98469) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565690'))))) OR (((`item_id2` = 98469) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565690'))))) OR (((`item_id3` = 98469) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565690')))))) 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` = 98463 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98463) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476779'))))) OR (((`item_id2` = 98463) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476779'))))) OR (((`item_id3` = 98463) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476779')))))) 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` = 98474 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98474) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476890'))))) OR (((`item_id2` = 98474) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476890'))))) OR (((`item_id3` = 98474) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476890')))))) 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` = 98485 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98485) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476839'))))) OR (((`item_id2` = 98485) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476839'))))) OR (((`item_id3` = 98485) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476839')))))) 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` = 98462 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98462) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476778'))))) OR (((`item_id2` = 98462) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476778'))))) OR (((`item_id3` = 98462) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476778')))))) 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` = 98473 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98473) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565730'))))) OR (((`item_id2` = 98473) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565730'))))) OR (((`item_id3` = 98473) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565730')))))) 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` = 98484 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98484) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565880'))))) OR (((`item_id2` = 98484) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565880'))))) OR (((`item_id3` = 98484) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565880')))))) 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` = 98461 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98461) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476777'))))) OR (((`item_id2` = 98461) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476777'))))) OR (((`item_id3` = 98461) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476777')))))) 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` = 98472 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98472) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565720'))))) OR (((`item_id2` = 98472) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565720'))))) OR (((`item_id3` = 98472) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565720')))))) 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` = 98483 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98483) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565850'))))) OR (((`item_id2` = 98483) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565850'))))) OR (((`item_id3` = 98483) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565850')))))) 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` = 98460 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98460) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476776'))))) OR (((`item_id2` = 98460) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476776'))))) OR (((`item_id3` = 98460) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476776')))))) 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` = 98471 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98471) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476788'))))) OR (((`item_id2` = 98471) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476788'))))) OR (((`item_id3` = 98471) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476788')))))) 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` = 98482 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98482) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565670'))))) OR (((`item_id2` = 98482) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565670'))))) OR (((`item_id3` = 98482) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565670')))))) 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` = 98459 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98459) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2476775'))))) OR (((`item_id2` = 98459) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2476775'))))) OR (((`item_id3` = 98459) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2476775')))))) 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` = 98470 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98470) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565750'))))) OR (((`item_id2` = 98470) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565750'))))) OR (((`item_id3` = 98470) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565750')))))) 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` = 98481 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98481) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565660'))))) OR (((`item_id2` = 98481) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565660'))))) OR (((`item_id3` = 98481) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565660')))))) 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` = 98458 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98458) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565820'))))) OR (((`item_id2` = 98458) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565820'))))) OR (((`item_id3` = 98458) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565820')))))) 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` = 98480 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98480) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565650'))))) OR (((`item_id2` = 98480) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565650'))))) OR (((`item_id3` = 98480) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565650')))))) 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` = 98457 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98457) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565810'))))) OR (((`item_id2` = 98457) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565810'))))) OR (((`item_id3` = 98457) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565810')))))) 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` = 98468 AND `Questionnaire`.`publish_flg` = 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`title` FROM `witinc_pqnavi_test`.`md_galleries` AS `Gallery` WHERE ((((`item_id1` = 98468) OR ((((item_id1 IS NULL OR item_id1 = '')) AND (`item_code1` = 'US-2565680'))))) OR (((`item_id2` = 98468) OR ((((item_id2 IS NULL OR item_id2 = '')) AND (`item_code2` = 'US-2565680'))))) OR (((`item_id3` = 98468) OR ((((item_id3 IS NULL OR item_id3 = '')) AND (`item_code3` = 'US-2565680')))))) 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 | |