| 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 != '' |
| |