Registrace

Zapomněli jste heslo?

Přátelský e-shop, certifikovaný e-shop České pošty

Nákup celkem: 0 EUR

originální výměnný provlékací pásek Apple Sport Loop...

Cena: 12,04 EUR

Bezdrátový LTE modem + WiFi router TP-Link Archer...

Cena: 47,72 EUR

Samsung S938B Galaxy S25 Ultra 5G AI 12GB/256GB černá...

Cena: 867,44 EUR

Apple Watch Series 8 GPS + Cellular 41mm Graphite...

Cena: 227,99 EUR

LTE modem ZyXel LTE4506 LTE-A HomeSpot bílá CZ

Cena: 41,11 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 ('89116810', '89116817', '89116818', '89116819', '89148142', '89148143', '89176248', '89148144', '89148145', ''), f2.id,
        IF(f2.ean IN ('89116810', '89116817', '89116818', '89116819', '89148142', '89148143', '89176248', '89148144', '89148145', ''), f2.ean,
          IF(f2.kod_vyrobce IN ('89116810', '89116817', '89116818', '89116819', '89148142', '89148143', '89176248', '89148144', '89148145', ''), 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 = '89116810' OR f2.id = '89116817' OR f2.id = '89116818' OR f2.id = '89116819' OR f2.id = '89148142' OR f2.id = '89148143' OR f2.id = '89176248' OR f2.id = '89148144' OR f2.id = '89148145' 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, '89116810', '89116817', '89116818', '89116819', '89148142', '89148143', '89176248', '89148144', '89148145', '')
				 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)

Zobrazit:

náhledy |

seznam

Kat.č.	Produkt	Cena	Skladem

Kategorie neobsahuje žádnou položku