「禁煙のメリット」で成功する

「風邪をひいても煙草は吸う」それは禁断症状。

HOME » 禁煙の効果 » 禁煙のメリット

禁煙のメリット

嬉しい禁煙のメリット

禁煙のメリット

身体も心も若返る!

男女ともに一番に感じる禁煙のメリットは、体力の回復です。

タバコを吸っているときはほとんど気づきませんが、じつは喫煙者の体力はそうとう落ちています。

タバコを止めると身体が10歳若返ります。

さまざまな禁煙のメリット

  1. 健康に良い!体力が戻る。息切れがしない。
  2. イライラしなくなる。倦怠感が無くなる。
  3. 無駄な出費が減る。保険も安い。
  4. 顔が若返った。笑顔が素敵になった。
  5. 美肌になった。肌ツヤが戻った。
  6. 化粧品のノリが違う。
  7. 歯が黄色くならない。気持ちよくキスできる。w
  8. 口がくさくない。口臭が改善。
  9. 体や髪の毛がヤニ臭くない。
  10. よく眠れる。朝気持ちよく起きれる。
  11. ご飯が美味しい。お酒も美味しい。
  12. 肌荒れが治る。血行が良くなる。肩こりも治る。
  13. 壁紙の黄ばみや部屋の匂いを気にしなくてもよい。
  14. 喫煙場所を探し回らずにすむ。
  15. 公共施設や打ち合わせの際にタバコを我慢しなくてすむ。

これらは一般的によく言われる禁煙のメリットや効果です。

禁煙すると誰もが顔色や肌つやが良くなり、健康な身体に生まれ変わったように感じます。

まわりの人の禁煙のメリット

レストランまちあわせ場所で困らない

管理人の場合はコーヒー好きなので、待ち合わせの際、駅近のスターバックスに気軽に入れるようになるのが大きいですね。

コーヒーとタバコの組み合わせは現状で管理人にとって必要不可欠なもの。

ですがここは敢えてタバコとお別れします。

待ち合わせや打ち合わせで人に迷惑を掛けるのは、社会人として問題アリアリです。

社会生活上のメリット

  • 歩きタバコや路上喫煙で人に迷惑をかけないですむ。
  • レストランやカフェで煙を気にしなくて良い。
  • 副流煙による家族の受動喫煙がなくなる。
  • 小さい子供がタバコを誤飲する危険性がなくなる。

こうして見ていくと、タバコを吸う自分自身よりも、まわりの人への影響が問題になっていることがわかります。

タバコは自分一人の問題ではありません。タバコを止めればまわりの人にもメリットが大きいのです。

禁煙タバコ生活

「禁煙のメリット」関連のコンテンツ
禁煙のメリット
禁煙効果が現れる期間
体力回復
美肌効果
睡眠不足解消
禁煙貯金
食事が美味しい
口臭の改善
顔が若返る
がん保険が安くなる
血液がサラサラになる
タバコ計算機

禁煙タバコ生活

(default) 238 queries took 28 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `templates`881
2DESCRIBE `rankings`771
3DESCRIBE `comments`10101
4DESCRIBE `base_comments`771
5SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_h1`, `Site`.`introduction`, `Site`.`site_intro`, `Site`.`site_keyword`, `Site`.`site_url`, `Site`.`site_body`, `Site`.`analysis`, `Site`.`news_num`, `Site`.`disp_flag`, `Site`.`sitemap_flag`, `Site`.`contact_flag`, `Site`.`created`, `Site`.`modified` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1110
6SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_h1`, `Site`.`introduction`, `Site`.`site_intro`, `Site`.`site_keyword`, `Site`.`site_url`, `Site`.`site_body`, `Site`.`analysis`, `Site`.`news_num`, `Site`.`disp_flag`, `Site`.`sitemap_flag`, `Site`.`contact_flag`, `Site`.`created`, `Site`.`modified` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1110
7SELECT `Space`.`space_name`, `Space`.`id`, `Space`.`space_file`, `Space`.`adv_type`, `Space`.`adv_timage`, `Space`.`adv_tagtitle`, `Space`.`adv_tagtext`, `Space`.`adv_text`, `Space`.`adv_intro`, `Space`.`adv_html`, `Space`.`adv_image`, `Space`.`adv_url`, `Space`.`adv_alt`, `Space`.`adv_follow`, `Space`.`adv_target`, `Space`.`adv_space` FROM `spaces` AS `Space` WHERE `Space`.`use_flag` = 1 ORDER BY `Space`.`id` DESC 440
8SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 7 AND `Advertisement`.`start_date` < '2019-12-06 09:09:46' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2019-12-06 09:09:46')))) 110
9SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 6 AND `Advertisement`.`start_date` < '2019-12-06 09:09:46' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2019-12-06 09:09:46')))) 111
10SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 5 AND `Advertisement`.`start_date` < '2019-12-06 09:09:46' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2019-12-06 09:09:46')))) 110
11SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 4 AND `Advertisement`.`start_date` < '2019-12-06 09:09:46' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2019-12-06 09:09:46')))) 110
12SELECT `Advertisement`.`adv_name`, `Advertisement`.`adv_type`, `Advertisement`.`adv_text`, `Advertisement`.`adv_timage`, `Advertisement`.`adv_tagtitle`, `Advertisement`.`adv_tagtext`, `Advertisement`.`adv_intro`, `Advertisement`.`adv_html`, `Advertisement`.`adv_image`, `Advertisement`.`adv_url`, `Advertisement`.`adv_alt`, `Advertisement`.`adv_follow`, `Advertisement`.`adv_target`, `Advertisement`.`adv_space` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 4 AND `Advertisement`.`start_date` < '2019-12-06 09:09:46' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2019-12-06 09:09:46')))) ORDER BY `Advertisement`.`id` DESC 110
13SELECT `Ranking`.`id`, `Ranking`.`ng_ip`, `Ranking`.`recognition_flag`, `Ranking`.`limit_rating`, `Ranking`.`type_write`, `Ranking`.`created`, `Ranking`.`modified` FROM `rankings` AS `Ranking` WHERE `Ranking`.`id` = 1 LIMIT 1110
14SELECT `Basis`.`title`, `Basis`.`path_file`, `Basis`.`new_text`, `Basis`.`cat_id`, `Basis`.`disp_date`, `Category`.`belong_id`, `Category`.`cat_name`, `Category`.`cat_path_file`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`new_flag` = 1 AND `Basis`.`disp_date` <= '2019-12-06 09:09:46' ORDER BY `Basis`.`disp_date` DESC, `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 2223
15SELECT `Category`.`id`, `Category`.`belong_id`, `Category`.`position`, `Category`.`cat_name`, `Category`.`cat_path_file`, `Category`.`cat_temp`, `Category`.`list_temp`, `Category`.`order`, `Category`.`cat_description`, `Category`.`cat_keyword`, `Category`.`cat_exp`, `Category`.`catchcopy`, `Category`.`lead`, `Category`.`keitai_flag`, `Category`.`disp_flag`, `Category`.`pimg_size`, `Category`.`rank_flag`, `Category`.`limit_page`, `Category`.`renewal_adm`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`id` = 5 LIMIT 1110
16SELECT `Basis`.`id`, `Basis`.`title`, `Basis`.`cat_id`, `Basis`.`path_file`, `Basis`.`keyword`, `Basis`.`description`, `Basis`.`image`, `Basis`.`img_size`, `Basis`.`link_url`, `Basis`.`order`, `Basis`.`rate_number`, `Basis`.`rate_member`, `Basis`.`catchcopy`, `Basis`.`lead`, `Basis`.`page_temp`, `Basis`.`cont_temp`, `Basis`.`topdisp_flag`, `Basis`.`new_flag`, `Basis`.`renewal_flag`, `Basis`.`pickup_flag`, `Basis`.`bkup_flag`, `Basis`.`keitai_flag`, `Basis`.`new_text`, `Basis`.`comment_flag`, `Basis`.`list_disp_flag`, `Basis`.`disp_flag`, `Basis`.`disp_date`, `Basis`.`page_memo`, `Basis`.`renewal_adm`, `Basis`.`created`, `Basis`.`modified` FROM `bases` AS `Basis` WHERE `Basis`.`cat_id` = (5) ORDER BY `Basis`.`order` DESC 38381
17SELECT `Category`.`id`, `Category`.`belong_id`, `Category`.`position`, `Category`.`cat_name`, `Category`.`cat_path_file`, `Category`.`cat_temp`, `Category`.`list_temp`, `Category`.`order`, `Category`.`cat_description`, `Category`.`cat_keyword`, `Category`.`cat_exp`, `Category`.`catchcopy`, `Category`.`lead`, `Category`.`keitai_flag`, `Category`.`disp_flag`, `Category`.`pimg_size`, `Category`.`rank_flag`, `Category`.`limit_page`, `Category`.`renewal_adm`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`id` = 5 LIMIT 1110
18SELECT `Basis`.`id`, `Basis`.`title`, `Basis`.`cat_id`, `Basis`.`path_file`, `Basis`.`keyword`, `Basis`.`description`, `Basis`.`image`, `Basis`.`img_size`, `Basis`.`link_url`, `Basis`.`order`, `Basis`.`rate_number`, `Basis`.`rate_member`, `Basis`.`catchcopy`, `Basis`.`lead`, `Basis`.`page_temp`, `Basis`.`cont_temp`, `Basis`.`topdisp_flag`, `Basis`.`new_flag`, `Basis`.`renewal_flag`, `Basis`.`pickup_flag`, `Basis`.`bkup_flag`, `Basis`.`keitai_flag`, `Basis`.`new_text`, `Basis`.`comment_flag`, `Basis`.`list_disp_flag`, `Basis`.`disp_flag`, `Basis`.`disp_date`, `Basis`.`page_memo`, `Basis`.`renewal_adm`, `Basis`.`created`, `Basis`.`modified` FROM `bases` AS `Basis` WHERE `Basis`.`cat_id` = (5) ORDER BY `Basis`.`order` DESC 38381
19SELECT `Category`.`id`, `Category`.`cat_name`, `Category`.`belong_id`, `Category`.`cat_path_file`, `Category`.`disp_flag`, `Category`.`rank_flag` FROM `categories` AS `Category` WHERE `Category`.`disp_flag` = 1 AND `Category`.`belong_id` = 0 ORDER BY `Category`.`order` ASC 550
20SELECT `Basis`.`id`, `Basis`.`image`, `Basis`.`title`, `Basis`.`path_file`, `Basis`.`pickup_flag`, `Category`.`cat_path_file`, `Category`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`disp_date` <= '2019-12-06 09:09:46' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 2 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC 881
21SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 15 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
22SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 15 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
23SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 15 AND `Rating`.`disp_flag` = 1 110
24SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 2 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
25SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 2 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
26SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 2 AND `Rating`.`disp_flag` = 1 110
27SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 35 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
28SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 35 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
29SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 35 AND `Rating`.`disp_flag` = 1 110
30SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 6 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
31SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 6 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
32SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 6 AND `Rating`.`disp_flag` = 1 110
33SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 5 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
34SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 5 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
35SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 5 AND `Rating`.`disp_flag` = 1 110
36SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 4 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
37SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 4 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
38SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 4 AND `Rating`.`disp_flag` = 1 110
39SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 3 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
40SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 3 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
41SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 3 AND `Rating`.`disp_flag` = 1 110
42SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 73 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
43SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 73 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 111
44SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 73 AND `Rating`.`disp_flag` = 1 110
45SELECT `Category`.`id`, `Category`.`cat_name`, `Category`.`belong_id`, `Category`.`cat_path_file`, `Category`.`disp_flag` FROM `categories` AS `Category` WHERE `Category`.`disp_flag` = 1 AND `Category`.`belong_id` = 2 ORDER BY `Category`.`order` ASC 110
46SELECT `Basis`.`id`, `Basis`.`image`, `Basis`.`title`, `Basis`.`path_file`, `Basis`.`pickup_flag`, `Category`.`cat_path_file`, `Category`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`disp_date` <= '2019-12-06 09:09:46' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 1 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC 11112
47SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 19 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
48SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 19 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
49SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 19 AND `Rating`.`disp_flag` = 1 110
50SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 1 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
51SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 1 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
52SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 1 AND `Rating`.`disp_flag` = 1 110
53SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 21 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
54SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 21 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
55SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 21 AND `Rating`.`disp_flag` = 1 110
56SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 20 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
57SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 20 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
58SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 20 AND `Rating`.`disp_flag` = 1 110
59SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 23 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
60SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 23 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
61SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 23 AND `Rating`.`disp_flag` = 1 110
62SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 22 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
63SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 22 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
64SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 22 AND `Rating`.`disp_flag` = 1 110
65SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 24 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
66SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 24 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
67SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 24 AND `Rating`.`disp_flag` = 1 110
68SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 42 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
69SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 42 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
70SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 42 AND `Rating`.`disp_flag` = 1 110
71SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 66 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
72SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 66 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
73SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 66 AND `Rating`.`disp_flag` = 1 110
74SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 52 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
75SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 52 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
76SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 52 AND `Rating`.`disp_flag` = 1 110
77SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 25 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
78SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 25 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
79SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 25 AND `Rating`.`disp_flag` = 1 110
80SELECT `Category`.`id`, `Category`.`cat_name`, `Category`.`belong_id`, `Category`.`cat_path_file`, `Category`.`disp_flag` FROM `categories` AS `Category` WHERE `Category`.`disp_flag` = 1 AND `Category`.`belong_id` = 1 ORDER BY `Category`.`order` ASC 000
81SELECT `Basis`.`id`, `Basis`.`image`, `Basis`.`title`, `Basis`.`path_file`, `Basis`.`pickup_flag`, `Category`.`cat_path_file`, `Category`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`disp_date` <= '2019-12-06 09:09:46' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 5 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC 21212
82SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 87 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
83SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 87 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
84SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 87 AND `Rating`.`disp_flag` = 1 110
85SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 87 ORDER BY `ContentList`.`id` ASC 12120
86SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 68 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
87SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 68 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
88SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 68 AND `Rating`.`disp_flag` = 1 110
89SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 68 ORDER BY `ContentList`.`id` ASC 12120
90SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 18 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
91SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 18 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
92SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 18 AND `Rating`.`disp_flag` = 1 110
93SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 18 ORDER BY `ContentList`.`id` ASC 13130
94SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 77 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
95SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 77 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
96SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 77 AND `Rating`.`disp_flag` = 1 110
97SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 77 ORDER BY `ContentList`.`id` ASC 12120
98SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 78 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
99SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 78 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
100SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 78 AND `Rating`.`disp_flag` = 1 110
101SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 78 ORDER BY `ContentList`.`id` ASC 12120
102SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 95 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
103SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 95 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
104SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 95 AND `Rating`.`disp_flag` = 1 110
105SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 95 ORDER BY `ContentList`.`id` ASC 12120
106SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 93 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
107SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 93 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
108SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 93 AND `Rating`.`disp_flag` = 1 110
109SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 93 ORDER BY `ContentList`.`id` ASC 12120
110SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 91 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
111SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 91 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
112SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 91 AND `Rating`.`disp_flag` = 1 110
113SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 91 ORDER BY `ContentList`.`id` ASC 12120
114SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 90 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
115SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 90 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
116SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 90 AND `Rating`.`disp_flag` = 1 110
117SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 90 ORDER BY `ContentList`.`id` ASC 12120
118SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 88 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
119SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 88 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
120SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 88 AND `Rating`.`disp_flag` = 1 110
121SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 88 ORDER BY `ContentList`.`id` ASC 12120
122SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 86 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
123SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 86 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
124SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 86 AND `Rating`.`disp_flag` = 1 110
125SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 86 ORDER BY `ContentList`.`id` ASC 12120
126SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 85 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
127SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 85 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
128SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 85 AND `Rating`.`disp_flag` = 1 110
129SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 85 ORDER BY `ContentList`.`id` ASC 12120
130SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 79 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
131SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 79 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
132SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 79 AND `Rating`.`disp_flag` = 1 110
133SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 79 ORDER BY `ContentList`.`id` ASC 12120
134SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 34 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1111
135SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 34 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
136SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 34 AND `Rating`.`disp_flag` = 1 110
137SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 34 ORDER BY `ContentList`.`id` ASC 12120
138SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 33 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
139SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 33 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
140SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 33 AND `Rating`.`disp_flag` = 1 110
141SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 33 ORDER BY `ContentList`.`id` ASC 11110
142SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 9 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
143SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 9 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
144SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 9 AND `Rating`.`disp_flag` = 1 110
145SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 9 ORDER BY `ContentList`.`id` ASC 12120
146SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 80 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
147SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 80 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
148SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 80 AND `Rating`.`disp_flag` = 1 110
149SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 80 ORDER BY `ContentList`.`id` ASC 12120
150SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 32 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
151SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 32 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
152SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 32 AND `Rating`.`disp_flag` = 1 110
153SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 32 ORDER BY `ContentList`.`id` ASC 11110
154SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 17 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
155SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 17 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
156SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 17 AND `Rating`.`disp_flag` = 1 110
157SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 17 ORDER BY `ContentList`.`id` ASC 12120
158SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 81 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
159SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 81 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
160SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 81 AND `Rating`.`disp_flag` = 1 110
161SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 81 ORDER BY `ContentList`.`id` ASC 12120
162SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 70 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
163SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 70 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
164SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 70 AND `Rating`.`disp_flag` = 1 110
165SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 70 ORDER BY `ContentList`.`id` ASC 12120
166SELECT `Category`.`id`, `Category`.`cat_name`, `Category`.`belong_id`, `Category`.`cat_path_file`, `Category`.`disp_flag` FROM `categories` AS `Category` WHERE `Category`.`disp_flag` = 1 AND `Category`.`belong_id` = 5 ORDER BY `Category`.`order` ASC 110
167SELECT `Basis`.`id`, `Basis`.`image`, `Basis`.`title`, `Basis`.`path_file`, `Basis`.`pickup_flag`, `Category`.`cat_path_file`, `Category`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`disp_date` <= '2019-12-06 09:09:46' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 3 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC 13132
168SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 41 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
169SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 41 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
170SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 41 AND `Rating`.`disp_flag` = 1 110
171SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 44 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
172SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 44 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
173SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 44 AND `Rating`.`disp_flag` = 1 110
174SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 46 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
175SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 46 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
176SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 46 AND `Rating`.`disp_flag` = 1 110
177SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 48 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
178SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 48 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
179SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 48 AND `Rating`.`disp_flag` = 1 110
180SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 47 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
181SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 47 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
182SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 47 AND `Rating`.`disp_flag` = 1 110
183SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 51 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
184SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 51 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
185SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 51 AND `Rating`.`disp_flag` = 1 110
186SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 49 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
187SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 49 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
188SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 49 AND `Rating`.`disp_flag` = 1 110
189SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 60 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
190SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 60 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
191SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 60 AND `Rating`.`disp_flag` = 1 110
192SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 45 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
193SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 45 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
194SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 45 AND `Rating`.`disp_flag` = 1 110
195SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 56 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
196SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 56 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
197SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 56 AND `Rating`.`disp_flag` = 1 110
198SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 50 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
199SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 50 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
200SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 50 AND `Rating`.`disp_flag` = 1 110