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 = '180175' 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 = '180170' 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 = '180173' 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 = '180100' WHERE c.id_cenik IN ('1', '3') AND c.id_mena = 'CZK' ORDER BY id_cenik

Lyžařské ponožky

Doporučená cena 499Kč