Chyba aplikace nebo serveru: Unknown column 'rank' in 'order clause' : /* *** SQL zbozi v kategorii *** */ SELECT z.id AS id , (z.cena * (100-z.sleva)/100 * (1+(d.hodnota/100)) / z.baleni) AS cena_s_dph , IF (z.zakazat_nakup='n' OR z.skladem like 'skladem' ,1,2) AS ord_zakazat_nakup FROM prefix_zbozi AS z LEFT JOIN prefix_zbozi_kategorie AS zk ON z.id =zk.id_zbozi , tmp_zbozi_fulltext_1742600594_0201 AS fulltext_results , prefix_dph AS d WHERE z.id_obchodu='3500' AND z.id = fulltext_results.id_zbozi AND z.id IN (1108419,901827950,1108420,901827906,901820661) AND ( z.aktivni='y' AND z.vypnuto='n' ) AND z.dph =d.id_dph AND d.id_obchodu='3500' AND z.zakazat_nakup='n' GROUP BY z.id ORDER BY ord_zakazat_nakup, rank DESC, z.poradi, z.id , z.id DESC LIMIT 3000