SQL ERROR Statim/Bien//Lot/Affiche=1
SELECT m.Id,m.userCreate,m.tmsCreate,m.tmsEdit,m.userEdit,m.uid,m.gid,m.umod,m.gmod,m.omod,m.`Titre` as `Titre`,m.`Ville` as `Ville`,m.`CoupCoeur` as `CoupCoeur`,m.`Nota` as `Nota`,m.`Divers` as `Divers`,m.`Constructeur` as `Constructeur`,m.`Nature` as `Nature`,m.`Statut` as `Statut`,m.`TitleMeta` as `TitleMeta`,m.`DescriptionMeta` as `DescriptionMeta`,m.`KeywordsMeta` as `KeywordsMeta`,m.`Url` as `Url`,m.`Template` as `Template` FROM `st-Statim-Lot` as `j1p`,`st-Statim-Bien` as `m` WHERE 1 AND ((((j1p.Affiche=1)))) AND (((j1p.BienId=m.Id))) AND (((m.omod>=3) OR ((m.umod>=3) AND (m.uid=1)) OR ((m.gmod>=3) AND (m.gid=1)))) ORDER BY m.uid, CAST(m.NumeroLot as unsigned) ASC LIMIT 0,1000
Unknown column 'm.NumeroLot' in 'order clause'
------------------------------- Statim Promoteur immobilier achat vente de terrains à batir immobilier neuf lotisseur - montpellier nimes carcassonne
