Use this script to list all the Sites, their Owners, and who the Sites are shared with, for one user, or all the users in the domain if used with the Two Legged OAuth option.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002320s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.093555s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002619s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002198s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.003157s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.006288s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002961s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003412s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016255s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002772s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 278598 [ RunTime:0.001239s ]
