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