
	select id AS the_project
	FROM resource where
	id NOT IN (9300, 9215, 9339) AND
	(
		(
			myLanguage_source1 is not null and myLanguage_source1 <> ''
			and (myLanguage_target1 is null or myLanguage_target1 = '')
		)
		OR
		(
			myLanguage_source2 is not null and myLanguage_source2 <> ''
			and (myLanguage_target2 is null or myLanguage_target2 = '')
		)
		OR
		(
			myLanguage_source3 is not null and myLanguage_source3 <> ''
			and (myLanguage_target3 is null or myLanguage_target3 = '')
		)
		OR
		(
			myLanguage_source4 is not null and myLanguage_source4 <> ''
			and (myLanguage_target4 is null or myLanguage_target4 = '')
		)
		OR
		(
			myLanguage_source5 is not null and myLanguage_source5 <> ''
			and (myLanguage_target5 is null or myLanguage_target5 = '')
		)
		OR
		(
			myLanguage_source6 is not null and myLanguage_source6 <> ''
			and (myLanguage_target6 is null or myLanguage_target6 = '')
		)
		OR

		(
			myLanguage_target1 is not null and myLanguage_target1 <> ''
			and (myLanguage_source1 is null or myLanguage_source1 = '')
		)
		OR
		(
			myLanguage_target2 is not null and myLanguage_target2 <> ''
			and (myLanguage_source2 is null or myLanguage_source2 = '')
		)
		OR
		(
			myLanguage_target3 is not null and myLanguage_target3 <> ''
			and (myLanguage_source3 is null or myLanguage_source3 = '')
		)
		OR
		(
			myLanguage_target4 is not null and myLanguage_target4 <> ''
			and (myLanguage_source4 is null or myLanguage_source4 = '')
		)
		OR
		(
			myLanguage_target5 is not null and myLanguage_target5 <> ''
			and (myLanguage_source5 is null or myLanguage_source5 = '')
		)
		OR
		(
			myLanguage_target6 is not null and myLanguage_target6 <> ''
			and (myLanguage_source6 is null or myLanguage_source6 = '')
		)
	)
