SELECT * FROM g_themes WHERE theme_id = 2 SELECT r.pub_type_id, r.pub_id, r.pub_date, r.pub_url_trans_en, r.pub_url_trans_fr, r.pub_url_trans_es, r.pub_filename, r.pub_url, r.pub_text, r.pub_author, r.pub_date, r.pub_summary, t.type_id, t.type_name, t.type_date, r.pub_pdf, r.pub_pdf2, r.pub_pdf_size, r.pub_pdf2_size FROM g_research r, g_types_research t WHERE r.pub_type_id = 1 AND t.type_id = r.pub_type_id WHERE r.pub_type_id = 5 AND t.type_id = r.pub_type_id WHERE r.pub_type_id = 6 AND t.type_id = r.pub_type_id ORDER BY pub_date desc

#getres.type_name#

GM contamination

SELECT r.pub_type_id, r.pub_id, r.pub_date, r.pub_url_trans_en, r.pub_url_trans_fr, r.pub_url_trans_es, r.pub_filename, r.pub_url, r.pub_text, r.pub_author, r.pub_date, r.pub_summary, t.type_id, t.type_name, t.type_date, r.pub_pdf, r.pub_pdf2, r.pub_pdf_size, r.pub_pdf2_size, r.pub_image FROM g_research r, g_types_research t WHERE r.pub_type_id = 8 AND t.type_id = r.pub_type_id ORDER BY pub_date desc picture

GRAIN analyses and reports

SELECT r.pub_type_id, r.pub_id, r.pub_date, r.pub_url_trans_en, r.pub_url_trans_fr, r.pub_url_trans_es, r.pub_filename, r.pub_url, r.pub_text, r.pub_author, r.pub_date, r.pub_summary, t.type_id, t.type_name, t.type_date, r.pub_pdf, r.pub_pdf2, r.pub_pdf_size, r.pub_pdf2_size FROM g_research r, g_types_research t WHERE r.pub_type_id = 11 AND t.type_id = r.pub_type_id ORDER BY pub_date desc