| 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.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.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
modulesV4_mod_vehicles AS v LEFT JOIN
modulesV4_mod_vehicles_category AS c ON v.category_id=c.id
LEFT JOIN modulesV4_mod_vehicles_agencies AS a ON
v.agency_id=a.id LEFT JOIN modulesV4_mod_vehicles_type AS t
ON v.type_id=t.id LEFT JOIN modulesV4_mod_vehicles_energy AS
e ON v.energy_id=e.id LEFT JOIN
modulesV4_mod_vehicles_gearboxes AS g ON v.gearbox_id=g.id
LEFT JOIN modulesV4_mod_vehicles_model AS m ON
v.model_id=m.id LEFT JOIN modulesV4_mod_vehicles_brand AS b
ON b.id=m.brand_id WHERE 1 AND v.type_id=5 AND
v.disponibility<=3 AND v.visibility=1 ORDER BY v.title LIMIT
0,12
|
0.00165 |
