burada benim tablolar

topics -id -title -category_id

posts -id -topic_id -user_id -date -time -txt

user -id -username

i want to list for a category every topic with the following information the author's username (who posted first), number of replies,the name of the last reply's author, and the date of last post sorted by the date of posts.

ben bazı iç içe döngü ve sorguları demet ile yapabilirdi ama ben merak ediyorum mümkün katiyen bir ya da belki iki mysql sorgu olur?

kod i sofar var ...

$query = "SELECT * FROM user u,topics t,posts p WHERE t.category_id=1 AND t.id=p.topic_id AND p.user_id=u.id ORDER BY p.date DESC, p.time DESC";