346,7 → 346,7 |
SELECT b.num_nom, num_taxon, nom_sci, GROUP_CONCAT(nom_vernaculaire), \ |
"nvjfl" AS group_id, CONCAT("nvjfl-", b.num_nom) as main_id \ |
FROM nvjfl_v2007 n \ |
LEFT JOIN bdtfx_v1_02 b ON n.num_taxon = b.num_taxonomique \ |
LEFT JOIN bdtfx_v1_01 b ON n.num_taxon = b.num_taxonomique \ |
WHERE b.num_nom IS NOT NULL \ |
GROUP by num_taxon |
|
377,7 → 377,7 |
# 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 = cle.tag AND cle.latest = 'Y' \ |
# LEFT JOIN bdtfx_v1_02 b ON c.flore_bdtfx_nn = b.num_nom \ |
# LEFT JOIN bdtfx_v1_01 b ON c.flore_bdtfx_nn = b.num_nom \ |
# LEFT JOIN nvjfl_v2007 n ON b.num_taxonomique = n.num_taxon \ |
# WHERE c.flore_bdtfx_nn != '' |
|