Array
(
    [0] => Array
        (
            [0] => 00000
            [1] => 
            [2] => 
            [3] => SELECT 
				IDAnnonceVehicule,
				IDListePhotos,
				ReferenceAnnonce,
				TitreAnnonce,
				NomModele AS Modele,
				Cylindree,
				NomMarque AS Marque,
				Marques.Logo AS MarqueLogo,
				Categorie,
				Location,
				NeufOuOccasionOuAccidenteOuDestocke,
				NombrefoisClique,
				DateMiseEnCirculation,
				DateCreationAnnonce,
				DateMiseAJourAnnonce,
				DateDebutAnnonceVehicule,
				DateFinAnnonceVehicule,
				DemandeEssai,
				Garantie,
				FinGarantie,
				Kilometrage,
				KilometrageOuHeure,
				TypeMotorisation,
				PrixVente,
				AncienPrix,
				AnnonceVehicule.Puissance,
				CouleurVehicule,
				Commentaire,
				AnnonceVehicule.Chassis,
				Retrocession,
				AnnonceVehicule.Motorisation,
				AnneeModele,
				PiaggoPrivilege,
				Approved,
				Collection,
				PremiereMain,
				DepotVente,
				FinSerie,
				ComformeReglementation,
				Homologue,
				LargeurChenille,
				LongueurChenille,
				PuissanceSelect,
				Caracteristiques,
				FinancementDuree,
				FinancementInterets,
				FinancenementApport,
				FinancementTotal,
				FinancementMontant,
				FinancementCGV,
				Token,
				PartagesVN,
				PartagesVA,
				PartagesVO,
				PartagesVD,
				PartagesVNActive,
				PartagesVAActive,
				PartagesVOActive,
				PartagesVDActive
				 FROM 
			AnnonceVehicule
			LEFT JOIN Marques ON (Marques.IDMarque = AnnonceVehicule.IDMarque)
			LEFT JOIN ModeleMarque ON (ModeleMarque.IDModeleMarque = AnnonceVehicule.IDModeleMarque)
			LEFT JOIN Categorie ON (Categorie.IDCategorie = AnnonceVehicule.IDCategorie)
			LEFT JOIN Cylindree ON (Cylindree.IDCylindree = AnnonceVehicule.IDCylindree)
		
WHERE
((AnnonceVehicule.IDConcession = "147299"
OR INSTR(Dupliquee,147299) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-08-24"
AND DateFinAnnonceVehicule > "2017-08-24"
)
OR (DateDebutAnnonceVehicule <= "2017-08-24"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-08-24"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule = "0000-00-00"
)
)
AND Marques.IDMarque IN ("35","157","32")
)
 ORDER BY DateMiseAJourAnnonce DESC LIMIT 0,15
            [4] => /opt/data/www/sites/composants/comp_templates/controller.php l.2532
        )

    [1] => Array
        (
            [0] => 00000
            [1] => 
            [2] => 
            [3] => SELECT COUNT(IDAnnonceVehicule) AS Total FROM 
			AnnonceVehicule
			LEFT JOIN Marques ON (Marques.IDMarque = AnnonceVehicule.IDMarque)
			LEFT JOIN ModeleMarque ON (ModeleMarque.IDModeleMarque = AnnonceVehicule.IDModeleMarque)
			LEFT JOIN Categorie ON (Categorie.IDCategorie = AnnonceVehicule.IDCategorie)
			LEFT JOIN Cylindree ON (Cylindree.IDCylindree = AnnonceVehicule.IDCylindree)
		
WHERE
((AnnonceVehicule.IDConcession = "147299"
OR INSTR(Dupliquee,147299) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-08-24"
AND DateFinAnnonceVehicule > "2017-08-24"
)
OR (DateDebutAnnonceVehicule <= "2017-08-24"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-08-24"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule = "0000-00-00"
)
)
AND Marques.IDMarque IN ("35","157","32")
)

            [4] => /opt/data/www/sites/composants/comp_templates/controller.php l.2534
        )

)
Occasions

Rechercher un véhicule d'occasion

Pages : 12
  • XSR 900 A
    YAMAHA
    8 990 €
    900 cc
    4515 Km
    Immat.:09/2016
    Détails
  • STREET TRIPLE RS
    TRIUMPH
    10 600 €
    800 cc
    2600 Km
    Immat.:08/2017
    Détails
  • daytona
    TRIUMPH
    6 490 €
    675 cc
    23000 Km
    Immat.:05/2006
    Détails
  • SPEED MASTER 865
    TRIUMPH
    7 400 €
    865 cc
    9107 Km
    Immat.:10/2014
    Détails
  • STREET CUP
    TRIUMPH
    10 000 €
    900 cc
    2800 Km
    Immat.:10/2016
    Détails
  • STREET TRIPLE 675 ABS
    TRIUMPH
    6 790 €
    675 cc
    5039 Km
    Immat.:10/2014
    Détails
  • STREET TRIPLE 675 ABS
    TRIUMPH
    6 490 €
    675 cc
    10308 Km
    Immat.:02/2014
    Détails
  • TIGER 1200 EXPLORER ABS
    TRIUMPH
    12 990 €
    1200 cc
    6544 Km
    Immat.:02/2015
    Détails
  • TIGER SPORT 1050 ABS
    TRIUMPH
    10 990 €
    1050 cc
    8110 Km
    Immat.:03/2014
    Détails
  • TIGER SPORT 1050 ABS
    TRIUMPH
    10 700 €
    1050 cc
    10800 Km
    Immat.:05/2014
    Détails
  • TIGER 1200 EXPLORER
    TRIUMPH
    10 490 €
    1200 cc
    31340 Km
    Immat.:05/2013
    Détails
  • SPEED TRIPLE 1050 S
    TRIUMPH
    11 900 €
    1050 cc
    9500 Km
    Immat.:02/2016
    Détails
  • STREET TRIPLE 675 ABS
    TRIUMPH
    7 900 €
    675 cc
    11567 Km
    Immat.:02/2016
    Détails
  • STREET TRIPLE 675 R ABS
    TRIUMPH
    7 190 €
    675 cc
    9976 Km
    Immat.:11/2013
    Détails
  • TRIUMPH TROPHY 1200 SE
    TRIUMPH
    8 590 €
    1200 cc
    82144 Km
    Immat.:01/2013
    Détails

Pages :12