Akční nabídka
Chyba aplikace nebo serveru: Neznámý sloupec 'ph.pocet_sklad' v field list : SELECT
zh.*,
ht.nazev AS nazev_hodnoty,
pt.nazev AS nazev_priplatku,
p.nasobek,
ph.kod,
ph.pocet_sklad,
ph.platba_predem,
ht.nazev_objednavka AS nazev_objednavka
FROM
prefix_priplatky AS p,
prefix_priplatky_hodnoty AS ph,
prefix_priplatky_texty AS pt,
prefix_priplatky_zbozi_hodnoty AS zh,
prefix_priplatky_hodnoty_texty AS ht
WHERE
p.id_obchodu='6511'
AND
pt.id_priplatku=p.id
AND
pt.lang='cz'
AND
zh.id_zbozi IN (902637053,902637045,902637046,902637049,902637043,902637041,902637052,902637047,902637044,902637048,902637051,902637050,902573424,902573454,902573447,902573457,902573435,902573431,902573439,902637042,902573451,902573445,902573437,902573455,902573433,902573446,902573443,902573430,902573456,902573450,902573423,902573426,902573459,902573453,902573448,902573440,902573449,902573444,902573441,902573427,902573436,902573434,902573438,902573432,902573429,902573425,902573458,902573452,902573442,902573428)
AND
zh.id_priplatku=p.id
AND
ht.id_phodnoty=zh.id_phodnoty
AND
ht.lang='cz'
AND
zh.id_phodnoty=ph.id
ORDER BY
p.poradi,p.id,zh.poradi,zh.id