 |
Zboží z katalogu |
|
|
Špatný dotaz: Unknown column '20ASC' in 'order clause'
select a.id,a.cena_nakup,a.id_kategorie,a.id_sazba_dph,a.id_vyrobce,a.evidencni_cislo,a.nazev,a.novinka,a.vyprodej,a.doporucujeme,a.url_vyrobce,a.zkracene,a.popis,a.cena_mo,a.cena_mo_s_dph,a.cena_vo,a.cena_dop,a.elektroodpad,a.autorska_odmena,a.zaruka as minutaz,zar.id as id_zaruka,zar.nazev as zaruka,s.sazba,v.nazev as vyrobce,a.sklad,a.koeficient_prepoctu,mj.nazev as merna_jednotka,dos.nazev as dostupnost,dos.id as id_dostupnost,a.dostupnost_datum,DATEDIFF(CURDATE(),a.dostupnost_datum) as dostupnost_dnu,a.zobrazovat,a.pevna_koncova_cena,a.body from katalog a left join cc_dostupnost dos on dos.id = a.id_dostupnost left join kategorie kat on kat.id = a.id_kategorie left join cc_merna_jednotka mj on mj.id = a.id_merna_jednotka left join cc_sazba_dph s on s.id = a.id_sazba_dph left join vyrobce v on v.id = a.id_vyrobce left join cc_zaruka zar on zar.id = a.id_zaruka where (a.id is not null and a.vyprodej="A" and a.zobrazovat="A" and a.zobrazovat_samostatne = "A" ) ORDER BY evidencni_cislo%20ASC |
