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 = "159490"
OR INSTR(Dupliquee,159490) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-08-22"
AND DateFinAnnonceVehicule > "2017-08-22"
)
OR (DateDebutAnnonceVehicule <= "2017-08-22"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-08-22"
)
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.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 = "159490"
OR INSTR(Dupliquee,159490) > 0
)
AND AnnonceVehicule.NeufOuOccasionOuAccidenteOuDestocke IN (0,2)
AND AnnonceVehicule.Active = 1
AND ((DateDebutAnnonceVehicule <= "2017-08-22"
AND DateFinAnnonceVehicule > "2017-08-22"
)
OR (DateDebutAnnonceVehicule <= "2017-08-22"
AND DateFinAnnonceVehicule = "0000-00-00"
)
OR (DateDebutAnnonceVehicule = "0000-00-00"
AND DateFinAnnonceVehicule > "2017-08-22"
)
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.2534
        )

)
Nos occasions

Rechercher un véhicule d'occasion

Pages : 12

Pages :12