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 'AND P.type IN ( 'channel', 'people', 'tvshow', 'serie' )
GROUP BY P.nid
' at line 13
query:
SELECT
P.nid,
P.title as node_title,
AVG(field_critique_note_value) AS note_moy,
I.field_illustr_fid,
count(*) as nb_notes
FROM node C
LEFT JOIN content_type_critique CV ON C.vid = CV.vid
LEFT JOIN content_field_product CP ON C.nid = CP.nid
LEFT JOIN node P ON CP.field_product_nid = P.nid
LEFT JOIN content_field_illustr I ON P.vid = I.vid
WHERE C.type = 'critique' AND C.created > AND P.type IN ( 'channel', 'people', 'tvshow', 'serie' )
GROUP BY P.nid
ORDER BY note_moy ASC LIMIT 0, 5 in /home/parlonstv/www.parlonstv.com/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1084.
warning: constant() [function.constant]: Couldn't find constant ISHOME in /home/parlonstv/www.parlonstv.com/sites/all/themes/parlonstv-theme/header.php on line 21.