|
|
|
|
|
| Nouveaux Reportages |
To see it more En voir plus
To see it less En voir moins To see it less En voir moins
|
|
|
|
|
Erreur sur Requete avec LEFT JOIN
SELECT
a.Id_NewRep,
IF(a.Mode='A','',a.Id_NewRep) as recordID,
a.NomRep,
a.DateEvenRep,
a.DateParuRep,
x.VilleRep,
f.INI_IMAGES,
a.LienImgRep,
f.INI_TRAVAIL,
a.LienPageRep,
f.INI_ACTION,
a.Id_NewOrg,
a.TxtOrg,
a.Id_NewTypeRep,
e.NomOrg,
'' as NomAct,
z.NomTypeRep,
g.NomAct as FirstAct,
a.TxtFirstAct,
a.TxtOthersAct,
a.TitreRep,
y.NomPho,
a.DirTravail,
replace(a.TitreRep,'
','') as TitreRep2,
concat(substr(a.Commentaire,1,300),'...') as Commentaire,
if (DATEDIFF(CURDATE(), a.DateParuRep) < 8,'NEW','') as NewDelai
FROM neworg e,newstyle d , newparam f, newtyperep z,newrep a , newact g, newpho y, newville x
where
a.Id_NewOrg = e.Id_NewOrg
and z.Id_NewTypeRep = a.Id_NewTypeRep
and a.Mode = f.Mode
and d.Id_NewStyle = a.Id_NewStyle
and a.Id_NewAct = g.Id_NewAct
and a.Id_NewPho = y.Id_NewPho
and a.Id_NewVille = x.Id_NewVille
and a.Id_NewFam = 9
order by DateEvenRep desc
LIMIT 0,60 [nativecode=1054 ** Unknown column 'a.Id_NewVille' in 'where clause']DB Error: no such field |
