Column 'BEASON' doesn't belong to any of the selected models (1), when preparing: SELECT Inscriptions.NO_INSCRIPTION, Inscriptions.AGENT_INSCRIPTEUR_1, Inscriptions.AGENT_INSCRIPTEUR_2, Inscriptions.PRIX_DEMANDE, Inscriptions.UM_PRIX_DEMANDE, Inscriptions.PRIX_LOCATION_DEMANDE, Inscriptions.UM_PRIX_LOCATION_DEMANDE, Inscriptions.IND_INTERNET, Inscriptions.MUN_CODE, Inscriptions.NO_CIVIQUE_DEBUT, Inscriptions.NO_CIVIQUE_FIN, Inscriptions.NOM_RUE_COMPLET, Inscriptions.APPARTEMENT, Inscriptions.CODE_POSTAL, Inscriptions.CATEGORIE_PROPRIETE, Inscriptions.GENRE_PROPRIETE, Inscriptions.NB_CHAMBRES, Inscriptions.NB_SALLES_BAINS, Inscriptions.CODE_STATUT, Inscriptions.IS_COLLECTION, Inscriptions.IND_TAXES_PRIX_DEMANDE, Inscriptions.IND_TAXES_PRIX_LOCATION_DEMANDE, Inscriptions.AGENT_INSCRIPTEUR_3, Inscriptions.AGENT_INSCRIPTEUR_4, Inscriptions.LATITUDE, Inscriptions.LONGITUDE, Inscriptions.DATE_INSCRIPTION, _photos.PhotoURL, _mun.description, _genre.DESCRIPTION_FRANCAISE, _genre.DESCRIPTION_ANGLAISE, _visites_libres.SEQ, IF(AGENT_INSCRIPTEUR_1 = BEASON OR AGENT_INSCRIPTEUR_2 = BEASON OR AGENT_INSCRIPTEUR_3 = BEASON OR AGENT_INSCRIPTEUR_4 = BEASON, 1, 0) AS [original_broker] FROM [Inscriptions] LEFT JOIN [Photos] AS [_photos] ON _photos.NO_INSCRIPTION = Inscriptions.NO_INSCRIPTION AND _photos.SEQ = 1 LEFT JOIN [Municipalites] AS [_mun] ON _mun.CODE = Inscriptions.MUN_CODE LEFT JOIN [Genres] AS [_genre] ON _genre.GENRE_PROPRIETE = Inscriptions.GENRE_PROPRIETE LEFT JOIN [VisitesLibres] AS [_visites_libres] ON _visites_libres.NO_INSCRIPTION = Inscriptions.NO_INSCRIPTION WHERE ((AGENT_INSCRIPTEUR_1 = "BEASON" OR AGENT_INSCRIPTEUR_2 = "BEASON" OR AGENT_INSCRIPTEUR_3 = "BEASON" OR AGENT_INSCRIPTEUR_4 = "BEASON")) AND (Inscriptions.FIN_AFFICHAGE >= 1685859539) GROUP BY Inscriptions.NO_INSCRIPTION ORDER BY original_broker DESC, DATE_INSCRIPTION DESC, Inscriptions.NO_INSCRIPTION