SELECT 
g.id,
if(g2 is null,cast(g.id as CHAR),g2) as title,

n200,
n201a, n201b, 
n202a, n202b, n202c, 
n203a, n203b, n203c, 
n204a, n204b, n204c, 
n205a, n205b, n205c, 
n206,
n207a, n207b, n207c, 
n208a, n208b, n208c, 
n209a, n209b, n209c, 

n210, 
n211a, n211b, n211c, 
n212, 
n213, 
n214a, n214b, n214c, 
n215, 
n216, 
n217a, n217b, n217c, 
n218a, n218b, n218c, 
n219a, n219b, n219c, 

n220a, n220b, n220c, 
n221, 
n222a, if(n222b='NULL',null,n222b) as n222b, n222c, 
n223a, if(n223b='NULL',null,n223b) as n223b, n223c, 
n224a, if(n224b='NULL',null,n224b) as n224b, n224c, 
n225a, if(n225b='NULL',null,n225b) as n225b, n225c, 
n226a, if(n226b='NULL',null,n226b) as n226b, n226c, 
n227a, if(n227b='NULL',null,n227b) as n227b, n227c, 
n228a, if(n228b='NULL',null,n228b) as n228b, n228c, 
n229a, if(n229b='NULL',null,n229b) as n229b, n229c,

n230a, 
if(n230b='NULL',null,n230b) as n230b,
n230c, 
n231a, if(n231b='NULL',null,n231b) as n231b, n231c, 
n232a, if(n232b='NULL',null,n232b) as n232b, n232c, 
n233a, if(n233b='NULL',null,n233b) as n233b, n233c, 
n234,
n235a, if(n235b='NULL',null,n235b) as n235b, n235c, 
n236a, if(n236b='NULL',null,n236b) as n236b, n236c, 
n237a, if(n237b='NULL',null,n237b) as n237b, n237c, 
n238a, if(n238b='NULL',null,n238b) as n238b, n238c, 
n239a, if(n239b='NULL',null,n239b) as n239b, n239c, 

n240a, if(n240b='NULL',null,n240b) as n240b, n240c, 
n241, n242a, n242b, n242c, n242d,
n243, n244, 
n245a, n245b, 
n246a, n246b,
n247, n248,
n249a, n249b,

n250a, n250b, n251

FROM genomos_novel g, genomos_general gg where gg.id=g.id order by id
