Fix market chain customer migration

SELECT CONCAT('INSERT INTO market_chain_customers (market_chain_id, customer_id, credit, friend_code, player_id, created_at, updated_at) VALUES (',
        m.market_chain_id, ', ',
        mc.customer_id, ', ',
        SUM(coalesce(mc.credit,0)), ', ''',
        (SELECT  friend_code
            FROM market_customers mc2
            JOIN markets m2
                ON m2.id = mc2.market_id
            WHERE mc2.customer_id = mc.customer_id
                  AND m2.market_chain_id = m.market_chain_id
            ORDER BY mc2.created_at DESC LIMIT 1), ''',''',
            (SELECT player_id
            FROM market_customers mc2
            JOIN markets m2
                ON m2.id = mc2.market_id
            WHERE mc2.customer_id = mc.customer_id
                  AND m2.market_chain_id = m.market_chain_id
            ORDER BY mc2.created_at DESC LIMIT 1), ''', NOW(), NOW());')
FROM market_customers mc
  JOIN markets m
    ON m.id = mc.market_id
  join customers c on c.id = mc.customer_id
GROUP BY mc.customer_id,m.market_chain_id;