ссср литва SELECT id_film rus name count as cnt concat FROM content co

/* ссср + литва */ 
SELECT id_film,rus,name,count(*) as cnt,concat
FROM content co 
INNER JOIN country_relation USING(id_content)
WHERE id_country IN (13,123)
group by id_film having cnt=2


/* ссср + азербайджан */ 
SELECT id_film,rus,name,count(*) as cnt
FROM content co 
INNER JOIN country_relation USING(id_content)
WHERE id_country IN (13,136)
group by id_film having cnt=2


/* ссср + латвия */ 
SELECT id_film,rus,name,count(*) as cnt
FROM content co 
INNER JOIN country_relation USING(id_content)
WHERE id_country IN (13,54)
group by id_film having cnt=2


/* ссср + грузия */ 
SELECT id_film,rus,name,count(*) as cnt
FROM content co 
INNER JOIN country_relation USING(id_content)
WHERE id_country IN (13,61)
group by id_film having cnt=2

/* ссср + армения */ 
SELECT id_film,rus,name,count(*) as cnt
FROM content co 
INNER JOIN country_relation USING(id_content)
WHERE id_country IN (13,89)
group by id_film having cnt=2




/* ссср + беларусь */ 
SELECT id_film,rus,name,count(*) as cnt
FROM content co 
INNER JOIN country_relation USING(id_content)
WHERE id_country IN (13,69)
group by id_film having cnt=2




/* ссср + украина */ 
SELECT id_film,rus,name,count(*) as cnt
FROM content co 
INNER JOIN country_relation USING(id_content)
WHERE id_country IN (13,62)
group by id_film having cnt=2