Indexed Images

Every day at midnight during site maintenance we generate a cached table of character + indexed images.

INSERT INTO characters_a
SELECT 0,0,characters.*,mt,date,RAND() FROM characters INNER JOIN publishers ON characters.publisher = publishers.id;
INSERT INTO characters_a
SELECT 0,characters_supplicant.*,mt,date,RAND() FROM characters_supplicant INNER JOIN publishers ON characters_supplicant.publisher = publishers.id;

The indexed images may have the same name and appear as duplicates where this table is used unfiltered.

https://www.animecharactersdatabase.com/characters_supplicant.php

List of pages using character_a table:

bash-5.1$ grep -il characters_a *php OLD-sort-characters.php ajax_titlecharacters.php animationdemo.php birthdays.php birthdays_sitemap.php bs.php c_chart.php c_latest.php c_newCharactersPageViewCounter.php c_va.php character_tags.php characters.php characters_supplicant.php characters_supplicant_post.php characterswith.php dropdown.php g_smashorpass.php groupcosplay.php guessthecharacter.php idlegame.php idlegame_post.php iframecharacters.php index.php kanjilookup.php my_watch.php myseriesva.php newCharactersPageViewCounter.php newsearchpanel.php noprotag.php notagsr.php nova.php novatitle.php popularity.php protagquotes.php reindex.php search2.php searchall.php sm_birthdays.php smashorpass.php smashorpassaudio.php sort_characters.php sort_series.php test-characterswith.php test-newtop.php title_tags.php topvas.php vacheck.php whois.php

bash-5.1$ grep -il characters_a *inc OLD-main.inc beta_top.inc bs_year_trivia.inc index_member.inc index_visitor.inc main-full.inc main.inc rei-main.inc sort_characters.inc ux_search.inc va.inc