Recreate table

[chikuru]

Database error in vBulletin 4.2.2:

Invalid SQL:

        INSERT INTO taggregate_temp_1492976820
                SELECT threadid, COUNT(*) AS views
                FROM threadviews
                GROUP BY threadid;

MySQL Error   : Can't find file: 'threadviews' (errno: 2)

Whats the query to recreate that table in vbulletin 4.2?
Thanks!