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