Thanks [out] - Quarry

SQL

-- Outgoing Thank Log in Persian Wikipedia
use fawiki_p;

SELECT *, count(log.log_action) from 
	(select distinct log_user,log_user_text from 
     	(SELECT log_user,log_user_text FROM logging where log_action='thank' and log_user=644 limit 100) as ll
     where  log_user=644 limit 100
    ) as dd 
    inner join logging log
    on dd.log_user=644
group by dd.log_user
limit 100
/*

select  u.log_user_text, count(l.log_user) num from logging u inner join 
on u.log_user=l.log_user 
 
and u.log_user=644 ##--(debug) 
group by u.log_user 
order by num desc, u.log_user_text asc
limit 100*/
SQL

Checking query status...
