DenChu

Выборка пользователей по реакции

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