Untitled

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