Jump to content


This forum is no longer in use. Please do not post here. Go to our new forums at http://7kingdoms.net/pw/


Photo

Animu & Mango

Japan

  • Please log in to reply
94 replies to this topic

#21 Nibra Kebru

Nibra Kebru

    Journeyman

  • Squire

  • 160 posts
  • LocationThe Universe, The Virgo Supercluster, Local Group, The Milky Way, The Solar System, Earth, The North Western Hemisphere, North America, The United States of America
  • Nation Link:Click Here

Posted 21 April 2015 - 09:26 PM

1. Steins;Gate

 

2. Code Geass R2

 

3. Death Note

 

4. Psycho-Pass

 

5. No Game No Life

 

http://myanimelist.net/profile/Exanimem


Edited by Nibra Kebru, 14 July 2015 - 12:36 PM.


Awards Bar:


#22 Mercury

Mercury

    Quality Control

  • Members
  • 3 posts

Posted 22 April 2015 - 08:35 PM

I liked Death Note but it seemed like it went on for too long.


"Any sufficiently advanced technology is indistinguishable from a completely ad-hoc plot device"
—David Langford

#23 Nibra Kebru

Nibra Kebru

    Journeyman

  • Squire

  • 160 posts
  • LocationThe Universe, The Virgo Supercluster, Local Group, The Milky Way, The Solar System, Earth, The North Western Hemisphere, North America, The United States of America
  • Nation Link:Click Here

Posted 22 April 2015 - 09:50 PM

I liked Death Note but it seemed like it went on for too long.

It certainty did, with Mellow and Near, but the rest is fantastic while the said part was a only a little bit over average



Awards Bar:


#24 Jaime Lannister

Jaime Lannister

    Artisan

  • Seven Kingdoms Envoy
  • 538 posts

Posted 24 April 2015 - 04:28 PM

Surprisingly educational about economics. 9/10 might trade goods again.

 

Not uncommonly, as was mentioned, the LN or Mango is better than the Animu. Baka-tsuki has the widest selection of LNs I've seen, and also has some mangos. 

 

"The Spice & Wolf series is now published in English by Yen Press, part of the Hachette Book Group, and can be purchased in most larger book stores both physical and virtual. Because of this, it is no longer available in English on this site."

 

What is the point of the site if I have to pay for a physical copy?  Lame.  I suppose will probably do the same with other popular titles.


Edited by Jaime Lannister, 24 April 2015 - 04:28 PM.

Posted Image

Awards Bar:


#25 Lautrec

Lautrec

    Apprentice

  • Members
  • 97 posts

Posted 27 April 2015 - 08:40 AM

Here is my top 10

 

1: Cowboy bebop

2: Ghost in the shell

3: One piece

4: FMA Brotherhood

5: Stein's Gate

6: Hellsing Ultimate

7: Grave of butterflies

8: Memories

9: Redline

10: Akira


Posted Image


Awards Bar:


#26 Seiranko

Seiranko

    彼岸花

  • Members
  • 109 posts

Posted 27 April 2015 - 06:31 PM

Surprisingly educational about economics. 9/10 might trade goods again.

 

Not uncommonly, as was mentioned, the LN or Mango is better than the Animu. Baka-tsuki has the widest selection of LNs I've seen, and also has some mangos. 

As a person that owns the first few light novels (pretty much all covered in the anime), I can confirm this. Though, the anime still is not bad and definitely worthwhile.

 

Reminds me, I really should continue reading World End Economica. It's also by Isuna Hasekura, who wrote S&W, though instead of old times travelling merchant life, it is in a futuristic stock market. Honestly, it is more entertaining than it sounds.



#27 ACH0225

ACH0225

    Owl

  • Members
  • 63 posts

Posted 27 April 2015 - 07:21 PM

I hope they make World End into an anime. I've read the LNs and played the VN, and I think that it'd be similar to S&W.

A new anime I've been watching is the Disappearance of Nagato Yuki, a spinoff of Haruhi series. Pretty much continues to underline that Nagato is, in fact, best girl.
Spain: Disregard natives, acquire gold.

5 months from now, I will publish a paper on an efficient method for rendering millions of owls to a screen.


#28 Nibra Kebru

Nibra Kebru

    Journeyman

  • Squire

  • 160 posts
  • LocationThe Universe, The Virgo Supercluster, Local Group, The Milky Way, The Solar System, Earth, The North Western Hemisphere, North America, The United States of America
  • Nation Link:Click Here

Posted 28 April 2015 - 05:22 PM

I hope they make World End into an anime. I've read the LNs and played the VN, and I think that it'd be similar to S&W.

A new anime I've been watching is the Disappearance of Nagato Yuki, a spinoff of Haruhi series. Pretty much continues to underline that Nagato is, in fact, best girl.

 I've been watching Nagato too, but Haruhi is still best girl



Awards Bar:


#29 Jaime Lannister

Jaime Lannister

    Artisan

  • Seven Kingdoms Envoy
  • 538 posts

Posted 29 April 2015 - 04:17 PM

From what I read, none of the characters have any of their abilities but are just regular high schoolers in this show.  Just slice of life.  Rather odd choice to make I have to say as Haruhi's godhood was the driving force of the the original series...


Posted Image

Awards Bar:


#30 Nibra Kebru

Nibra Kebru

    Journeyman

  • Squire

  • 160 posts
  • LocationThe Universe, The Virgo Supercluster, Local Group, The Milky Way, The Solar System, Earth, The North Western Hemisphere, North America, The United States of America
  • Nation Link:Click Here

Posted 30 April 2015 - 05:12 PM

From what I read, none of the characters have any of their abilities but are just regular high schoolers in this show.  Just slice of life.  Rather odd choice to make I have to say as Haruhi's godhood was the driving force of the the original series...

Agreed, but it's still enjoyable (After you drop the fact that the other series exists)



Awards Bar:


#31 Jaime Lannister

Jaime Lannister

    Artisan

  • Seven Kingdoms Envoy
  • 538 posts

Posted 30 April 2015 - 07:05 PM

Probably explains its low rating then, I'll give the show a go and attempt to forget the previous series exists when seeing it so I don't mentally compare them (I'll really try).  I'm just puzzled why these characters would be used if they are nothing like their other selves in a different world (though my understanding is his series has no connection whatsoever with the others).  I hope its not just an attempt to get viewership by using the characters from a popular show, I'm hoping for more than a generic high school show after all. 

 

Haruhi forbid the SOS Brigade actually does literature club activities. ;)


Edited by Jaime Lannister, 30 April 2015 - 07:06 PM.

Posted Image

Awards Bar:


#32 Nibra Kebru

Nibra Kebru

    Journeyman

  • Squire

  • 160 posts
  • LocationThe Universe, The Virgo Supercluster, Local Group, The Milky Way, The Solar System, Earth, The North Western Hemisphere, North America, The United States of America
  • Nation Link:Click Here

Posted 02 May 2015 - 03:27 PM

Probably explains its low rating then, I'll give the show a go and attempt to forget the previous series exists when seeing it so I don't mentally compare them (I'll really try).  I'm just puzzled why these characters would be used if they are nothing like their other selves in a different world (though my understanding is his series has no connection whatsoever with the others).  I hope its not just an attempt to get viewership by using the characters from a popular show, I'm hoping for more than a generic high school show after all. 

 

Haruhi forbid the SOS Brigade actually does literature club activities. ;)

Took me until the third episode to actually enjoy it, and I'm assuming you know Haruhi is kidna secretly god, so this is probably a new universe from her mind. 



Awards Bar:


#33 Jaime Lannister

Jaime Lannister

    Artisan

  • Seven Kingdoms Envoy
  • 538 posts

Posted 02 May 2015 - 10:10 PM

Oh yes, Haruhi is god even if she isn't allowed to flex those godly muscles.  Shame really.


Posted Image

Awards Bar:


#34 ACH0225

ACH0225

    Owl

  • Members
  • 63 posts

Posted 03 May 2015 - 02:33 PM

 I've been watching Nagato too, but Haruhi is still best girl

 

See, that's where you're wrong.

 

Haruhi is god

That'd be Kanade Tachibana, actually.

 

 

Just finished Denpa Teki no Kanojo. People sometimes say Bakemonogatari was an acid trip, but these two OVAs were the real deal.


Spain: Disregard natives, acquire gold.

5 months from now, I will publish a paper on an efficient method for rendering millions of owls to a screen.


#35 Greatnate

Greatnate

    Novice

  • Members
  • 8 posts

Posted 12 May 2015 - 08:38 PM

In no particular order, my top 10 anime shows (no movies) would be:

  1. Steins;Gate
  2. Full Metal Alchemist: Brotherhood
  3. Neon Genesis Evangelion
  4. Cowboy Bebop
  5. Mushi-Shi
  6. Serial Experiments Lain
  7. FLCL
  8. Puella Magi Madoka Magica
  9. Planetes
  10. Paranoia Agent

This was surprisingly hard, I could probably go another 10 easy, without feeling that any are much better than the others.



#36 ACH0225

ACH0225

    Owl

  • Members
  • 63 posts

Posted 13 May 2015 - 06:17 AM

So, they're making anime of Gate: Long words in Japanese about the JSDF, and Monster Musume. The first was arguably one of the best mango I've ever read, and one of the most intelligent(also, militarily accurate). Second is arguably the most perverted and also pretty funny. Any anime coming out this summer anyone else is looking forwards to?

Edited by ACH0225, 13 May 2015 - 06:17 AM.

Spain: Disregard natives, acquire gold.

5 months from now, I will publish a paper on an efficient method for rendering millions of owls to a screen.


#37 Jaime Lannister

Jaime Lannister

    Artisan

  • Seven Kingdoms Envoy
  • 538 posts

Posted 13 May 2015 - 04:30 PM

Looking through the summer 2015 chart the only anime that catches my interest is Million Doll.  Everything is just so generic these days.  Have to wait until the summer shows start airing and I can see how people start rating on MAL before I decide whether to start something of not.  I'm more apt to start an older show than a new one anyway.


Posted Image

Awards Bar:


#38 Valdoroth

Valdoroth

    Professor

  • King

  • 3,517 posts
  • LocationUSA
  • Nation Link:Click Here
  • Group Name:Astapor

Posted 16 May 2015 - 12:24 AM

Here ya go mates. Crunchyroll passes of 48 hours of Premium+. if you take one, plz indicate which one you take. I get one of these every month.

 

8MMG54ZGSK7

 

EMTC3C9PUS9

 

BJETEMM8GBQ

 

RLEXQS3WHBD


Edited by Valdoroth, 16 May 2015 - 10:32 AM.

TDT Playground (198.24.160.34:32846)
Expecting the unexpected and unexpecting the expected.
u4QPzRq.png

Awards Bar:


#39 Nibra Kebru

Nibra Kebru

    Journeyman

  • Squire

  • 160 posts
  • LocationThe Universe, The Virgo Supercluster, Local Group, The Milky Way, The Solar System, Earth, The North Western Hemisphere, North America, The United States of America
  • Nation Link:Click Here

Posted 16 May 2015 - 07:14 AM

Here ya go mates. Crunchyroll passes of 48 hours of Premium+. if you take one, plz indicate which one you take. I get one of these every month.

 

8MMG54ZGSK7

 

EMTC3C9PUS9

 

BJETEMM8GBQ

 

RLEXQS3WHBD

 Just in time to watch some ad-free 1080p Saturday anime!  Taking fourth.

 

EDIT: I tried to redeem it, just got  "Coupon code not found" . Do you know what I'm doing wrong?


Edited by Nibra Kebru, 16 May 2015 - 07:23 AM.


Awards Bar:


#40 Lautrec

Lautrec

    Apprentice

  • Members
  • 97 posts

Posted 16 May 2015 - 10:18 AM

Just redeemed the first code. Thanks :)


Posted Image


Awards Bar:





Debug Information (Toggle Debug Information)

IPSDebug Messages
makeSeoTitle (guest) called
Retreiving user agent information from the DB
Creating GUEST session: 63eaeb58b0938008f5a9a952a3c1677c
makeSeoTitle (guest) called
Gateway file confirmed: html
Skin set not found, setting default. Using set #4
Setting current module to: forums and current section to: topics

IPSMember Cache Actions
ADDED: Member ID: 217 with tables pfields_content,profile_portal,groups key (df28af09ab8ba146fbf4f722a6e192c4)

(78) Included Files
/home/westeros/public_html/pw/forum/index.php
/home/westeros/public_html/pw/forum/initdata.php
/home/westeros/public_html/pw/forum/constants.php
/home/westeros/public_html/pw/forum/codystayaway/sources/base/ipsRegistry.php
/home/westeros/public_html/pw/forum/codystayaway/sources/base/ipsController.php
/home/westeros/public_html/pw/forum/codystayaway/sources/base/core.php
/home/westeros/public_html/pw/forum/codystayaway/sources/base/ipsMember.php
/home/westeros/public_html/pw/forum/codystayaway/extensions/coreVariables.php
/home/westeros/public_html/pw/forum/conf_global.php
/home/westeros/public_html/pw/forum/ips_kernel/classDbMysql.php
/home/westeros/public_html/pw/forum/ips_kernel/classDb.php
/home/westeros/public_html/pw/forum/ips_kernel/classDbMysqliClient.php
/home/westeros/public_html/pw/forum/cache/furlCache.php
/home/westeros/public_html/pw/forum/codystayaway/applications/forums/extensions/coreVariables.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/session/publicSessions.php
/home/westeros/public_html/pw/forum/codystayaway/applications/forums/extensions/coreExtensions.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/useragents/userAgentFunctions.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/class_localization.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/class_public_permissions.php
/home/westeros/public_html/pw/forum/codystayaway/applications/forums/app_class_forums.php
/home/westeros/public_html/pw/forum/codystayaway/applications/forums/sources/classes/forums/class_forums.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/tags/bootstrap.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/tags/abstract.php
/home/westeros/public_html/pw/forum/codystayaway/applications/forums/extensions/tags/topics.php
/home/westeros/public_html/pw/forum/codystayaway/applications/forums/sources/classes/topics.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/class_reputation_cache.php
/home/westeros/public_html/pw/forum/hooks/trackMembers_reputation_17d48b096bc3f3c15ff0ef9bc9633733.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/itemmarking/classItemMarking.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/output/publicOutput.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/output/formats/coreOutput.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/output/formats/html/htmlOutput.php
/home/westeros/public_html/pw/forum/cache/lang_cache/1/core_public_global.php
/home/westeros/public_html/pw/forum/codystayaway/applications/forums/modules_public/forums/topics.php
/home/westeros/public_html/pw/forum/hooks/trackMembers_viewTopic_271ecd1cc4ea83565300e06b06f3a274.php
/home/westeros/public_html/pw/forum/hooks/pinAwardsProSigHook_4823418b7df562cda396c9d9de16e07e.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/like/composite.php
/home/westeros/public_html/pw/forum/codystayaway/applications/forums/extensions/like/topics.php
/home/westeros/public_html/pw/forum/cache/lang_cache/1/forums_public_forums.php
/home/westeros/public_html/pw/forum/cache/lang_cache/1/forums_public_topic.php
/home/westeros/public_html/pw/forum/cache/skin_cache/cacheid_4/skin_global.php
/home/westeros/public_html/pw/forum/cache/skin_cache/cacheid_4/skin_global_other.php
/home/westeros/public_html/pw/forum/cache/lang_cache/1/forums_public_boards.php
/home/westeros/public_html/pw/forum/cache/lang_cache/1/core_public_editors.php
/home/westeros/public_html/pw/forum/codystayaway/applications_addon/other/trackmembers/sources/library.php
/home/westeros/public_html/pw/forum/hooks/pinAwardsTopicViewQueryDataHook_9605e5b4176a506b2c9f806653f32c0d.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/customfields/profileFields.php
/home/westeros/public_html/pw/forum/ips_kernel/classCustomFields.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/ads.php
/home/westeros/public_html/pw/forum/cache/lang_cache/1/awards_public_awards.php
/home/westeros/public_html/pw/forum/codystayaway/applications_addon/other/awards/sources/classes/classAwards.php
/home/westeros/public_html/pw/forum/codystayaway/applications_addon/other/awards/sources/classes/classCache.php
/home/westeros/public_html/pw/forum/cache/skin_cache/cacheid_4/skin_awards.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/session/api.php
/home/westeros/public_html/pw/forum/cache/skin_cache/cacheid_4/skin_topic.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/tags/search/bootstrap.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/tags/search/sql.php
/home/westeros/public_html/pw/forum/codystayaway/applications/core/sources/classes/reportLibrary.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/editor/composite.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/text/parser.php
/home/westeros/public_html/pw/forum/ips_kernel/HTMLPurifier/HTMLPurifier.auto.php
/home/westeros/public_html/pw/forum/ips_kernel/HTMLPurifier/HTMLPurifier/Bootstrap.php
/home/westeros/public_html/pw/forum/ips_kernel/HTMLPurifier/HTMLPurifier.autoload.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/text/parser/legacy.php
/home/westeros/public_html/pw/forum/codystayaway/sources/handlers/han_login.php
/home/westeros/public_html/pw/forum/codystayaway/sources/loginauth/login_core.php
/home/westeros/public_html/pw/forum/codystayaway/sources/loginauth/login_interface.php
/home/westeros/public_html/pw/forum/codystayaway/sources/loginauth/internal/auth.php
/home/westeros/public_html/pw/forum/hooks/tbPasswordChangeReminder_b503e18203b30b9a197ba69b3e14734a.php
/home/westeros/public_html/pw/forum/hooks/readthattopicCheckPermission_04e124f8e3cb22e36abaa1287188bbc3.php
/home/westeros/public_html/pw/forum/hooks/globalGlobalForumMessage_b81058205f3cdef84f654c40784780da.php
/home/westeros/public_html/pw/forum/codystayaway/sources/handlers/han_parse_bbcode.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/bbcode/core.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/text/parser/bbcode.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/text/parser/html.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/text/parser/bbcode/defaults.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/text/parser/bbcode/customTables.php
/home/westeros/public_html/pw/forum/codystayaway/sources/classes/text/parser/bbcode/bbsoundcloud.php
/home/westeros/public_html/pw/forum/hooks/globalGlobalForumMessageGroup_79c0a89a4dca050f5b0b5b0eab802eba.php

Loaded Caches
TOTAL: 0bytes

Loaded Classes In ipsRegistry::getClass()

FORM and GET Input
module = forums
section = topics
request_method = get
page = 2
showtopic = 1551
app = forums
t = 1551
last_visit = 1508672770
f = 58
start =
view =
selectedpids =
selectedpidcount = 0

SKIN, MEMBER & TASK Info
set_id = 4
set_name = Rotating Background
set_key = _1387227323
set_parent_id = 5
set_parent_array = a:1:{i:0;s:1:"5";}
set_child_array = a:0:{}
set_permissions = *
set_is_default = 0
set_author_name =
set_author_url =
set_image_dir = memory
set_emo_dir = default
set_css_inline = 1
set_css_groups = a:20:{s:4:"1.59";a:2:{s:9:"css_group";s:6:"awards";s:12:"css_position";s:1:"1";}s:3:"1.1";a:2:{s:9:"css_group";s:15:"cal...
set_added = 0
set_updated = 1491587628
set_output_format = html
set_locked_uagent =
set_hide_from_list = 0
set_minify = 1
set_master_key = root
set_order = 3
set_by_skin_gen = 0
set_skin_gen_data =
_userAgents =
_youCanUse = 1
_gatewayExclude =
_skincacheid = 4
_csscacheid = css_4
Next task = 08 October 2017 - 10:00 PM
Time now = Today, 06:46 AM
Timestamp Now = 1508672770

MEMBER: last_visit: 1508672770 / Today, 06:46 AM

MEMBER: uagent_key: __NONE__

MEMBER: uagent_type:

MEMBER: uagent_version: 0


Loaded PHP Templates
skin_global, skin_global_other, skin_awards, skin_topic
skin_global_4, skin_global_other_4, skin_awards_4, skin_topic_4
core_public_global, forums_public_forums, forums_public_topic, forums_public_boards, core_public_editors, awards_public_awards

Queries Used

SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks' )

DELETE FROM sessions WHERE ip_address='54.80.10.56'

SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=1551

SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id )

SELECT * FROM skin_cache WHERE cache_set_id=4 AND cache_type IN ('css', 'replacements')

SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,m.m_awards,m.m_awards_display,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM ( SELECT pid, post_date FROM posts WHERE topic_id=1551 AND queued=0 ORDER BY pid asc LIMIT 20,20 ) z LEFT JOIN posts p ON ( p.pid=z.pid ) LEFT JOIN members m ON ( m.member_id=p.author_id ) LEFT JOIN profile_portal pp ON ( m.member_id=pp.pp_member_id ) LEFT JOIN members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid ) LEFT JOIN pfields_content pc ON ( pc.member_id=p.author_id ) LEFT JOIN reputation_index rep_index ON ( rep_index.app='forums' AND rep_index.type='pid' AND rep_index.type_id=p.pid AND rep_index.member_id=0 ) LEFT JOIN reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid ) LEFT JOIN content_cache_posts cca ON ( cca.cache_content_id=p.pid ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) ORDER BY z.pid asc

SELECT * FROM cache_store WHERE cs_key IN ( 'awards_categories' )

SELECT * FROM cache_store WHERE cs_key IN ( 'awards_awards' )

SELECT * FROM core_like_cache WHERE like_cache_id='703821ed78dfb69191354197af340232'

SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type_id=f.id AND p.app='forums' AND p.perm_type='forum' ) WHERE f.id=0

SELECT tg.* ,t.*, t.approved, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post,m.*,p.*,xxx.* FROM core_tags tg LEFT JOIN topics t ON (t.tid=tg.tag_meta_id) LEFT JOIN members m ON (last_poster_id=m.member_id) LEFT JOIN profile_portal p ON (p.pp_member_id=m.member_id) LEFT JOIN core_tags_cache xxx ON (xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid))) WHERE tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_meta_id !=1551 AND tg.tag_text IN ('Japan') AND tg.tag_aai_lookup IN (SELECT tag_perm_aai_lookup FROM core_tags_perms WHERE ( ( FIND_IN_SET(2,tag_perm_text) ) OR ( tag_perm_text='*' ) ) AND tag_perm_visible=1 ) ORDER BY tg.tag_meta_id desc LIMIT 0,100

SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=217

SHUTDOWN: INSERT INTO sessions (`id`,`member_name`,`member_id`,`member_group`,`login_type`,`running_time`,`ip_address`,`browser`,`in_error`,`current_appcomponent`,`current_module`,`current_section`,`location_1_type`,`location_1_id`,`location_2_type`,`location_2_id`,`location_3_type`,`location_3_id`,`uagent_key`,`uagent_version`,`uagent_type`,`uagent_bypass`) VALUES('63eaeb58b0938008f5a9a952a3c1677c','',0,2,0,1508672770,'54.80.10.56','CCBot/2.0 (http://commoncrawl.org/faq/)',0,'forums','forums','topics','topic',1551,'forum',0,'',0,'__NONE__',0,'',0)

SHUTDOWN: INSERT INTO topic_views (`views_tid`) VALUES(1551)