Review_Summary

terms, $wpdb->term_taxonomy
WHERE $wpdb->terms.term_id = $wpdb->term_taxonomy.term_id
AND $wpdb->term_taxonomy.taxonomy = ‘season’
ORDER BY year + 0 DESC, FIELD(season,’Winter’,’Spring’,’Summer’,’Fall’) DESC
“;
$result = $wpdb->get_results($sql, OBJECT);
foreach ($result as $season) {
$i=0;
?>

name; ?>

term_relationships
WHERE $wpdb->term_relationships.term_taxonomy_id = $season->term_taxonomy_id
“;
$shows = array(“”);
$result = $wpdb->get_results($sql, OBJECT);
echo “

“;
foreach ($result as $post) {
$sql = ”
SELECT * FROM $wpdb->term_relationships, $wpdb->term_taxonomy, $wpdb->terms
WHERE $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id
AND $wpdb->term_relationships.object_id = $post->object_id
AND $wpdb->term_taxonomy.term_id = $wpdb->terms.term_id
AND $wpdb->term_taxonomy.taxonomy = ‘show’
“;
$show = $wpdb->get_row($sql, OBJECT);
if (!in_array($show->slug, $shows)) {
$shows[$show->slug] = array($show->slug, $show->name);
}
}
sort($shows);
foreach ($shows as $show) {
if (!$show == “”) {
$i++;
?>

“;
}
}
}
echo “

“;
}
}
?>
terms
WHERE $wpdb->terms.slug = ‘”. $show . “‘
“;
$result = $wpdb->get_row($sql, OBJECT);
echo “

” . $result->name . “

“;
$sql = ”
SELECT *
FROM $wpdb->term_taxonomy
WHERE $wpdb->term_taxonomy.term_id = ‘”. $result->term_id. “‘
AND $wpdb->term_taxonomy.taxonomy = ‘show’
“;
$result = $wpdb->get_row($sql, OBJECT);
echo “

” . $result->description . “

“;

$args=array(
‘show’ => $show,
‘post_type’ => ‘post’,
‘posts_per_page’ => 10,
‘caller_get_posts’=> 1,
‘orderby’ => ‘grade’,
‘order’ => ASC

);
$my_query = null;
$my_query = new WP_Query($args);
if( $my_query->have_posts() ) {
?>

have_posts()) : $my_query->the_post(); ?>
ID, ‘grade’, ”, ‘, ‘, ” ));
?>

Group Grade

134 thoughts on “Review_Summary”

  1. Nice idea, the only thing that is needed would be to load the shows directly inside of this page without loading a new one. Somewhat like a combobox.

    Reply
  2. does anyone have a recommendation for deadman wonderland? Cuz there are only 2 fansub reviews here but there are like 4-5 groups who did it.

    Reply
  3. sorry but I had one more question, can you give me a recommendation for Naruto/Bleach/One Piece and Fairy tail? Would really really appreciate it.

    Reply
  4. Hey DS, I was wondering you could tell me know which would be a wise choice between
    REVO
    THORA
    Coalgirls
    for Karigurashi no Arrietty

    Reply
  5. Hi guys, I was wondering if anyone could tell me the best fansubs for naruto shippuuden. I’m thinking:
    1-92 dattebayo
    rest taka
    is that good?

    Reply
      • lol. I see. That’s good then. btw was dattebayo releasing in 640×480 at the start of naruto shippuuden? I always had a feeling they releassed 720p. ah well it was a long time ago and i can’t remember :D
        btw what about tsuki or DSFS? are they any good?

        Reply
  6. hey DS, why don’t you make each fansub group a category? so like if we click on a fansub’s name we can see all their reviews. that way we can get a better understand of their level.

    Reply
  7. well seems i kinda missed the tags at the bottom of the reviews. but yea i think it’d be good to have the name of the fansubs be a link to their list of reviews in this page

    Reply
  8. Hey Dark. I was wondering, can you at least put up a recommendation fansubs for all the series of this season? I don’t really need reviews cuz I trust your judgment. All I’m asking is to just make a list of best fansubs for each series. Would really appreciate it.

    Reply
    • Uhh, just click on a show on this page and I have a little blurb about which group is recommended. No need to read the reviews if you don’t want to.

      Reply
      • I think you misunderstood – he probably wants just a list of best fansubbs of all the shows, including (or, to be exact, specifically) ones that still aren’t reviewed.
        IMO it would be a nice idea.

        Reply
          • Maybe something like:

            Ben-to – EveTaku
            Chibi Devi – Doki or Zenyaku
            Fate/Zero – UTW
            Guilty Crown – Hatsyuuki-Tsuki or Commie
            and so on

            List of shows and best subs for each one. Whole reviews later.
            It wouldn’t take as much of your time as writing reviews and it would certainly help some impatient readers of your blog.
            I prefer reviews of course but you could use it as last resort in situations like this season when life just won’t give you any free time.

            Reply
  9. You know, it would have been nice if each page for series could have its own comments. so we could comment about each series in general instead of commenting here and making it all clustered

    Reply
  10. Honestly these reviews are a godsend to anime viewers, but their usefulness drops exponentially as you wait longer and longer to write reviews since the probability that someone (like me) decides on a fansub group without relying on your review due to impatience increases exponentially over time. How often can we expect a review from you?

    Reply
    • When I get to it. I ditched my girlfriend, my step-brothers, and my best friend this weekend all so I could do nothing but review.

      Trust me, I’m trying. Monday-Thursday I can’t do anything. My hands are literally tied. So I have a very small window in which to make a big impact.

      I’ll work the hardest I can to make this site relevant to you and I apologize for the delays. I wouldn’t delay shit if I didn’t have to.

      Reply
  11. ^what he said

    It would be nice to see reviews of:
    Lagrange (finish Commie and review Underwater), GetWet’s Symphogear (as Commie is already taken care of), Ano Natsu (CoalGuys vs Commie + Hayaku incoming), Pirates (WhyNot vs Commie), DxD (big competition there), KMB (there’s some new group, Muteki there)
    (didn’t mean this list to be so long, sorry, it should be all at this moment)
    first
    as they may be hard to decide on for us. (e.g. Another is just Underwater vs HorribleSubs, no-brainer, no need for now)

    Reply
  12. Hey, I just wanna know when you will start reviewing the winter release. And which are the animes that you’ll be reviewing.

    Reply
  13. I asked this earlier but didn’t get any response… Will you finish writing reviews for the new Hunter x Hunter 2011 show? I’ve already decided on my group by now, but I’m still interested in reading your reviews of them!

    Reply
  14. Fuck.
    I’ve dling Tsuki since Tidal dropped. FML.
    But from the review they don’t seem THAT bad (well, I don’t speak Japanese so……)

    Oh well… I’ll dl UnMabushii Corp. subs if they ever want to catch up. If not, there’s HorribleSubs… Personally dislike what they do…

    Reply
  15. GX_ST is also subbing Black Rock Shooter, and they seem to have done a good job at it (e.g. TL notes for the meanings of “Kotoriasobi” and “Takanashi”). Will you review theirs too?

    Reply
    • As quoted from Dark_Sage from the Review_Queue:
      “Edit: They did release, but they’re irrelevant. They don’t have their show on TokyoTosho. :/”

      Reply
  16. hi i tried to download Another episodes via the underwater website but they only seem to have script subtitles not typesetting as you described in this review. can you help??? where can you download typesetting subbed Another episodes??? Thanks!!! Also what is the difference between typesetting and script subtitles????

    Reply
    • Typesetting is part of most scripts. Font, for example, is part of typesetting… Can’t really imagine any script without some degree of typesetting O.o.

      What is it you’re talking about? Are you looking for a script with karaoke effects, because I’m watching Another from Underwater, and karaoke works perfectly for me. Or are you looking for sign translations? Just a tip to be more specific.

      Reply
      • Hi thanks for the reply. :) i ment like the text such as for example on signs and other areas of the video not just the spoken parts if you get what i mean. :)

        Reply
  17. Thank you so much for the reviews. This site has saved me a lot of time. I wish I had known about this site sooner.

    Thank you Dark_Sage for your hard work.

    Reply
  18. I’m not sure where I should request this, so I’m doing it here. Dark_Sage thank you for everything you’ve done so far and I would greatly appreciate if you could review the following: Sankarea[Hatsuyuki], Sankarea[EveTaku], Zetman[Hatsuyuki], Fate/Zero 2[UTW] & Zero no Tsukaima F[Static-Subs].

    Let me know your thoughts :D

    Reply
  19. HS has been doing a lot of subs for the Fall run. Is there a serious reason that they don’t often get included with the reviews? Moral or personal issue with them or something along those lines? I don’t mean to pry, just a bit of curiosity.

    Reply
  20. Kinda awkward having official subs and old subs where they are. Don’t think that movie in Winter 2013 was released in that season either.

    Reply
  21. Just for explanation’s sake, I consider my review breakdowns as such:

    A-tier and B+: Excellent subs. This range is what a group that has a consistent focus on quality will reach. I reserve A-tier for those subs with a certain cachet that mark them above the rest, but a B+ release falls under this general designation.
    B- to B: This is where I expect most groups to be hitting. It’d be nice if everyone released A+ shit, but that’s unrealistic. These scores, while not glamorous, are completely understandable.
    C- to C+: Needs some work. Generally these subs will not have been significantly edited or QC’d. Sometimes visual failings can sink a group to this level (though that happened far less this season than any other).
    D- to D+: There needs to be a significant staff change for a show if your group hits this level of stupid. You can leave things as they are, but your more discerning viewers probably won’t be pleased.
    F: What are you doing

    I was going to make a post about this but then decided that would be retarded.

    Reply
  22. Umm…there isn’t fansub’s review for Shingeki no Kyojin..??
    I think it’s gonna be strict competition since commie, evetaku, gg, & Hatsuyuki placed each of their work for the bid.

    Reply
    • I personally recommend MMM, despite them getting worse reviews on crymore(and I trust D_S’s reviews but yeah)

      They did seem to improve quite a bit and seemed to have a better script(but don’t quote me on that) and as fans of the series with a decent TL, I’d /bet/ they are among the most accurate.

      Or Commie as Dark_Sage said.

      Reply
      • I will prefer commie all the way. The amount of time all the staff is putting in this anime is impressive. Be aware the TSer is a TS perfectionist with a goal of destroying all toasters around. :3

        Also, commie is going to do the BD version. ;)

        Reply

Leave a Comment