「コストと効果」で成功する

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

HOME » 禁煙の方法 » コストと効果

コストと効果

禁煙にはお金がかかる…! 禁煙するならコストは覚悟すべし!

コストと効果

禁煙にはお金がかかる

タバコを吸うことを我慢しようとして、その結果、タバコ代の方が安いのではないのか!? と思うほど出費がかさんでしまう。

こんな経験、身に覚えがある方も多いと思います。

禁煙のし始めというのは、ガムであったり、フリスクであったり、様々な嗜好品(代用品)についつい手が出てしまいます。

何かを口にすることで口寂しさを紛らわせようとするからです。

禁煙コスト<<<タバコを止められた効果!

タバコを止めるために、タバコ代以上お金をかけてどうする!? とお思いの方もいるでしょう。

ですが管理人はそれでもタバコを止めた方が良いと判断しています。

なぜならタバコをやめるのにいくらコストがかかったとしても、タバコを止められたときの見返りの方が遥かに大きいからです。

それは健康面だけでなく、金銭面からもです。

禁煙にかかる期間とお金はたった3ヶ月分!

禁煙外来での平均治療期間は3ヶ月です。

逆に言えば、禁煙を宣言して3ヶ月後に止められていなければ、その人は禁煙に失敗したのです。

良くも悪くも禁煙は3ヶ月でハッキリ結果が出ます

その意味で禁煙にかかる費用は、どんなにかかっても3ヶ月分だけの一時的なものなのです。

3ヶ月間の禁煙コストと、そのまま継続して吸い続けた場合のタバコ代、どちらがお金がかかるかは火を見るよりも明らかです。

1ヶ月間タバコを吸うと、いくらになるのか?

管理人は職場環境の関係で日に少なくとも20本を吸っています。

およそ1日1箱。1箱300円として単純計算で1ヶ月9,000円。

自分がタバコで使っている金額はタバコ計算機でチェック!

もちろん1日1箱以上吸うことも多々あります。

ですからもし仮に管理人が禁煙に成功したとしたら、1ヶ月で約1万円節約できる計算になります。

例えば10回やった内、1回でも成功すれば、禁煙にかかった費用のもとはあっというまに取れてしまいます。だからこそ管理人は何度も禁煙に挑戦しているのです。

もちろんお金のためだけじゃなく、健康のためにも、どんな方法であれ禁煙した方が得なのは当たり前です。

禁煙にかかるコスト=自分のタバコ代1ヶ月分

禁煙にチャレンジしている期間は、もちろんタバコを吸いません。

ですから別の見方をすれば、その我慢している期間分はタバコ代が浮く計算になります。

例えば管理人の場合、1ヶ月で1万円までは禁煙のためにお金を使っても損しないと考えています。

これが管理人が禁煙方法に1ヶ月でかけられるコストの目安です。

禁煙のために使ってもよい金額を、自分のタバコ代1ヶ月分とすれば、楽に始められるかもしれませんね。

誰もが永遠の禁煙チャレンジャー…じきにマゾヒスティックな悦びが…

本サイトで紹介する禁煙方法は、役に立つのも、お笑いにしかならないものも、ほぼすべて費用がかかるものばかりです。

本サイトの記事だけでなく、本やTV、ネットも参考にして、よーく選んで、もっとも自分にあった禁煙方法を見つけて下さい。

もちろん自分の意志のみで我慢して禁煙できる人も中にはいるのでしょう。ですが、それでできるなら誰もこんなに苦労はしません。

管理人なぞは6~7回禁煙に失敗していますが、ちかごろでは

斬新な禁煙方法を発見するたび、禁煙すること自体が面白くなってきています。

なんとかして禁煙してやろう、ここまでやっても駄目なのか!? と駄目な自分(や他人)の限界を知るたびにマゾヒスティックな悦びを覚えています。

皆さんはこのようなディープな世界にハマる前に、サクッと禁煙チャレンジャー生活を終了させてくださいね。

では、禁煙方法を見ていきましょう。

禁煙タバコ生活

「コストと効果」関連のコンテンツ
コストと効果
禁煙外来
ニコチンパッチ
禁煙グッズ紹介
禁煙旅行
禁煙マラソン
禁煙セラピー
イタリア式禁煙方法
タバコを吸い始めたきっかけ
タバコを吸う本当の理由
禁煙の禁断症状
禁煙コスト
ニコチン依存症診断テスト
ニコチン中毒度診断プログラム

禁煙タバコ生活

(default) 248 queries took 53 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `bases`31311
2DESCRIBE `categories`21211
3DESCRIBE `contents`661
4DESCRIBE `m_contents`661
5DESCRIBE `content_lists`991
6DESCRIBE `ratings`771
7DESCRIBE `sites`15151
8DESCRIBE `templates`881
9DESCRIBE `admins`23231
10DESCRIBE `spaces`22221
11DESCRIBE `advertisements`23231
12DESCRIBE `rankings`771
13DESCRIBE `comments`10101
14DESCRIBE `base_comments`771
15SELECT `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
16SELECT `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
17SELECT `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
18SELECT 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` < '2018-08-15 19:30:18' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2018-08-15 19:30:18')))) 111
19SELECT 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` < '2018-08-15 19:30:18' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2018-08-15 19:30:18')))) 111
20SELECT 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` < '2018-08-15 19:30:18' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2018-08-15 19:30:18')))) 111
21SELECT 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` < '2018-08-15 19:30:18' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2018-08-15 19:30:18')))) 111
22SELECT `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` < '2018-08-15 19:30:18' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2018-08-15 19:30:18')))) ORDER BY `Advertisement`.`id` DESC 111
23SELECT `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 1111
24SELECT `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` <= '2018-08-15 19:30:18' ORDER BY `Basis`.`disp_date` DESC, `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 2226
25SELECT `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
26SELECT `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
27SELECT `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
28SELECT `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
29SELECT `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
30SELECT `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` <= '2018-08-15 19:30:18' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 2 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC 882
31SELECT `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
32SELECT 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
33SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 15 AND `Rating`.`disp_flag` = 1 110
34SELECT `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
35SELECT 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
36SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 2 AND `Rating`.`disp_flag` = 1 110
37SELECT `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
38SELECT 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
39SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 35 AND `Rating`.`disp_flag` = 1 110
40SELECT `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
41SELECT 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
42SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 6 AND `Rating`.`disp_flag` = 1 110
43SELECT `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
44SELECT 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
45SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 5 AND `Rating`.`disp_flag` = 1 110
46SELECT `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
47SELECT 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
48SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 4 AND `Rating`.`disp_flag` = 1 110
49SELECT `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
50SELECT 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
51SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 3 AND `Rating`.`disp_flag` = 1 110
52SELECT `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
53SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 73 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 110
54SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 73 AND `Rating`.`disp_flag` = 1 110
55SELECT `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
56SELECT `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` <= '2018-08-15 19:30:18' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 1 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC 11112
57SELECT `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
58SELECT 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
59SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 19 AND `Rating`.`disp_flag` = 1 110
60SELECT `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 1111
61SELECT 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
62SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 1 AND `Rating`.`disp_flag` = 1 110
63SELECT `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
64SELECT 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
65SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 21 AND `Rating`.`disp_flag` = 1 110
66SELECT `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
67SELECT 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
68SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 20 AND `Rating`.`disp_flag` = 1 110
69SELECT `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
70SELECT 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
71SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 23 AND `Rating`.`disp_flag` = 1 110
72SELECT `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
73SELECT 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
74SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 22 AND `Rating`.`disp_flag` = 1 110
75SELECT `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
76SELECT 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
77SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 24 AND `Rating`.`disp_flag` = 1 110
78SELECT `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 1111
79SELECT 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
80SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 42 AND `Rating`.`disp_flag` = 1 110
81SELECT `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
82SELECT 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
83SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 66 AND `Rating`.`disp_flag` = 1 110
84SELECT `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
85SELECT 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
86SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 52 AND `Rating`.`disp_flag` = 1 110
87SELECT `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
88SELECT 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
89SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 25 AND `Rating`.`disp_flag` = 1 110
90SELECT `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
91SELECT `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` <= '2018-08-15 19:30:18' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 5 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC 21213
92SELECT `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 1111
93SELECT 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
94SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 87 AND `Rating`.`disp_flag` = 1 110
95SELECT `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
96SELECT `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
97SELECT 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
98SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 68 AND `Rating`.`disp_flag` = 1 110
99SELECT `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
100SELECT `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
101SELECT 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
102SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 18 AND `Rating`.`disp_flag` = 1 110
103SELECT `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 13131
104SELECT `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 1111
105SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 77 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC 111
106SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 77 AND `Rating`.`disp_flag` = 1 111
107SELECT `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
108SELECT `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
109SELECT 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
110SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 78 AND `Rating`.`disp_flag` = 1 110
111SELECT `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
112SELECT `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
113SELECT 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
114SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 95 AND `Rating`.`disp_flag` = 1 110
115SELECT `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 12121
116SELECT `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
117SELECT 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
118SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 93 AND `Rating`.`disp_flag` = 1 110
119SELECT `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
120SELECT `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
121SELECT 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
122SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 91 AND `Rating`.`disp_flag` = 1 110
123SELECT `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
124SELECT `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
125SELECT 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
126SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 90 AND `Rating`.`disp_flag` = 1 110
127SELECT `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
128SELECT `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
129SELECT 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
130SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 88 AND `Rating`.`disp_flag` = 1 110
131SELECT `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
132SELECT `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
133SELECT 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
134SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 86 AND `Rating`.`disp_flag` = 1 110
135SELECT `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
136SELECT `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
137SELECT 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
138SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 85 AND `Rating`.`disp_flag` = 1 110
139SELECT `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
140SELECT `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
141SELECT 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
142SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 79 AND `Rating`.`disp_flag` = 1 110
143SELECT `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
144SELECT `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 1110
145SELECT 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
146SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 34 AND `Rating`.`disp_flag` = 1 110
147SELECT `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
148SELECT `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
149SELECT 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
150SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 33 AND `Rating`.`disp_flag` = 1 110
151SELECT `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
152SELECT `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
153SELECT 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
154SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 9 AND `Rating`.`disp_flag` = 1 110
155SELECT `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
156SELECT `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
157SELECT 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
158SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 80 AND `Rating`.`disp_flag` = 1 110
159SELECT `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
160SELECT `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
161SELECT 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
162SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 32 AND `Rating`.`disp_flag` = 1 110
163SELECT `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
164SELECT `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
165SELECT 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
166SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 17 AND `Rating`.`disp_flag` = 1 110
167SELECT `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
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` = 81 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1110
169SELECT 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
170SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 81 AND `Rating`.`disp_flag` = 1 110
171SELECT `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
172SELECT `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
173SELECT 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
174SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 70 AND `Rating`.`disp_flag` = 1 110
175SELECT `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
176SELECT `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
177SELECT `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` <= '2018-08-15 19:30:18' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 3 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC 13131
178SELECT `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
179SELECT 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
180SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 41 AND `Rating`.`disp_flag` = 1 110
181SELECT `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
182SELECT 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
183SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 44 AND `Rating`.`disp_flag` = 1 110
184SELECT `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
185SELECT 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
186SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 46 AND `Rating`.`disp_flag` = 1 110
187SELECT `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
188SELECT 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
189SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 48 AND `Rating`.`disp_flag` = 1 110
190SELECT `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
191SELECT 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
192SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 47 AND `Rating`.`disp_flag` = 1 110
193SELECT `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
194SELECT 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
195SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 51 AND `Rating`.`disp_flag` = 1 110
196SELECT `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
197SELECT 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
198SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 49 AND `Rating`.`disp_flag` = 1 110
199SELECT `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
200SELECT 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