Blu-ray Kolekce
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 (find_in_set(p.hl_kategorie,'1140') or p.id in (select produkt from produkty2kategorie where find_in_set(kategorie,'1140')))
) as p
) as p
order by datum_vydani desc nulls last
limit 60 offset -40" do databáze
ERROR: OFFSET must not be negative
Nastala chyba. Omlouváme se.