--- a/legacy/src/main/resources/org/wnsql/builder/legacy/sqlite.properties
+++ b/legacy/src/main/resources/org/wnsql/builder/legacy/sqlite.properties
@@ -76,10 +76,10 @@
 LegacyXSense$X$.insert=INSERT INTO %LegacySense.table.base%$X$ (wordid,synsetid,pos,sensenum,senseid,sensekey) VALUES (?,?,?,?,?,?);
 
 legacy0.LegacySenseMap$X$~$Z$.view=%LegacySenseMap.table.base%$X$$Z$
-legacy0.LegacySenseMap$X$~$Z$.createview=DROP VIEW IF EXISTS %legacy0.LegacySenseMap$X$~$Z$.view%; CREATE VIEW %legacy0.LegacySenseMap$X$~$Z$.view% AS SELECT m1.wordid,m1.srcsynsetid,m2.synsetid,(m1.quality*m2.quality) AS quality FROM %LegacySenseMap.table.base%$X$~$Y$ m1 INNER JOIN %LegacySenseMap.table.base%$Y$~$Z$ m2 ON m1.wordid = m2.wordid AND m1.synsetid = m2.srcsynsetid;
+legacy0.LegacySenseMap$X$~$Z$.createview=DROP VIEW IF EXISTS %legacy0.LegacySenseMap$X$~$Z$.view%; CREATE VIEW %legacy0.LegacySenseMap$X$~$Z$.view% AS SELECT m1.wordid,m1.srcsynsetid,m2.synsetid,(m1.quality*m2.quality) AS quality FROM %LegacySenseMap.table.base%$X$$Y$ m1 INNER JOIN %LegacySenseMap.table.base%$Y$$Z$ m2 ON m1.wordid = m2.wordid AND m1.synsetid = m2.srcsynsetid;
 legacy0.LegacySynsetMap$X$~$Z$.view=%LegacySynsetMap.table.base%$X$$Z$
-legacy0.LegacySynsetMap$X$~$Z$.createview=DROP VIEW IF EXISTS %legacy0.LegacySynsetMap$X$~$Z$.view%; CREATE VIEW %legacy0.LegacySynsetMap$X$~$Z$.view% AS SELECT m1.srcsynsetid,m2.synsetid,(m1.quality*m2.quality) AS quality FROM %LegacySynsetMap.table.base%$X$~$Y$ m1 INNER JOIN %LegacySynsetMap.table.base%$Y$~$Z$ m2 ON m1.synsetid = m2.srcsynsetid;
+legacy0.LegacySynsetMap$X$~$Z$.createview=DROP VIEW IF EXISTS %legacy0.LegacySynsetMap$X$~$Z$.view%; CREATE VIEW %legacy0.LegacySynsetMap$X$~$Z$.view% AS SELECT m1.srcsynsetid,m2.synsetid,(m1.quality*m2.quality) AS quality FROM %LegacySynsetMap.table.base%$X$$Y$ m1 INNER JOIN %LegacySynsetMap.table.base%$Y$$Z$ m2 ON m1.synsetid = m2.srcsynsetid;
 legacy0.LegacySynset$X$.view=%LegacySynset.view.base%$X$
-legacy0.LegacySynset$X$.createview=DROP VIEW IF EXISTS %legacy0.LegacySynset$X$.view%; CREATE VIEW %legacy0.LegacySynset$X$.view% AS SELECT DISTINCT srcsynsetid FROM %LegacySenseMap.table.base%$X$~$Y$;
+legacy0.LegacySynset$X$.createview=DROP VIEW IF EXISTS %legacy0.LegacySynset$X$.view%; CREATE VIEW %legacy0.LegacySynset$X$.view% AS SELECT DISTINCT srcsynsetid FROM %LegacySenseMap.table.base%$X$$Y$;
 legacy0.Legacy$X$.view=%Legacy.view.base%$X$
-legacy0.Legacy$X$.createview=DROP VIEW IF EXISTS %legacy0.Legacy$X$.view%; CREATE VIEW %legacy0.Legacy$X$.view% AS SELECT s.wordid,lemma,m.quality,s.sensekey AS ssensekey,d.sensekey AS dsensekey,m.srcsynsetid AS ssynsetid,m.synsetid AS dsynsetid,d.senseid AS dsenseid,d.sensenum,d.lexid,d.tagcount,definition FROM %Sense.table%$X$ AS s INNER JOIN %LegacySenseMap.table.base%$X$~$Y$ m ON s.wordid = m.wordid AND s.synsetid = m.srcsynsetid INNER JOIN %Sense.table% AS d ON m.wordid = d.wordid AND m.synsetid = d.synsetid LEFT JOIN %Synset.table% AS y ON d.synsetid = y.synsetid LEFT JOIN %Word.table% AS w ON d.wordid = w.wordid;
+legacy0.Legacy$X$.createview=DROP VIEW IF EXISTS %legacy0.Legacy$X$.view%; CREATE VIEW %legacy0.Legacy$X$.view% AS SELECT s.wordid,lemma,m.quality,s.sensekey AS ssensekey,d.sensekey AS dsensekey,m.srcsynsetid AS ssynsetid,m.synsetid AS dsynsetid,d.senseid AS dsenseid,d.sensenum,d.lexid,d.tagcount,definition FROM %Sense.table%$X$ AS s INNER JOIN %LegacySenseMap.table.base%$X$$Y$ m ON s.wordid = m.wordid AND s.synsetid = m.srcsynsetid INNER JOIN %Sense.table% AS d ON m.wordid = d.wordid AND m.synsetid = d.synsetid LEFT JOIN %Synset.table% AS y ON d.synsetid = y.synsetid LEFT JOIN %Word.table% AS w ON d.wordid = w.wordid;