Other Need a quick SQL query for xF!

trizz

Active member
Hey guys -

Need a quick SQL query to find out the top 10 users with most posts between two given dates - Feb 1 2017 and Feb 7 2017.

Can anyone help me? Willing to compensate!
 

SpecialK

Active member
Code:
select COUNT(*) as count, user_id, username FROM xf_post WHERE post_date BETWEEN 1485907200 AND 1486511940 GROUP BY user_id ORDER BY count DESC  LIMIT 10
should do it.
 
Top