Vážná hudba se slevou až 47%
Vážná hudba se slevou až 47%
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 (159434,619078,128821,438375,129866,159442,629208,357174,486723,755410,796436,319418,511215,772553,765368,934900,750821,840837,700465,116166,390519,128807,114332,853129,854212,137129,869211,301380,390513,728557,793437,838619,306635,112233,138629,429408,619147,792424,120001,904454,925232,783357,869229,128764,393396,599463,629426,411883,734959,774283,753865,869880,117333,511250,750840,755417,131187,756425,128355,720001,619160,764844,137703,751553,760573,350870,607466,774286,913965,930603,116167,786878,878427,753040,758767,629371,756432,913966,900108,129108,926670,145218,112472,795178,799478,807168,112471,129364,761810,419088,160389,160622,316877,847351,901558,159708,767283,854211,137557,930601,720012,589917,711839,803395,128331,804475,869413,115349,786877,878428,879828))
) as p
) as p
order by p.datum_vydani desc nulls last
limit 20 offset -40" do databáze
ERROR: OFFSET must not be negative
Nastala chyba. Omlouváme se.