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_1594490718_9664 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='6075' AND z.id IN (65,66,67,441,471,514,712,713,714,720,721,722,723,724,725,2095,2096,2097,2098,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,2131,4001,5491,5492,5493,5494,5657,45,46,47,48,49,55,56,57,58,468,522,1350,4090) AND ( z.aktivni='y' AND z.vypnuto='n' ) AND z.dph =d.id_dph AND d.id_obchodu='6075' GROUP BY z.id ORDER BY rank DESC, z.poradi, z.id , z.id LIMIT 3000