SELECT wdodavate,varianta, id,id_nadkategorie,akce, preklad, dodavatel, obrazek, priorita, kod, seo, lhuta, skladem, cena,konecnacena, popis, kontrola2, kontrola 
                  FROM(
                  
                  SELECT varianta, id, dodavatel, akce, expedice,
                  if( min(kontrola) = 2 and zobrazit='0',text , nazev ) AS preklad,
                  if( min(kontrola) = 2 and zobrazit='0',knseo, kseo ) as seo, obrazek, priorita,  kod, jazyk, zobrazit, zobraz,
                  if( min(kontrola2) = 2 , zccena , kcena ) AS cena,konecnacena,
                  od, do, knod, kndo, lhuta, skladem, popis, kontrola2, kontrola, id_nadkategorie,wdodavate 
                  FROM (
                  
                  SELECT   z.nove, zs.expirace as expedice,d.web_nazev as wdodavate, d.nazev as dodavatel, zc.cena as zccena,k.konecnacena,k.id_nadkategorie, k. cena as kcena, k.kratky_popis as popis, k.lhuta, k.skladem, k.cena, k.seo_nazev as kseo, kn.seo_nazev as knseo, k.id, k.kod, k.obrazek, k.nazev, kn.nazev as text, k.priorita, k.zobrazit as zobraz, kn.zobrazit  as zobrazit,
                  k.od , k.do, kn.od as knod, kn.do as kndo,  if( kn.jazyk ='125', 2, 999) AS kontrola, kn.jazyk,
                  if( zc.id_meny =116, 2, 999) AS kontrola2,
                   if(zs.expirace>4,NULL,a.id) as akce, zs.id as varianta 
                  FROM zbozi k
                  LEFT JOIN kategorie kk ON k.id_nadkategorie=kk.id
                  LEFT JOIN zbozi_nazvy kn ON k.id = kn.id_zbozi and kn.jazyk ='125'
                  LEFT JOIN zbozi_cena zc ON k.id = zc.id_zbozi and zc.id_meny =116
                  LEFT JOIN zbozi_kategorie zk on k.id=zk.id_zbozi 
                  LEFT JOIN kategorie kk2 ON zk.id_kategorie=kk2.id
                  LEFT JOIN dodavatele d on k.id_dodavatele=d.id
                  LEFT JOIN zbozi_sklad zs on k.id=zs.id_zbozi
                  LEFT JOIN zbozi_doporucujeme a on k.id=a.id_zbozi
                  WHERE (
                  (kk.id_bloku = '394' or kk2.id_bloku='394') and k.id_obchodu='121'
                  )
                  
                  ORDER BY kontrola ASC
                  
                  ) AS tab1 
                   GROUP BY id
                   ) AS tab2
                  
                  where ((zobrazit='0' or zobrazit is NULL) and zobraz='0' and nove='1') 
                  and ( ( od='0000-00-00' or od<='2012-05-19') and (do='0000-00-00' or do>='2012-05-19'))
                  and ( ( knod='0000-00-00' or knod<='2012-05-19' or knod is NULL) and (kndo='0000-00-00' or kndo>='2012-05-19' or kndo is NULL)
                  ) ORDER BY akce desc, expedice asc, konecnacena desc, priorita  asc /Unknown column 'z.nove' in 'field list'