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