| | |
| | | vce.id, |
| | | vce.order_number, |
| | | vce.goods_id, |
| | | (select vim.name from volunteer_integral_merchant as vim where vim.id=vce..goods_id) as goods_name, |
| | | (select vim.cover_url from volunteer_integral_merchant as vim where vim.id=vce..goods_id) as goods_url, |
| | | (select vim.name from volunteer_integral_merchant as vim where vim.id=vce.goods_id) as goods_name, |
| | | (select vim.cover_url from volunteer_integral_merchant as vim where vim.id=vce.goods_id) as goods_url, |
| | | vce.need_score, |
| | | vce.user_id, |
| | | (select sy.name from sys_user as sy where sy.user_id=vce..user_id) as userName, |
| | | (select sy.phone from sys_user as sy where sy.user_id=vce..user_id) as userPhone, |
| | | (select sy.name from sys_user as sy where sy.user_id=vce.user_id) as userName, |
| | | (select sy.phone from sys_user as sy where sy.user_id=vce.user_id) as userPhone, |
| | | vce.creation_time, |
| | | vce.condition, |
| | | vce.dispose_time, |