Content selection: request about mixed mode.

Hi,

it looks like this kind of request is quite popular :) I found similar ones #203798: Preferred language option and #78973: List translated nodes without duplicates, in particular, the latter asks pretty much what I am also asking.

I ported the patch from #78973: List translated nodes without duplicates to i18n-6.x-1.0, which I am attaching here.
It works for me on frontpage, but I would like to hear what do you think about it.

Waiting for comments...

Regards,
Antonio

mmh, maybe we can use UNIQUE(tnid) after ordering the nodes instead of using a subquery?

Regards,
Antonio

Well, as dereine pointed out in #434308: Filter duplicate translations, the UNIQUE way can't work because nodes without translations are all in the same translation group with tnid=0.

So, the query I am searching for should really be this one:

SELECT *
  FROM node AS n1
  WHERE (n1.promote <> 0) AND (n1.status <> 0) AND (
    tnid IS NULL OR tnid=0 OR nid=(
      SELECT nid FROM node AS n2
        WHERE n2.tnid=n1.tnid
        ORDER BY
          CASE n2.language
            WHEN @current_language THEN 1
            WHEN @default_language THEN 2
            ELSE 1000
          END
        LIMIT 1
    )
  )
  ORDER BY n1.sticky DESC, n1.created DESC;

Which I find more readable than the old one I copied from mardy78.

I attach here an updated patch, please let me know if you find it suitable for inclusion, in that case we could find a better name than "mixed_single" which I don't like too much.

Regards,
Antonio

Ok, the Active Translation module does basically what I am looking for, and I also found the solution for Views in the Select Translation module.

I am leaving the issue open and changing the target to HEAD, maybe you can add this content selection mode to D7 so an external module would not be needed anymore for a such fairly requested feature.

Thanks,
Antonio

If you use Views the Select Translation module should be ok for you. It solved the issue perfectly for me and without using an additional table in the DataBase as Active Translation does.