Desio® Negozio online ufficiale per Italia | Lenti a contatto colorate | Desio Color contacts lenses Desiolens.eu
Špatný dotaz: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{variant.id_varianta}}) LIMIT 0,15' at line 1
select k.id,k.cena_nakup,k.id_kategorie,k.id_kategorie_slev,kat.nazev as kategorie_nazev,ifnull(sde.id_sazba_dph,k.id_sazba_dph) as id_sazba_dph,k.id_vyrobce,k.evidencni_cislo,k.velkosklad_cislo,k.ean,k.nazev,k.novinka,k.vyprodej,k.doporucujeme,k.hmotnost,k.url_vyrobce,k.zkracene,k.popis,k.cena_mo,k.cena_mo_s_dph,k.cena_vo,k.cena_dop,k.elektroodpad,k.autorska_odmena,k.zaruka as minutaz,zar.id as id_zaruka,zar.nazev as zaruka,zar.externi_kod as zaruka_kod,s.sazba as sazba,ifnull(sde.sazba,s.sazba) as sazba_real,v.nazev as vyrobce,k.sklad,k.koeficient_prepoctu,mj.nazev as merna_jednotka,dos.nazev as dostupnost,dos.id as id_dostupnost,k.dostupnost_datum,DATEDIFF(CURDATE(),k.dostupnost_datum) as dostupnost_dnu,k.zobrazovat,k.pevna_koncova_cena,k.body,k.model,dos.dostupnost_text,dos.kod_jyxo as dostupnost_jyxo,k.orientace,k.original,att.soubornew as picture,k.id_oblast,obl.nazev as oblast, obl.popis as oblast_popis,obl.poradi as oblast_poradi,k.orientace,ori.id as id_orientace,ori.nazev as orientace_nazev,ifnull(k.hodnoceni,0) as hodnoceni,ifnull(k.recenzi,0) as recenzi,k.preferovane,ifnull(k.uzivatelska_sada,"N") as uzivatelska_sada from katalog k left join cc_dostupnost dos on dos.id = k.id_dostupnost left join kategorie kat on kat.id = k.id_kategorie left join cc_merna_jednotka mj on mj.id = k.id_merna_jednotka left join cc_sazba_dph s on s.id = k.id_sazba_dph left join vyrobce v on v.id = k.id_vyrobce left join cc_zaruka zar on zar.id = k.id_zaruka left join prilohy att on att.id_katalog = k.id and att.sektor="HLAVNI" left join oblast obl on obl.id = k.id_oblast left join cc_orientation ori on ori.kod = k.orientace left join katalog_sazba_dph_external kse on kse.id_katalog = k.id and kse.id_stat = "" left join cc_sazba_dph_external sde on sde.id_sazba_dph = kse.id_sazba_dph_external and sde.id_stat = kse.id_stat left join cc_sazba_dph saze on saze.id = sde.id_sazba_dph where k.id in({{variant.id_varianta}}) LIMIT 0,15