CA breaks Views

The moment I enable Content Access module, I get the following error when trying to access my views

user warning: You have an error IN your SQL syntax; CHECK the manual that corresponds TO your MySQL server version FOR the RIGHT syntax TO USE near 'DISTINCT(node.nid), node_data_field_image.field_image_fid AS node_data_field_' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node_data_field_image.field_image_fid AS node_data_field_image_field_image_fid, node_data_field_image.field_image_list AS node_data_field_image_field_image_list, node_data_field_image.field_image_data AS node_data_field_image_field_image_data, node.type AS node_type, node.vid AS node_vid, node_data_field_image.field_manuf_value AS node_data_field_image_field_manuf_value, node_data_field_image.field_model_value AS node_data_field_image_field_model_value, node_data_field_image.field_cal_value AS node_data_field_image_field_cal_value, node.changed AS node_changed, node_data_field_image.field_prix_value AS node_data_field_image_field_prix_value, DATE_FORMAT((FROM_UNIXTIME(node.changed) + INTERVAL 7200 SECOND), '%Y%m%d%H%i') AS node_changed_minute FROM node node LEFT JOIN content_type_arme node_data_field_occ_value_0 ON node.vid = node_data_field_occ_value_0.vid AND node_data_field_occ_value_0.field_occ_value = 'new' LEFT JOIN content_type_arme node_data_field_image ON node.vid = node_data_field_image.vid WHERE (node.type IN ('arme')) AND (node_data_field_occ_value_0.field_occ_value = 'new') ORDER BY node_changed_minute DESC IN /home/i8186int/public_html/dekaise/sites/ALL/modules/views/includes/VIEW.inc ON line 735.

This is on Drupal 6.10, with Views 6.x-2.3

The moment I switch content access off, everything is back to normal again, but I kinda need both.

Thanks in advance !