| 375,16 → 375,19 |
|---|
| |
| 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 \ |
| "bdtfx" AS group_id, CONCAT("bdtfx-", b.num_nom) as main_id, b.num_nom, \ |
| CONCAT(bret.nom_sci, ' ', bret.auteur) AS nom_ret \ |
| FROM bdtfx_v1_01 b LEFT JOIN bdtfx_v1_01 bret ON b.num_nom_retenu = bret.num_nom \ |
| 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 \ |
| "bdtxa" AS group_id, CONCAT("bdtxa-", a.num_nom) AS main_id, a.num_nom, \ |
| CONCAT(aret.nom_sci, ' ', aret.auteur) AS nom_ret \ |
| FROM bdtxa_v1_00 a LEFT JOIN bdtxa_v1_00 aret ON a.num_nom_retenu = aret.num_nom \ |
| 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 |
| "isfan" AS group_id, CONCAT("isfan-", i.num_nom) AS main_id, i.num_nom, \ |
| CONCAT(iret.nom_sci, ' ', iret.auteur) AS nom_ret \ |
| FROM isfan_v2013 i LEFT JOIN isfan_v2013 iret ON i.num_nom_retenu = iret.num_nom |
| |
| sql_field_string = group_id |
| sql_field_string = nom_sci |
| 391,6 → 394,7 |
|---|
| sql_field_string = auteur |
| sql_attr_string = main_id |
| sql_attr_uint = num_nom |
| sql_attr_string = nom_ret |
| |
| 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 |
| } |
| 410,7 → 414,52 |
|---|
| } |
| |
| |
| # noms scientifiques / noms d'auteur BDTFX2 |
| source bdtfx2 : common { |
| sql_db = tb_eflore |
| |
| sql_query = \ |
| SELECT b.num_nom, b.nom_sci AS nom_sci, b.auteur AS auteur, \ |
| "bdtfx2" AS group_id, CONCAT("bdtfx2-", b.num_nom) as main_id, b.num_nom, \ |
| CONCAT(bret.nom_sci, ' ', bret.auteur) AS nom_ret \ |
| FROM bdtfx_v2_00 b LEFT JOIN bdtfx_v2_00 bret ON b.num_nom_retenu = bret.num_nom \ |
| 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, \ |
| CONCAT(aret.nom_sci, ' ', aret.auteur) AS nom_ret \ |
| FROM bdtxa_v1_00 a LEFT JOIN bdtxa_v1_00 aret ON a.num_nom_retenu = aret.num_nom \ |
| 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, \ |
| CONCAT(iret.nom_sci, ' ', iret.auteur) AS nom_ret \ |
| FROM isfan_v2013 i LEFT JOIN isfan_v2013 iret ON i.num_nom_retenu = iret.num_nom |
| |
| 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_attr_string = nom_ret |
| |
| sql_query_info = SELECT * FROM bdtfx_v2_00 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_bdtfx2 : i_common { |
| source = bdtfx2 |
| path = /var/lib/sphinx/bdtfx2 |
| |
| stopwords = |
| morphology = |
| infix_fields = b.nom_sci, b.auteur |
| enable_star = 0 |
| min_word_len = 1 |
| min_prefix_len = 0 |
| min_infix_len = 3 |
| |
| } |
| |
| |
| |
| # COSTE / NVJFL |
| # source costenvjfl : common { |
| # sql_db = tb_eflore |