Adding relationship in views
You need to add a Entity Translation relationship (with 'Require this relationship' checked).
Stop my site to run as query uses no index:
Using index condition; Using where; Using filesort
We have near about 50,000 nodes on site. Any way to optimise this?
else tutorial is very nice