| 366,6 → 366,41 |
|---|
| |
| |
| |
| # noms scientifiques / noms d'auteur BDTFX |
| source bdtfx : common { |
| sql_db = tb_eflore |
| |
| sql_query = \ |
| SELECT b.num_nom, b.nom_sci AS nom_sci, b.auteur AS auteur, \ |
| "bdtfx" AS group_id, CONCAT("bdtfx-", b.num_nom) as main_id, b.num_nom \ |
| FROM bdtfx_v1_01 b \ |
| UNION ALL \ |
| SELECT a.num_nom + 500000, a.nom_sci, a.auteur, \ |
| "bdtxa" AS group_id, CONCAT("bdtxa-", a.num_nom) AS main_id, a.num_nom \ |
| FROM bdtxa_v1_00 a \ |
| UNION ALL \ |
| SELECT i.num_nom + 1000000, i.nom_sci, i.auteur, \ |
| "isfan" AS group_id, CONCAT("isfan-", i.num_nom) AS main_id, i.num_nom \ |
| FROM isfan_v2013 i |
| |
| sql_field_string = group_id |
| sql_field_string = nom_sci |
| sql_field_string = auteur |
| sql_attr_string = main_id |
| sql_attr_uint = num_nom |
| |
| sql_query_info = SELECT * FROM bdtfx_v1_01 b, bdtxa_v1_00 a, isfan_v2013 is WHERE b.num_nom=$id OR a.num_nom=$id OR is.num_nom=$id |
| } |
| |
| index i_bdtfx : i_common { |
| source = bdtfx |
| path = /var/lib/sphinx/bdtfx |
| |
| infix_fields = b.nom_sci, b.auteur |
| } |
| |
| |
| |
| # COSTE / NVJFL |
| # source costenvjfl : common { |
| # sql_db = tb_eflore |