SELECT        TOP (100) PERCENT dbo.APT.AptID, dbo.APT.AptTypeID, dbo.APT.AptOrgID, dbo.APT.AptNumstreetID, dbo.APT.AptLocationID, dbo.APT.AptPets, dbo.APT.AptSmoking,
                         dbo.APT.AptElevator, dbo.APT.AptParking, dbo.APT.AptBalcony, dbo.APT.AptTerrace, dbo.APT.AptAircond, dbo.APT.AptWasher, dbo.APT.AptDryer,
                         dbo.APT.AptDishwasher, dbo.APT.AptCable, dbo.APT.AptAdsl, dbo.APT.AptDailyprice, dbo.APT.AptWeeklyprice, dbo.APT.AptMonthlyprice, dbo.APT.AptNbpeopleMin,
                         dbo.APT.AptNbpeoplemax, dbo.APT.AptWeb, dbo.APT.AptData, dbo.APT.AptVeryshortterm, dbo.APT.AptShortterm, dbo.APT.AptLongterm, dbo.APT.AptSpecial,
                         dbo.APT.AptMuchbath, dbo.APT.AptLuxe, dbo.APT.AptNumsubwayID, dbo.APT.AptNumsubway2ID, dbo.APT.AptFloor, dbo.APT.AptAsavoir, dbo.APT.AptSqf,
                         dbo.APT.AptNoApt, dbo.APT.AptVcr, dbo.APT.AptPrefLT, dbo.APT.AptPrefST, dbo.APT.AptEval, dbo.APT.AptZipID, dbo.APT.AptShowphoto, dbo.APT.AptNo,
                         dbo.APT.AptDateFirst, dbo.APT.AptTemp, dbo.APT.AptPosition, dbo.APT.AptAgentID, dbo.Availabilities.AvailFrom, dbo.Availabilities.AvailTo, dbo.AptRef.AptRef,
                         dbo.ACity.Acity, dbo.Alocation.Alocation, dbo.Aorg.Aorg, dbo.ZIP.Zip, dbo.AptTyp.AptTyp, dbo.Metros_Lignes.LigneNom, dbo.Metros_Lignes.LigneID,
                         dbo.Streets.Streets, dbo.AssocAptInt.TypeIntervenantID, dbo.Intervenant.COILastName, dbo.Intervenant.COIFirstName, dbo.AssocAptInt.IntervenantID,
                         dbo.Metros_Stations.StationNom, dbo.AptTx.AptTxTrPa, dbo.ExistIPSByApt(dbo.APT.AptID, 1) AS ExistWeeklyIPS, dbo.ExistIPSByApt(dbo.APT.AptID, 2)
                         AS ExistMonthlyIPS, dbo.APT.AptToRecontact, dbo.APT.AptLastMinute, dbo.AssocAptInt.SelectedInt, dbo.Agent.AgentSession, dbo.MoyenPaiement.TypePaiementID,
                         dbo.APT.AptView, dbo.APT.AptFavorite, dbo.APT.AptNew, dbo.APT.AptImportant, dbo.APT.AptStatut2, dbo.RqState.RqState, dbo.APT.AptExclusif
FROM            dbo.Metros_Stations RIGHT OUTER JOIN
                         dbo.RqState INNER JOIN
                         dbo.APT ON dbo.RqState.RqStateID = dbo.APT.AptStatut2 LEFT OUTER JOIN
                         dbo.MoyenPaiement ON dbo.APT.AptID = dbo.MoyenPaiement.PaiementAptID LEFT OUTER JOIN
                         dbo.AssocAptInt INNER JOIN
                         dbo.Intervenant ON dbo.AssocAptInt.IntervenantID = dbo.Intervenant.COIID ON dbo.APT.AptID = dbo.AssocAptInt.AptID LEFT OUTER JOIN
                         dbo.AptTx ON dbo.APT.AptID = dbo.AptTx.AptTxID ON dbo.Metros_Stations.StationID = dbo.APT.AptNumsubwayID LEFT OUTER JOIN
                         dbo.Metros_Lignes INNER JOIN
                         dbo.Metros_Appartient ON dbo.Metros_Lignes.LigneID = dbo.Metros_Appartient.MALigneID INNER JOIN
                         dbo.Metros_Stations AS Metros_Stations_1 ON dbo.Metros_Appartient.MAStationID = Metros_Stations_1.StationID ON
                         dbo.Metros_Stations.StationID = dbo.Metros_Appartient.MAStationID AND dbo.APT.AptNumsubwayID = Metros_Stations_1.StationID LEFT OUTER JOIN
                         dbo.Agent ON dbo.APT.AptAgentID = dbo.Agent.AgentID LEFT OUTER JOIN
                         dbo.Streets ON dbo.APT.AptNumstreetID = dbo.Streets.StreetsID LEFT OUTER JOIN
                         dbo.ZIP ON dbo.APT.AptZipID = dbo.ZIP.ZipID LEFT OUTER JOIN
                         dbo.AptTyp ON dbo.APT.AptTypeID = dbo.AptTyp.AptTypID LEFT OUTER JOIN
                         dbo.ACity ON dbo.APT.AptCityID = dbo.ACity.AcityId LEFT OUTER JOIN
                         dbo.Alocation ON dbo.APT.AptLocationID = dbo.Alocation.AlocationID LEFT OUTER JOIN
                         dbo.Aorg ON dbo.APT.AptOrgID = dbo.Aorg.AorgID LEFT OUTER JOIN
                         dbo.AptRef ON dbo.APT.AptID = dbo.AptRef.AptID LEFT OUTER JOIN
                         dbo.Availabilities ON dbo.APT.AptID = dbo.Availabilities.AvailAptID
WHERE        (dbo.AssocAptInt.TypeIntervenantID = 2 OR
                         dbo.AssocAptInt.TypeIntervenantID = 3 OR
                         dbo.AssocAptInt.TypeIntervenantID = 4 OR
                         dbo.AssocAptInt.TypeIntervenantID = 5 OR
                         dbo.AssocAptInt.TypeIntervenantID = 6 OR
                         dbo.AssocAptInt.TypeIntervenantID = 8) AND (dbo.AssocAptInt.SelectedInt = 1) AND (dbo.APT.AptStatut2 >= 200000)