• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 Facebook registrations

Chris D

XenForo developer
Staff member
#5
Code:
SELECT COUNT(*)
FROM xf_user_external_auth AS ext
INNER JOIN xf_user AS user ON
    (user.user_id = ext.user_id)
WHERE ext.provider = 'facebook'
AND user.register_date > unix_timestamp('2014-01-01')
That will give you the number of Facebook registrations since 1st January 2014 (YYYY-MM-DD).

Change the date accordingly (or remove that line to count them all).