/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 |