Hi,

I have a multilingual site (English/Arabic). It contains a block, called "Featured Items". This block depends on the rating field to sort items and get the top 5 items.

The issue is rating node (e.g. node1) in Arabic and English will affect in node1.tnid not in node1.nid, but using views to create this block will generate a SQL query and Join that depends on nid not on tnid that return wrong result.

NB, I have already enabled all patches regarding voting and fivestars, and created that view referencing this video tutorial http://www.lullabot.com/node/425/play

and rating contents in any language affects on the other one, but sorting them is not matched in both languages, because it depends on nid which is for English one only.

Many thanks in advance.