記事を条件検索する

ログインする
初回は会員登録(無料)になります

このサービスは「レポハピ」の仕組みを利用しています。
会員登録(無料)は、『人気店や企業から招待状が届く レポハピ』
サービスに登録となります。あらかじめご了承ください。

SNSから取得した情報は当サービスで利用し、招待状などの表示条件やフレンド間でお気入り記事共有などに利用します。

会員登録をすると、あなたのレポハピレベルが測定されます。

あなたの登録情報や興味関心、SNS利用状況で、届くオファーや招待状が変わります。

ログインしてください

LINEアカウントを利用してログインを行います。

本Webサービスでは、ログイン時の認証画面にて許可を頂いた場合のみ、あなたのLINEアカウントに登録されているメールアドレスを取得します。
取得したメールアドレスは、以下の目的以外では使用いたしません。また、法令に定められた場合を除き、第三者への提供はいたしません。

  • ユーザーIDとしてアカウントの管理に利用
  • パスワード再発行時の本人確認に利用
  • 通知、お知らせの送付
人気のタグ:
(default) 124 queries took 4313 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Writer`.`id`, `Writer`.`username`, `Writer`.`password`, `Writer`.`name`, `Writer`.`name_kana`, `Writer`.`nickname`, `Writer`.`phone`, `Writer`.`profile`, `Writer`.`profile_image`, `Writer`.`postal_code`, `Writer`.`prefecture_id`, `Writer`.`address2`, `Writer`.`address3`, `Writer`.`person_in_charge1`, `Writer`.`person_in_charge2`, `Writer`.`contact`, `Writer`.`department`, `Writer`.`email1`, `Writer`.`email2`, `Writer`.`homepage`, `Writer`.`contractor_name`, `Writer`.`contract_plan_type`, `Writer`.`company_logo`, `Writer`.`fan_program_note`, `Writer`.`last_login_date`, `Writer`.`type`, `Writer`.`external_link`, `Writer`.`tags`, `Writer`.`main_visual`, `Writer`.`contact_email`, `Writer`.`agency_code`, `Writer`.`initial_fee`, `Writer`.`monthly_fee_1`, `Writer`.`monthly_fee_2`, `Writer`.`directory`, `Writer`.`display_matching_personal_information`, `Writer`.`display_top`, `Writer`.`status`, `Writer`.`created`, `Writer`.`modified` FROM `repohappy_web`.`writers` AS `Writer` WHERE NOT (COALESCE(`Writer`.`status`, 0) = 'delete') AND `Writer`.`type` = 'fan' AND `Writer`.`id` = 92 LIMIT 1111
2SELECT COUNT(*) AS `count` FROM `repohappy_web`.`fans` AS `Fan` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Fan`.`user_id` = `User`.`id`) WHERE `Fan`.`address` LIKE '%/92'113
3SELECT COUNT(*) AS `count` FROM `repohappy_web`.`articles` AS `Article` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Article`.`external_id` = `Shop`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`shops` AS `Owners` ON (`Article`.`external_id` = `Owners`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`writers` AS `Writer` ON (`Article`.`external_id` = `Writer`.`id` AND model = 'writer') LEFT JOIN `repohappy_web`.`writers` AS `Author` ON (`Article`.`writer_id` = `Author`.`id`) LEFT JOIN `repohappy_web`.`shops` AS `OwnersAuthor` ON (`Article`.`external_id` = `OwnersAuthor`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`writers` AS `FanAuthor` ON (`Article`.`external_id` = `FanAuthor`.`id` AND model = 'writer') WHERE `Article`.`status` = 'published' AND `Article`.`external_id` = 92 AND ((`Article`.`type` IN ('press', 'fan')) AND (`Article`.`model` = 'writer')) GROUP BY `Article`.`id`27271
4SELECT `Article`.`id`, `Article`.`title`, `Article`.`main_image`, `Article`.`created`, `Article`.`modified`, `Article`.`category_id`, `Article`.`model`, `Article`.`type`, `Article`.`fan_type`, `Article`.`approval_date`, `Article`.`published_date`, `Writer`.`id`, `Writer`.`username`, `Writer`.`nickname`, `Writer`.`name`, `Writer`.`prefecture_id`, `Writer`.`address2`, `Author`.`profile_image`, `Author`.`nickname`, `FanAuthor`.`directory`, `Shop`.`id`, `Shop`.`city_id`, `Shop`.`shop_category`, `Shop`.`shop_name`, `Shop`.`shop_area`, `Shop`.`shop_area2`, `Shop`.`article_thumbnail`, `Shop`.`state`, `Shop`.`status`, (SELECT name FROM areas WHERE Shop.shop_area = areas.id) as area, (27) AS `Article__total_count` FROM `repohappy_web`.`articles` AS `Article` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Article`.`external_id` = `Shop`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`shops` AS `Owners` ON (`Article`.`external_id` = `Owners`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`writers` AS `Writer` ON (`Article`.`external_id` = `Writer`.`id` AND model = 'writer') LEFT JOIN `repohappy_web`.`writers` AS `Author` ON (`Article`.`writer_id` = `Author`.`id`) LEFT JOIN `repohappy_web`.`shops` AS `OwnersAuthor` ON (`Article`.`external_id` = `OwnersAuthor`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`writers` AS `FanAuthor` ON (`Article`.`external_id` = `FanAuthor`.`id` AND model = 'writer') WHERE `Article`.`status` = 'published' AND `Article`.`external_id` = 92 AND ((`Article`.`type` IN ('press', 'fan')) AND (`Article`.`model` = 'writer')) GROUP BY `Article`.`id` ORDER BY `Article`.`page_view_count` desc LIMIT 1010101
5SELECT `ArticleItem`.`id`, `ArticleItem`.`article_id`, `ArticleItem`.`title`, `ArticleItem`.`text`, `ArticleItem`.`media`, `ArticleItem`.`type`, `ArticleItem`.`sort`, `ArticleItem`.`created`, `ArticleItem`.`modified` FROM `repohappy_web`.`article_items` AS `ArticleItem` WHERE `ArticleItem`.`article_id` IN (900, 1132, 913, 958, 1254, 1258, 924, 915, 911, 1065) ORDER BY `ArticleItem`.`sort` ASC1691692
6SELECT `ArticleTag`.`id`, `ArticleTag`.`article_id`, `ArticleTag`.`tag_id`, `ArticleTag`.`created`, `ArticleTag`.`modified` FROM `repohappy_web`.`article_tags` AS `ArticleTag` WHERE `ArticleTag`.`article_id` IN (900, 1132, 913, 958, 1254, 1258, 924, 915, 911, 1065)10100
7SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` IN (900, 1132, 913, 958, 1254, 1258, 924, 915, 911, 1065)65651
8SELECT `Comment`.`id`, `Comment`.`article_id`, `Comment`.`user_id`, `Comment`.`icon`, `Comment`.`comment`, `Comment`.`status`, `Comment`.`created`, `Comment`.`modified` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` IN (900, 1132, 913, 958, 1254, 1258, 924, 915, 911, 1065)000
9SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 900 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
10SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/900' AND `Interest`.`cookie` = '' LIMIT 1001
11SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 900 AND `Favorite`.`model` = 'article'111
12SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/900'110
13SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 900 AND NOT (`Comment`.`status` = 'delete')110
14SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '900' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')1116
15SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 1132 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
16SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1132' AND `Interest`.`cookie` = '' LIMIT 1001
17SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 1132 AND `Favorite`.`model` = 'article'111
18SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1132'110
19SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 1132 AND NOT (`Comment`.`status` = 'delete')110
20SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '1132' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')1111
21SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 913 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
22SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/913' AND `Interest`.`cookie` = '' LIMIT 1001
23SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 913 AND `Favorite`.`model` = 'article'110
24SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/913'110
25SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 913 AND NOT (`Comment`.`status` = 'delete')110
26SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '913' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')113
27SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 958 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
28SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/958' AND `Interest`.`cookie` = '' LIMIT 1001
29SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 958 AND `Favorite`.`model` = 'article'111
30SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/958'110
31SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 958 AND NOT (`Comment`.`status` = 'delete')110
32SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '958' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')112
33SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 1254 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
34SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1254' AND `Interest`.`cookie` = '' LIMIT 1001
35SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 1254 AND `Favorite`.`model` = 'article'110
36SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1254'110
37SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 1254 AND NOT (`Comment`.`status` = 'delete')110
38SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '1254' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')112
39SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 1258 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
40SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1258' AND `Interest`.`cookie` = '' LIMIT 1001
41SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 1258 AND `Favorite`.`model` = 'article'110
42SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1258'110
43SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 1258 AND NOT (`Comment`.`status` = 'delete')110
44SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '1258' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')112
45SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 924 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
46SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/924' AND `Interest`.`cookie` = '' LIMIT 1001
47SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 924 AND `Favorite`.`model` = 'article'110
48SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/924'110
49SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 924 AND NOT (`Comment`.`status` = 'delete')110
50SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '924' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')112
51SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 915 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
52SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/915' AND `Interest`.`cookie` = '' LIMIT 1001
53SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 915 AND `Favorite`.`model` = 'article'110
54SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/915'110
55SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 915 AND NOT (`Comment`.`status` = 'delete')110
56SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '915' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')112
57SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 911 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
58SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/911' AND `Interest`.`cookie` = '' LIMIT 1001
59SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 911 AND `Favorite`.`model` = 'article'110
60SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/911'110
61SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 911 AND NOT (`Comment`.`status` = 'delete')110
62SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '911' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')112
63SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 1065 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
64SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1065' AND `Interest`.`cookie` = '' LIMIT 1001
65SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 1065 AND `Favorite`.`model` = 'article'110
66SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1065'110
67SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 1065 AND NOT (`Comment`.`status` = 'delete')110
68SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '1065' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')112
69SELECT `Article`.`id`, `Article`.`title` FROM `repohappy_web`.`articles` AS `Article` WHERE `Article`.`external_id` = 92 AND `Article`.`Type` IN ('press', 'fan')39391
70SELECT `ArticleTag`.`id`, `ArticleTag`.`article_id`, `ArticleTag`.`tag_id`, `ArticleTag`.`created`, `ArticleTag`.`modified`, `Tag`.`id`, `Tag`.`external_id`, `Tag`.`name`, `Tag`.`type`, `Tag`.`level`, `Tag`.`status`, `Tag`.`created`, `Tag`.`modified` FROM `repohappy_web`.`article_tags` AS `ArticleTag` LEFT JOIN `repohappy_web`.`tags` AS `Tag` ON (`ArticleTag`.`tag_id` = `Tag`.`id`) WHERE `ArticleTag`.`article_id` IN (900, 911, 912, 913, 915, 923, 924, 925, 926, 927, 928, 946, 958, 983, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1076, 1087, 1096, 1132, 1148, 1254, 1258, 1259, 1274, 1277, 1284, 1399, 1400, 1401, 1408, 1409) GROUP BY `ArticleTag`.`article_id`39391
71SELECT `Tag`.`id`, `Tag`.`name` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`UserTagPoint`.`user_id` = `User`.`id`) LEFT JOIN `repohappy_web`.`tags` AS `Tag` ON (`UserTagPoint`.`tag_id` = `Tag`.`id`) WHERE `UserTagPoint`.`tag_id` IN (20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 265, 265, 265, 265, 265, 265) AND `UserTagPoint`.`action` = 'page_view_fan' GROUP BY `UserTagPoint`.`tag_id`000
72SELECT `Article`.`id`, `Article`.`writer_id`, `Article`.`shop_id`, `Article`.`external_id`, `Article`.`category_id`, `Article`.`title`, `Article`.`main_image`, `Article`.`url`, `Article`.`recommendation`, `Article`.`main_visual`, `Article`.`featured`, `Article`.`fan_type`, `Article`.`type`, `Article`.`model`, `Article`.`keywords1`, `Article`.`keywords2`, `Article`.`status`, `Article`.`display_comment_button`, `Article`.`page_view_count`, `Article`.`interview_date`, `Article`.`approval_date`, `Article`.`published_date`, `Article`.`created`, `Article`.`modified`, (SELECT count(`user_tag_points`.`id`) FROM user_tag_points WHERE `user_tag_points`.`entity_id` = `Article`.`id` AND `user_tag_points`.`action` IN ("page_view_gourmet", "page_view_fan")) AS `Article__views`, (27) AS `Article__total_count`, `Shop`.`id`, `Shop`.`login_id`, `Shop`.`password`, `Shop`.`shop_kind`, `Shop`.`shop_category`, `Shop`.`shop_name`, `Shop`.`shop_name_kana`, `Shop`.`shop_tel`, `Shop`.`officer_name`, `Shop`.`officer_name_kana`, `Shop`.`supervisor_name`, `Shop`.`staff_name`, `Shop`.`staff_name_kana`, `Shop`.`staff_tel`, `Shop`.`staff_mail`, `Shop`.`mail2`, `Shop`.`monthly_basic_price`, `Shop`.`monthly_uu_unit_price`, `Shop`.`initial_fee`, `Shop`.`main_visual_1`, `Shop`.`main_visual_2`, `Shop`.`main_visual_3`, `Shop`.`main_visual_4`, `Shop`.`article_thumbnail`, `Shop`.`shop_url`, `Shop`.`external_url`, `Shop`.`postal_code`, `Shop`.`state`, `Shop`.`city_id`, `Shop`.`street`, `Shop`.`shop_open_start`, `Shop`.`shop_open_end`, `Shop`.`shop_area`, `Shop`.`shop_area2`, `Shop`.`offer_total`, `Shop`.`offer_person`, `Shop`.`matching_total`, `Shop`.`agreement_date`, `Shop`.`cancel_date`, `Shop`.`agreement_plan`, `Shop`.`picture1`, `Shop`.`picture1_ext`, `Shop`.`picture2`, `Shop`.`picture2_ext`, `Shop`.`matching_menu`, `Shop`.`is_suspension_service`, `Shop`.`shop_pr1`, `Shop`.`shop_pr2`, `Shop`.`holiday`, `Shop`.`special_gift`, `Shop`.`gift_period`, `Shop`.`agency_code`, `Shop`.`payment_method`, `Shop`.`credit_card_status`, `Shop`.`business_hours`, `Shop`.`average_budget`, `Shop`.`available_days_before_reservation`, `Shop`.`phone`, `Shop`.`seats`, `Shop`.`nearest_station`, `Shop`.`reward`, `Shop`.`miruden`, `Shop`.`promotion_banner_image`, `Shop`.`promotion_banner_url`, `Shop`.`type`, `Shop`.`job_use_flg`, `Shop`.`test`, `Shop`.`token`, `Shop`.`status`, `Shop`.`delete_flg`, `Shop`.`created`, `Shop`.`modified`, `Owners`.`id`, `Owners`.`login_id`, `Owners`.`password`, `Owners`.`shop_kind`, `Owners`.`shop_category`, `Owners`.`shop_name`, `Owners`.`shop_name_kana`, `Owners`.`shop_tel`, `Owners`.`officer_name`, `Owners`.`officer_name_kana`, `Owners`.`supervisor_name`, `Owners`.`staff_name`, `Owners`.`staff_name_kana`, `Owners`.`staff_tel`, `Owners`.`staff_mail`, `Owners`.`mail2`, `Owners`.`monthly_basic_price`, `Owners`.`monthly_uu_unit_price`, `Owners`.`initial_fee`, `Owners`.`main_visual_1`, `Owners`.`main_visual_2`, `Owners`.`main_visual_3`, `Owners`.`main_visual_4`, `Owners`.`article_thumbnail`, `Owners`.`shop_url`, `Owners`.`external_url`, `Owners`.`postal_code`, `Owners`.`state`, `Owners`.`city_id`, `Owners`.`street`, `Owners`.`shop_open_start`, `Owners`.`shop_open_end`, `Owners`.`shop_area`, `Owners`.`shop_area2`, `Owners`.`offer_total`, `Owners`.`offer_person`, `Owners`.`matching_total`, `Owners`.`agreement_date`, `Owners`.`cancel_date`, `Owners`.`agreement_plan`, `Owners`.`picture1`, `Owners`.`picture1_ext`, `Owners`.`picture2`, `Owners`.`picture2_ext`, `Owners`.`matching_menu`, `Owners`.`is_suspension_service`, `Owners`.`shop_pr1`, `Owners`.`shop_pr2`, `Owners`.`holiday`, `Owners`.`special_gift`, `Owners`.`gift_period`, `Owners`.`agency_code`, `Owners`.`payment_method`, `Owners`.`credit_card_status`, `Owners`.`business_hours`, `Owners`.`average_budget`, `Owners`.`available_days_before_reservation`, `Owners`.`phone`, `Owners`.`seats`, `Owners`.`nearest_station`, `Owners`.`reward`, `Owners`.`miruden`, `Owners`.`promotion_banner_image`, `Owners`.`promotion_banner_url`, `Owners`.`type`, `Owners`.`job_use_flg`, `Owners`.`test`, `Owners`.`token`, `Owners`.`status`, `Owners`.`delete_flg`, `Owners`.`created`, `Owners`.`modified`, `Writer`.`id`, `Writer`.`username`, `Writer`.`password`, `Writer`.`name`, `Writer`.`name_kana`, `Writer`.`nickname`, `Writer`.`phone`, `Writer`.`profile`, `Writer`.`profile_image`, `Writer`.`postal_code`, `Writer`.`prefecture_id`, `Writer`.`address2`, `Writer`.`address3`, `Writer`.`person_in_charge1`, `Writer`.`person_in_charge2`, `Writer`.`contact`, `Writer`.`department`, `Writer`.`email1`, `Writer`.`email2`, `Writer`.`homepage`, `Writer`.`contractor_name`, `Writer`.`contract_plan_type`, `Writer`.`company_logo`, `Writer`.`fan_program_note`, `Writer`.`last_login_date`, `Writer`.`type`, `Writer`.`external_link`, `Writer`.`tags`, `Writer`.`main_visual`, `Writer`.`contact_email`, `Writer`.`agency_code`, `Writer`.`initial_fee`, `Writer`.`monthly_fee_1`, `Writer`.`monthly_fee_2`, `Writer`.`directory`, `Writer`.`display_matching_personal_information`, `Writer`.`display_top`, `Writer`.`status`, `Writer`.`created`, `Writer`.`modified`, `Author`.`id`, `Author`.`username`, `Author`.`password`, `Author`.`name`, `Author`.`name_kana`, `Author`.`nickname`, `Author`.`phone`, `Author`.`profile`, `Author`.`profile_image`, `Author`.`postal_code`, `Author`.`prefecture_id`, `Author`.`address2`, `Author`.`address3`, `Author`.`person_in_charge1`, `Author`.`person_in_charge2`, `Author`.`contact`, `Author`.`department`, `Author`.`email1`, `Author`.`email2`, `Author`.`homepage`, `Author`.`contractor_name`, `Author`.`contract_plan_type`, `Author`.`company_logo`, `Author`.`fan_program_note`, `Author`.`last_login_date`, `Author`.`type`, `Author`.`external_link`, `Author`.`tags`, `Author`.`main_visual`, `Author`.`contact_email`, `Author`.`agency_code`, `Author`.`initial_fee`, `Author`.`monthly_fee_1`, `Author`.`monthly_fee_2`, `Author`.`directory`, `Author`.`display_matching_personal_information`, `Author`.`display_top`, `Author`.`status`, `Author`.`created`, `Author`.`modified`, `OwnersAuthor`.`id`, `OwnersAuthor`.`login_id`, `OwnersAuthor`.`password`, `OwnersAuthor`.`shop_kind`, `OwnersAuthor`.`shop_category`, `OwnersAuthor`.`shop_name`, `OwnersAuthor`.`shop_name_kana`, `OwnersAuthor`.`shop_tel`, `OwnersAuthor`.`officer_name`, `OwnersAuthor`.`officer_name_kana`, `OwnersAuthor`.`supervisor_name`, `OwnersAuthor`.`staff_name`, `OwnersAuthor`.`staff_name_kana`, `OwnersAuthor`.`staff_tel`, `OwnersAuthor`.`staff_mail`, `OwnersAuthor`.`mail2`, `OwnersAuthor`.`monthly_basic_price`, `OwnersAuthor`.`monthly_uu_unit_price`, `OwnersAuthor`.`initial_fee`, `OwnersAuthor`.`main_visual_1`, `OwnersAuthor`.`main_visual_2`, `OwnersAuthor`.`main_visual_3`, `OwnersAuthor`.`main_visual_4`, `OwnersAuthor`.`article_thumbnail`, `OwnersAuthor`.`shop_url`, `OwnersAuthor`.`external_url`, `OwnersAuthor`.`postal_code`, `OwnersAuthor`.`state`, `OwnersAuthor`.`city_id`, `OwnersAuthor`.`street`, `OwnersAuthor`.`shop_open_start`, `OwnersAuthor`.`shop_open_end`, `OwnersAuthor`.`shop_area`, `OwnersAuthor`.`shop_area2`, `OwnersAuthor`.`offer_total`, `OwnersAuthor`.`offer_person`, `OwnersAuthor`.`matching_total`, `OwnersAuthor`.`agreement_date`, `OwnersAuthor`.`cancel_date`, `OwnersAuthor`.`agreement_plan`, `OwnersAuthor`.`picture1`, `OwnersAuthor`.`picture1_ext`, `OwnersAuthor`.`picture2`, `OwnersAuthor`.`picture2_ext`, `OwnersAuthor`.`matching_menu`, `OwnersAuthor`.`is_suspension_service`, `OwnersAuthor`.`shop_pr1`, `OwnersAuthor`.`shop_pr2`, `OwnersAuthor`.`holiday`, `OwnersAuthor`.`special_gift`, `OwnersAuthor`.`gift_period`, `OwnersAuthor`.`agency_code`, `OwnersAuthor`.`payment_method`, `OwnersAuthor`.`credit_card_status`, `OwnersAuthor`.`business_hours`, `OwnersAuthor`.`average_budget`, `OwnersAuthor`.`available_days_before_reservation`, `OwnersAuthor`.`phone`, `OwnersAuthor`.`seats`, `OwnersAuthor`.`nearest_station`, `OwnersAuthor`.`reward`, `OwnersAuthor`.`miruden`, `OwnersAuthor`.`promotion_banner_image`, `OwnersAuthor`.`promotion_banner_url`, `OwnersAuthor`.`type`, `OwnersAuthor`.`job_use_flg`, `OwnersAuthor`.`test`, `OwnersAuthor`.`token`, `OwnersAuthor`.`status`, `OwnersAuthor`.`delete_flg`, `OwnersAuthor`.`created`, `OwnersAuthor`.`modified`, `FanAuthor`.`id`, `FanAuthor`.`username`, `FanAuthor`.`password`, `FanAuthor`.`name`, `FanAuthor`.`name_kana`, `FanAuthor`.`nickname`, `FanAuthor`.`phone`, `FanAuthor`.`profile`, `FanAuthor`.`profile_image`, `FanAuthor`.`postal_code`, `FanAuthor`.`prefecture_id`, `FanAuthor`.`address2`, `FanAuthor`.`address3`, `FanAuthor`.`person_in_charge1`, `FanAuthor`.`person_in_charge2`, `FanAuthor`.`contact`, `FanAuthor`.`department`, `FanAuthor`.`email1`, `FanAuthor`.`email2`, `FanAuthor`.`homepage`, `FanAuthor`.`contractor_name`, `FanAuthor`.`contract_plan_type`, `FanAuthor`.`company_logo`, `FanAuthor`.`fan_program_note`, `FanAuthor`.`last_login_date`, `FanAuthor`.`type`, `FanAuthor`.`external_link`, `FanAuthor`.`tags`, `FanAuthor`.`main_visual`, `FanAuthor`.`contact_email`, `FanAuthor`.`agency_code`, `FanAuthor`.`initial_fee`, `FanAuthor`.`monthly_fee_1`, `FanAuthor`.`monthly_fee_2`, `FanAuthor`.`directory`, `FanAuthor`.`display_matching_personal_information`, `FanAuthor`.`display_top`, `FanAuthor`.`status`, `FanAuthor`.`created`, `FanAuthor`.`modified` FROM `repohappy_web`.`articles` AS `Article` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Article`.`external_id` = `Shop`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`shops` AS `Owners` ON (`Article`.`external_id` = `Owners`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`writers` AS `Writer` ON (`Article`.`external_id` = `Writer`.`id` AND model = 'writer') LEFT JOIN `repohappy_web`.`writers` AS `Author` ON (`Article`.`writer_id` = `Author`.`id`) LEFT JOIN `repohappy_web`.`shops` AS `OwnersAuthor` ON (`Article`.`external_id` = `OwnersAuthor`.`id` AND model = 'shop') LEFT JOIN `repohappy_web`.`writers` AS `FanAuthor` ON (`Article`.`external_id` = `FanAuthor`.`id` AND model = 'writer') WHERE `Article`.`external_id` = 92 AND `Article`.`Type` IN ('press', 'fan') AND `Article`.`status` = 'published' ORDER BY `Article`.`published_date` desc LIMIT 8884226
73SELECT `ArticleItem`.`id`, `ArticleItem`.`article_id`, `ArticleItem`.`title`, `ArticleItem`.`text`, `ArticleItem`.`media`, `ArticleItem`.`type`, `ArticleItem`.`sort`, `ArticleItem`.`created`, `ArticleItem`.`modified` FROM `repohappy_web`.`article_items` AS `ArticleItem` WHERE `ArticleItem`.`article_id` IN (1076, 1070, 1068, 1067, 1096, 1064, 1254, 1069) ORDER BY `ArticleItem`.`sort` ASC92921
74SELECT `ArticleTag`.`id`, `ArticleTag`.`article_id`, `ArticleTag`.`tag_id`, `ArticleTag`.`created`, `ArticleTag`.`modified` FROM `repohappy_web`.`article_tags` AS `ArticleTag` WHERE `ArticleTag`.`article_id` IN (1076, 1070, 1068, 1067, 1096, 1064, 1254, 1069)880
75SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` IN (1076, 1070, 1068, 1067, 1096, 1064, 1254, 1069)12121
76SELECT `Comment`.`id`, `Comment`.`article_id`, `Comment`.`user_id`, `Comment`.`icon`, `Comment`.`comment`, `Comment`.`status`, `Comment`.`created`, `Comment`.`modified` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` IN (1076, 1070, 1068, 1067, 1096, 1064, 1254, 1069)000
77SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 1076 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
78SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1076' AND `Interest`.`cookie` = '' LIMIT 1001
79SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 1076 AND `Favorite`.`model` = 'article'110
80SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1076'110
81SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 1076 AND NOT (`Comment`.`status` = 'delete')110
82SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '1076' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')110
83SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 1070 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
84SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1070' AND `Interest`.`cookie` = '' LIMIT 1001
85SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 1070 AND `Favorite`.`model` = 'article'110
86SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1070'110
87SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 1070 AND NOT (`Comment`.`status` = 'delete')110
88SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '1070' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')111
89SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 1068 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
90SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1068' AND `Interest`.`cookie` = '' LIMIT 1001
91SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 1068 AND `Favorite`.`model` = 'article'110
92SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1068'110
93SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 1068 AND NOT (`Comment`.`status` = 'delete')110
94SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '1068' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')110
95SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 1067 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
96SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1067' AND `Interest`.`cookie` = '' LIMIT 1001
97SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 1067 AND `Favorite`.`model` = 'article'110
98SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1067'110
99SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 1067 AND NOT (`Comment`.`status` = 'delete')110
100SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '1067' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')111
101SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 1096 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
102SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1096' AND `Interest`.`cookie` = '' LIMIT 1001
103SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 1096 AND `Favorite`.`model` = 'article'110
104SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1096'110
105SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 1096 AND NOT (`Comment`.`status` = 'delete')110
106SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '1096' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')111
107SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 1064 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
108SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1064' AND `Interest`.`cookie` = '' LIMIT 1001
109SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 1064 AND `Favorite`.`model` = 'article'110
110SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1064'110
111SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 1064 AND NOT (`Comment`.`status` = 'delete')110
112SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '1064' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')112
113SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 1254 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
114SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1254' AND `Interest`.`cookie` = '' LIMIT 1001
115SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 1254 AND `Favorite`.`model` = 'article'110
116SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1254'110
117SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 1254 AND NOT (`Comment`.`status` = 'delete')110
118SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '1254' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')112
119SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 1069 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
120SELECT `Interest`.`id`, `Interest`.`user_id`, `Interest`.`cookie`, `Interest`.`address`, `Interest`.`created`, `Interest`.`modified`, `User`.`id`, `User`.`login_id`, `User`.`uid`, `User`.`name`, `User`.`name_kana`, `User`.`first_name`, `User`.`last_name`, `User`.`age`, `User`.`gender`, `User`.`pref_id`, `User`.`city_id`, `User`.`street`, `User`.`tel`, `User`.`birthday`, `User`.`mail`, `User`.`job`, `User`.`relationship_status`, `User`.`family`, `User`.`mobile_carriers`, `User`.`picture`, `User`.`is_show_picture`, `User`.`prefecture1`, `User`.`prefecture2`, `User`.`prefecture3`, `User`.`area1`, `User`.`area2`, `User`.`area3`, `User`.`matching`, `User`.`impression`, `User`.`satisfaction_point_avg`, `User`.`all_point_avg`, `User`.`low_evaluation_flg`, `User`.`low_reporting_rate_flg`, `User`.`offer_time`, `User`.`offer_catagory`, `User`.`rank_point`, `User`.`rank_point_base`, `User`.`rank`, `User`.`level`, `User`.`sns_type`, `User`.`sns_id`, `User`.`sns_screen_name`, `User`.`sns_data`, `User`.`friend`, `User`.`friends`, `User`.`friends_display`, `User`.`last_login`, `User`.`mail_send_denied`, `User`.`withdraw`, `User`.`token`, `User`.`type`, `User`.`status`, `User`.`agreement`, `User`.`tag_score`, `User`.`prohibit_comment`, `User`.`blog_url`, `User`.`blog_token`, `User`.`access_token`, `User`.`blog`, `User`.`basic_score_1`, `User`.`basic_score_2`, `User`.`basic_score_3`, `User`.`additional_score_1`, `User`.`additional_score_2`, `User`.`external_client_token`, `User`.`stop_client_mail_send_denied`, `User`.`delete_flg`, `User`.`created`, `User`.`modified`, (TIMESTAMPDIFF(YEAR, birthday, CURDATE())) AS `User__user_age`, (FLOOR(basic_score_1 + basic_score_2 + basic_score_3 + additional_score_1 + additional_score_2)) AS `User__score` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1069' AND `Interest`.`cookie` = '' LIMIT 1001
121SELECT COUNT(*) AS `count` FROM `repohappy_web`.`favorites` AS `Favorite` LEFT JOIN `repohappy_web`.`shops` AS `Shop` ON (`Favorite`.`external_id` = `Shop`.`id` AND `Favorite`.`model` = 'shop') LEFT JOIN `repohappy_web`.`articles` AS `Article` ON (`Favorite`.`external_id` = `Article`.`id` AND `Favorite`.`model` = 'article') LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) WHERE `Favorite`.`external_id` = 1069 AND `Favorite`.`model` = 'article'111
122SELECT COUNT(*) AS `count` FROM `repohappy_web`.`interests` AS `Interest` LEFT JOIN `repohappy_web`.`users` AS `User` ON (`Interest`.`user_id` = `User`.`id`) WHERE `Interest`.`address` = '/press/articles/view/1069'110
123SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 1069 AND NOT (`Comment`.`status` = 'delete')110
124SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '1069' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')111