記事を条件検索する

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

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

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

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

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

ログインしてください

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

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

  • ユーザーIDとしてアカウントの管理に利用
  • パスワード再発行時の本人確認に利用
  • 通知、お知らせの送付
(default) 64 queries took 1978 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` = 78 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 '%/78'112
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` = 78 AND ((`Article`.`type` IN ('press', 'fan')) AND (`Article`.`model` = 'writer')) GROUP BY `Article`.`id`441
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, (4) 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` = 78 AND ((`Article`.`type` IN ('press', 'fan')) AND (`Article`.`model` = 'writer')) GROUP BY `Article`.`id` ORDER BY `Article`.`published_date` desc LIMIT 10441
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 (897, 812, 773, 767) ORDER BY `ArticleItem`.`sort` ASC68681
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 (897, 812, 773, 767)880
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 (897, 812, 773, 767)880
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 (897, 812, 773, 767)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` = 897 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1001
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/897' 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` = 897 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/897'111
13SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 897 AND NOT (`Comment`.`status` = 'delete')110
14SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '897' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')114
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` = 812 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/812' 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` = 812 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/812'110
19SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 812 AND NOT (`Comment`.`status` = 'delete')110
20SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '812' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')112
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` = 773 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/773' 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` = 773 AND `Favorite`.`model` = 'article'111
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/773'110
25SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 773 AND NOT (`Comment`.`status` = 'delete')110
26SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '773' 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` = 767 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1001
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/767' 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` = 767 AND `Favorite`.`model` = 'article'110
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/767'110
31SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 767 AND NOT (`Comment`.`status` = 'delete')110
32SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '767' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')113
33SELECT `Article`.`id`, `Article`.`title` FROM `repohappy_web`.`articles` AS `Article` WHERE `Article`.`external_id` = 78 AND `Article`.`Type` IN ('press', 'fan')550
34SELECT `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 (767, 773, 812, 813, 897) GROUP BY `ArticleTag`.`article_id`551
35SELECT `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 (67, 67, 67, 67, 67) AND `UserTagPoint`.`action` = 'page_view_fan' GROUP BY `UserTagPoint`.`tag_id`000
36SELECT `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`, (4) 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` = 78 AND `Article`.`Type` IN ('press', 'fan') AND `Article`.`status` = 'published' ORDER BY `Article`.`published_date` desc LIMIT 8441926
37SELECT `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 (897, 812, 773, 767) ORDER BY `ArticleItem`.`sort` ASC68681
38SELECT `ArticleTag`.`id`, `ArticleTag`.`article_id`, `ArticleTag`.`tag_id`, `ArticleTag`.`created`, `ArticleTag`.`modified` FROM `repohappy_web`.`article_tags` AS `ArticleTag` WHERE `ArticleTag`.`article_id` IN (897, 812, 773, 767)880
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` IN (897, 812, 773, 767)881
40SELECT `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 (897, 812, 773, 767)001
41SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 897 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
42SELECT `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/897' AND `Interest`.`cookie` = '' LIMIT 1001
43SELECT 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` = 897 AND `Favorite`.`model` = 'article'110
44SELECT 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/897'110
45SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 897 AND NOT (`Comment`.`status` = 'delete')111
46SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '897' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')114
47SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 812 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
48SELECT `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/812' AND `Interest`.`cookie` = '' LIMIT 1001
49SELECT 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` = 812 AND `Favorite`.`model` = 'article'111
50SELECT 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/812'110
51SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 812 AND NOT (`Comment`.`status` = 'delete')110
52SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '812' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')112
53SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 773 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
54SELECT `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/773' AND `Interest`.`cookie` = '' LIMIT 1001
55SELECT 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` = 773 AND `Favorite`.`model` = 'article'111
56SELECT 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/773'110
57SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 773 AND NOT (`Comment`.`status` = 'delete')110
58SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '773' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')113
59SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`external_id`, `Favorite`.`model`, `Favorite`.`created`, `Favorite`.`modified` FROM `repohappy_web`.`favorites` AS `Favorite` WHERE `Favorite`.`external_id` = 767 AND `Favorite`.`model` = 'article' AND `Favorite`.`user_id` IS NULL LIMIT 1000
60SELECT `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/767' AND `Interest`.`cookie` = '' LIMIT 1001
61SELECT 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` = 767 AND `Favorite`.`model` = 'article'111
62SELECT 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/767'110
63SELECT COUNT(*) AS `count` FROM `repohappy_web`.`comments` AS `Comment` WHERE `Comment`.`article_id` = 767 AND NOT (`Comment`.`status` = 'delete')110
64SELECT COUNT(*) AS `count` FROM `repohappy_web`.`user_tag_points` AS `UserTagPoint` WHERE `UserTagPoint`.`entity_id` = '767' AND `UserTagPoint`.`action` IN ('page_view_gourmet', 'page_view_fan')113