用 SQLAlchemy 改写下面 SQL
sql = '''SELECT a.id FROM a
INNER JOIN b ON a.id = b.a_id
WHERE (SELECT COUNT(1) AS num FROM d
WHERE d.id = a.id AND d.user_id=:user_id) = 0
AND a.year>2010 limit 0,:group_size ;'''
parms = {
'user_id':user_id,
'knowPoint_id':knowPoint_id,
'group_size':group_size*2
}
list = dbconn.get_sql_session_all_data(sql,parms)
SqlAlchemy可以执行sql语句的,应该可以不用转