Notice (8): Constant REDIS_PORT already defined [APP/Config/app_config.php, line 36]
array(1) { [1]=> array(2) { ["pref"]=> string(9) "東京都" ["pref_key"]=> int(13) } } パチンコ&パチスロ機種解析・店舗情報【パチ7】

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

  •  
  •  
  •  
  •  
  •  

パチンコ&パチスロ情報満載! パチ7おすすめコンテンツ

パチンコ&パチスロ情報満載!
パチ7おすすめコンテンツ

機種攻略情報

本日の狩場

T&Jあどれな!試打劇場

最強台ランキング

パチポイント

神の道ルート判別

神の道

新機種特集

神の道

最新機種PVまとめ

お宝空き台チェッカー

ブロック(大)5

ブロック(中)5

ブロック(小)5

  • test

  • test2

ブロック(中)6

ブロック(小)6

ブロック(大)6



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

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

パチスロ新台情報

パチンコ新台情報

(product) 40 queries took 238 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created_at` FROM `pachiseven`.`cake_sessions` AS `Session` WHERE `id` = 'unfqvfrvt1gvoekfakl3g0l1k2024rrk' LIMIT 1001
2SELECT `BannerAreaRatio`.`id`, `BannerAreaRatio`.`start_date`, `BannerAreaRatio`.`end_date`, `BannerAreaRatio`.`rate`, `BannerAreaRatio`.`created_by`, `BannerAreaRatio`.`created`, `BannerAreaRatio`.`modified_by`, `BannerAreaRatio`.`modified`, `BannerAreaRatio`.`del_flg` FROM `pachiseven`.`banner_area_ratios` AS `BannerAreaRatio` WHERE `del_flg` = 0 AND start_date <= NOW() AND end_date >= NOW() ORDER BY `id` desc LIMIT 1115
3SELECT `BannerAreaRatio`.`id`, `BannerAreaRatio`.`start_date`, `BannerAreaRatio`.`end_date`, `BannerAreaRatio`.`rate`, `BannerAreaRatio`.`created_by`, `BannerAreaRatio`.`created`, `BannerAreaRatio`.`modified_by`, `BannerAreaRatio`.`modified`, `BannerAreaRatio`.`del_flg` FROM `pachiseven`.`banner_area_ratios` AS `BannerAreaRatio` WHERE `del_flg` = 0 AND start_date <= NOW() AND end_date >= NOW() ORDER BY `id` desc LIMIT 1111
4SELECT `SortTable`.`sort_no`, `SortTable`.`target_id` FROM `pachiseven`.`sort_tables` AS `SortTable` WHERE `table_id` = 1 ORDER BY `sort_no` asc551
5SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 3 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
6SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 2 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
7SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 4 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
8SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 1 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1114
9SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 5 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
10SELECT * FROM site_content_imps WHERE site_id in (1043,1014,1035,1025,1042) AND created = CURRENT_DATE()551
11UPDATE site_content_imps SET imp = imp + 1 WHERE site_id in (1043,1014,1035,1025,1042) AND created = CURRENT_DATE()556
12SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 6 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
13SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 7 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
14SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 8 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1114
15SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 9 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
16SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 10 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
17SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 11 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
18SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 12 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
19SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 13 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
20SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 14 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1115
21SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 15 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
22SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 16 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
23SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 17 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
24SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 18 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
25SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 19 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
26SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 20 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
27SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 21 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
28SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 22 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1111
29SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 23 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1115
30 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 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 14141
31 SELECT * FROM `banner_imps` WHERE 1 and banner_id in (1,2,3,4,5,6,7,8,11,12,13,14,9,10) and created = CURRENT_DATE() 001
32SELECT `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` = 1 AND `area_no` = 121 AND `Banner`.`pref_id` IN (13, 0) ORDER BY `Banner`.`pref_id` DESC111
33SELECT `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` = 1 AND `area_no` = 121 AND `Banner`.`pref_id` IN (13, 0) ORDER BY `Banner`.`pref_id` DESC111
34SELECT `Enquete`.`id`, `Enquete`.`title`, `Enquete`.`summary`, `Enquete`.`category`, `Enquete`.`type`, `Enquete`.`select_num`, `Enquete`.`start_date`, `Enquete`.`end_date`, `Enquete`.`grant_point`, `Enquete`.`result_hide_flg`, `Enquete`.`comment_flg`, `Enquete`.`status`, `Enquete`.`create_by`, `Enquete`.`created`, `Enquete`.`modified_by`, `Enquete`.`modified`, `Enquete`.`del_flg`, (CASE WHEN `Enquete`.`start_date` BETWEEN date_add(current_date, interval -7 day) AND NOW() THEN TRUE ELSE FALSE END) AS `Enquete__new_flg`, (CASE WHEN `Enquete`.`end_date` < NOW() THEN TRUE ELSE FALSE END) AS `Enquete__close_flg` FROM `pachiseven`.`enquetes` AS `Enquete` WHERE `Enquete`.`del_flg` = 0 AND `Enquete`.`status` = 0 AND `Enquete`.`start_date` <= NOW() ORDER BY `Enquete`.`start_date` desc, `Enquete`.`end_date` desc, `Enquete`.`id` desc LIMIT 1111
35SELECT EnqueteChoice.id, EnqueteChoice.title, `EnqueteChoice`.`img`, `EnqueteChoice`.`enquete_id` FROM `pachiseven`.`enquete_choices` AS `EnqueteChoice` WHERE `EnqueteChoice`.`del_flg` = 0 AND `EnqueteChoice`.`enquete_id` = (27) ORDER BY `EnqueteChoice`.`sort_no` ASC 441
36SELECT `Handbill`.*, `Hall`.`name`, (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) AS `Handbill__sort_public`, (EXISTS (SELECT * FROM handbill_imps WHERE `handbill_imps`.`created` = CURRENT_DATE() AND `handbill_imps`.`handbill_id` = `Handbill`.`id`)) AS `Handbill__is_imps`, (CONCAT(`Hall`.`pref`, `Hall`.`city`, `Hall`.`address`)) AS `Handbill__full_address`, (RAND(3165)) AS `Handbill__sort_number` 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() 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`.`type` DESC, `Handbill`.`start_date` DESC, (RAND(3165)) ASC, `Handbill`.`id` ASC LIMIT 100087
37SELECT `Handbill`.*, `Hall`.`name`, (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) AS `Handbill__sort_public`, (EXISTS (SELECT * FROM handbill_imps WHERE `handbill_imps`.`created` = CURRENT_DATE() AND `handbill_imps`.`handbill_id` = `Handbill`.`id`)) AS `Handbill__is_imps`, (CONCAT(`Hall`.`pref`, `Hall`.`city`, `Hall`.`address`)) AS `Handbill__full_address`, (RAND(3165)) AS `Handbill__sort_number` 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() 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`.`type` DESC, `Handbill`.`start_date` DESC, (RAND(3165)) ASC, `Handbill`.`id` ASC LIMIT 100090
38SELECT `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
39SELECT `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
40SELECT `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