Haruka Harumi - Best Quotes
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 |