Il n'y a actuellement aucune contribution dans cette catégorie.

SELECT node.nid nid, term_data.name term, node.created created FROM {node} node LEFT JOIN {term_node} term_node ON node.vid = term_node.vid LEFT JOIN {term_data} term_data ON term_node.tid = term_data.tid WHERE node.status <> 0 AND term_data.name <> 'Page' AND node.type = 'event' AND term_data.name = 'Médias' ORDER BY created DESC

Array ( [0] => event [1] => category [2] => Médias )