Subversion Repositories Applications.papyrus

Rev

Rev 2123 | Rev 2128 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2123 Rev 2125
Line 344... Line 344...
344 
    # note: 66 taxons nvjfl n'ont pas de numéro nomenclatural
 344 
    # note: 66 taxons nvjfl n'ont pas de numéro nomenclatural
345 
	sql_query		= \
 345 
	sql_query		= \
346 
        SELECT b.num_nom, num_taxon, nom_sci, GROUP_CONCAT(nom_vernaculaire), \
 346 
        SELECT b.num_nom, num_taxon, nom_sci, GROUP_CONCAT(nom_vernaculaire), \
347 
        "nvjfl" AS group_id, CONCAT("nvjfl-", b.num_nom) as main_id	\
 347 
        "nvjfl" AS group_id, CONCAT("nvjfl-", b.num_nom) as main_id	\
348 
        FROM nvjfl_v2007 n \
 348 
        FROM nvjfl_v2007 n \
349 
        LEFT JOIN bdtfx_v1_02 b ON n.num_taxon = b.num_taxonomique \
 349 
        LEFT JOIN bdtfx_v1_01 b ON n.num_taxon = b.num_taxonomique \
350 
        WHERE b.num_nom IS NOT NULL \
 350 
        WHERE b.num_nom IS NOT NULL \
351 
        GROUP by num_taxon
 351 
        GROUP by num_taxon
Line 352... Line 352...
352 
 
 352 
 
353 
	sql_field_string	= group_id
 353 
	sql_field_string	= group_id
Line 375... Line 375...
375 
#         GROUP_CONCAT(n.nom_vernaculaire) AS nvjfl, n.num_taxon AS num_taxonomique, \
 375 
#         GROUP_CONCAT(n.nom_vernaculaire) AS nvjfl, n.num_taxon AS num_taxonomique, \
376 
#         "costenvjfl" AS group_id, CONCAT("costenvjfl-", c.flore_bdtfx_nn) as main_id	\
 376 
#         "costenvjfl" AS group_id, CONCAT("costenvjfl-", c.flore_bdtfx_nn) as main_id	\
377 
#         FROM tb_eflore.coste_v2_00 c \
 377 
#         FROM tb_eflore.coste_v2_00 c \
378 
#         LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \
 378 
#         LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \
379 
#         LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y' \
 379 
#         LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y' \
380 
#         LEFT JOIN bdtfx_v1_02 b ON c.flore_bdtfx_nn = b.num_nom \
 380 
#         LEFT JOIN bdtfx_v1_01 b ON c.flore_bdtfx_nn = b.num_nom \
381 
#         LEFT JOIN nvjfl_v2007 n ON b.num_taxonomique = n.num_taxon \
 381 
#         LEFT JOIN nvjfl_v2007 n ON b.num_taxonomique = n.num_taxon \
382 
#         WHERE c.flore_bdtfx_nn != ''
 382 
#         WHERE c.flore_bdtfx_nn != ''
Line 383... Line 383...
383 
 
 383 
 
384 
# 	sql_field_string	= group_id
 384 
# 	sql_field_string	= group_id