如果它不为空，则返回MYSQL查询的值，否则返回空字符串

I'm running a query where I one of the values should be an empty if the result of a subquery is empty or the result of the actual subquery. Here is the working query:I'm running a query where I one of the values s