| 200,7 → 200,7 |
|---|
| // joins: |
| $other_join = self::sqlAddJoins($params, $champs_valides_non_formattes); |
| $requete_tpl = "SELECT SQL_CALC_FOUND_ROWS %s ". |
| "FROM tb_eflore.coste_v2_00 c ". |
| "FROM 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' ". |
| " %s ". |
| 347,7 → 347,7 |
|---|
| // ou contraintes générées par sqlAddConstraint() |
| if(array_key_exists('masque.famille', $params) || |
| array_key_exists('famille', $champs)) { |
| $j .= 'LEFT JOIN tb_eflore.bdtfx_v2_00 b ON c.flore_bdtfx_nn = b.num_nom'; |
| $j .= 'LEFT JOIN bdtfx_v2_00 b ON c.flore_bdtfx_nn = b.num_nom'; |
| } |
| |
| return $j; |