I've been reading alot about joins and optimizations ...
mysql> explain SELECT a.blog_id, a.user_id, a.time, a.title, a.message, a.comments, a.views,
-> b.active_id, c.username, c.location, c.gender, c.age, c.class, c.login_time, d.filename
-> FROM blogs a
-> LEFT JOIN active b ON a.user_id = b.user_id
-> LEFT JOIN account_photos d ON a.user_id = d.user_id
-> AND d.main = 1
-> JOIN users c ON a.user_id = c.user_id
-> ORDER BY a.blog_id DESC
-> LIMIT 0,20;
+-------+--------+---------------+---------+---------+-----------+------+-------+
| table | type | possible_keys | key | key_len | ref | rows | Extra |
+-------+--------+---------------+---------+---------+-----------+------+-------+
| a | index | user_id | PRIMARY | 3 | NULL | 1236 | |
| b | ref | user_id | user_id | 3 | a.user_id | 1 | |
| d | ref | user_id,main | user_id | 3 | a.user_id | 5 | |
| c | eq_ref | PRIMARY | PRIMARY | 3 | a.user_id | 1 | |
+-------+--------+---------------+---------+---------+-----------+------+-------+
4 rows in set (0.01 sec)
Based off the information provided back from mysql, that looks like the best it could be right?
