Garage James David : Vente de camping car d'occasion à Montgivray près de La Châtre et Châteauroux (Indre 36)

SET NAMES utf8mb4

SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
modulesV4_core_users AS u INNER JOIN
modulesV4_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN modulesV4_core_users_online AS o ON
o.ident='35.153.39.7' WHERE u.id=1

UPDATE modulesV4_core_users_online SET logged=1606742274,
prev_url='https://www.garagejamesdavid.com/vehicules&type_id=5'
WHERE ident='35.153.39.7'

SELECT b.id, b.active, b.title, b.slug, b.description,
b.logo, COUNT(v.id) AS num_vehicles FROM
modulesV4_mod_vehicles_brand AS b LEFT JOIN
modulesV4_mod_vehicles_model AS m ON b.id=m.brand_id LEFT
JOIN modulesV4_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
modulesV4_mod_vehicles_model AS m LEFT JOIN
modulesV4_mod_vehicles_brand AS b ON b.id=m.brand_id LEFT
JOIN modulesV4_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 t.*, COUNT(v.id) AS num_vehicles FROM
modulesV4_mod_vehicles_type AS t LEFT JOIN
modulesV4_mod_vehicles AS v ON t.id=v.type_id WHERE 1 AND
t.active=1  GROUP BY t.id ORDER BY t.title ASC 

SELECT e.id, e.active, e.title, COUNT(v.id) AS num_vehicles
FROM modulesV4_mod_vehicles_energy AS e LEFT JOIN
modulesV4_mod_vehicles AS v ON e.id=v.energy_id WHERE 1 AND
e.active=1  GROUP BY e.id ORDER BY e.title ASC 

SELECT COUNT(v.id) AS num_vehicles 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<=4 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.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<=4 AND v.visibility=1 ORDER BY v.title LIMIT
0,12 

 SELECT * 
                        FROM modulesV4_mod_vehicles_prices
                        WHERE 1 AND actif = '1' 

SELECT f.id, f.active, f.type, f.category, f.ord, f.html_id,
f.colonne, f.picto, f.options, f.info_personnelle, fl.title,
fl.legend, fl.description, fl.value FROM
modulesV4_mod_contact_fields f LEFT JOIN
modulesV4_mod_contact_fields_locales AS fl ON
fl.field_id=f.id AND fl.category=f.category WHERE 1  AND
f.active>0  AND f.category = "insert" AND fl.language='fr'
ORDER BY ord ASC 

 SELECT t.*, tl.rubrique_slug FROM
modulesV4_mod_slideshow_type t
                       LEFT JOIN
modulesV4_mod_slideshow_type_locales tl ON tl.id_type =
t.id_type AND tl.language = 'fr'
                       WHERE 1 AND
FIND_IN_SET('/vehicules&type_id=5', tl.rubrique_slug) > 0
ORDER BY nom 

SELECT t.*, tl.* FROM modulesV4_mod_slideshow_type t
                     LEFT JOIN
modulesV4_mod_slideshow_type_locales tl ON tl.id_type =
t.id_type AND tl.language = 'fr'
                     WHERE t.id_type = '2'

 SELECT p.*, pl.valeur AS legende, pl.lien,   
                          DATE_FORMAT(p.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                          DATE_FORMAT(p.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                       FROM modulesV4_mod_slideshow p
                       LEFT JOIN
modulesV4_mod_slideshow_locales pl ON pl.id_slideshow =
p.id_slideshow AND pl.language = 'fr'
                       WHERE 1 AND p.actif = '1' AND id_type
= '2' ORDER BY position

#0 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]

#1 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]

#2 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#3 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]

#4 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]

#5 oktTemplating->render( called at [/oktModules/vehicles/inc/class.vehicles.controller.php:194]

#6 vehiclesController->vehiclesList( called at [/oktInc/classes/router/class.oktRouter.php:305]

#7 oktRouter->callRouteHanlder( called at [/oktopus.php:58]