| 9 |
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 v.disponibility<=3 AND
v.visibility=1 ORDER BY v.title LIMIT 0,8
|
0.00767 |
