/users/recently_answered/85 Questions Recently Answered by DarcyB Mon, 01 Dec 2008 10:24:55 -0800 http://guruza.com/question/224/reward-50.00/492 We need a performance monitoring solution that will tell us if something is amiss with the site. The answer that provides the most comprehensive discussion of various solutions and which one is recommended (and why) will win the reward. Wed, 05 Jul 2006 11:49:44 -0700 http://guruza.com/question/119/reward-10.00/126 What is the best way to write a simple sql statement that groups on one column and uses the first value located on the other columns? ex:table users: id, email, name, passwordtable posts: user_id, title, bodySELECT users.*, COUNT(users.id) as post_countFROM users, postsWHERE users.id = posts.user_idGROUP BY users.idORDER BY post_countThis will not work as you must include each user column in an aggregate function or in the group by clause. My actual table has many fields and I don't want to specify each column. Tue, 27 Jun 2006 15:37:29 -0700