Irisbus

Afficher les filtres de recherche


Chercher parmi tous nos vehicules


Il y a 10 véhicules affichés sur 2 pages.

Détails

Tarifs sur demande
CH
723200Km
Manuelle 6
Diesel
Irisbus Karosa Recreo Autocar Irisbus Karosa Recreo

Détails

Tarifs sur demande
Autocar Irisbus Karosa Recreo CH
2004
355200Km
Manuelle 6
Diesel
Irisbus Arway EEV Autocar Irisbus Arway EEV

Détails

Tarifs sur demande
Autocar Irisbus Arway EEV CH
2007
341000Km
Automatique
Diesel
Irisbus Crossway Autocar Irisbus Crossway

Détails

Tarifs sur demande
Autocar Irisbus Crossway CH
2008
549500Km
Manuelle 6
Diesel
Irisbus Arway EEV Autocar Irisbus Arway EEV

Détails

Tarifs sur demande
Autocar Irisbus Arway EEV CH
2007
341000Km
Automatique
Diesel
Irisbus Axer Autocar Irisbus Axer

Détails

Tarifs sur demande
Autocar Irisbus Axer CH
2004
476000Km
Manuelle 6
Diesel
Irisbus Evadys H Autocar Irisbus Evadys H

Détails

Tarifs sur demande
Autocar Irisbus Evadys H CH
2007
497500Km
Manuelle 6
Diesel
Irisbus Noge Touring Autocar Irisbus Noge  Touring

Détails

Tarifs sur demande
Autocar Irisbus Noge Touring CH
2005
442300Km
Manuelle
Diesel
  • 1
  • 2

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 : 12,46 Mo
  • Pic mémoire allouée par PHP : 13,34 Mo
  • Temps d'execution du script : 0.757 s
  • Lang :
  • Path : vehicules/marque/url-11
  • Route : vehiclesBrand
  • $okt->page->module : vehicles
  • $okt->page->action : brand
ID Query Time
1
SET NAMES utf8mb4
0.00035
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.230.144.31' WHERE u.id=1
0.00062
3
UPDATE oktopusV1_core_users_online SET logged=1632291055,
prev_url='https://www.negocebus.com/vehicules/marque/url-11'
WHERE ident='3.230.144.31'
0.00049
4
UPDATE oktopusV1_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 
0.00062
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.00040
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-11' AND b.active=1 AND m.active=1  GROUP BY
b.id ORDER BY b.title ASC 
0.00085
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.00061
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.00043
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=11  AND
v.disponibility<=3 AND v.visibility=1 
0.00110
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=11  AND
v.disponibility<=3 AND v.visibility=1 ORDER BY v.id DESC
LIMIT 0,8 
0.02146
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.00041
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=11 AND m.active=1 AND b.active=1  GROUP BY
m.id ORDER BY brand_title ASC, m.title ASC 
0.00499
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.00044
# type fichier ligne classe fonction message