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_1742345163_8481 AS fulltext_results , prefix_dph AS d
WHERE
z.id_obchodu='1788' AND z.cena > 0 AND z.id = fulltext_results.id_zbozi AND z.id IN (655429,531621,647699,536426,524833,655434,844971,531404,656608,758600,604490,844961,807143,784016)
AND ( z.cena > 0 AND z.aktivni='y' AND z.vypnuto='n' ) AND z.dph =d.id_dph AND d.id_obchodu='1788' 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