比较复杂的sql

select from_base64(o.nick_name) from activity_win_record o left join activity_win_recipient p
on o.id = p.win_id

SELECT
o.nick_name,
o.prize_name,
o.win_amount,
o.create_date,
o.odd_num,
p. NAME,
p.address,
p.phone

FROM
activity_win_record o
LEFT JOIN activity_win_recipient p ON o.id = p.win_id

SELECT

o.nick_name,o.prize_name,
o.win_amount,
o.create_date,
o.odd_num,
p. NAME,
p.address,
p.phone,
(
CASE o.STATUS
WHEN 01 THEN ‘待领取’
WHEN 02 THEN ‘待发放’
WHEN 04 THEN ‘已发放’
WHEN 05 THEN ‘已领取’
WHEN 06 THEN ‘已退款’
WHEN 07 THEN ‘已锁定’
END
) AS status,
(
CASE o.prize_type
WHEN ‘QUITA_RED’ THEN ‘定额红包’
WHEN ‘RANDOM_RED’ THEN ‘随机红包’
WHEN ‘INTEGRAL’ THEN ‘积分’
WHEN ‘MATERIAL’ THEN ‘实物’
WHEN ‘FORCARTEX’ THEN ‘福卡’
WHEN ‘THANKS’ THEN ‘谢谢’
END
) AS prize_type
FROM (SELECT CONCAT(FROM_BASE64(nick_name),” “) AS nick_name,id,prize_name,win_amount,create_date,odd_num,status,prize_type,activity_id FROM activity_win_record WHERE o.activity_id=’25e1178432d94984ac05a27561061ffd’) o
LEFT JOIN activity_win_recipient p ON o.id = p.win_id
WHERE o.activity_id=’25e1178432d94984ac05a27561061ffd’

SELECT o.nick_name,o.prize_name,
o.win_amount,
o.create_date,
o.odd_num,
p. NAME,
p.address,
p.phone,
(
CASE o.STATUS
WHEN 01 THEN ‘待领取’
WHEN 02 THEN ‘待发放’
WHEN 04 THEN ‘已发放’
WHEN 05 THEN ‘已领取’
WHEN 06 THEN ‘已退款’
WHEN 07 THEN ‘已锁定’
END
) AS STATUS,(
CASE o.prize_type
WHEN ‘QUITA_RED’ THEN ‘定额红包’
WHEN ‘RANDOM_RED’ THEN ‘随机红包’
WHEN ‘INTEGRAL’ THEN ‘积分’
WHEN ‘MATERIAL’ THEN ‘实物’
WHEN ‘FORCARTEX’ THEN ‘福卡’
WHEN ‘THANKS’ THEN ‘谢谢’
END
) AS prize_type
FROM (SELECT CONCAT(FROM_BASE64(nick_name)) AS nick_name,id,prize_name,win_amount,create_date,odd_num,STATUS,prize_type,activity_id FROM activity_win_record ) o
LEFT JOIN activity_win_recipient p ON o.id = p.win_id WHERE o.activity_id=’25e1178432d94984ac05a27561061ffd’

SELECT
o.nick_name,o.prize_name,
(
CASE o.prize_type
WHEN ‘QUITA_RED’ THEN truncate(o.win_amount/100,2)
WHEN ‘RANDOM_RED’ THEN truncate(o.win_amount/100,2)
else o.win_amount
END
) AS win_amount,
– truncate(o.win_amount/100,2) as win_amount,
o.create_date,
o.odd_num,
p. NAME,
p.address,
p.phone,
(
CASE o.STATUS
WHEN ‘01’ THEN ‘待领取’
WHEN ‘02’ THEN ‘待发放’
WHEN ‘04’ THEN ‘已发放’
WHEN ‘05’ THEN ‘已领取’
WHEN ‘06’ THEN ‘已退款’
WHEN ‘07’ THEN ‘已锁定’
END
) AS STATUS,(
CASE o.prize_type
WHEN ‘QUITA_RED’ THEN ‘定额红包’
WHEN ‘RANDOM_RED’ THEN ‘随机红包’
WHEN ‘INTEGRAL’ THEN ‘积分’
WHEN ‘MATERIAL’ THEN ‘实物’
WHEN ‘FORCARTEX’ THEN ‘福卡’
WHEN ‘THANKS’ THEN ‘谢谢’
END
) AS prize_type
FROM (SELECT CONCAT(FROM_BASE64(nick_name)) AS nick_name,id,prize_name,win_amount,create_date,odd_num,STATUS,prize_type,activity_id FROM activity_win_record ) o
LEFT JOIN activity_win_recipient p ON o.id = p.win_id WHERE o.activity_id=’80ea078faba341e58ac915adcf5a4143’

select * from user_activity_prize where activity_id in (select id from user_activity_base where company_id = ‘80ea078faba341e58ac915adcf5a4143’)