select 
		 `emails_messages`.`subject`
		,IF(
			 `send_after` is NULL 
			,DATE_FORMAT(`emails_messages`.`datetime`,'%Y-%m-%d %H:%i')
			,DATE_FORMAT(`emails_messages`.`send_after`,'%Y-%m-%d %H:%i')
		) as `showdate`
		,IF(
			 `send_after` is NULL 
			,`emails_messages`.`datetime`
			,`emails_messages`.`send_after`
		) as `sortdate`
		,`emails_messages`.`id`
		,IF(
			 `emails_messages`.`body_html`<>''
			,`emails_messages`.`body_html`
			,`emails_messages`.`body_text`
		)as `body`
		,`emails_messages`.`CopyFromID`
		
		,`from`.`addr` as `from`
		,(
			SELECT 
				CONCAT_WS(',', `addr` ) 
			from `emails_messages_addr`
			where `type`='to' and `message_id`=`emails_messages_addr`.`id`
		)as `to`
	from `emails_messages` 
	left join `emails_messages_addr`  as `from` 
			on `from`.`message_id`=`emails_messages`.`id`
	where `from`.`type`='from'
	order by `sortdate`