Špatný dotaz: Unknown column 'ZKR' in 'order clause'<BR>select distinct a.id,a.cena_nakup,a.id_kategorie,a.id_sazba_dph,a.id_vyrobce,a.evidencni_cislo,a.nazev,a.novinka,a.vyprodej,a.doporucujeme,a.url_vyrobce,a.zkracene,a.popis,a.cena_mo,a.cena_mo_s_dph,a.cena_vo,a.cena_dop,a.elektroodpad,a.autorska_odmena,a.zaruka as minutaz,zar.id as id_zaruka,zar.nazev as zaruka,s.sazba,v.nazev as vyrobce,a.sklad,a.koeficient_prepoctu,mj.nazev as merna_jednotka,dos.nazev as dostupnost,dos.id as id_dostupnost,a.dostupnost_datum,DATEDIFF(CURDATE(),a.dostupnost_datum) as dostupnost_dnu,a.zobrazovat,a.pevna_koncova_cena,a.body from katalog a left join cc_dostupnost dos on dos.id = a.id_dostupnost left join kategorie kat on kat.id = a.id_kategorie left join cc_merna_jednotka mj on mj.id = a.id_merna_jednotka left join cc_sazba_dph s on s.id = a.id_sazba_dph left join vyrobce v on v.id = a.id_vyrobce left join cc_zaruka zar on zar.id = a.id_zaruka join mutace_data mud on mud.id_zdroj = a.id and mud.jazyk = "" join mutace mut on mut.id = mud.id_mutace and mut.tabulka="katalog" and mut.sloupec in ("nazev","popis") where a.id is not null and a.zobrazovat="A" and a.zobrazovat_samostatne = "A"  and (mud.hodnota_VARCHAR like "%A%" or mud.hodnota_LONGTEXT like "%A%" or a.evidencni_cislo like "%A%") and kat.zobrazovat="A" ORDER BY ZKR