Subversion Repositories Applications.papyrus

Rev

Rev 2113 | Rev 2115 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2113 Rev 2114
Line 193... Line 193...
193 
source coste : common {
 193 
source coste : common {
194 
	sql_query		= \
 194 
	sql_query		= \
195 
        SELECT c.num_nom AS id, CONCAT("bdtfx", ":", c.num_nom) AS group_id, CONCAT(c.nom_sci, dsc.body) AS texte, CONCAT(c.nom_sci, cle.body) AS determination, c.nom_sci AS nom_sci \
 195 
        SELECT c.num_nom AS id, CONCAT("bdtfx", ":", c.num_nom) AS group_id, CONCAT(c.nom_sci, dsc.body) AS texte, CONCAT(c.nom_sci, cle.body) AS determination, c.nom_sci AS nom_sci \
196 
        FROM tb_eflore.coste_v2_00 c \
 196 
        FROM tb_eflore.coste_v2_00 c \
197 
        LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \
 197 
        LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \
198 
        LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = dsc.tag AND dsc.latest = 'Y';
 198 
        LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y';
Line 199... Line 199...
199 
 
 199 
 
200 
	sql_field_string	= group_id
 200 
	sql_field_string	= group_id
201 
    sql_query_pre   = SET NAMES utf8
 201 
    sql_query_pre   = SET NAMES utf8