195,7 → 195,7 |
SELECT c.num_nom AS id, CONCAT("bdtfx", ":", c.num_nom) AS group_id, CONCAT(c.nom_sci, dsc.body) AS texte, CONCAT(c.nom_sci, cle.body) AS determination, c.nom_sci AS nom_sci \ |
FROM tb_eflore.coste_v2_00 c \ |
LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \ |
LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = dsc.tag AND dsc.latest = 'Y'; |
LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y'; |
|
sql_field_string = group_id |
sql_query_pre = SET NAMES utf8 |