Bova

Afficher les filtres de recherche


Chercher parmi tous nos vehicules


Il y a 4 véhicules.

Bova VDL BOVA FLD127

Détails

Tarifs sur demande
CH
611300Km
Manuelle 6
Diesel
Bova FHD 127.365 EURO 4 Autocar Bova FHD 127.365

Détails

Tarifs sur demande
Autocar Bova FHD 127.365 CH
2007
966800Km
Automatique
Diesel
Bova Futura FHD 21.380 Autocar BOVA Futura FHD 12.380

Détails

Tarifs sur demande
Autocar BOVA Futura FHD 12.380 CH
2003
843400Km
Manuelle 6
Diesel
Bova Bova FHD 12.380

Détails

Tarifs sur demande
CH
Km
Manuelle

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,48 Mo
  • Pic mémoire allouée par PHP : 12,51 Mo
  • Temps d'execution du script : 0.287 s
  • Lang :
  • Path : vehicules/marque/url
  • Route : vehiclesBrand
  • $okt->page->module : vehicles
  • $okt->page->action : brand
ID Query Time
1
SET NAMES utf8mb4
0.00018
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.00105
3
UPDATE oktopusV1_core_users_online SET logged=1631854234,
prev_url='https://www.negocebus.com/vehicules/marque/url'
WHERE ident='3.236.212.116'
0.00042
4
UPDATE oktopusV1_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 
0.00046
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.00020
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' AND b.active=1 AND m.active=1  GROUP BY
b.id ORDER BY b.title ASC 
0.00062
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.00020
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.00024
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=1  AND
v.disponibility<=3 AND v.visibility=1 
0.00125
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=1  AND
v.disponibility<=3 AND v.visibility=1 ORDER BY v.id DESC
LIMIT 0,8 
0.01628
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.00019
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=1 AND m.active=1 AND b.active=1  GROUP BY
m.id ORDER BY brand_title ASC, m.title ASC 
0.00319
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.00020
# type fichier ligne classe fonction message