exaulz's profile

Threads: 2
Comments: 3
Registered: 5 years ago
Often used Tags: What are tags?
onelobby boredness bored_again_wtf feedback haha lol myself oh_jes spam test
Recent Threads: View All
Very nice work, k4st. 5 years ago by exaulz with 6 comments. Tags: onelobby, feedback Peter, so far, you've done an amazing job with OneLobby. This thing is really going to reinvent a few things… I wish you the best of luck with it. … So hawt n sexy OneLobby is.
OMFG. OL is teh COOL. 5 years ago by exaulz with 1 comments. Tags: test, spam, onelobby, boredness, lol, haha, myself, bored_again_wtf, oh_jes Effing awesome-ness-ness-ness ….

The Wall

| View All
No one has posted to this wall yet... You can be the first though!

OneLobby
QueryQuery TimeAffected Rows
SELECT * FROM k4_users WHERE user_id=28 GROUP BY user_id LIMIT 1

 0.5444 

 1 

 
SELECT t.tag_name, COUNT(tt.tag_id) AS tag_count FROM k4_tags t, k4_thread_users tu JOIN k4_thread_tags tt USING (thread_id) WHERE t.tag_id=tt.tag_id AND tu.thread_id=tt.thread_id AND tu.user_id=28 GROUP BY t.tag_id ORDER BY tag_count DESC, t.tag_name ASC LIMIT 0,50

 0.5458 

 10 

 
SELECT DISTINCT t.thread_id, t.*, ts.tag_name, GROUP_CONCAT(ts.tag_name SEPARATOR ',') AS tags, u.name AS user_name, uu.name AS edit_user_name FROM k4_thread_tags tt, k4_tags ts, k4_threads t, k4_users u, k4_users uu WHERE t.user_id=28 AND t.thread_id=tt.thread_id AND ts.tag_id=tt.tag_id AND t.user_id=u.user_id AND t.edit_user_id=uu.user_id GROUP BY t.thread_id ORDER BY created DESC LIMIT 10

 0.5506 

 2 

 
SELECT wp.*, u.name AS poster_name FROM k4_wall_posts wp LEFT JOIN k4_users u ON wp.poster_id=u.user_id WHERE wp.user_id=28 AND (wp.private < 1 OR wp.private=1 AND wp.poster_id=1) GROUP BY wp.post_id ORDER BY created DESC LIMIT 10

 0.5525 

 0