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 = '010.23021'
WHERE
c.id_cenik IN ('1', '8') AND
c.id_mena = 'PLN'
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 = '010.23017'
WHERE
c.id_cenik IN ('1', '8') AND
c.id_mena = 'PLN'
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 = '010.23009'
WHERE
c.id_cenik IN ('1', '8') AND
c.id_mena = 'PLN'
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 = '010.23013'
WHERE
c.id_cenik IN ('1', '8') AND
c.id_mena = 'PLN'
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 = '010.23001'
WHERE
c.id_cenik IN ('1', '8') AND
c.id_mena = 'PLN'
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 = '010.23005'
WHERE
c.id_cenik IN ('1', '8') AND
c.id_mena = 'PLN'
ORDER BY id_cenik