Python List Of String To SQL IN Parameter

I have this query in python: ssim_group = [S1200,S1300] query = '''select WIPMessageCnt from waferdata where recipename in (%s) and equipment = ? and

Solution 1:

ssim_group = ['S1200', 'S1300']
query = '''select WIPMessageCnt from waferdata where recipename in ('%s') and equipment = ? and runtype = ? order by  stopts desc limit 1''' % ("','".join(ssim_group))