Views Filter for field language column for translatable fields and language neutral situations.

i have a 2 nodes on bundle page.
node 253 is language neutral and node 618 is field entity based but tagged as en.. but whose fields have both english and spanish.

Create a view showing nodes of content type page, published and add field language filter.

Field language filter with option checked only Current language of user will only show node 2 always.
Field language filter with options checked : (current language of user and language none)

This the rough mysql pumped out by views and i had to edit for demo purposes:

SELECT node.nid AS nid,
field_data_field_live_date.field_live_date_value,
field_data_field_live_date.language,
field_data_field_thumbnail_promo_image.field_thumbnail_promo_image_fid,
field_data_field_thumbnail_promo_image.language
FROM
node node
LEFT JOIN field_data_field_thumbnail_promo_image field_data_field_thumbnail_promo_image ON node.nid = field_data_field_thumbnail_promo_image.entity_id AND (field_data_field_thumbnail_promo_image.entity_type = 'node' AND field_data_field_thumbnail_promo_image.deleted = '0')
LEFT JOIN field_data_field_live_date field_data_field_live_date ON node.nid = field_data_field_live_date.entity_id AND (field_data_field_live_date.entity_type = 'node' AND field_data_field_live_date.deleted = '0')
WHERE (( (node.status = '1') AND (node.type IN ('ppv_event_display')) AND (field_data_field_thumbnail_promo_image.field_thumbnail_promo_image_fid IS NOT NULL ) AND (field_data_field_thumbnail_promo_image.language IN ('en', 'und')) AND (field_data_field_live_date.language IN ('en', 'und'))
AND node.nid not in (633,635)
))
ORDER BY field_data_field_live_date.field_live_date_value ASC