<cfif client.language EQ 2> Toutes les publications de GRAIN sur une page <cfelseif client.language EQ 3> Todas las publicaciones de GRAIN en una pagina <cfelse> All GRAIN's publications on one page </cfif>

SELECT b.pub_filename, b.pub_date, b.pub_name, b.pub_id, z.type_id, z.type_name, b.pub_lang_id FROM g_briefings b, g_types_briefings z WHERE b.pub_type_id = z.type_id AND z.type_name <> 'hidden' AND b.pub_lang_id = UNION SELECT a.pub_filename, a.pub_date, a.pub_name, a.pub_id, y.type_id, y.type_name, a.pub_lang_id FROM g_articles a, g_types_articles y WHERE a.pub_type_id = y.type_id AND y.type_name <> 'hidden' AND a.pub_lang_id = UNION SELECT i.pub_filename, i.pub_date, i.pub_name, i.pub_id, x.type_id, x.type_name, i.pub_lang_id FROM g_biodiversidad i, g_types_biodiversidad x WHERE i.pub_type_id = x.type_id AND i.pub_cat_id = 2 AND x.type_name <> 'hidden' AND i.pub_lang_id = UNION SELECT s.pub_filename, s.pub_date, s.pub_name, s.pub_id, w.type_id, w.type_name, s.pub_lang_id FROM g_seedling s, g_types_seedling w WHERE s.pub_type_id = w.type_id AND w.type_name <> 'hidden' AND s.pub_lang_id = UNION SELECT e.pub_filename, e.pub_date, e.pub_name, e.pub_id, v.type_id, v.type_name, e.pub_lang_id FROM g_semences e, g_types_semences v WHERE e.pub_type_id = v.type_id AND v.type_name <> 'hidden' AND e.pub_lang_id = ORDER BY b.pub_date desc <cfif client.language EQ 2> Toutes les publications de GRAIN sur une page <cfelseif client.language EQ 3> Todas las publicaciones de GRAIN en una pagina <cfelse> All GRAIN's publications on one page </cfif>

Toutes les publications de GRAIN sur une page Todas las publicaciones de GRAIN en una pagina All GRAIN's publications on one page

Voir les publications en: Ver las publicaciones en: View publications in: français | Español | English | toutes les langues todos los idiomas all languages

#pub_filename#
(#LSdateformat(pub_date, "dd mmmm yyyy")# - Les rapports de GRAIN) Documentos de análisis) GRAIN Briefing)

#pub_filename#
(#LSdateformat(pub_date, "dd mmmm yyyy")# - - "Against the grain") “A contrapelo") "Against the grain")

Seedling - #pub_filename#
(#LSdateformat(pub_date, "mmmm yyyy")#)

La Revista Biodiversidad - #pub_filename#
(#LSdateformat(pub_date, "mmmm yyyy")#)

#pub_filename#
(#LSdateformat(pub_date, "mmmm yyyy")# - Semences de la biodiversité)