Subversion Repositories Applications.papyrus

source nvjfl : common {

source nvjfl : common {

	sql_db			= tb_eflore

	sql_db			= tb_eflore

    # note: 66 taxons nvjfl n'ont pas de numéro nomenclatural

    # note: 66 taxons nvjfl n'ont pas de numéro nomenclatural

        SELECT b.num_nom, num_taxon, nom_sci, GROUP_CONCAT(nom_vernaculaire), \

        SELECT b.num_nom, num_taxon, nom_sci AS titre, GROUP_CONCAT(DISTINCT nom_vernaculaire) AS texte, \

        "nvjfl" AS group_id, CONCAT("nvjfl-", b.num_nom) as main_id	\

        "nvjfl" AS group_id, CONCAT("nvjfl-", b.num_nom) as main_id	\

        FROM nvjfl_v2007 n \

        FROM nvjfl_v2007 n \

        LEFT JOIN bdtfx_v1_01 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 \

        WHERE b.num_nom IS NOT NULL \

        GROUP by num_taxon

	sql_field_string	= texte

	sql_field_string	= group_id

	sql_field_string	= group_id

	sql_attr_string		= main_id

	sql_attr_string		= main_id