SELECT DISTINCT ON (id_cenik) c.*, k.vat_cz AS vat FROM slim.helios_ceny AS c JOIN slim.heilos_k_karty AS k ON k.id = c.id_k_karta AND k.article_number = '10185300328' WHERE c.id_cenik IN ('1', '3') AND c.id_mena = 'CZK' ORDER BY id_cenik
SELECT DISTINCT ON (id_cenik) c.*, k.vat_cz AS vat FROM slim.helios_ceny AS c JOIN slim.heilos_k_karty AS k ON k.id = c.id_k_karta AND k.article_number = '10185400T83' WHERE c.id_cenik IN ('1', '3') AND c.id_mena = 'CZK' ORDER BY id_cenik
SELECT DISTINCT ON (id_cenik) c.*, k.vat_cz AS vat FROM slim.helios_ceny AS c JOIN slim.heilos_k_karty AS k ON k.id = c.id_k_karta AND k.article_number = '10185500812' WHERE c.id_cenik IN ('1', '3') AND c.id_mena = 'CZK' ORDER BY id_cenik
SELECT DISTINCT ON (id_cenik) c.*, k.vat_cz AS vat FROM slim.helios_ceny AS c JOIN slim.heilos_k_karty AS k ON k.id = c.id_k_karta AND k.article_number = '20153200745' WHERE c.id_cenik IN ('1', '3') AND c.id_mena = 'CZK' ORDER BY id_cenik
SELECT DISTINCT ON (id_cenik) c.*, k.vat_cz AS vat FROM slim.helios_ceny AS c JOIN slim.heilos_k_karty AS k ON k.id = c.id_k_karta AND k.article_number = '20153300849' WHERE c.id_cenik IN ('1', '3') AND c.id_mena = 'CZK' ORDER BY id_cenik

Skialpinistické

Doporučená cena 18.199Kč
Doporučená cena 15.599Kč
Doporučená cena 12.999Kč
Doporučená cena 15.599Kč
Doporučená cena 12.999Kč