SELECT 
 s.subject_id, s.subject_title, s.subject_body, 
 UNIX_TIMESTAMP(s.subject_create_datetime) as subject_create_datetime, 
 c.connection_avatar, c.connection_id, c.connection_openid, c.connection_nickname 
FROM am_plugin_forum_subject s, am_connection c 
INNER JOIN am_plugin_forum_tag t ON s.subject_id=t.subject_id 
WHERE s.connection_id=c.connection_id AND 
 s.webspace_id=1 AND 
 s.subject_archived IS NULL AND 
 t.tag_name='ee' AND 
 1=1 
ORDER BY s.subject_sticky DESC, s.subject_create_datetime DESC