/kr/Mami Koyama Characters
|
Filters Clear All Hair Color ▲
Hair Length ▲
Gender ▲
Animal Ears ▲
Age ▲
Eye Color ▲
Wearing ▲
Hair Color Highlight ▲
Other Char ▲
Role ▲
Exact Hair Color ▲
Try Anime With to find titles that have characters with selected traits.Auto submit is [ ON ] |
|
i
Information
NOTE: This page uses a cached copy of characters data. New characters and recent edits will not be reflected in results until tomorrow. The order of the characters is based on Tributes by members. Characters with more Wealth appear first!
Kawaii or NOT?!
(
select SQL_CACHE 'birthday' as type, u.user_name as user, c.romji as target, null AS amount, c.thumb, b.date, c.id
from api_favs b
inner join e107.e107_user u ON( uid = user_id )
inner join characters c USING(id)
WHERE type_id = 13
order by b.date desc
limit 5
)
union all
(
select 'join' as type, u.user_name, null, null, u.user_image, u.user_join, null
from e107.e107_user u
order by u.user_join desc
limit 5
)
union all
(
select 'stars2' as type, u.user_name, c.romji, rating, c.thumb, d.date, c.id
from stars2 d
inner join e107.e107_user u ON( uid = user_id )
inner join characters c USING(id)
order by d.date desc
limit 5
)
union all
(
select 'stars3' as type, u.user_name, c.english, rating, c.img1, d.date, c.id
from stars3 d
inner join e107.e107_user u ON( uid = user_id )
inner join publishers c USING(id)
order by d.date desc
limit 5
)
union all
(
select 'quote' as type, u.user_name, c.romji, null, c.thumb, b.date, c.id
from quoteupvotes b
inner join srt_lines ON( b.id = srt_lines.line_id )
inner join e107.e107_user u ON( uid = user_id )
inner join characters c ON( cid = c.id )
order by b.date desc
limit 5
)
union all
(
select 'slayer' as type, u.user_name, c.romji, null, c.thumb, d.date_found, c.id
from slayers_candidate d
inner join e107.e107_user u USING(user_id)
inner join characters c USING(id)
order by d.date_found desc
limit 5
)
union all
(
select 'cotm' as type, u.user_name, c.romji, null, c.thumb, d.vote_date, c.id
from characterofthemonth d
inner join e107.e107_user u USING(user_id)
inner join characters c USING(id)
WHERE vote_year_month = 202601 AND vote_isvalid = 1
order by d.vote_date desc
limit 5
)
union all
(
select 'cotw' as type, u.user_name, c.romji, null, c.thumb, d.vote_date, c.id
from characteroftheweek d
inner join e107.e107_user u USING(user_id)
inner join characters c USING(id)
WHERE vote_year_week = 20265 AND vote_isvalid = 1
order by d.vote_date desc
limit 5
)
union all
(
select 'cotd' as type, u.user_name, c.romji, null, c.thumb, d.vote_date, c.id
from characteroftheday d
inner join e107.e107_user u USING(user_id)
inner join characters c USING(id)
WHERE vote_year_day = 202629 AND vote_isvalid = 1
order by d.vote_date desc
limit 5
)
order by date desc
limit 10
[close]
scot rated Kuina Sazanami ★★★★★
|
| scot joined |
| popolol joined |
Clener74 wished Polka Omaru a Happy Birthday
|
Clener74 wished Yoshikage Kira a Happy Birthday
|
Clener74 wished Satono Diamond a Happy Birthday
|
Clener74 wished Akari Mizunashi a Happy Birthday
|
Clener74 wished Helena Douglas a Happy Birthday
|
miko_200 liked a quote by Milim Nava
|
| ImperialNinja joined |