Who is Yamashiro ?
History
 |
Maya Natsume from Tenjho Tenge Wrong! |
|---|---|
 |
Makina Nishioka from Honoo no Haramase Oppai Ero Appli Gakuen Wrong! |
 |
Asta from Black Clover Wrong! |
 |
Shui from Reborn as a Vending Machine, I Now Wander the Dungeon Wrong! |
 |
Kiriko Matsumiya from See you at other side of the moon Wrong! |
 |
Flame Haze Shana from Burning Eyes Shana Wrong! |
 |
Suzu from Cast Away...Airan Island Wrong! |
 |
Clarissa Snowflake from New Sakura Wars the Animation Wrong! |
 |
Aichi Sendou from Cardfight!! Vanguard Wrong! |
 |
Special Week from Uma Musume: Pretty Derby (Anime) Wrong! |
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 |