Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT SQL_CALC_FOUND_ROWS COUNT(*) as 'Полезность', m.name as 'Имя',
- concat('https://www.amk-team.ru/forum/profile/',`member_received`,'-',`members_seo_name`) as 'Ссылка на профиль'
- FROM ipb_core_reputation_index ri
- JOIN ipb_core_members m on (ri.member_received = m.member_id)
- WHERE `reaction` = '10' AND `rep_date` > '1546290000'
- GROUP BY `member_received`
- ORDER BY `Полезность` DESC
- LIMIT 20
Add Comment
Please, Sign In to add comment