- user warning: Unknown column 'node_data_field_medias_video_date.field_medias_video_date_value' in 'where clause'
query: SELECT COUNT(*) FROM (SELECT node.nid AS nid
FROM node node
INNER JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN content_type_coupure_de_presse node_data_field_presse_coup_date_parution ON node.vid = node_data_field_presse_coup_date_parution.vid
WHERE ((node.status = 1) AND (node.type in ('video')) AND (term_node.tid = 147))
AND ((DATE_FORMAT(STR_TO_DATE(node_data_field_medias_video_date.field_medias_video_date_value, '%Y-%m-%dT%T'), '%Y') <= '2007' AND DATE_FORMAT(STR_TO_DATE(node_data_field_medias_video_date.field_medias_video_date_value, '%Y-%m-%dT%T'), '%Y') >= '2007'))
) count_alias in /homez.22/aclalhfq/www/sites/all/modules/views/includes/view.inc on line 790.
- user warning: Unknown column 'node_data_field_medias_video_date.field_medias_video_date_value' in 'where clause'
query: SELECT node.nid AS nid,
node_data_field_presse_coup_date_parution.field_presse_coup_date_parution_value AS node_data_field_presse_coup_date_parution_field_presse_coup_date_parution_value
FROM node node
INNER JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN content_type_coupure_de_presse node_data_field_presse_coup_date_parution ON node.vid = node_data_field_presse_coup_date_parution.vid
WHERE ((node.status = 1) AND (node.type in ('video')) AND (term_node.tid = 147))
AND ((DATE_FORMAT(STR_TO_DATE(node_data_field_medias_video_date.field_medias_video_date_value, '%Y-%m-%dT%T'), '%Y') <= '2007' AND DATE_FORMAT(STR_TO_DATE(node_data_field_medias_video_date.field_medias_video_date_value, '%Y-%m-%dT%T'), '%Y') >= '2007'))
ORDER BY node_data_field_presse_coup_date_parution_field_presse_coup_date_parution_value ASC
LIMIT 0, 10 in /homez.22/aclalhfq/www/sites/all/modules/views/includes/view.inc on line 795.
2007