SELECT p.*, v.nazev AS vyrobce_nazev, v.alias AS vyrobce_alias, v.logo AS vyrobce_logo, v.www AS vyrobce_www,
p.cena_a+0 AS cena,
p.cena_d+0 AS cena_doporucena,
d.titulek AS dostupnost_text, d.titulek_sk AS dostupnost_text_sk
FROM eshop_produkty AS p
LEFT JOIN eshop_vyrobci AS v ON p.vyrobce_id=v.id
LEFT JOIN eshop_produkty_dostupnost AS d ON p.dostupnost=d.dni
WHERE p.web_id='0' AND (p.zobrazovat = 1 OR p.vyrazeny = 1) AND p.alias='1540202025-strap-securing-pin-w-ring-02-thule-40202025'