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

50 thoughts on “Review Summary”

  2. I’d say FroZen (Frostii-Saizen) because blakbunnie27 translated, and because I personally prefer their styling. Yes, they didnt’ get the best grade, but somehow QC derped that specific episode it was reviewed.

    Reply

    • What about them? The only release that I know they did was Soul Eater Not! They didn’t sub Kamisama no Inai Nichiyoubi AFAIK

      Im saying this because you suggested [S-T-D] under the results for Kamisama no Inai Nichiyoubi, so…

      Edit: LOL this website… there are no comments for specific release results?? Ok. Well S-T-D was probably a one off thing will not be used again/very often

      Reply

  6. List is getting fairly big…you need collapsing categories!

    Reminds me to fix this shit when I’ve not been drinkin’.

    Reply

  12. The other day we were talking about how a lot of old manga (context was yatterman) is bad/for kids. I’ve been wanting to try out Lupin, but a lot of it is older and presumable also bad/for kids. Any suggestions on where a newcomer should be jump into that franchise?

    Reply

    • You could probably jump in with Castle of Castliogro or whatever it is. I’d check the name but Monster Hunter has fried my brain.

      Reply

    • Interesting. Yes, I do have a Vampire Holmes post in the works, but I didn’t expect it to show up here before I actually posted it.

      Reply

      • And now DanMachi shows up. Well, I guess that gives y’all a reason to check this out before I’ve actually posted anything. Easier than me updating the Review Queue manually at least!

        Reply

  15. You are a lifesaver, I’ve been using you for years, first comment though. Thanks so much for the work you’ve done!

    On a side note, you obviously can’t get around to all anime, are there any other sites like this that do similar reviews?

    Reply

    • Similar to fansub reviews? No, nothing even comes close to Crymore in that regard. Even finding uninformed, crowdsourced opinions on subtitles is gonna be an effort, as sites like MyAnimeList are now trying to curry favor with official distributors by censoring anything that mentions fansubs for certain shows.

      Still, MyAnimeList would have to be the best alternative to Crymore — you’ll need to make an account to force the fansub opinions to show up on the anime pages, though (they’re hidden otherwise).

      Reply

      • I’d never even heard of that site till you mentioned it. Interesting.

        This post is assuredly out of date, but I guess it serves as an archive of sorts if you’re interested in non-English sites too.

        Reply

  16. Well, I certainly fucked that update up. Guess that’s what I get for not reviewing anything in over a year.

    Uhh, I’m sure you’ll all get over it. Do it for me, thanks. <3

    Reply

    • TL Party work?

      Edit: To clarify, we’re looking at a 3-way TL Party or a tenshi vs Chyuu Subtitle Comparison plus a SanZoro review.

      Basically, tenshi and Chyuu are similarly mediocre, but SanZoro is hilariously shit.

      Reply

Leave a Comment

© 2022 Crymore.net • Built with GeneratePress - Sitemap