/* ссср + литва */ 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