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.23069'
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.23065'
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.23061'
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.23057'
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.23053'
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.23045'
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.23041'
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.23037'
WHERE
c.id_cenik IN ('1', '8') AND
c.id_mena = 'PLN'
ORDER BY id_cenik