mysql 先排序后查询 查询合并 自定义排序

SELECT
	* 
FROM
	(
	SELECT
		* 
	FROM
		topic 
	WHERE
		AND ( `typeid` <> '5' AND `typeid` <> '4' ) 
	UNION ALL     //连接两个结果集
	SELECT
		* 
	FROM
		(
		SELECT
			* 
		FROM
			topic 
		WHERE
			( typeid = 4 OR typeid = 5 ) 
		ORDER BY
			addtime DESC 
			LIMIT 999    //先排序后分组的问题，因数据库的版本差异，5.7以上的得这样
		) t 
	GROUP BY
		typeid 
	) g 
ORDER BY
	FIELD( typeid, 5, 4 ) DESC,  //自定义排序
	istop DESC,
	istop_time DESC,
	uptime DESC