SET NAMES utf8mb4

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

UPDATE oktopusV1_core_users_online SET logged=1631853502,
prev_url='https://www.negocebus.com/vehicules/categorie/autocar-de-transport-scolaire'
WHERE ident='3.236.212.116'

UPDATE oktopusV1_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 

UPDATE oktopusV1_mod_news SET active = 0
                              WHERE active = 1 AND end_at !=
"0000-00-00 00:00:00" 
                              AND NOW() > end_at 

SELECT c.id, c.active, c.title, c.slug, c.description,
COUNT(v.id) AS num_vehicles FROM
oktopusV1_mod_vehicles_category AS c LEFT JOIN
oktopusV1_mod_vehicles AS v ON c.id=v.category_id WHERE 1 
AND c.slug='autocar-de-transport-scolaire' AND c.active=1 
GROUP BY c.id ORDER BY c.title ASC 

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 

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 

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 v.category_id=4  AND
v.disponibility<=3 AND v.visibility=1 

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.category_id=4  AND
v.disponibility<=3 AND v.visibility=1 ORDER BY v.id DESC
LIMIT 0,8 

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 

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 

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