Nabídka platí 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 (914590,931311,952773,931347,932750,933262,952195,913048,933291,947593,942341,915675,932348,945408,946617,939117,926860,950468,944925,924391,932889,924124,934986,939185,938092,924981,953169,939380,923997,924787,937954,931055,925730,943420,935090,929506,934239,930267,949472,936193,945412,934991,924182,926805,938380,913853,928660,950355,914572,950464,907788,929486,911827,951053,951910,924522,953030,940438,944929,879694,933863,915455,944563,855428,931418,944312,952236,914498,750390,937953,943775,955778,930702,946833,932049,904195,910525,944066,939146,791996,940927,792827,906379,911261,841438,914916,953011,927142,940432,945625,931815,930087,932168,883315,931040,932885,946263,938379,938378,946422,928165,951878,925729,946231,903284,914229,940786,868856,946162,942369,925955,928231,939539,913787,938376,951260,942699,913794,932837,945727,918412,927110,952017,952139,935895,942773,938093,950838,939155,933846,945951,914351,945281,912576,924953,946080,910996,673524,907480,924502,928412,934486,951248,952677,938910,948736,939093,945231,947596,952016,940926,854351,927533,853554,937484,940331,942749,945402,950467,953047,924393,925159,931488,938788,949457,952674,915986,924221,939557,944924,944042,947201,924650,932829,935944,914048,897260,941376,935888,900872,943332,951860,790961,940800,913083,925021,937035,940790,923903,940520,927603,930409,925413,951042,933337,930630,949723,929223,931282,933323,938953,923907,930643,943954,930092,938094,948941,951589,952142,775972,951766,800128,913208,932046,924640,941539,874863,943239,949453,906486,935578,940473,940435,914348,931275,924094,869519,918404,934699,890522,909632,924739,931310,932493,952121,952243,938390,941157,944960,938789,951063,924106,949466,913557,933166,945438,947185,924281,947152,797230,924945,950616,940865,939469,938280,924782,933902,927166,945439,914153,950375,906676,923559,942166,951402,913565,944015,908191,914225,928232,931346,933202,933590,853655,913862,914811,870114,943443,939620,914231,930089,947210,349809,802913,946104,935736,922993,927144,940556,915618,918441,943130,913645,903529,924176,923908,882383,937371,951584,938389,946459,925536,932732,917818,930280,913767,924742,951545,950086,950353,926055,931345,945942,928112,949647,951399,929492,928667,940884,787320,938377,938838,951583,923998,935936,937281,948606,931283,943441,927638,947221,939558,938444,946559,949042,944787,949806,952593,935498,942923,917260,918231,927565,936194,930086,941166,944661,918113,947348,924122,946792,915404,924724,933876,890976,939315,753482,844031,951343,910699,939126,932352,942001,952772,914429,909059,926466,928595,935176,936374,938443,943233,944906,938353,945466,914948,907207,924856,930269,931140,952160,936128,946105,934983,951714,932234,928602,953123,936651,938346,912715,934995,939872,933515,947305,923762,940593,932733,927143,923858,937097,946102,942976,940467,926389,913157,931199,941393,945968,913675,914596,916577,932576,918426,937565,923966,933857,851871,915212,883596,929576,924299,933853,953121,940873,942417,953120,932365,951394,911285,927811,903608,938058,863998,932203,950284,910960,934702,932364,945966,944712,947594,937969,938888,915384,932173,929507,949981,932266,851846,945626,929353,939621,934415,950006,755804,913863,939260,929578,950563)) ) as p ) as p order by p.datum_vydani desc nulls last limit 60 offset -20" do databáze