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

  1. パチセブントップ
  2. ホール情報
  3. ホール詳細

[11374] Apple-ホール情報

店舗イメージ お気に入り追加

[11374] Apple

  • LINE
  • Twitter
  • facebook

ホール情報|住所 アクセス 営業時間 入場ルール

ホール情報

住所

〒070-0010
北海道旭川市大雪通3-489-80

最寄り駅 新旭川  新旭川  
アクセス
営業時間
入場ルール
ルール詳細
貸玉
台数
定休日
駐車場台数
電話番号
特徴

未登録のホール様へ

ホール情報を編集する



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

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

パチスロ新台情報

パチンコ新台情報

(staging) 16 queries took 56 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created_at` FROM `pachiseven`.`cake_sessions` AS `Session` WHERE `id` = 'rg8be7c5no2kmfstfh1qa3k9fsdpcd0c' LIMIT 1004
2SELECT `Hall`.`id`, `Hall`.`manage_no`, `Hall`.`company_manage_no`, `Hall`.`company_id`, `Hall`.`dl_service_flg`, `Hall`.`dl_service_amount`, `Hall`.`unique_handbill`, `Hall`.`special_mention`, `Hall`.`ptora_flg`, `Hall`.`ptora_id`, `Hall`.`pken_flg`, `Hall`.`pken_id`, `Hall`.`nifty_id`, `Hall`.`nana_link_id`, `Hall`.`daito_flg`, `Hall`.`name`, `Hall`.`logo`, `Hall`.`hall_pic`, `Hall`.`post`, `Hall`.`pref`, `Hall`.`city`, `Hall`.`address`, `Hall`.`map_url`, `Hall`.`lat`, `Hall`.`lon`, `Hall`.`link_title_1`, `Hall`.`link_url_1`, `Hall`.`link_title_2`, `Hall`.`link_url_2`, `Hall`.`link_title_3`, `Hall`.`link_url_3`, `Hall`.`feature`, `Hall`.`infection_measures`, `Hall`.`near_station_1`, `Hall`.`near_station_2`, `Hall`.`near_station_3`, `Hall`.`access_comment`, `Hall`.`tel`, `Hall`.`parking`, `Hall`.`machine_p`, `Hall`.`machine_s`, `Hall`.`machine_total`, `Hall`.`bussiness_hours`, `Hall`.`holiday`, `Hall`.`rent_rate`, `Hall`.`low_rate_flg`, `Hall`.`entrance_rule`, `Hall`.`entrance_rule_detail`, `Hall`.`memo`, `Hall`.`free_type_1`, `Hall`.`free_url_1`, `Hall`.`free_title_1`, `Hall`.`free_contents_1`, `Hall`.`free_start_date_1`, `Hall`.`free_end_date_1`, `Hall`.`free_date_display_1`, `Hall`.`free_type_2`, `Hall`.`free_url_2`, `Hall`.`free_title_2`, `Hall`.`free_contents_2`, `Hall`.`free_start_date_2`, `Hall`.`free_end_date_2`, `Hall`.`free_date_display_2`, `Hall`.`free_type_3`, `Hall`.`free_url_3`, `Hall`.`free_title_3`, `Hall`.`free_contents_3`, `Hall`.`free_start_date_3`, `Hall`.`free_end_date_3`, `Hall`.`free_date_display_3`, `Hall`.`free_type_4`, `Hall`.`free_url_4`, `Hall`.`free_title_4`, `Hall`.`free_contents_4`, `Hall`.`free_start_date_4`, `Hall`.`free_end_date_4`, `Hall`.`free_date_display_4`, `Hall`.`news_1`, `Hall`.`news_url_1`, `Hall`.`news_start_date_1`, `Hall`.`news_end_date_1`, `Hall`.`news_date_display_1`, `Hall`.`news_2`, `Hall`.`news_url_2`, `Hall`.`news_start_date_2`, `Hall`.`news_end_date_2`, `Hall`.`news_date_display_2`, `Hall`.`line_ad_account_id`, `Hall`.`line_qr`, `Hall`.`line_button`, `Hall`.`start_date`, `Hall`.`status`, `Hall`.`system_office_id`, `Hall`.`salesman`, `Hall`.`user_flg`, `Hall`.`created_by`, `Hall`.`created`, `Hall`.`modified_by`, `Hall`.`modified`, `Hall`.`del_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`, ((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`, ((SELECT CASE WHEN id IS NULL THEN 0 ELSE 1 END 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_valid`, (EXISTS (SELECT * FROM system_users WHERE `system_users`.`del_flg` = 0 AND `system_users`.`hall_id` = `Hall`.`id`)) AS `Hall__is_hall_user` FROM `pachiseven`.`halls` AS `Hall` WHERE `Hall`.`del_flg` = 0 AND `Hall`.`status` = 0 AND IFNULL(`Hall`.`start_date`, NOW()) <= NOW() AND `Hall`.`id` = 11374 LIMIT 11111
3UPDATE hall_imps SET day_21 = day_21 + 1, modified = NOW() WHERE hall_id = 11374 AND pv_date = '2024-06-01'117
4SELECT `HallIcon`.`id`, `HallIcon`.`image` FROM `pachiseven`.`hall_icons` AS `HallIcon` WHERE `disable_flg` = 047471
5SELECT `HallIcon`.`id`, `HallIcon`.`name` FROM `pachiseven`.`hall_icons` AS `HallIcon` WHERE `disable_flg` = 047471
6SELECT `SystemUser`.`id` FROM `pachiseven`.`system_users` AS `SystemUser` WHERE `system_auth_id` = 25 AND `company_id` = 232 AND `del_flg` = 0 LIMIT 1001
7SELECT DISTINCT SystemUser.id FROM system_users AS SystemUser INNER JOIN hall_managers AS HallManager ON SystemUser.id = HallManager.system_user_id WHERE SystemUser.system_auth_id = 20 AND SystemUser.company_id = 232 AND HallManager.hall_id = 11374 AND SystemUser.del_flg = 0001
8SELECT Article.id, Article.title FROM article_report_lists ARL INNER JOIN articles Article ON (ARL.article_id = Article.id AND Article.status = 0 AND Article.del_flg = 0) INNER JOIN handbill_calendar HC ON (ARL.article_id = HC.article_id AND HC.status = 0 AND HC.del_flg = 0) INNER JOIN article_categories ArticleCategory ON (Article.category_id = ArticleCategory.id AND ArticleCategory.del_flg = 0) WHERE ARL.hall_id = ? AND ARL.child = 0 AND DATE(NOW()) <= HC.public_date AND DATE(NOW()) >= Article.start_date ORDER BY HC.public_date ASC , params[ 11374 ]006
9SELECT Article.id, Article.title FROM article_report_lists ARL INNER JOIN articles Article ON (ARL.article_id = Article.id AND Article.status = 0 AND Article.del_flg = 0) INNER JOIN article_categories ArticleCategory ON (Article.category_id = ArticleCategory.id AND ArticleCategory.del_flg = 0) WHERE ARL.hall_id = ? AND ARL.child = 1 ORDER BY ARL.start_date DESC LIMIT 4 , params[ 11374 ]009
10SELECT `Handbill`.`id`, `Handbill`.`type`, `Handbill`.`front_image`, `Handbill`.`back_image`, `Handbill`.`hall_id` FROM `pachiseven`.`handbills` AS `Handbill` INNER JOIN `pachiseven`.`halls` AS `Hall` ON (`Handbill`.`hall_id` = `Hall`.`id` AND `Hall`.`del_flg` = 0 AND `Hall`.`status` = 0 AND IFNULL(`Hall`.`start_date`, NOW()) <= NOW()) WHERE `Handbill`.`del_flg` = 0 AND `Handbill`.`approval_status` = 0 AND `Handbill`.`status` = 0 AND `Handbill`.`start_date` <= NOW() AND `Handbill`.`end_date` >= NOW() AND `Handbill`.`hall_id` = 11374 ORDER BY (CASE WHEN (to_days(now()) - to_days(`Handbill`.`public_date`)) = 0 THEN 1 WHEN (to_days(now()) - to_days(`Handbill`.`public_date`)) = -1 THEN 2 WHEN (to_days(now()) - to_days(`Handbill`.`public_date`)) = 1 THEN 3 ELSE 4 END) asc, `Handbill`.`public_date` desc002
11SELECT `ScriptBlock`.`id`, `ScriptBlock`.`contents` FROM `pachiseven`.`script_blocks` AS `ScriptBlock` WHERE NOW() BETWEEN start_date AND IFNULL(end_date, NOW()) AND `target_area_id` = 1 AND `target_id` = 11374 AND `status` = 0 AND `del_flg` = 0 ORDER BY `start_date` ASC, `id` ASC001
12SELECT `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` = 3) OR (((`type` = 1) AND (`Banner`.`id` < 1000)))) AND `area_no` = 121 AND `Banner`.`pref_id` IN (1, 0) ORDER BY `Banner`.`pref_id` DESC111
13SELECT `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` = 3) OR (((`type` = 1) AND (`Banner`.`id` < 1000)))) AND `area_no` = 121 AND `Banner`.`pref_id` IN (1, 0) ORDER BY `Banner`.`pref_id` DESC114
14SELECT `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
15SELECT `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 1002
16SELECT `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)