Nabídka platí do 22. 12. 2024 nebo do vyprodání zásob.
Chyba při dotazu "select p.* from ( select p.seskupeni,p.* from ( select p.*,dph.hodnota as hodnota_dph, (select polozky2produkty.polozka from polozky2produkty left join polozky_parametru pp on polozky2produkty.polozka=pp.id where produkt=p.id and parametr=8 limit 1) as nosic_id, v.cena_eshop as cena_order, v.cena_sort as cena_sort, v.cena_doporucena as cena_doporucena, v.id as vid, pt.nazev as nazev_order, pt.nazev,ptcz.nazev as nazev_cz,pten.nazev as nazev_en, vt.nazev as v_nazev , pt.popis, v.kat_cislo, v.cena_eshop,v.cena_nakupni, v.cena_maloobchodni, (select sum(zakoupeno_aktualne) from varianty where varianty.produkt=p.id limit 1) as zakoupeno_aktualne, (select sum(skladem) from varianty where varianty.produkt=p.id limit 1) as skladem, CASE WHEN (select sum(skladem) from varianty where varianty.produkt=p.id limit 1) > 0 THEN 1 ELSE 0 END as jeskladem, (select sum(stav) from prodejny_stav where prodejny_stav.varianta=v.id and prodejny_stav.prodejna<>5100 limit 1) as sklademprodejny from produkty p left join produkty_text pt on p.id=pt.produkt left join produkty_text ptcz on p.id=ptcz.produkt left join produkty_text pten on p.id=pten.produkt left join dph on p.dph=dph.id left join varianty v on v.id=p.hl_varianta left join varianty_text vt on v.id=vt.varianta WHERE ptcz.mutace=1 and pten.mutace=2 and pt.mutace=1 and vt.mutace=1 and p.viditelny = 1 and (p.id in (619078,438375,765424,129866,357174,887770,114712,589922,764712,102767,112299,319418,759183,934900,914881,700465,301361,128807,114332,854212,301380,390513,879827,762983,869411,128189,138629,778032,868575,869410,917358,852488,793603,120001,904454,323170,774283,913968,924002,925667,704923,750840,750379,128355,924911,129477,912717,120069,765012,120071,123680,159653,939656,864413,913631,139697,903960,758767,937439,754622,756432,938625,911231,913966,760536,900108,145218,309396,750775,795178,938627,114113,912491,925322,700489,120784,546888,807168,933742,112471,765366,807946,765370,936311,160389,316877,400241,754017,912817,901558,754018,128385,907018,116542,137557,352144,765999,129505,700799,764711,910224,518280,720012,120070,933980,804475,869413,128676,786877,878428,309464,879828,129512,128375,728567,128764,393396,411883,734959,526823,753865,159421,129367,908424,619160,764844,767707,912490,888483,914880,915875,927969,121333,128284,406473,706003,865362,935703,783350,853144,751553,607466,643893,878029,899916,913965,923578,930603,932109,753070,111983,419069,796436,711824,772553,792425,129270,750821,840837,120068,366832,924231,775941,390519,914126,786879,869211,159606,306635,794686,763334,118227,357116,503045,619147,804476,903746,783357,869229,629426,837712,854209,321592,772225,900109,136723,343699,774284,763390,934747,760573,711830,116167,160304,786878,878427,753040,629371,760779,903745)) ) as p ) as p order by p.datum_vydani desc nulls last limit 20 offset -40" do databáze