Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT fc.COMMUNEINSEE AS CODE_INSEE,t.id AS IDTEXTE,oct.IDOC AS IDOC,t.idfichier AS IDFICHIER,f.nom AS NOMFICHIER,etp.TYPEPLAN AS TYPEPLAN,enn.nomniveau AS NOMNIVEAU,CASE WHEN (enn.NOMNIVEAU LIKE '%BP' )THEN 'BP' WHEN (enn.NOMNIVEAU LIKE '%MPB' )THEN 'MPB' WHEN (enn.NOMNIVEAU LIKE '%MPC' ) THEN 'MPC' WHEN (enn.NOMNIVEAU LIKE '%PRC%') THEN 'PRC' WHEN (enn.NOMNIVEAU LIKE '%TLC%') THEN 'TLC' WHEN (enn.NOMNIVEAU LIKE '%EP%') THEN 'EP' WHEN (enn.NOMNIVEAU LIKE '%EP%') THEN 'VDC' WHEN (enn.NOMNIVEAU LIKE '%EP%') THEN 'BT' WHEN (enn.NOMNIVEAU LIKE '%Brt%') THEN 'Branchement' ELSE NULL END AS THEME, -- "COULEUR","FONT","JUSTIFICATION","ITALIQUE","ORIENTATION","TEXTE","VALEUR"t.font as FONT,t.ITALIQUE as ITALIQUE,t.texte as TEXTE,t.GEOM as GEOM from TEXTE tjoin fichier f on f.ID = t.IDFICHIERjoin fichier_commune fc on fc.IDFICHIER = f.idjoin ENUM_TYPE_PLAN etp on etp.id = f.IDPLANTYPEjoin ENUM_NOM_NIVEAU enn on enn.id = t.IDNOMNIVEAUjoin ENUM_USER_STYLE eus on eus.ID = t.IDUSERSTYLEleft outer join oc_texte oct on oct.idtexte = t.idwhere 1=1and fc.COMMUNEINSEE='88196'and ((font <> 23 and italique = 1) or (font =23 and italique =0 ))and t.idnomniveau in ('27', – Cote+PtConsAbanGaz'28', – Cote+PtConsMPB'29', – Cote+PtConsProt'30', – Cote+PtConstBP'31', – Cote+PtConstBrtGaz'32', – Cote+PtConstMPC'33', – Cote+PtConstPRC'34', – Cote+PtConstTLCGaz'35', – CotesRéseauBP'281', – CotesRéseauBT'36', – CotesRéseauEP'37', -- CotesRéseauMPB'38', – CotesRéseauMPC'39', – CotesRéseauPRC'40', – CotesRéseauTLC'222', – CotesRéseauTLR'241' – CotesRéseauVDC)and oct.IDOC is not null;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement