akce na CD a LP, slevy až 75%
Nabídka platí od 11. 12. 2023 0:01 do 10. 1. 2024 23:59 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 (936002,914266,903423,846712,915738,933286,929468,931463,924131,909096,932315,905438,904153,913767,915269,932047,789855,935734,935111,916298,942567,599805,804430,901964,938077,890201,938076,937968,890727,930952,904059,937082,939464,119985,909420,913768,927637,936254,943633,917380,927638,789030,911585,935091,750734,942764,901477,932958,934975,939617,940557,135552,941543,913040,905439,914742,931380,890157,890158,913020,939618,939463,936004,947420,934222,937977,924133,937978,890728,944938,930347,902109,932577,936003,942568,931379,941178,890159,910718,910720,931348,932578,934974,901480,924135,497501,913770,940812,936368,903968,936083,903969,932352,940602,910719,932739,938075,926866,912242,931461,931815,940158,937810,918104,914779,942927,915270,912903,912799,783474,924856,937970,939777,915179,930230,910717,934983,912133,912240,913042,903425,783640,889927,942569,939342,910716,934403,905612,914265,901478,906779,882323,913069,941374,905436,789029,869581,931466,882143,924130,941497,938963,944779,937967,939614,931465,935735,942359,942773,839936,912874,922956,914740,924134,915178,903117,914813,918132,769875,932960,941215,793884,931812,937958,902003,905434,932139,936369,934364,758004,905435,937575,942058,911277,924132,932740,907487,797000,914780,941213,902102,925718,911612,913278,795082,930903,797001,935078,944937,910721,793986,934370,793067,900890,939630,923585,902104,907982,926868,870391,937305,934223,926546,882326,926543,901479,935544,897135,924853,934398,941077,927635,934363,937976,941177,942566,924136,801480,905440,914757,914776,930572,903424,804083,914751,901373,933284,882405,931459,931340,924137,906777,931341,941542,882654,941181,938078,792969,940598,924163,599946,874663,902106,902108,903115,924106,942063,869198,912800,937971,914741,930231,941182,937809,905437,910336,942919,879549,932933,938705,938437,882324,931353,930417,942057,936001,936411,936084,914264,933285,933281,943443,940552,938438,788364,935736,915737,765993,941498,904301,937304,938442,750735,944927))
) as p
) as p
order by p.datum_vydani desc nulls last
limit 20 offset -20" do databáze
ERROR: OFFSET must not be negative
Nastala chyba. Omlouváme se.