PDA

View Full Version : Help finding these queries


trackpads
11-10-2012, 07:27 PM
Any idea what mod these might be from or are they from VB? If not then I have to take the site down later and go file by file. I would VERY much apprecaite the help if you can,

Thanks,

Jason



# Time: 121110 15:03:40
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 116.362738 Lock_time: 0.000086 Rows_sent: 1 Rows_examined: 3393026
SET timestamp=1352577820;
SELECT
P.userid, COUNT(userid) AS times
FROM vb_thread AS T
INNER JOIN vb_post AS P ON T.lastpostid=P.postid
WHERE P.userid=32258
AND T.dateline > 315532800 AND T.dateline < 1352577704
AND P.dateline > 315532800 AND P.dateline < 1352577704
GROUP BY P.userid
ORDER BY P.dateline DESC, P.userid;


# Time: 121110 15:05:19
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 89.153733 Lock_time: 0.000073 Rows_sent: 1 Rows_examined: 3393026
SET timestamp=1352577919;
SELECT
P.userid, COUNT(userid) AS times
FROM vb_thread AS T
INNER JOIN vb_post AS P ON T.lastpostid=P.postid
WHERE P.userid=32262
AND T.dateline > 315532800 AND T.dateline < 1352577830
AND P.dateline > 315532800 AND P.dateline < 1352577830
GROUP BY P.userid
ORDER BY P.dateline DESC, P.userid;



--------------- Added 1352579559 at 1352579559 ---------------

Found them, Vb experience