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