INSERT INTO tqk_finance (id, add_time, price, `status`, backcash, uid, income, mark, phone, `client`, ids)
SELECT null, DATE_FORMAT(NOW(),'%Y-%m-%d'), SUM(list.pub_share_pre_fee), 2, 0, 0, SUM(list.user_rate), list.tk_earning_time, list.relation_id, 'app', GROUP_CONCAT(id)
FROM (SELECT id,relation_id,DATE_FORMAT(tk_ear...