home email
top02Home | Novinky | Akční nabídka | O firmě | Obchodní podmínky | Kontaktytop04
top05
leva Špatný dotaz: Column 'id' in order clause is ambiguous
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.hmotnost,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_kategorie = "27" and a.zobrazovat="A" and a.zobrazovat_samostatne = "A" ) or exists (select * from katalog_kategorie kk join katalog 1k on 1k.id = kk.id_katalog where kk.id_kategorie = "27" and kk.id_katalog = a.id and 1k.zobrazovat="A" and 1k.zobrazovat_samostatne="A" ) ORDER BY id%20DESC