dave's profile

Threads: 2
Comments: 1
Registered: 5 years ago
Recent Threads: View All
Ruby on Rails framework Hey guys, haven't been here in a while. College has put a different perspective on what I spend my time doing online, but you can never really forget some things of particular interest. What if we...
Nice Nice, so simple, and sleek too.

The Wall

So you like it sofar?

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

 0.6011 

 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=15 GROUP BY t.tag_id ORDER BY tag_count DESC, t.tag_name ASC LIMIT 0,50

 0.6026 

 6 

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=15 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.6066 

 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=15 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.609 

 2