Untitled

SELECT STRAIGHT_JOIN
  	               mo.timestamp,

	  	             member.username,
	  	             member.city,
	  	             member.state,
	  	             
	  	             mds.date_of_birth,

	  	             media.media_id,
	  	             media.media_server,
	  	             media.directory_index,
                     media.path
  	  	       FROM
	  	             member_online mo
	  	             INNER JOIN member USING( member_id )
	  	             INNER JOIN member_dating_search mds USING (member_id)
	  	             LEFT JOIN media ON media.media_id = member.media_id AND media.approved='yes'
	  	         ORDER BY mo.timestamp DESC
	  	         LIMIT $more