Mercedes

Afficher les filtres de recherche


Chercher parmi tous nos vehicules


Il y a 5 véhicules.

Mercedes Mercedes 413 CDI

Détails

Tarifs sur demande
CH
408000Km
Manuelle 5
Diesel
Mercedes Mercedes 413 CDI

Détails

Tarifs sur demande
CH
529700Km
Manuelle 5
Diesel
Mercedes Mercedes 416 CDI 4X4

Détails

Tarifs sur demande
CH
363400Km
Manuelle 5
Diesel
Mercedes Sprinter 515 CDI Autocar Mercedes Sprinter 515 CDI

Détails

Tarifs sur demande
Autocar Mercedes Sprinter 515 CDI CH
2007
303000Km
Automatique
Diesel
Mercedes 0345 Connecto Autocar Mercedes 0345 Connecto Boite Manuelle

Détails

Tarifs sur demande
Autocar Mercedes 0345 Connecto Boite Manuelle CH
2003
396500Km
Manuelle 6
Diesel

Acheter ou vendre?


Contactez-nous !

Une question ?


02 37 46 89 57

MONDIAL NEGOCE BUS


  • 13 Rue Ethe Virton
  • 28100 DREUX

Horaires

Lundi au vendredi de 9h à 12h30 et de 13h30 à 17h30.

Samedi de 9h à 12h30.

Fermé le dimanche.

Plan d'accès

  • Mémoire utilisée par PHP : 11,79 Mo
  • Pic mémoire allouée par PHP : 12,78 Mo
  • Temps d'execution du script : 0.626 s
  • Lang :
  • Path : vehicules/marque/url-12
  • Route : vehiclesBrand
  • $okt->page->module : vehicles
  • $okt->page->action : brand
ID Query Time
1
SET NAMES utf8mb4
0.00036
2
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV1_core_users AS u INNER JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV1_core_users_online AS o ON
o.ident='3.236.212.116' WHERE u.id=1
0.00079
3
UPDATE oktopusV1_core_users_online SET logged=1631855244,
prev_url='https://www.negocebus.com/vehicules/marque/url-12'
WHERE ident='3.236.212.116'
0.00083
4
UPDATE oktopusV1_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 
0.00067
5
UPDATE oktopusV1_mod_news SET active = 0
                              WHERE active = 1 AND end_at !=
"0000-00-00 00:00:00" 
                              AND NOW() > end_at 
0.00044
6
SELECT b.id, b.active, b.title, b.slug, b.description,
b.logo, COUNT(v.id) AS num_vehicles FROM
oktopusV1_mod_vehicles_brand AS b LEFT JOIN
oktopusV1_mod_vehicles_model AS m ON b.id=m.brand_id LEFT
JOIN oktopusV1_mod_vehicles AS v ON m.id=v.model_id WHERE 1 
AND b.slug='url-12' AND b.active=1 AND m.active=1  GROUP BY
b.id ORDER BY b.title ASC 
0.00114
7
SELECT b.id, b.active, b.title, b.slug, b.description,
b.logo, COUNT(v.id) AS num_vehicles FROM
oktopusV1_mod_vehicles_brand AS b LEFT JOIN
oktopusV1_mod_vehicles_model AS m ON b.id=m.brand_id LEFT
JOIN oktopusV1_mod_vehicles AS v ON m.id=v.model_id WHERE 1
AND b.active=1 AND m.active=1 GROUP BY b.id ORDER BY b.title
ASC 
0.00044
8
SELECT m.id, m.brand_id, m.active, m.title, m.slug,
m.description, b.title AS brand_title, b.slug AS brand_slug,
COUNT(v.id) AS num_vehicles FROM
oktopusV1_mod_vehicles_model AS m LEFT JOIN
oktopusV1_mod_vehicles_brand AS b ON b.id=m.brand_id LEFT
JOIN oktopusV1_mod_vehicles AS v ON m.id=v.model_id WHERE 1
AND m.active=1 AND b.active=1  GROUP BY m.id ORDER BY
brand_title ASC, m.title ASC 
0.00049
9
SELECT COUNT(v.id) AS num_vehicles FROM
oktopusV1_mod_vehicles AS v LEFT JOIN
oktopusV1_mod_vehicles_category AS c ON v.category_id=c.id
LEFT JOIN oktopusV1_mod_vehicles_agencies AS a ON
v.agency_id=a.id LEFT JOIN oktopusV1_mod_vehicles_type AS t
ON v.type_id=t.id LEFT JOIN oktopusV1_mod_vehicles_energy AS
e ON v.energy_id=e.id LEFT JOIN
oktopusV1_mod_vehicles_gearboxes AS g ON v.gearbox_id=g.id
LEFT JOIN oktopusV1_mod_vehicles_model AS m ON
v.model_id=m.id LEFT JOIN oktopusV1_mod_vehicles_brand AS b
ON b.id=m.brand_id WHERE 1  AND m.brand_id=12  AND
v.disponibility<=3 AND v.visibility=1 
0.00163
10
SELECT v.id, v.title, v.slug, v.title_tag, v.title_seo,
v.model_id, v.type_id, v.category_id, v.agency_id,
v.energy_id, v.gearbox_id, hybrid_engine, v.created_at,
v.updated_at, v.desc_short, v.desc_long, v.ref,
v.meta_description, v.meta_keywords, v.gateway, v.annee,
v.date, v.roadworthiness, v.km, v.hours, v.environmental,
v.cv, v.kw, v.engine_size, v.engine_size_liter,
v.wheel_drive, v.air_conditioning, v.cylinder_number,
v.valves_number, v.front_brakes, v.rear_brakes, v.asr,
v.abs_system, v.registration, v.procedure, v.back_theft,
v.company_car, v.driving_school, v.rear_view_camera,
v.rear_view_warning, v.length, v.width, v.height,
v.wheelbase, v.turning_circle, v.weight,
v.carrying_capacity, v.ptra, v.axle, v.capacity, 
v.type_mine, v.norme_euro, v.carrosserie, v.ptac,
v.poids_utile, v.num_serie, v.usure_pneu, v.crit_air, 
v.seating, v.disability, v.disability_pmr_elec,
v.disability_pmr_manual, v.standing, v.toilet,
v.video_screen, v.number_vehicles, v.alcolocks, v.webasto,
v.kneeling, v.belts, v.convertible, v.retarder,
v.retarder_txt,  v.vane, v.vane_brand, v.lateral_vane,
v.frontal_vane, v.back_vane,  v.portes, v.garantie,
v.garantie_name, v.color_ext, v.color_family, v.color_int,
v.saddlery, v.rims, v.tires, v.maximum_speed,
v.maximum_torque, v.zero_to_one_hundred,
v.thousand_meters_ss, v.consumption, v.prix,
v.prix_marchand, v.prix_promo, v.disponibility,
v.tank_capacity, v.tank_capacity_adblue,
v.tank_position_adblue, v.images, v.files, v.promo,
v.promo_start, v.promo_end, v.nouvo, v.nouvo_start,
v.nouvo_end, v.favo, v.favo_start, v.favo_end, v.first_hand,
(v.first_hand = 1) AS is_first_hand, v.exclu, (v.exclu = 1)
AS is_exclu, v.visibility, (v.visibility = 1) AS is_visible,
v.filing_sale, (v.filing_sale = 1) AS is_filing_sale,
c.title AS category, c.description AS category_description,
e.title AS energy, g.title AS gearbox, t.title AS type,
b.title AS brand, b.slug AS brand_slug, m.title AS model,
m.brand_id, a.title AS agency_title, a.active AS
agency_active, a.adress AS agency_adress, a.adress2 AS
agency_adress2, a.code AS agency_code, a.city AS
agency_city, a.tel AS agency_tel, a.tel2 AS agency_tel2,
a.email AS agency_email, a.contact AS agency_contact,
(v.promo = 1) AS is_promo, (v.nouvo = 1) AS is_nouvo,
(v.favo = 1) AS is_favo, CONCAT_WS('
',b.title,m.title,v.title) AS intitle FROM
oktopusV1_mod_vehicles AS v LEFT JOIN
oktopusV1_mod_vehicles_category AS c ON v.category_id=c.id
LEFT JOIN oktopusV1_mod_vehicles_agencies AS a ON
v.agency_id=a.id LEFT JOIN oktopusV1_mod_vehicles_type AS t
ON v.type_id=t.id LEFT JOIN oktopusV1_mod_vehicles_energy AS
e ON v.energy_id=e.id LEFT JOIN
oktopusV1_mod_vehicles_gearboxes AS g ON v.gearbox_id=g.id
LEFT JOIN oktopusV1_mod_vehicles_model AS m ON
v.model_id=m.id LEFT JOIN oktopusV1_mod_vehicles_brand AS b
ON b.id=m.brand_id WHERE 1  AND m.brand_id=12  AND
v.disponibility<=3 AND v.visibility=1 ORDER BY v.id DESC
LIMIT 0,8 
0.01328
11
SELECT b.id, b.active, b.title, b.slug, b.description,
b.logo, COUNT(v.id) AS num_vehicles FROM
oktopusV1_mod_vehicles_brand AS b LEFT JOIN
oktopusV1_mod_vehicles_model AS m ON b.id=m.brand_id LEFT
JOIN oktopusV1_mod_vehicles AS v ON m.id=v.model_id WHERE 1
AND b.active=1 AND m.active=1 GROUP BY b.id ORDER BY b.title
ASC 
0.00045
12
SELECT m.id, m.brand_id, m.active, m.title, m.slug,
m.description, b.title AS brand_title, b.slug AS brand_slug,
COUNT(v.id) AS num_vehicles FROM
oktopusV1_mod_vehicles_model AS m LEFT JOIN
oktopusV1_mod_vehicles_brand AS b ON b.id=m.brand_id LEFT
JOIN oktopusV1_mod_vehicles AS v ON m.id=v.model_id WHERE 1 
AND m.brand_id=12 AND m.active=1 AND b.active=1  GROUP BY
m.id ORDER BY brand_title ASC, m.title ASC 
0.00252
13
SELECT m.*, 
                              ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM oktopusV1_mod_map AS m 
LEFT JOIN oktopusV1_mod_map_locales AS ml ON m.id=ml.id_map
AND ml.language='fr' WHERE 1  AND m.id = 2  AND
ml.language='fr' AND m.active=1 ORDER BY m.created_at DESC 
0.00045
# type fichier ligne classe fonction message