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 |