select nnavesky_tisk.*,
nnavesky_nast.text_obb, 
nnavesky_nast.text_obn, 
nnavesky_nast.text_obv, 
nnavesky_nast.text_obz, 
"Jiný text 
" as text_jin, 
nnavesky_nast.text_gen, 
nnavesky_nast.regcislo, 
nnavesky_nast.zemevyroby, 
nnavesky_nast.czbio, 
nnavesky_nast.vynechat_osivo, 
nnavesky_nast.druhy_brambory, 
nnavesky_nast.email_ukzuz, 
"1" as stredisko
 from nnavesky_tisk, nnavesky_nast where nnavesky_tisk.ccislo >= "302981010495" and nnavesky_tisk.ccislo <= "302981010495"
and nnavesky_nast.pc = "00" order by nnavesky_tisk.ccislo
