Vyhledávání zboží

Chyba aplikace nebo serveru: Unknown column 'rank' in 'order clause' : SELECT z.id AS id ,(SELECT fulltextrank FROM tmp_zbozi_fulltext_1586316454_9035 WHERE id_zbozi=z.id) AS fulltextrank, (z.cena * (100-z.sleva)/100 * (1+(d.hodnota/100)) / z.baleni) AS cena_s_dph FROM prefix_zbozi AS z LEFT JOIN prefix_zbozi_kategorie AS zk ON z.id =zk.id_zbozi , prefix_dph AS d WHERE z.id_obchodu='3804' AND z.id IN (1181801) AND ( z.aktivni='y' AND z.vypnuto='n' ) AND z.dph =d.id_dph AND d.id_obchodu='3804' GROUP BY z.id ORDER BY rank DESC, z.poradi, z.id , z.id LIMIT 3000