- Xiaomi Redmi 15 LTE 8GB/256GB NFC šedá CZ Distribuce
- Samsung S731B Galaxy S25 FE 5G AI 8GB/128GB bílá CZ Distribuce
- Xiaomi Redmi Buds 6 Pro ANC bílá
- Ochranné flexibilní sklo BestSuit Flexible na displej Samsung A057G Galaxy A05s černá - 6.7
- Xiaomi Redmi 15 5G 4GB/128GB NFC zelená CZ Distribuce
- chytré hodinky Samsung SM-L500N Galaxy Watch8 Classic 46mm bílá CZ Distribuce
- Aligator Hotwav T7 Pro 6GB/256GB černá CZ Distribuce
- Xiaomi Redmi Buds 6 ANC zelená
Alcatel LTE modem LINK ZONE černá CZ
Cena: 27,66 EUR
Apple iPhone 16 Pro Max 512GB Bílý titan CZ Distribuce...
Cena: 1.282,72 EUR
FIXED pouzdro TPU Story pro vivo V50 Lite LTE, V50...
Cena: 10,34 EUR
Realme Note 70T 4GB/128GB zlatá CZ
Cena: 78,41 EUR
Xiaomi Redmi 15C 5G 4GB/128GB NFC zelená CZ Distribuce...
Cena: 119,93 EUR
MYSQLDotaz:SELECT
SQL_CALC_FOUND_ROWS f2.id,
f2.artikl_id,
f2.id,
IF(akce_eshopu != '', CONCAT(produkt,akce_eshopu), produkt) AS produkt,
akce_eshopu,
f2.popis,
f2.cena_eshop AS cena_eshop,
sazba_dph,
cena_1,
akcni_cena,
vyprodej,
prod.pocet_prodano AS pocet_prodano,
prod_all.pocet_prodano_celkem, endoflife AS endoflife,
IF(f2.id IN ('89155729', '89155737', '89156615', '89155736', '89161531', '89156612', '89161533', '89156617', ''), f2.id,
IF(f2.ean IN ('89155729', '89155737', '89156615', '89155736', '89161531', '89156612', '89161533', '89156617', ''), f2.ean,
IF(f2.kod_vyrobce IN ('89155729', '89155737', '89156615', '89155736', '89161531', '89156612', '89161533', '89156617', ''), f2.kod_vyrobce, '')
)
) AS row2sort,
(SELECT file FROM katalog_pics fx1 WHERE fx1.artikl_id = f2.artikl_id AND verejne=1 AND energy_label=0 ORDER BY poradi, id LIMIT 1) AS obr,
fsklad.celkem_skladem AS celkem_skladem,
ftimer.id timer_akce
FROM
(SELECT * FROM katalog fx2 WHERE fx2.id > 0 AND archiv = 0 AND (f2.id = '89155729' OR f2.id = '89155737' OR f2.id = '89156615' OR f2.id = '89155736' OR f2.id = '89161531' OR f2.id = '89156612' OR f2.id = '89161533' OR f2.id = '89156617' OR f2.id = '')) f2
LEFT JOIN katalog2menu f1 ON f1.prod_id = f2.artikl_id
LEFT JOIN menu f3 ON f3.id = f1.kat_id
LEFT JOIN (SELECT id, katalog_id FROM timer_ceny WHERE pole='cena_eshop' AND zacatek <= current_timestamp AND konec > current_timestamp LIMIT 1) ftimer ON (ftimer.katalog_id = f2.id)
LEFT JOIN (SELECT artikl_id, SUM(mnozstvi) AS celkem_skladem FROM sklad_mnozstvi WHERE stav_id IN (1,2) AND sklad_id > 0 AND sklad_id NOT IN (11,22) AND rezervace = 0 GROUP BY artikl_id) fsklad ON fsklad.artikl_id = f2.artikl_id
LEFT JOIN (SELECT artikl_id, SUM(mnozstvi) AS pocet_prodano_celkem FROM sklad_mnozstvi GROUP BY artikl_id) prod_all ON prod_all.artikl_id = f2.artikl_id
LEFT JOIN (
SELECT
sm.artikl_id,
SUM(sm.mnozstvi) AS pocet_prodano
FROM
sklad_mnozstvi sm
LEFT JOIN (SELECT id FROM kasa_doklad WHERE datum >= '2025-11-17') kd ON kd.id = sm.kasa_doklad_id
LEFT JOIN polozkaebaliku pe ON pe.sklad_mnozstvi_id = sm.id
LEFT JOIN objednane_polozky op ON op.id_polozky = pe.objednane_polozky_id
LEFT JOIN (SELECT id_obj FROM objednavky WHERE datum_expedice >= '2025-11-17') o ON o.id_obj = op.id_obj
WHERE
kd.id IS NOT NULL OR o.id_obj IS NOT NULL
GROUP BY sm.artikl_id
) prod ON prod.artikl_id = f2.artikl_id
WHERE
f2.id > 0
AND f2.aktivni = '1'
AND f2.archiv = 0
AND f3.viditelne = '1'
AND f3.neprodejne = '0'
HAVING
(endoflife=0 OR endoflife IS NULL)
OR (endoflife=1 AND celkem_skladem > 0)
ORDER BY FIELD(row2sort, '89155729', '89155737', '89156615', '89155736', '89161531', '89156612', '89161533', '89156617', '')
LIMIT 0,50
Chyba:Unknown column 'f2.id' in 'where clause'Výsledky vyhledávání
Pro hledaný výraz "sada kat. čísel" bylo nalezeno 5 produktů (celkem 1 strana)
| Kat.č. | Produkt | Cena | Skladem |
|---|
Kategorie neobsahuje žádnou položku





seznam
infolinka: 722 944 944



