user warning: Unknown column 'node_data_field_depart.field_depart_value' in 'where clause' query: execute /* Anonyme : execute */ SELECT DISTINCT(users.uid) AS uid, users.picture AS users_picture, users.name AS users_name, users.mail AS users_mail, node_users__node_data_field_depart.field_activit_value AS node_users__node_data_field_depart_field_activit_value, node_users.nid AS node_users_nid, node_users.language AS node_users_language, node_users.type AS node_users_type, node_users.vid AS node_users_vid, node_users__node_data_field_depart.field_nom_value AS node_users__node_data_field_depart_field_nom_value, node_users__node_data_field_depart.field_pseudo_value AS node_users__node_data_field_depart_field_pseudo_value FROM users users LEFT JOIN node node_users ON users.uid = node_users.uid AND node_users.type = 'profile' LEFT JOIN content_type_profile node_users__node_data_field_depart ON node_users.vid = node_users__node_data_field_depart.vid WHERE DATE_FORMAT(STR_TO_DATE(node_data_field_depart.field_depart_value, '%Y-%m-%dT%T'), '%Y-%m-%d') <= '2012-02-24' GROUP BY uid ORDER BY COALESCE(node_users__node_data_field_depart_field_pseudo_value, node_users__node_data_field_depart_field_nom_value, users_name) ASC in /homez.16/lamalter/www/malterie/sites/all/modules/views/includes/view.inc on line 775.