Hi,

>L INDEX (PK_LANGUAGE),
>JOIN (
>VYD NATURAL,

I'd say VYD sould not use natural scan. Can you change the following:

JOIN table4 vyd ON (vyv.table4_id = vyd.table4_id)

TO

LEFT JOIN table4 vyd ON (vyv.table4_id = vyd.table4_id)

and see if it works for you...


Regards,
Anderson Farias