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

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

パチ7ホール取材

東北

東北地方の都道府県から選択してください

取材検索

都道府県から探す

九州・沖縄

中国

四国

関西

北陸・甲信越

東海

北海道

東北

関東




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

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

パチスロ新台情報

パチンコ新台情報

(staging) 14 queries took 365 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created_at` FROM `pachiseven`.`cake_sessions` AS `Session` WHERE `id` = '5n8oldi5gfflodciqi3o9e5tc0pq429s' LIMIT 1005
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` desc8815
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 1844674407370955161591691676
4select article_report_halls.article_id from article_report_halls where hall_id in (6,15,32,38,57,71,73,74,232,240,258,273,285,305,340,343,345,351,352,364,365,366,370,374,375,378,381,383,387,392,393,399,408,409,433,445,461,503,535,557,559,606,643,657,658,666,686,698,712,730,737,753,755,758,764,765,778,779,784,789,790,801,810,811,813,829,872,874,875,888,899,943,962,963,986,987,990,1032,1043,1072,1077,1087,1139,1160,1184,1196,1209,1220,1228,1242,1243,1246,1248,1249,1250,1251,1252,1253,1254,1271,1274,1309,1311,1327,1328,1335,1339,1347,1348,1359,1360,1391,1392,1393,1394,1424,1435,1439,1444,1473,1491,1590,1594,1608,1614,1637,1647,1688,1693,1699,1708,1710,1721,1730,1738,1751,1753,1758,1761,1767,1773,1794,1796,1811,1819,1820,1833,1871,1878,1880,1889,1893,1898,1913,1914,1915,1923,1932,1958,1959,1973,1977,1978,1986,1987,2013,2014,2030,2040,2059,2108,2120,2149,2150,2166,2167,2200,2232,2233,2282,2283,2297,2311,2315,2317,2335,2358,2359,2386,2390,2401,2414,2428,2446,2450,2455,2456,2500,2501,2529,2531,2540,2551,2559,2560,2573,2589,2590,2598,2608,2624,2637,2641,2651,2654,2678,2686,2689,2702,2714,2737,2739,2767,2777,2783,2791,2792,2798,2807,2822,2823,2854,2893,2899,2947,2948,2949,2950,2951,2952,2953,2954,2956,2957,2958,2959,2960,2961,2962,2963,2964,2966,2967,2978,2979,2988,2992,3019,3040,3045,3062,3074,3084,3085,3088,3091,3112,3190,3191,3192,3193,3194,3195,3197,3198,3199,3200,3201,3202,3203,3219,3227,3233,3235,3239,3260,3284,3307,3308,3310,3325,3326,3344,3345,3347,3351,3352,3376,3391,3394,3408,3409,3410,3447,3450,3469,3470,3474,3477,3478,4122,4123,4124,4125,4126,4127,4128,4129,4130,4131,4132,4133,4134,4135,4136,4137,4138,4139,4140,4141,4142,4143,4144,4145,4146,4147,4148,4149,4150,4151,4152,4153,4154,4155,4156,4157,4158,4159,4160,4161,4162,4163,4164,4165,4166,4167,4168,4169,4170,4171,4172,4173,4174,4175,4176,4177,4178,4179,4180,4181,4182,4183,4184,4185,4186,4187,4188,4189,4190,4191,4192,4193,4194,4195,4196,4197,4198,4199,4200,4201,4202,4203,4204,4205,4206,4207,4208,4209,4210,4211,4212,4213,4214,4215,4216,4263,4290,4326,4350,4375,4383,4413,4414,4425,4446,4478,4479,4480,4484,4496,4536,4542,4548,4576,4579,4580,4609,4631,4665,4676,4677,4678,4682,4688,4757,4758,4759,4760,4770,4771,4772,4773,4774,4775,4776,4777,4778,4850,4851,4852,4853,4854,4855,4856,4857,4878,4879,4880,4881,4908,4909,4910,4911,4912,4913,5093,5094,5095,5096,5097,5201,5236,5242,5331,5338,5341,5350,5351,5364,5372,5378,5391,5392,5401,5417,5430,5446,5448,5478,5483,5485,5517,5518,5553,5554,5555,5569,5584,5585,5594,5648,5670,5673,5676,5677,5689,5774,5783,5788,5795,5796,5799,5805,5842,5865,5877,5897,5922,5939,5946,5966,5979,5980,5994,6019,6031,6033,6041,6093,6094,6100,6109,6124,6125,6127,6128,6129,6139,6144,6145,6180,6185,6224,6226,6257,6283,6302,6306,6317,6337,6353,6356,6358,6359,6361,6378,6379,6411,6414,6415,6433,6438,6527,6573,6594,6622,6638,6644,6646,6648,6651,6660,6695,6714,6716,6719,6723,6736,6737,6754,6778,6788,6798,6845,6852,6921,6924,6971,6972,6973,6976,6978,6979,6990,6991,6992,6997,6998,7001,7003,7004,7005,7008,7012,7014,7244,7256,7257,7286,7306,7311,7313,7323,7339,7365,7432,7439,7442,7457,7458,7461,7462,7465,7499,7501,7519,7531,7532,7533,7552,7554,7577,7578,7579,7580,7581,7585,7586,7592,7593,7594,7599,7600,7601,7602,7604,7608,7609,7624,7635,7637,7657,7659,7664,7670,7731,7749,7797,7798,7810,7811,7840,7841,7873,7889,7893,7894,7896,7897,7924,7955,7974,8029,8036,8059,8064,8069,8082,8083,8084,8094,8099,8100,8101,8102,8113,8114,8116,8122,8123,8126,8168,8175,8184,8196,8226,8271,8275,8286,8287,8288,8308,8309,8310,8311,8335,8336,8360,8363,8364,8370,8398,8401,8426,8427,8449,8450,8451,8452,8453,8454,8565,8604,8612,8615,8626,8627,8647,8667,8683,8688,8689,8718,8722,8723,8724,8725,8726,8727,8728,8735,8736,8737,8747,8753,8769,8770,8771,8772,8777,8815,8896,8904,8906,8922,8945,8987,9016,9025,9026,9027,9028,9035,9064,9067,9069,9072,9074,9080,9085,9113,9153,9183,9202,9203,9205,9220,9221,9234,9267,9284,9309,9332,9336,9353,9354,9359,9366,9454,9464,9467,9488,9489,9522,9529,9530,9553,9587,9593,9625,9639,9641,9643,9647,9653,9661,9669,9684,9685,9692,9695,9715,9719,9734,9744,9764,9770,9788,9811,9818,9823,9826,9852,9860,9863,9868,9893,9923,9931,9946,10002,10015,10023,10050,10051,10055,10070,10071,10078,10079,10081,10109,10110,10122,10146,10149,10162,10168,10169,10209,10227,10230,10244,10245,10246,10253,10254,10255,10284,10299,10300,10332,10335,10344,10348,10375,10379,10405,10420,10438,10464,10465,10466,10467,10468,10470,10480,10513,10519,10525,10539,10609,10637,10653,10682,10700,10712,10715,10719,10721,10722,10723,10750,10796,10825,10826,10827,10829,10851,10857,10875,10887,10912,10935,10999,11003,11012,11014,11021,11037,11050,11051,11162,11194,11196,11383) and del_flg = 017176
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 (396, 1063, 1001, 939, 936, 935, 360, 388, 412, 992, 1008, 1025, 2760, 2781, 2865, 2877, 5638) AND NOT (`Article`.`parent_article_id` IS NULL) ORDER BY `Article`.`modified` desc, `Article`.`start_date` desc, `Article`.`id` desc LIMIT 10002
6SELECT `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 888183
7SELECT `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 50049
8SELECT `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` DESC116
9SELECT `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` DESC117
10 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 10108
11 SELECT * FROM `banner_imps` WHERE 1 and banner_id in (1,2,3,4,5,6,7,8,9,10) and created = CURRENT_DATE() 10105
12SELECT `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 1001
13SELECT `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
14SELECT `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` ASC331
(productReplica) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)