vsichni me ignoruji. fake zmrdi

fiona apple

neucil jsem se na zkousky

v pici zivot

WITH
et AS (
SELECT yfj.jid, COUNT(DISTINCT yfj.year) AS year_count
FROM z_year_field_journal yfj
JOIN z_field_ford ff ON yfj.fid = ff.fid
JOIN z_field_of_science fos ON ff.sid = fos.sid
WHERE fos.name = 'Engineering and Technology'
GROUP BY yfj.jid
),
ns AS (
SELECT yfj.jid, COUNT(DISTINCT yfj.year) AS year_count
FROM z_year_field_journal yfj
JOIN z_field_ford ff ON yfj.fid = ff.fid
JOIN z_field_of_science fos ON ff.sid = fos.sid
WHERE fos.name = 'Natural Sciences'
GROUP BY yfj.jid
)
SELECT j.name
FROM et
JOIN z_journal j ON j.jid = et.jid
WHERE EXISTS(
SELECT *
FROM ns
WHERE et.jid = ns.jid AND et.year_count != ns.year_count
)

fakt ale