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 = "159476"
OR INSTR(Dupliquee,159476) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-09-24"
AND DateFinAnnonceVehicule > "2017-09-24"
)
OR (DateDebutAnnonceVehicule <= "2017-09-24"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-09-24"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule = "0000-00-00"
)
)
AND Marques.IDMarque IN ("35","157","1","14","16","18","19","27","33","31","32","97","777248","176","180","94","42","105","95","159","81","116","2","141","134","3","91","137","230","43","4","166","5","6","84","7","80","216","107","220","112","37","248","8","9","155","44","167","109","119","108","165","45","131","191","36","126","211","46","47","48","110","103","145","206","10","217","49","11","202","244","12","38","121","212","13","154","140","179","104","148","214","226","15","130","207","139","219","133","50","175","51","143","52","41","53","99","96","243","237","54","17","146","172","89","93","186","120","215","249","161","204","142","164","229","193","147","231","55","40","20","56","150","151","152","106","168","129","250","21","57","58","136","209","111","239","247","22","23","236","192","170","218","60","124","24","198","25","61","26","213","85","62","100","63","28","208","182","102","251","234","132","29","30","195","78","65","200","174","201","122","118","210","233","173","153","228","196","242","128","252","227","92","235","115","39","156","76","86","77","171","69","205","101","135","88","68","160","253","70","113","187","71","72","127","87","169","138","73","194","158","245","67","199","232","144","181","66","34","185","75","190","114","162","149","225","189","224","197","177","98","117")
)
 ORDER BY DateMiseAJourAnnonce DESC LIMIT 0,15
            [4] => /opt/data/www/sites/composants/comp_templates/controller.php l.2537
        )

    [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 = "159476"
OR INSTR(Dupliquee,159476) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-09-24"
AND DateFinAnnonceVehicule > "2017-09-24"
)
OR (DateDebutAnnonceVehicule <= "2017-09-24"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-09-24"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule = "0000-00-00"
)
)
AND Marques.IDMarque IN ("35","157","1","14","16","18","19","27","33","31","32","97","777248","176","180","94","42","105","95","159","81","116","2","141","134","3","91","137","230","43","4","166","5","6","84","7","80","216","107","220","112","37","248","8","9","155","44","167","109","119","108","165","45","131","191","36","126","211","46","47","48","110","103","145","206","10","217","49","11","202","244","12","38","121","212","13","154","140","179","104","148","214","226","15","130","207","139","219","133","50","175","51","143","52","41","53","99","96","243","237","54","17","146","172","89","93","186","120","215","249","161","204","142","164","229","193","147","231","55","40","20","56","150","151","152","106","168","129","250","21","57","58","136","209","111","239","247","22","23","236","192","170","218","60","124","24","198","25","61","26","213","85","62","100","63","28","208","182","102","251","234","132","29","30","195","78","65","200","174","201","122","118","210","233","173","153","228","196","242","128","252","227","92","235","115","39","156","76","86","77","171","69","205","101","135","88","68","160","253","70","113","187","71","72","127","87","169","138","73","194","158","245","67","199","232","144","181","66","34","185","75","190","114","162","149","225","189","224","197","177","98","117")
)

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

)
Sideways Second Hand

Sideways Triumph Tours sélectionne et garantit ses véhicules d'occasion. Votre concessionnaire s'est spécialisé dans les occasions d'origine Triumph, fort de son expérience dans la marque. Sideways Triumph Tours, c'est le plus ancien point de ventes en activité à ce jour pour la marque Triumph.

Nos ocasions sont labelisées Sideways Second Hand, contrpolées, révisées, sans aucun frais à prévoir et garanties trois mois.

Achetez en toute sérénité avec nos occasions Sideways Second Hand.

Rechercher un véhicule d'occasion

Pages : 1
  • TIGER 1050
    TRIUMPH
    4 500 €
    1050 cc
    71000 Km
    Immat.:02/2007
    Détails
  • 250 EXC-F SIX DAYS
    KTM
    8 995 €
    9 955 €
    250 cc
    0 Km
    Immat.:11/2016
    Détails

Pages :1