Ambientní lampy MOODOO
SELECT DISTINCT p.id AS pid,url,nazev,autor,popis,cena,nakupni_cena,cmss_sleva,img,skladem,stara_cena,oblibenost,visible,sp.poradi AS sp_poradi FROM produkty AS p LEFT JOIN stranky_produkty AS sp ON p.id=sp.produkt WHERE p.jazyk='cz' AND sp.stranka=14 AND p.visible=1 ORDER BY oblibenost DESC