Subversion Repositories Applications.papyrus

Compare Revisions

Ignore whitespace Rev 2124 → Rev 2125

/trunk/papyrus/applettes/moteur_recherche/moteur_recherche_sphinx.php
187,7 → 187,7
$db = $GLOBALS['_MOTEUR_RECHERCHE_']['bd']['papyrus'];
$req = $db->query(sprintf(<<<EOF
SELECT b.num_nom AS id, CONCAT(nom_sci, ' (nn: ', b.num_nom, ', nt: ', num_taxonomique, ')') AS titre, GROUP_CONCAT(n.nom_vernaculaire) AS description
FROM tb_eflore.bdtfx_v1_02 b
FROM tb_eflore.bdtfx_v1_01 b
LEFT JOIN tb_eflore.nvjfl_v2007 n ON n.num_taxon = b.num_taxonomique
WHERE b.num_nom IN (%s)
GROUP BY n.num_taxon
/trunk/papyrus/applettes/moteur_recherche/sphinx-min.conf
346,7 → 346,7
SELECT b.num_nom, num_taxon, nom_sci, GROUP_CONCAT(nom_vernaculaire), \
"nvjfl" AS group_id, CONCAT("nvjfl-", b.num_nom) as main_id \
FROM nvjfl_v2007 n \
LEFT JOIN bdtfx_v1_02 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 \
GROUP by num_taxon
 
377,7 → 377,7
# FROM tb_eflore.coste_v2_00 c \
# LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \
# LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y' \
# LEFT JOIN bdtfx_v1_02 b ON c.flore_bdtfx_nn = b.num_nom \
# LEFT JOIN bdtfx_v1_01 b ON c.flore_bdtfx_nn = b.num_nom \
# LEFT JOIN nvjfl_v2007 n ON b.num_taxonomique = n.num_taxon \
# WHERE c.flore_bdtfx_nn != ''