パチンコ・パチスロを楽しむための情報サイト パチ7!
新台情報から解析情報、全国のチラシ情報まで、完全無料で配信中!

  1. パチセブントップ
  2. パチ7ホール取材
  3. 絞り込み

パチ7ホール取材

九州・沖縄

九州・沖縄地方の都道府県から選択してください

  • レポートはこちら
  • 告知記事
「九州・沖縄」で絞り込み中

【ホル調 THE MOVIE #12】3日間で万枚!?ミッション3DAYS!《番長3・ゴッド凱旋》

【#12:3日間を戦い抜け!いざ、GO!zone!】お笑い芸人のハニートラップ梅木こと『ガチますく』が今日も張り切って全力調査!今回はなんと"3日間ミッションに挑む"特別回となっております。最後におまけもアリ…?(調査ホール:zone行橋店)

2018.03.01 ガチますく ガチますく  

ホル調 THE MOVIE【撮影取材】

【12/23(土)】福岡県「zone本城店」を天草ヤスヲが調査!

天草ヤスヲが福岡県「zone本城店」にて調査を敢行!

2018.02.07 天草ヤスヲ 天草ヤスヲ  

パチ7コミック漫画調査隊が行く!

【11/23(木)】福岡県「zone本城店」をまろっこが調査!

まろっこが福岡県「zone本城店」にて調査を再び敢行! 果たして状況はどうだったのか!?

2017.12.25 まろっこ まろっこ  

パチ7コミック漫画調査隊が行く!

【8/23(水)】福岡県「zone本城店」を天草ヤスヲが調査!

8/23(水)福岡県「zone本城店」を天草ヤスヲが調査! 果たしてその状況は・・・!?

2017.09.22 天草ヤスヲ 天草ヤスヲ  

パチ7コミック漫画調査隊が行く!

【7/23(日)】福岡県「zone本城店」をまろっこが調査!

まろっこが福岡県「zone本城店」にて調査を再び敢行!

2017.08.22 まろっこ まろっこ  

パチ7コミック漫画調査隊が行く!

取材検索

都道府県から探す

九州・沖縄

中国

四国

関西

北陸・甲信越

東海

北海道

東北

関東




会員登録済みの方はこちらから

パスワードを忘れた方はこちら

パチスロ新台情報

パチンコ新台情報

(staging) 36 queries took 328 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created_at` FROM `pachiseven`.`cake_sessions` AS `Session` WHERE `id` = 'suda2iovak9emgrfk55cesgm5944t0a9' LIMIT 1001
2SELECT `ArticleCategory`.`id`, `ArticleCategory`.`name` FROM `pachiseven`.`article_categories` AS `ArticleCategory` WHERE `ArticleCategory`.`type` = 2 AND `ArticleCategory`.`kind_id` = 11 AND `ArticleCategory`.`display` = 'public' AND `ArticleCategory`.`del_flg` = 0 AND EXISTS (SELECT * FROM articles WHERE `articles`.`del_flg` = 0 AND `articles`.`status` = 0 AND NOW() BETWEEN `articles`.`start_date` AND IFNULL(`articles`.`end_date`, NOW()) AND `ArticleCategory`.`id` = `articles`.`category_id` and `articles`.`type` = 2) ORDER BY `ArticleCategory`.`order` asc, `ArticleCategory`.`modified` desc8821
3SELECT `Hall`.`id`, `Hall`.`name`, `Hall`.`hall_pic`, `Hall`.`memo`, `Hall`.`bussiness_hours`, `Hall`.`news_1`, `Hall`.`news_start_date_1`, `Hall`.`news_url_1`, `Hall`.`news_date_display_1`, `Hall`.`news_2`, `Hall`.`news_start_date_2`, `Hall`.`news_url_2`, `Hall`.`news_date_display_2`, `Hall`.`user_flg`, `Hall`.`line_qr`, `Hall`.`line_button`, ((SELECT id FROM handbills WHERE `handbills`.`del_flg` = 0 AND `handbills`.`status` = 0 AND `handbills`.`approval_status` = 0 AND (NOW() BETWEEN `handbills`.`start_date` AND `handbills`.`end_date`) AND `handbills`.`hall_id` = `Hall`.`id` ORDER BY `handbills`.`start_date` DESC LIMIT 1)) AS `Hall__handbill_flg`, (CONCAT(`Hall`.`pref`, `Hall`.`city`, `Hall`.`address`)) AS `Hall__full_address`, (CASE WHEN `Hall`.`news_start_date_1` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_1` AND IFNULL(`Hall`.`news_end_date_1`, NOW())) THEN CASE WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN NULL ELSE `Hall`.`news_start_date_2` END WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN `Hall`.`news_start_date_1` ELSE IF(`Hall`.`news_start_date_1` >= `Hall`.`news_start_date_2`, `Hall`.`news_start_date_1`, `Hall`.`news_start_date_2`) END) AS `Hall__news_date`, (CASE WHEN `Hall`.`news_start_date_1` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_1` AND IFNULL(`Hall`.`news_end_date_1`, NOW())) THEN CASE WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN NULL ELSE `Hall`.`news_2` END WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN `Hall`.`news_1` ELSE IF(`Hall`.`news_start_date_1` >= `Hall`.`news_start_date_2`, `Hall`.`news_1`, `Hall`.`news_2`) END) AS `Hall__news_contents`, (NOW() BETWEEN IFNULL(`Hall`.`news_start_date_1`, '9999/12/31') AND IFNULL(`Hall`.`news_end_date_1`, NOW())) AS `Hall__news_flg_1`, (NOW() BETWEEN IFNULL(`Hall`.`news_start_date_2`, '9999/12/31') AND IFNULL(`Hall`.`news_end_date_2`, NOW())) AS `Hall__news_flg_2` FROM `pachiseven`.`halls` AS `Hall` WHERE `Hall`.`del_flg` = 0 AND `Hall`.`status` = 0 AND IFNULL(`Hall`.`start_date`, NOW()) <= NOW() AND `Hall`.`pref` IN ('九州・沖縄', '福岡県', '佐賀県', '長崎県', '熊本県', '大分県', '宮崎県', '鹿児島県', '沖縄県') LIMIT 184467440737095516151444144476
4select article_report_halls.article_id from article_report_halls where hall_id in (33,34,35,42,45,46,51,52,53,54,66,67,68,79,84,85,86,87,88,100,111,115,120,121,122,123,125,127,130,136,144,149,151,152,153,155,156,157,158,159,160,161,162,163,164,165,166,168,170,171,173,174,175,177,178,179,180,181,182,191,192,199,200,226,242,243,257,272,316,330,412,416,432,439,444,446,449,450,458,468,470,477,487,490,494,513,519,520,541,542,543,544,555,556,574,575,580,581,589,591,594,595,598,602,603,604,610,611,624,625,629,639,646,655,675,682,683,691,695,696,700,702,703,725,729,747,756,769,781,802,803,812,814,848,859,863,864,886,905,906,933,937,941,946,951,972,973,978,981,994,996,1002,1008,1012,1023,1026,1029,1035,1050,1054,1057,1088,1090,1096,1097,1099,1107,1108,1113,1114,1115,1116,1117,1118,1119,1121,1124,1131,1138,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1187,1188,1191,1207,1214,1216,1217,1222,1244,1245,1272,1279,1281,1286,1314,1315,1334,1338,1340,1341,1353,1396,1412,1413,1414,1415,1416,1417,1418,1419,1423,1425,1426,1427,1467,1471,1483,1493,1494,1496,1499,1501,1502,1514,1516,1539,1544,1549,1553,1555,1569,1573,1576,1585,1587,1595,1597,1611,1634,1651,1652,1654,1661,1662,1685,1687,1694,1695,1700,1719,1729,1745,1749,1755,1769,1774,1778,1780,1790,1793,1800,1826,1827,1828,1831,1836,1850,1852,1874,1879,1887,1892,1904,1910,1925,1936,1953,1957,1963,1972,1974,1980,1982,1983,1988,1991,1992,1993,1995,1996,1999,2003,2007,2012,2021,2027,2070,2071,2084,2086,2087,2091,2094,2118,2128,2137,2140,2145,2152,2158,2175,2180,2181,2182,2183,2184,2185,2187,2188,2189,2190,2191,2192,2193,2205,2223,2228,2229,2231,2235,2236,2242,2246,2247,2248,2249,2261,2268,2271,2272,2276,2277,2280,2284,2332,2339,2340,2341,2362,2374,2384,2389,2391,2398,2415,2417,2418,2436,2437,2439,2442,2445,2449,2454,2463,2465,2471,2492,2502,2503,2504,2508,2520,2532,2538,2544,2545,2550,2561,2564,2565,2571,2575,2596,2616,2622,2626,2635,2645,2648,2649,2662,2664,2693,2694,2707,2716,2717,2725,2742,2743,2744,2745,2746,2752,2758,2759,2764,2789,2794,2795,2806,2808,2809,2813,2824,2840,2841,2848,2849,2850,2851,2858,2859,2860,2861,2862,2863,2864,2865,2866,2868,2869,2900,2983,2985,2989,3010,3011,3013,3041,3042,3052,3056,3075,3077,3080,3095,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3113,3246,3252,3256,3259,3263,3265,3266,3267,3295,3296,3314,3331,3338,3363,3367,3368,3393,3402,3438,3440,3441,3491,3492,3493,3494,3495,3496,3497,3498,3499,3500,3501,3502,3503,3504,3505,3506,3507,3508,3509,3510,3511,3512,3513,3514,3515,3516,3517,3518,3519,3520,3521,3522,3523,3524,3525,3526,3527,3528,3529,3530,3531,3532,3533,3534,3535,3536,3537,3538,3539,3540,3541,3542,3543,3544,3545,3546,3547,3548,3549,3550,3551,3552,3553,3554,3555,3556,3557,3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3599,3600,3601,3602,3603,3604,3605,3606,3607,3608,4258,4260,4267,4268,4291,4319,4320,4329,4331,4335,4339,4340,4347,4348,4361,4362,4363,4385,4388,4390,4391,4392,4396,4399,4428,4432,4433,4438,4439,4440,4476,4477,4483,4493,4503,4508,4512,4521,4522,4524,4549,4553,4560,4565,4566,4592,4599,4601,4602,4607,4608,4612,4613,4626,4627,4630,4649,4656,4658,4661,4674,4686,4690,4703,4752,4753,4754,4755,4756,4767,4768,4769,4784,4785,4786,4787,4788,4789,4822,4823,4824,4869,4870,4871,4872,4873,4874,4875,4876,4877,4972,4973,4974,4975,4976,4977,4978,4979,4980,4981,4982,4983,4984,4985,4986,5076,5077,5078,5079,5080,5081,5082,5083,5084,5085,5086,5087,5088,5089,5090,5091,5092,5187,5246,5250,5256,5259,5270,5271,5272,5275,5284,5292,5293,5318,5346,5347,5348,5349,5352,5353,5354,5355,5356,5357,5358,5359,5360,5371,5379,5381,5410,5425,5426,5427,5429,5437,5438,5451,5452,5458,5468,5474,5476,5497,5498,5499,5500,5501,5502,5503,5504,5505,5507,5523,5546,5547,5548,5549,5550,5551,5552,5570,5578,5586,5595,5641,5644,5651,5663,5664,5669,5678,5683,5685,5700,5711,5713,5714,5716,5717,5718,5720,5723,5733,5752,5755,5759,5764,5777,5780,5785,5786,5793,5817,5845,5859,5862,5869,5882,5883,5888,5915,5918,5919,5942,5943,5945,5949,5958,5962,5988,5990,5992,5993,6002,6011,6024,6043,6045,6049,6053,6054,6055,6056,6057,6058,6059,6068,6091,6120,6130,6138,6151,6163,6166,6172,6186,6192,6193,6197,6213,6216,6246,6249,6264,6265,6272,6276,6279,6287,6294,6312,6319,6332,6336,6373,6376,6381,6383,6384,6398,6399,6419,6422,6423,6425,6436,6458,6465,6466,6490,6491,6492,6493,6494,6495,6496,6528,6529,6537,6538,6539,6540,6543,6544,6545,6566,6567,6583,6586,6587,6616,6617,6618,6619,6620,6624,6625,6629,6634,6654,6655,6673,6682,6688,6697,6699,6717,6725,6731,6732,6733,6738,6739,6746,6769,6792,6836,6838,6841,6844,6846,6862,6866,6897,6920,6956,6957,6958,6960,6961,6962,6963,6964,6965,6966,7199,7200,7201,7202,7203,7204,7205,7206,7207,7210,7211,7212,7213,7214,7215,7216,7217,7218,7219,7221,7222,7223,7224,7227,7228,7229,7232,7233,7236,7237,7238,7239,7240,7241,7242,7249,7255,7259,7261,7266,7271,7275,7277,7278,7280,7285,7322,7327,7331,7337,7338,7340,7352,7358,7368,7370,7372,7376,7378,7397,7398,7406,7417,7422,7430,7431,7436,7444,7449,7450,7451,7459,7466,7467,7471,7476,7483,7487,7492,7502,7526,7527,7529,7548,7550,7555,7566,7570,7610,7614,7615,7616,7631,7640,7651,7658,7663,7668,7669,7678,7687,7701,7702,7703,7729,7735,7750,7753,7754,7755,7756,7765,7766,7789,7790,7791,7792,7813,7842,7857,7860,7864,7872,7879,7880,7881,7884,7888,7898,7901,7961,7969,7971,7983,7987,7989,8017,8020,8021,8025,8035,8050,8090,8091,8092,8109,8139,8140,8170,8178,8199,8200,8201,8202,8228,8233,8258,8259,8260,8262,8268,8270,8273,8276,8285,8291,8292,8293,8294,8295,8296,8297,8298,8299,8300,8303,8313,8321,8322,8323,8324,8339,8340,8377,8383,8400,8403,8409,8410,8423,8424,8425,8437,8439,8440,8441,8456,8462,8463,8464,8466,8473,8498,8499,8500,8501,8502,8535,8600,8606,8617,8618,8619,8620,8629,8630,8631,8634,8635,8636,8661,8662,8663,8664,8665,8666,8686,8687,8694,8695,8696,8697,8701,8706,8748,8750,8757,8758,8811,8812,8813,8863,8872,8876,8877,8885,8890,8892,8918,8919,8920,8933,8934,8935,8936,8937,8943,8946,8947,8948,9000,9029,9059,9061,9062,9063,9098,9099,9100,9146,9174,9178,9191,9194,9223,9227,9231,9257,9269,9280,9294,9296,9300,9302,9304,9313,9318,9333,9341,9347,9351,9356,9361,9367,9368,9369,9375,9379,9386,9391,9392,9403,9404,9420,9427,9428,9429,9434,9455,9463,9474,9475,9478,9486,9487,9498,9512,9532,9533,9534,9535,9536,9537,9538,9545,9550,9554,9559,9560,9563,9564,9572,9575,9586,9597,9598,9637,9640,9657,9668,9673,9674,9675,9722,9727,9743,9746,9753,9773,9829,9834,9846,9854,9858,9859,9866,9869,9894,9896,9918,9934,9936,9937,9938,9939,9958,9972,9977,9978,9997,9998,10026,10042,10056,10057,10058,10061,10080,10087,10102,10106,10108,10116,10120,10121,10128,10150,10158,10164,10175,10176,10178,10180,10191,10243,10248,10251,10277,10286,10295,10315,10322,10325,10328,10329,10331,10373,10410,10412,10414,10417,10418,10450,10455,10456,10460,10461,10474,10475,10476,10483,10487,10495,10521,10524,10538,10540,10544,10545,10617,10622,10641,10688,10745,10746,10754,10755,10758,10761,10771,10786,10856,10871,10890,10891,10902,10907,10908,10929,10947,10959,10970,10976,10977,10978,10979,10988,11006,11022,11038,11046,11058,11070,11149,11155,11160,11169,11170,11174,11177,11182,11183,11320,11357) and del_flg = 087687610
5SELECT `Article`.`id`, `Article`.`type`, `Article`.`parent_article_id`, `Article`.`category_id`, `Article`.`writer_id`, `Article`.`article_footer_id`, `Article`.`title`, `Article`.`title_tag`, `Article`.`canonical_tag`, `Article`.`explanation`, `Article`.`image`, `Article`.`start_date`, `Article`.`end_date`, `Article`.`coverage_store_disp_flg`, `Article`.`login_flg`, `Article`.`comment_flg`, `Article`.`vote_flg`, `Article`.`vote_button_title`, `Article`.`yell_flg`, `Article`.`public_date`, `Article`.`status`, `Article`.`created_by`, `Article`.`created`, `Article`.`modified_by`, `Article`.`modified`, `Article`.`del_flg`, ((SELECT COUNT(*) FROM article_votes WHERE `Article`.`id` = `article_votes`.`article_id` AND `article_votes`.`del_flg` = 0)) AS `Article__vote_count`, ((SELECT COUNT(*) FROM article_yells WHERE `Article`.`id` = `article_yells`.`article_id` AND `article_yells`.`del_flg` = 0)) AS `Article__yell_count`, `ArticleCategory`.`id`, `ArticleCategory`.`type`, `ArticleCategory`.`kind_id`, `ArticleCategory`.`filter_id`, `ArticleCategory`.`name`, `ArticleCategory`.`color`, `ArticleCategory`.`image_1`, `ArticleCategory`.`image_2`, `ArticleCategory`.`explanation`, `ArticleCategory`.`order`, `ArticleCategory`.`main_writer_id`, `ArticleCategory`.`writer_name_1`, `ArticleCategory`.`writer_memo_1`, `ArticleCategory`.`writer_image_1`, `ArticleCategory`.`writer_name_2`, `ArticleCategory`.`writer_memo_2`, `ArticleCategory`.`writer_image_2`, `ArticleCategory`.`writer_name_3`, `ArticleCategory`.`writer_memo_3`, `ArticleCategory`.`writer_image_3`, `ArticleCategory`.`calendar_icon`, `ArticleCategory`.`created_by`, `ArticleCategory`.`created`, `ArticleCategory`.`modified_by`, `ArticleCategory`.`modified`, `ArticleCategory`.`display`, `ArticleCategory`.`del_flg`, `ArticleWriter`.`id`, `ArticleWriter`.`name`, `ArticleWriter`.`memo`, `ArticleWriter`.`image`, `ArticleWriter`.`main_contents`, `ArticleWriter`.`system_user_id`, `ArticleWriter`.`mail_address`, `ArticleWriter`.`status`, `ArticleWriter`.`link_url_1`, `ArticleWriter`.`link_url_2`, `ArticleWriter`.`link_url_3`, `ArticleWriter`.`link_url_4`, `ArticleWriter`.`created_by`, `ArticleWriter`.`created`, `ArticleWriter`.`modified_by`, `ArticleWriter`.`modified`, `ArticleWriter`.`del_flg` FROM `pachiseven`.`articles` AS `Article` LEFT JOIN `pachiseven`.`article_categories` AS `ArticleCategory` ON (`Article`.`category_id` = `ArticleCategory`.`id` AND `ArticleCategory`.`del_flg` = 0 AND `ArticleCategory`.`display` = 'public') LEFT JOIN `pachiseven`.`article_writers` AS `ArticleWriter` ON (`Article`.`writer_id` = `ArticleWriter`.`id` AND `ArticleWriter`.`del_flg` = 0) WHERE `Article`.`del_flg` = 0 AND `Article`.`status` = 0 AND NOW() BETWEEN `Article`.`start_date` AND IFNULL(`Article`.`end_date`, NOW()) AND `Article`.`type` = 2 AND `ArticleCategory`.`type` = 2 AND `ArticleCategory`.`kind_id` = (11) AND `ArticleCategory`.`display` = 'public' AND `Article`.`id` IN (1280, 1281, 1311, 1311, 1311, 1356, 1225, 1379, 1191, 591, 617, 408, 1412, 1413, 1237, 1197, 1167, 1043, 1023, 971, 908, 864, 869, 867, 1427, 1428, 1429, 1432, 1434, 1447, 1456, 1457, 1471, 1490, 1492, 377, 415, 475, 607, 655, 649, 636, 645, 673, 681, 688, 722, 726, 761, 735, 679, 778, 792, 792, 792, 792, 792, 792, 792, 792, 792, 798, 806, 806, 806, 806, 806, 806, 805, 834, 842, 845, 861, 872, 903, 899, 910, 926, 959, 923, 942, 976, 979, 987, 988, 996, 1012, 1037, 1085, 1084, 1120, 1118, 1159, 1159, 1159, 1159, 1159, 1159, 1190, 1519, 1525, 1548, 1560, 1597, 1622, 1623, 1625, 1634, 1646, 1662, 1697, 395, 429, 450, 497, 650, 724, 758, 760, 763, 777, 779, 832, 837, 852, 855, 855, 855, 855, 855, 855, 855, 855, 855, 863, 878, 879, 883, 900, 904, 909, 922, 933, 934, 945, 953, 955, 963, 964, 985, 995, 1009, 1015, 1016, 1029, 1035, 1052, 1064, 1081, 1095, 1097, 1099, 1105, 1113, 1117, 1139, 1155, 1156, 1212, 1214, 1219, 1233, 1262, 1267, 1282, 1284, 1293, 1298, 1308, 1320, 1335, 1341, 1358, 1359, 1380, 1396, 1401, 1426, 1463, 1468, 1469, 1494, 1502, 1521, 1551, 1565, 1589, 1601, 1620, 1628, 1630, 1631, 1652, 1653, 1659, 1721, 1738, 1755, 1761, 1764, 1766, 1773, 1751, 1784, 1785, 1786, 1788, 1799, 1821, 1837, 1850, 1853, 1859, 1873, 1874, 1860, 1882, 1877, 1896, 1897, 1909, 1936, 1946, 1949, 1953, 1963, 1971, 1972, 1973, 1977, 1978, 1979, 2024, 2036, 2056, 2057, 2062, 2077, 2079, 2085, 2090, 2091, 2094, 2102, 2135, 2164, 2168, 2169, 2174, 2175, 2182, 2183, 2185, 2186, 2195, 2196, 2204, 2244, 2269, 2270, 2283, 2285, 2287, 2294, 2296, 2300, 2320, 2327, 2343, 2362, 2369, 2382, 2393, 2403, 2404, 2420, 2436, 2479, 2480, 2491, 2492, 2505, 2534, 2536, 2580, 2586, 2587, 2618, 2630, 2657, 2660, 2676, 2688, 2665, 2708, 2709, 2714, 2723, 2747, 2756, 2759, 2768, 2770, 2790, 2802, 2821, 2839, 2840, 2854, 2879, 2882, 2884, 2885, 2901, 2924, 2926, 2927, 2940, 2942, 2949, 2960, 2963, 2985, 2992, 2996, 2997, 3004, 3035, 3042, 3056, 3059, 3061, 3067, 3069, 3084, 3095, 3098, 3113, 3126, 3130, 3137, 3157, 3175, 3187, 3191, 3207, 3211, 3213, 3221, 3228, 3240, 3248, 3254, 3257, 3263, 3266, 3294, 3296, 3308, 3325, 3332, 3337, 3345, 3347, 3358, 3365, 3373, 3395, 3399, 3419, 3425, 3393, 3440, 3441, 3445, 3448, 3460, 3465, 3474, 3481, 3490, 3495, 3496, 3536, 3541, 3548, 3552, 3553, 3576, 3594, 3607, 3615, 3616, 3643, 3643, 3653, 3654, 3663, 3666, 3682, 3697, 3703, 3703, 3705, 3713, 3714, 3716, 3731, 3737, 3747, 3780, 3782, 3792, 3797, 3813, 3817, 3818, 3833, 3834, 3836, 3837, 3844, 3848, 3849, 3850, 3856, 3857, 3858, 3869, 3870, 3872, 3873, 3874, 3877, 3884, 3886, 3893, 3900, 3901, 3912, 3913, 3914, 3915, 3920, 3921, 3927, 3928, 3929, 3932, 3936, 3937, 3938, 3943, 3944, 3948, 3953, 3954, 3955, 3966, 3967, 3968, 3969, 3970, 3976, 3984, 3987, 3997, 3999, 4004, 4009, 4010, 4016, 4025, 4028, 4029, 4030, 4031, 4032, 4039, 4040, 4045, 4064, 4070, 4072, 4074, 4075, 4084, 4093, 4094, 4117, 4118, 4125, 4134, 4135, 4136, 4138, 4140, 4159, 4167, 4167, 4167, 4170, 4177, 4193, 4195, 4196, 4204, 4208, 4209, 4215, 4219, 4228, 4230, 4232, 4233, 4244, 4247, 4248, 4254, 4286, 4295, 4301, 4308, 4310, 4312, 4316, 4329, 4331, 4351, 4362, 4371, 4377, 4384, 4387, 4392, 4393, 4408, 4426, 4464, 4469, 4504, 4516, 4523, 4526, 4527, 4545, 4552, 4559, 4564, 4572, 4655, 4662, 4669, 4670, 4674, 4676, 4679, 4682, 4709, 4725, 4754, 4755, 4757, 4758, 4763, 4769, 4775, 4777, 4800, 4804, 4811, 4812, 4815, 4819, 4839, 4858, 4875, 4892, 4895, 4900, 4910, 4912, 4929, 4941, 4945, 4957, 4963, 4964, 4971, 5008, 5009, 5011, 5039, 5042, 5049, 5060, 5062, 5069, 5080, 5083, 5091, 5112, 5120, 5134, 5138, 5139, 5140, 5141, 5155, 5169, 5183, 5191, 5197, 5206, 5207, 5212, 5241, 5244, 5254, 5259, 5273, 5276, 5277, 5295, 5344, 5359, 5365, 5373, 5388, 5389, 5404, 5412, 5415, 5429, 5434, 5439, 5444, 5447, 5451, 5462, 5463, 5464, 5469, 5491, 5502, 5503, 5514, 5522, 5549, 5554, 5561, 5562, 5571, 5572, 5590, 5612, 5614, 5623, 5626, 5627, 5661, 5663, 5694, 5700, 5709, 5712, 5728, 5734, 5740, 5748, 5766, 5772, 5778, 5788, 5801, 5809, 5818, 5831, 5843, 5860, 5895, 5905, 5907, 5925, 5935, 5936, 5942, 5960, 5968, 5975, 6002, 6005, 6022, 6026, 6041, 6042, 6051, 6056, 6070, 6099, 6105, 6116, 6122, 6127, 6128, 6129, 6130, 6136, 6137, 6144, 6159, 6161, 6181, 6184, 6192, 6221, 6226, 6234, 6249, 6251, 6267, 6270, 6274, 6287, 6292, 6293, 6301, 6304, 6305, 6309, 6310, 6314, 6315, 6321, 6322, 6334, 6351, 6359, 6360, 6364, 6366, 6371, 6375, 6402, 6409, 6419, 6440, 6443, 6452, 6461, 6462, 6473, 6482, 6492, 6496, 6518, 6526, 6533, 6557, 6587, 6588, 6601, 6604, 6607, 6626, 6634, 6632, 6639, 6652, 6654, 6660, 6663, 6674, 6679, 6682, 6688, 6687, 6692, 6693, 6695, 6724, 6729, 6733, 6739, 6742, 6751, 6763, 6764, 6770, 6789, 6790, 6798, 6817, 6851, 6864, 6866, 6873, 6874, 6876, 6880, 6883, 6886, 6894, 6910, 6912, 6916, 6928, 6932, 6936, 6938, 6961, 6963, 6970, 6975, 6977, 7001, 7008, 7011, 7040, 7041, 7046, 7056, 7057, 7058, 7062, 7065, 7073, 7074, 7119, 7125, 7126, 7130, 7132, 7161, 7162, 7172, 7180, 7182, 7193, 7204, 7216, 7232, 7251, 7288, 7291, 7292, 7297, 7303, 7344, 7357, 7371, 7386, 7388, 7402, 7415, 7431, 7479, 7480, 7484, 7486, 7493, 7514, 7516, 7555, 7570, 7583) AND NOT (`Article`.`parent_article_id` IS NULL) ORDER BY `Article`.`modified` desc, `Article`.`start_date` desc, `Article`.`id` desc LIMIT 1010109
6SELECT COUNT(*) AS `count` FROM `pachiseven`.`articles` AS `Article` LEFT JOIN `pachiseven`.`article_categories` AS `ArticleCategory` ON (`Article`.`category_id` = `ArticleCategory`.`id` AND `ArticleCategory`.`del_flg` = 0 AND `ArticleCategory`.`display` = 'public') LEFT JOIN `pachiseven`.`article_writers` AS `ArticleWriter` ON (`Article`.`writer_id` = `ArticleWriter`.`id` AND `ArticleWriter`.`del_flg` = 0) WHERE `Article`.`del_flg` = 0 AND `Article`.`status` = 0 AND NOW() BETWEEN `Article`.`start_date` AND IFNULL(`Article`.`end_date`, NOW()) AND `Article`.`type` = 2 AND `ArticleCategory`.`type` = 2 AND `ArticleCategory`.`kind_id` = (11) AND `ArticleCategory`.`display` = 'public' AND `Article`.`id` IN (1280, 1281, 1311, 1311, 1311, 1356, 1225, 1379, 1191, 591, 617, 408, 1412, 1413, 1237, 1197, 1167, 1043, 1023, 971, 908, 864, 869, 867, 1427, 1428, 1429, 1432, 1434, 1447, 1456, 1457, 1471, 1490, 1492, 377, 415, 475, 607, 655, 649, 636, 645, 673, 681, 688, 722, 726, 761, 735, 679, 778, 792, 792, 792, 792, 792, 792, 792, 792, 792, 798, 806, 806, 806, 806, 806, 806, 805, 834, 842, 845, 861, 872, 903, 899, 910, 926, 959, 923, 942, 976, 979, 987, 988, 996, 1012, 1037, 1085, 1084, 1120, 1118, 1159, 1159, 1159, 1159, 1159, 1159, 1190, 1519, 1525, 1548, 1560, 1597, 1622, 1623, 1625, 1634, 1646, 1662, 1697, 395, 429, 450, 497, 650, 724, 758, 760, 763, 777, 779, 832, 837, 852, 855, 855, 855, 855, 855, 855, 855, 855, 855, 863, 878, 879, 883, 900, 904, 909, 922, 933, 934, 945, 953, 955, 963, 964, 985, 995, 1009, 1015, 1016, 1029, 1035, 1052, 1064, 1081, 1095, 1097, 1099, 1105, 1113, 1117, 1139, 1155, 1156, 1212, 1214, 1219, 1233, 1262, 1267, 1282, 1284, 1293, 1298, 1308, 1320, 1335, 1341, 1358, 1359, 1380, 1396, 1401, 1426, 1463, 1468, 1469, 1494, 1502, 1521, 1551, 1565, 1589, 1601, 1620, 1628, 1630, 1631, 1652, 1653, 1659, 1721, 1738, 1755, 1761, 1764, 1766, 1773, 1751, 1784, 1785, 1786, 1788, 1799, 1821, 1837, 1850, 1853, 1859, 1873, 1874, 1860, 1882, 1877, 1896, 1897, 1909, 1936, 1946, 1949, 1953, 1963, 1971, 1972, 1973, 1977, 1978, 1979, 2024, 2036, 2056, 2057, 2062, 2077, 2079, 2085, 2090, 2091, 2094, 2102, 2135, 2164, 2168, 2169, 2174, 2175, 2182, 2183, 2185, 2186, 2195, 2196, 2204, 2244, 2269, 2270, 2283, 2285, 2287, 2294, 2296, 2300, 2320, 2327, 2343, 2362, 2369, 2382, 2393, 2403, 2404, 2420, 2436, 2479, 2480, 2491, 2492, 2505, 2534, 2536, 2580, 2586, 2587, 2618, 2630, 2657, 2660, 2676, 2688, 2665, 2708, 2709, 2714, 2723, 2747, 2756, 2759, 2768, 2770, 2790, 2802, 2821, 2839, 2840, 2854, 2879, 2882, 2884, 2885, 2901, 2924, 2926, 2927, 2940, 2942, 2949, 2960, 2963, 2985, 2992, 2996, 2997, 3004, 3035, 3042, 3056, 3059, 3061, 3067, 3069, 3084, 3095, 3098, 3113, 3126, 3130, 3137, 3157, 3175, 3187, 3191, 3207, 3211, 3213, 3221, 3228, 3240, 3248, 3254, 3257, 3263, 3266, 3294, 3296, 3308, 3325, 3332, 3337, 3345, 3347, 3358, 3365, 3373, 3395, 3399, 3419, 3425, 3393, 3440, 3441, 3445, 3448, 3460, 3465, 3474, 3481, 3490, 3495, 3496, 3536, 3541, 3548, 3552, 3553, 3576, 3594, 3607, 3615, 3616, 3643, 3643, 3653, 3654, 3663, 3666, 3682, 3697, 3703, 3703, 3705, 3713, 3714, 3716, 3731, 3737, 3747, 3780, 3782, 3792, 3797, 3813, 3817, 3818, 3833, 3834, 3836, 3837, 3844, 3848, 3849, 3850, 3856, 3857, 3858, 3869, 3870, 3872, 3873, 3874, 3877, 3884, 3886, 3893, 3900, 3901, 3912, 3913, 3914, 3915, 3920, 3921, 3927, 3928, 3929, 3932, 3936, 3937, 3938, 3943, 3944, 3948, 3953, 3954, 3955, 3966, 3967, 3968, 3969, 3970, 3976, 3984, 3987, 3997, 3999, 4004, 4009, 4010, 4016, 4025, 4028, 4029, 4030, 4031, 4032, 4039, 4040, 4045, 4064, 4070, 4072, 4074, 4075, 4084, 4093, 4094, 4117, 4118, 4125, 4134, 4135, 4136, 4138, 4140, 4159, 4167, 4167, 4167, 4170, 4177, 4193, 4195, 4196, 4204, 4208, 4209, 4215, 4219, 4228, 4230, 4232, 4233, 4244, 4247, 4248, 4254, 4286, 4295, 4301, 4308, 4310, 4312, 4316, 4329, 4331, 4351, 4362, 4371, 4377, 4384, 4387, 4392, 4393, 4408, 4426, 4464, 4469, 4504, 4516, 4523, 4526, 4527, 4545, 4552, 4559, 4564, 4572, 4655, 4662, 4669, 4670, 4674, 4676, 4679, 4682, 4709, 4725, 4754, 4755, 4757, 4758, 4763, 4769, 4775, 4777, 4800, 4804, 4811, 4812, 4815, 4819, 4839, 4858, 4875, 4892, 4895, 4900, 4910, 4912, 4929, 4941, 4945, 4957, 4963, 4964, 4971, 5008, 5009, 5011, 5039, 5042, 5049, 5060, 5062, 5069, 5080, 5083, 5091, 5112, 5120, 5134, 5138, 5139, 5140, 5141, 5155, 5169, 5183, 5191, 5197, 5206, 5207, 5212, 5241, 5244, 5254, 5259, 5273, 5276, 5277, 5295, 5344, 5359, 5365, 5373, 5388, 5389, 5404, 5412, 5415, 5429, 5434, 5439, 5444, 5447, 5451, 5462, 5463, 5464, 5469, 5491, 5502, 5503, 5514, 5522, 5549, 5554, 5561, 5562, 5571, 5572, 5590, 5612, 5614, 5623, 5626, 5627, 5661, 5663, 5694, 5700, 5709, 5712, 5728, 5734, 5740, 5748, 5766, 5772, 5778, 5788, 5801, 5809, 5818, 5831, 5843, 5860, 5895, 5905, 5907, 5925, 5935, 5936, 5942, 5960, 5968, 5975, 6002, 6005, 6022, 6026, 6041, 6042, 6051, 6056, 6070, 6099, 6105, 6116, 6122, 6127, 6128, 6129, 6130, 6136, 6137, 6144, 6159, 6161, 6181, 6184, 6192, 6221, 6226, 6234, 6249, 6251, 6267, 6270, 6274, 6287, 6292, 6293, 6301, 6304, 6305, 6309, 6310, 6314, 6315, 6321, 6322, 6334, 6351, 6359, 6360, 6364, 6366, 6371, 6375, 6402, 6409, 6419, 6440, 6443, 6452, 6461, 6462, 6473, 6482, 6492, 6496, 6518, 6526, 6533, 6557, 6587, 6588, 6601, 6604, 6607, 6626, 6634, 6632, 6639, 6652, 6654, 6660, 6663, 6674, 6679, 6682, 6688, 6687, 6692, 6693, 6695, 6724, 6729, 6733, 6739, 6742, 6751, 6763, 6764, 6770, 6789, 6790, 6798, 6817, 6851, 6864, 6866, 6873, 6874, 6876, 6880, 6883, 6886, 6894, 6910, 6912, 6916, 6928, 6932, 6936, 6938, 6961, 6963, 6970, 6975, 6977, 7001, 7008, 7011, 7040, 7041, 7046, 7056, 7057, 7058, 7062, 7065, 7073, 7074, 7119, 7125, 7126, 7130, 7132, 7161, 7162, 7172, 7180, 7182, 7193, 7204, 7216, 7232, 7251, 7288, 7291, 7292, 7297, 7303, 7344, 7357, 7371, 7386, 7388, 7402, 7415, 7431, 7479, 7480, 7484, 7486, 7493, 7514, 7516, 7555, 7570, 7583) AND NOT (`Article`.`parent_article_id` IS NULL)115
7SELECT ArticleReportHall.article_id, Hall.id, Hall.name FROM article_report_halls ArticleReportHall INNER JOIN halls Hall ON (ArticleReportHall.hall_id = Hall.id AND ArticleReportHall.del_flg = 0 AND Hall.del_flg = 0 )WHERE ArticleReportHall.article_id IN (5344,5212,4957,4371,4193,3997,3541,2723,1335,1139)10102
8select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 5344001
9select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 5344001
10select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 5212001
11select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 5212001
12select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 4957001
13select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 4957001
14select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 4371001
15select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 4371001
16select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 4193001
17select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 4193001
18select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 3997001
19select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 3997001
20select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 3541001
21select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 3541001
22select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 2723001
23select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 2723001
24select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 1335001
25select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 1335001
26select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 1139005
27select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 1139001
28SELECT `ArticleCategory`.`id`, `ArticleCategory`.`type`, `ArticleCategory`.`kind_id`, `ArticleCategory`.`filter_id`, `ArticleCategory`.`name`, `ArticleCategory`.`color`, `ArticleCategory`.`image_1`, `ArticleCategory`.`image_2`, `ArticleCategory`.`explanation`, `ArticleCategory`.`order`, `ArticleCategory`.`main_writer_id`, `ArticleCategory`.`writer_name_1`, `ArticleCategory`.`writer_memo_1`, `ArticleCategory`.`writer_image_1`, `ArticleCategory`.`writer_name_2`, `ArticleCategory`.`writer_memo_2`, `ArticleCategory`.`writer_image_2`, `ArticleCategory`.`writer_name_3`, `ArticleCategory`.`writer_memo_3`, `ArticleCategory`.`writer_image_3`, `ArticleCategory`.`calendar_icon`, `ArticleCategory`.`created_by`, `ArticleCategory`.`created`, `ArticleCategory`.`modified_by`, `ArticleCategory`.`modified`, `ArticleCategory`.`display`, `ArticleCategory`.`del_flg`, ((SELECT `articles`.`start_date` FROM articles WHERE `ArticleCategory`.`id` = `articles`.`category_id` AND `articles`.`status` = 0 AND `articles`.`del_flg` = 0 AND NOW() BETWEEN `articles`.`start_date` AND IFNULL(`articles`.`end_date`, NOW()) ORDER BY `articles`.`start_date` DESC LIMIT 1)) AS `ArticleCategory__update_date` FROM `pachiseven`.`article_categories` AS `ArticleCategory` WHERE `ArticleCategory`.`type` = 2 AND NOT (((SELECT `articles`.`start_date` FROM articles WHERE `ArticleCategory`.`id` = `articles`.`category_id` AND `articles`.`status` = 0 AND `articles`.`del_flg` = 0 AND NOW() BETWEEN `articles`.`start_date` AND IFNULL(`articles`.`end_date`, NOW()) ORDER BY `articles`.`start_date` DESC LIMIT 1)) IS NULL) AND `ArticleCategory`.`kind_id` = 11 AND `ArticleCategory`.`del_flg` = 0 AND `ArticleCategory`.`display` = 'public' ORDER BY `ArticleCategory`.`order` ASC, `ArticleCategory`.`modified` desc LIMIT 888129
29SELECT `Column`.`id`, `Column`.`column_category_id`, `Column`.`column_event_id`, `Column`.`title`, `Column`.`title_img`, `Column`.`contents`, `Column`.`tag`, `Column`.`vote_button_title`, `Column`.`start_date`, `Column`.`limit_date`, `Column`.`status`, `Column`.`unread_cnt`, `Column`.`pv_cnt`, `Column`.`user_id`, `Column`.`created`, `Column`.`modified_by`, `Column`.`modified`, `Column`.`del_flg`, ((SELECT COUNT(*) FROM column_comments WHERE `Column`.`id` = `column_comments`.`column_id` AND `column_comments`.`status` = 0 AND `column_comments`.`del_flg` = 0)) AS `Column__comment_count`, ((SELECT COUNT(*) FROM column_votes WHERE `Column`.`id` = `column_votes`.`column_id` AND `column_votes`.`del_flg` = 0)) AS `Column__vote_count`, `ColumnEvent`.`event_title`, `ColumnEventV2`.`event_title` FROM `pachiseven`.`columns` AS `Column` LEFT JOIN `pachiseven`.`column_events` AS `ColumnEvent` ON (`Column`.`column_event_id` = `ColumnEvent`.`id` AND `ColumnEvent`.`del_flg` = 0 AND `ColumnEvent`.`status` = 0) LEFT JOIN `pachiseven`.`column_events_v2` AS `ColumnEventV2` ON (`Column`.`column_event_id` = `ColumnEventV2`.`id` AND `ColumnEventV2`.`del_flg` = 0 AND `ColumnEventV2`.`status` = 0) WHERE `Column`.`status` = 0 AND `Column`.`del_flg` = 0 AND DATE_FORMAT(`Column`.`start_date`, "%Y") < 9999 AND `Column`.`start_date` >= DATE_FORMAT(date_add(NOW(), interval -7 day), "%Y-%m-%d") AND `Column`.`column_category_id` = 9 AND `Column`.`column_event_id` = 0 ORDER BY ((SELECT COUNT(*) FROM column_votes WHERE `Column`.`id` = `column_votes`.`column_id` AND `column_votes`.`del_flg` = 0)) DESC, `Column`.`start_date` DESC LIMIT 50027
30SELECT `Banner`.`id`, `Banner`.`type`, `Banner`.`area_no`, `Banner`.`rate`, `Banner`.`title`, `Banner`.`image`, `Banner`.`link_url`, `Banner`.`disp_mark`, `Banner`.`pref_id`, `Banner`.`bg_color`, `Banner`.`bg_image_pc`, `Banner`.`bg_image_sp`, `BannerImp`.* FROM `pachiseven`.`banners` AS `Banner` LEFT JOIN `pachiseven`.`banner_imps` AS `BannerImp` ON (`BannerImp`.`banner_id` = `Banner`.`id` AND `BannerImp`.`created` = CURRENT_DATE()) WHERE `del_flg` = 0 AND `status` = 0 AND NOW() BETWEEN start_date AND end_date AND ((`type` = 17) OR (((`type` = 1) AND (`Banner`.`id` < 1000)))) AND `area_no` = 121 AND `Banner`.`pref_id` IN (1, 0) ORDER BY `Banner`.`pref_id` DESC112
31SELECT `Banner`.`id`, `Banner`.`type`, `Banner`.`area_no`, `Banner`.`rate`, `Banner`.`title`, `Banner`.`image`, `Banner`.`link_url`, `Banner`.`disp_mark`, `Banner`.`pref_id`, `Banner`.`bg_color`, `Banner`.`bg_image_pc`, `Banner`.`bg_image_sp`, `BannerImp`.* FROM `pachiseven`.`banners` AS `Banner` LEFT JOIN `pachiseven`.`banner_imps` AS `BannerImp` ON (`BannerImp`.`banner_id` = `Banner`.`id` AND `BannerImp`.`created` = CURRENT_DATE()) WHERE `del_flg` = 0 AND `status` = 0 AND NOW() BETWEEN start_date AND end_date AND ((`type` = 17) OR (((`type` = 1) AND (`Banner`.`id` < 1000)))) AND `area_no` = 121 AND `Banner`.`pref_id` IN (1, 0) ORDER BY `Banner`.`pref_id` DESC111
32 SELECT Banner.id, type, area_no, rate, title, image, link_url, disp_mark FROM `banners` as Banner WHERE 1 and type = 1 AND area_no < 121 AND (area_no NOT BETWEEN 9 AND 12) AND Banner.pref_id = 0 AND del_flg = 0 AND status = 0 AND (NOW() BETWEEN start_date AND end_date) order by area_no, Banner.id 10101
33 SELECT * FROM `banner_imps` WHERE 1 and banner_id in (1,2,3,4,5,6,7,8,9,10) and created = CURRENT_DATE() 10101
34SELECT `Site`.`image` FROM `pachiseven`.`sites` AS `Site` WHERE `site_content_id` = 904 AND NOW() BETWEEN start_date AND end_date AND `del_flg` = 0 ORDER BY `start_date` desc, `id` desc LIMIT 10014
35SELECT `Site`.`title`, `Site`.`image`, `Site`.`link_url` FROM `pachiseven`.`sites` AS `Site` WHERE `site_content_id` = 903 AND NOW() BETWEEN start_date AND end_date AND `del_flg` = 0 ORDER BY `start_date` desc, `id` desc LIMIT 1001
36SELECT `ScriptBlock`.`id`, `ScriptBlock`.`contents` FROM `pachiseven`.`script_blocks` AS `ScriptBlock` WHERE NOW() BETWEEN start_date AND IFNULL(end_date, NOW()) AND `target_area_id` = 0 AND `target_id` = 0 AND `status` = 0 AND `del_flg` = 0 ORDER BY `start_date` ASC, `id` ASC334
(productReplica) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)