This is a collection of some Open Source Software Projects from Dennis Mueller.
To see the different projects just go to the wikipages on the right side.
Feel free to contact me via email (muellerdennis at gmail dot com) if you have any questions.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001287s ]
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.085932s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001174s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001925s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001160s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003616s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001027s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003323s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.019084s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001491s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 194574 [ RunTime:0.001469s ]