View difference between Paste ID: YdQZJE5z and aTwBp3Yx

 import sqlite3
 
 con = sqlite3.connect(":memory:")
 c = con.cursor()
 
 c.execute("create table jjo_errors (id integer primary key, name varchar(100))")
 c.execute("create table tasks (id integer primary key, name varchar(100))")
 c.execute("""create table connections_to_jjos (
     connections_id integer,
     jjo_error_id integer,
     binder_task_id integer)""")
 
 c.execute("insert into jjo_errors values (1, 'known'), (2, '--Unknown--')")
 c.execute("insert into tasks values (3, 'DCDD'), (4, 'ANDD')")
 
 q = """
 INSERT INTO connections_to_jjos(
     connections_id,
     jjo_error_id,
     binder_task_id
 )
 VALUES
 
 (
     55,
     (select id from jjo_errors where name = "--Unknown--"),
     (select id from tasks where name = "DCDD")
 )
 ,
 
 (
     55,
     (select id from jjo_errors where name = "--Unknown--"),
     (select id from tasks where name = "ANDD")
 )
 """
 c.execute(q)
 c.execute('select * from connections_to_jjos')
 print(c.fetchall())
 
 c.execute("insert into jjo_errors values (5, 'known'), (6, '--Unknown--')")
 c.execute("insert into tasks values (7, 'something'), (8, 'ANDD')")
 
 c.execute(q)
 c.execute('select * from connections_to_jjos')
 print(c.fetchall())
 
 
 """
 everyting ok using:
 Python 2.7.4 - sqlite3.sqlite_version '3.7.15.2'
 Python 3.3.1 - sqlite3.version '2.6.0'
 """