- Ochranné flexibilní sklo BestSuit Flexible na displej Samsung A057G Galaxy A05s černá - 6.7
- chytré hodinky Samsung SM-L500N Galaxy Watch8 Classic 46mm bílá CZ Distribuce
- Samsung F766B Galaxy Z Flip7 5G AI 12GB/256GB modrá CZ Distribuce
- chytré hodinky Samsung SM-L500N Galaxy Watch8 Classic 46mm černá CZ Distribuce
- Samsung Galaxy Tab S11 11.0 (SM-X736) 12GB/128GB 5G AI stříbrná CZ Distribuce
- Aligator R35 eXtremo Dual SIM černá CZ Distribuce
- Samsung F966B Galaxy Z Fold7 5G AI 12GB/256GB Dual SIM černá CZ Distribuce
- ZTE Blade A35e LTE 2GB/64GB Dual SIM šedá CZ Distribuce
T-Mobile T Phone 3 6GB/128GB stříbrná CZ
Cena: 2.990 Kč
chytré hodinky Huawei Watch GT 6 41mm fialová CZ
Cena: 3.888 Kč
Apple iPhone Air 512GB černá CZ Distribuce AKČNÍ CENA...
Cena: 27.990 Kč
bezdrátový telefon Siemens Gigaset A180 černá CZ
Cena: 290 Kč
Samsung F956B Galaxy Z Fold6 5G AI 12GB/256GB Dual...
Cena: 19.990 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 ('89291982', '89291969', '89274792', '89292004', '89309017', '89309015', '89274788', '89273567', '89291945', '89309018', '89274791', '89291989', '89287015', '89306348', '89306350', '89287039', '89243772', '89243765', '89287040', '89309021', '89292005', '89273564', '89291995', '89287012', '89287041', '89292000', '89273563', '89291992', '89291988', '89309020', '89243091', '89243764', '89287020', '89287027', '89243762', '89291993', '89291986', '89243769', '89287006', '89287025', '89273568', '89292001', '89287043', '89287016', '89287008', '89306349', '89287033', '89287014', '89287042', '89243767', '89315644', '89315643', '89315649', '89315645', '89315648', '89315647', '89315641', '89315642', '89248500', '89248501', '89248502', '89263856', '89306512', '89263849', '89306508', '89306511', '89306478', '89306507', '89306509', '89306547', '89263847', '89306443', '89306487', '89306480', '89263857', '89306522', '89306546'), f2.id,
IF(f2.ean IN ('89291982', '89291969', '89274792', '89292004', '89309017', '89309015', '89274788', '89273567', '89291945', '89309018', '89274791', '89291989', '89287015', '89306348', '89306350', '89287039', '89243772', '89243765', '89287040', '89309021', '89292005', '89273564', '89291995', '89287012', '89287041', '89292000', '89273563', '89291992', '89291988', '89309020', '89243091', '89243764', '89287020', '89287027', '89243762', '89291993', '89291986', '89243769', '89287006', '89287025', '89273568', '89292001', '89287043', '89287016', '89287008', '89306349', '89287033', '89287014', '89287042', '89243767', '89315644', '89315643', '89315649', '89315645', '89315648', '89315647', '89315641', '89315642', '89248500', '89248501', '89248502', '89263856', '89306512', '89263849', '89306508', '89306511', '89306478', '89306507', '89306509', '89306547', '89263847', '89306443', '89306487', '89306480', '89263857', '89306522', '89306546'), f2.ean,
IF(f2.kod_vyrobce IN ('89291982', '89291969', '89274792', '89292004', '89309017', '89309015', '89274788', '89273567', '89291945', '89309018', '89274791', '89291989', '89287015', '89306348', '89306350', '89287039', '89243772', '89243765', '89287040', '89309021', '89292005', '89273564', '89291995', '89287012', '89287041', '89292000', '89273563', '89291992', '89291988', '89309020', '89243091', '89243764', '89287020', '89287027', '89243762', '89291993', '89291986', '89243769', '89287006', '89287025', '89273568', '89292001', '89287043', '89287016', '89287008', '89306349', '89287033', '89287014', '89287042', '89243767', '89315644', '89315643', '89315649', '89315645', '89315648', '89315647', '89315641', '89315642', '89248500', '89248501', '89248502', '89263856', '89306512', '89263849', '89306508', '89306511', '89306478', '89306507', '89306509', '89306547', '89263847', '89306443', '89306487', '89306480', '89263857', '89306522', '89306546'), 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 = '89291982' OR f2.id = '89291969' OR f2.id = '89274792' OR f2.id = '89292004' OR f2.id = '89309017' OR f2.id = '89309015' OR f2.id = '89274788' OR f2.id = '89273567' OR f2.id = '89291945' OR f2.id = '89309018' OR f2.id = '89274791' OR f2.id = '89291989' OR f2.id = '89287015' OR f2.id = '89306348' OR f2.id = '89306350' OR f2.id = '89287039' OR f2.id = '89243772' OR f2.id = '89243765' OR f2.id = '89287040' OR f2.id = '89309021' OR f2.id = '89292005' OR f2.id = '89273564' OR f2.id = '89291995' OR f2.id = '89287012' OR f2.id = '89287041' OR f2.id = '89292000' OR f2.id = '89273563' OR f2.id = '89291992' OR f2.id = '89291988' OR f2.id = '89309020' OR f2.id = '89243091' OR f2.id = '89243764' OR f2.id = '89287020' OR f2.id = '89287027' OR f2.id = '89243762' OR f2.id = '89291993' OR f2.id = '89291986' OR f2.id = '89243769' OR f2.id = '89287006' OR f2.id = '89287025' OR f2.id = '89273568' OR f2.id = '89292001' OR f2.id = '89287043' OR f2.id = '89287016' OR f2.id = '89287008' OR f2.id = '89306349' OR f2.id = '89287033' OR f2.id = '89287014' OR f2.id = '89287042' OR f2.id = '89243767' OR f2.id = '89315644' OR f2.id = '89315643' OR f2.id = '89315649' OR f2.id = '89315645' OR f2.id = '89315648' OR f2.id = '89315647' OR f2.id = '89315641' OR f2.id = '89315642' OR f2.id = '89248500' OR f2.id = '89248501' OR f2.id = '89248502' OR f2.id = '89263856' OR f2.id = '89306512' OR f2.id = '89263849' OR f2.id = '89306508' OR f2.id = '89306511' OR f2.id = '89306478' OR f2.id = '89306507' OR f2.id = '89306509' OR f2.id = '89306547' OR f2.id = '89263847' OR f2.id = '89306443' OR f2.id = '89306487' OR f2.id = '89306480' OR f2.id = '89263857' OR f2.id = '89306522' OR f2.id = '89306546')) 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, '89291982', '89291969', '89274792', '89292004', '89309017', '89309015', '89274788', '89273567', '89291945', '89309018', '89274791', '89291989', '89287015', '89306348', '89306350', '89287039', '89243772', '89243765', '89287040', '89309021', '89292005', '89273564', '89291995', '89287012', '89287041', '89292000', '89273563', '89291992', '89291988', '89309020', '89243091', '89243764', '89287020', '89287027', '89243762', '89291993', '89291986', '89243769', '89287006', '89287025', '89273568', '89292001', '89287043', '89287016', '89287008', '89306349', '89287033', '89287014', '89287042', '89243767', '89315644', '89315643', '89315649', '89315645', '89315648', '89315647', '89315641', '89315642', '89248500', '89248501', '89248502', '89263856', '89306512', '89263849', '89306508', '89306511', '89306478', '89306507', '89306509', '89306547', '89263847', '89306443', '89306487', '89306480', '89263857', '89306522', '89306546')
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
