Přihlášení
Relaxace
Chyba při dotazu "select p.*
from (
select distinct on (p.seskupeni) p.seskupeni,p.*
from (
select p.*,dph.hodnota as hodnota_dph,
v.cena_eshop as cena_order,
pt.nazev as nazev_order,
pt.nazev,
vt.nazev as v_nazev ,
pt.popis, v.kat_cislo,
v.cena_eshop,v.cena_nakupni, v.cena_maloobchodni,v.skladem
from produkty p
left join produkty_text pt on p.id=pt.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
pt.mutace=1 and vt.mutace=1
and p.viditelny = 1
and (find_in_set(p.hl_kategorie,'20') or p.id in (select produkt from produkty2kategorie where find_in_set(kategorie,'20')))
order by p.id) as p
order by seskupeni,p.id) as p
order by nazev_order
limit 30 offset -15" do databáze
ERROR: OFFSET must not be negative
ERROR: OFFSET must not be negative