- Samsung S731B Galaxy S25 FE 5G AI 8GB/128GB tmavě modrá CZ Distribuce
- Ochranné flexibilní sklo BestSuit Flexible na displej Samsung A057G Galaxy A05s černá - 6.7
- Xiaomi 15 5G 12GB/512GB Dual SIM černá CZ Distribuce
- Xiaomi Redmi 15C LTE 4GB/128GB NFC černá CZ Distribuce
- chytré hodinky Samsung SM-L320N Galaxy Watch8 40mm stříbrná CZ Distribuce
- Samsung F966B Galaxy Z Fold7 5G AI 12GB/512GB Dual SIM černá CZ Distribuce
- Xiaomi Redmi Buds 6 Pro ANC bílá
- Samsung Galaxy Tab S11 Ultra 14.6 (SM-X936B) 12GB/256GB 5G AI šedá CZ Distribuce
duální LTE modem ZTE WF831 bílá CZ - POŠKOZENÉ BALENÍ...
Cena: 444 Kč
chytré hodinky Motorola Moto Watch Fit zelená CZ
Cena: 1.333 Kč
T-Mobile T Phone 3 6GB/128GB stříbrná CZ
Cena: 3.444 Kč
Sluchátko pro bezdrátový telefon Yealink W73H černá...
Cena: 555 Kč
Xiaomi Redmi 15C 5G 4GB/128GB NFC černá CZ
Cena: 2.444 Kč
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 ('89306394', '89306393', '89306392', '89306390', '89306384', '89306365', '89306396', '89306395', '89306418', '89306421', '89306422', '89306423', '89306411', '89306413', '89306414', '89306400', '89306409', '89306410', '89312902', '89312900', '89312899', '89312896', '89312907', '89312906', '89312904', '89312905', '89306349', '89287020', '89287016', '89287021', '89287019', '89306350', '89287014', '89287012', '89287015', '89287013', '89287009', '89287006', '89287011', '89287008', '89287033', '89287029', '89287031', '89287030', '89287028', '89287025', '89287027', '89287026', '89287038', '89287035', '89287037', '89287036', '89287046', '89306345', '89287043', '89287045', '89287044', '89287042', '89306348', '89287039', '89287041', '89287040', '89312911', '89312912', '89312913', '89312914', '89312916', '89312917', '89312918', '89312920', '89312922', '89312923', '89312924', '89312925', '89312926'), f2.id,
IF(f2.ean IN ('89306394', '89306393', '89306392', '89306390', '89306384', '89306365', '89306396', '89306395', '89306418', '89306421', '89306422', '89306423', '89306411', '89306413', '89306414', '89306400', '89306409', '89306410', '89312902', '89312900', '89312899', '89312896', '89312907', '89312906', '89312904', '89312905', '89306349', '89287020', '89287016', '89287021', '89287019', '89306350', '89287014', '89287012', '89287015', '89287013', '89287009', '89287006', '89287011', '89287008', '89287033', '89287029', '89287031', '89287030', '89287028', '89287025', '89287027', '89287026', '89287038', '89287035', '89287037', '89287036', '89287046', '89306345', '89287043', '89287045', '89287044', '89287042', '89306348', '89287039', '89287041', '89287040', '89312911', '89312912', '89312913', '89312914', '89312916', '89312917', '89312918', '89312920', '89312922', '89312923', '89312924', '89312925', '89312926'), f2.ean,
IF(f2.kod_vyrobce IN ('89306394', '89306393', '89306392', '89306390', '89306384', '89306365', '89306396', '89306395', '89306418', '89306421', '89306422', '89306423', '89306411', '89306413', '89306414', '89306400', '89306409', '89306410', '89312902', '89312900', '89312899', '89312896', '89312907', '89312906', '89312904', '89312905', '89306349', '89287020', '89287016', '89287021', '89287019', '89306350', '89287014', '89287012', '89287015', '89287013', '89287009', '89287006', '89287011', '89287008', '89287033', '89287029', '89287031', '89287030', '89287028', '89287025', '89287027', '89287026', '89287038', '89287035', '89287037', '89287036', '89287046', '89306345', '89287043', '89287045', '89287044', '89287042', '89306348', '89287039', '89287041', '89287040', '89312911', '89312912', '89312913', '89312914', '89312916', '89312917', '89312918', '89312920', '89312922', '89312923', '89312924', '89312925', '89312926'), 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 = '89306394' OR f2.id = '89306393' OR f2.id = '89306392' OR f2.id = '89306390' OR f2.id = '89306384' OR f2.id = '89306365' OR f2.id = '89306396' OR f2.id = '89306395' OR f2.id = '89306418' OR f2.id = '89306421' OR f2.id = '89306422' OR f2.id = '89306423' OR f2.id = '89306411' OR f2.id = '89306413' OR f2.id = '89306414' OR f2.id = '89306400' OR f2.id = '89306409' OR f2.id = '89306410' OR f2.id = '89312902' OR f2.id = '89312900' OR f2.id = '89312899' OR f2.id = '89312896' OR f2.id = '89312907' OR f2.id = '89312906' OR f2.id = '89312904' OR f2.id = '89312905' OR f2.id = '89306349' OR f2.id = '89287020' OR f2.id = '89287016' OR f2.id = '89287021' OR f2.id = '89287019' OR f2.id = '89306350' OR f2.id = '89287014' OR f2.id = '89287012' OR f2.id = '89287015' OR f2.id = '89287013' OR f2.id = '89287009' OR f2.id = '89287006' OR f2.id = '89287011' OR f2.id = '89287008' OR f2.id = '89287033' OR f2.id = '89287029' OR f2.id = '89287031' OR f2.id = '89287030' OR f2.id = '89287028' OR f2.id = '89287025' OR f2.id = '89287027' OR f2.id = '89287026' OR f2.id = '89287038' OR f2.id = '89287035' OR f2.id = '89287037' OR f2.id = '89287036' OR f2.id = '89287046' OR f2.id = '89306345' OR f2.id = '89287043' OR f2.id = '89287045' OR f2.id = '89287044' OR f2.id = '89287042' OR f2.id = '89306348' OR f2.id = '89287039' OR f2.id = '89287041' OR f2.id = '89287040' OR f2.id = '89312911' OR f2.id = '89312912' OR f2.id = '89312913' OR f2.id = '89312914' OR f2.id = '89312916' OR f2.id = '89312917' OR f2.id = '89312918' OR f2.id = '89312920' OR f2.id = '89312922' OR f2.id = '89312923' OR f2.id = '89312924' OR f2.id = '89312925' OR f2.id = '89312926')) 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-16') 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-16') 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, '89306394', '89306393', '89306392', '89306390', '89306384', '89306365', '89306396', '89306395', '89306418', '89306421', '89306422', '89306423', '89306411', '89306413', '89306414', '89306400', '89306409', '89306410', '89312902', '89312900', '89312899', '89312896', '89312907', '89312906', '89312904', '89312905', '89306349', '89287020', '89287016', '89287021', '89287019', '89306350', '89287014', '89287012', '89287015', '89287013', '89287009', '89287006', '89287011', '89287008', '89287033', '89287029', '89287031', '89287030', '89287028', '89287025', '89287027', '89287026', '89287038', '89287035', '89287037', '89287036', '89287046', '89306345', '89287043', '89287045', '89287044', '89287042', '89306348', '89287039', '89287041', '89287040', '89312911', '89312912', '89312913', '89312914', '89312916', '89312917', '89312918', '89312920', '89312922', '89312923', '89312924', '89312925', '89312926')
LIMIT 0,20
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)
náhledy
seznamKategorie neobsahuje žádnou položku
infolinka: 722 944 944
