Ce site utilise des cookies afin d’améliorer votre expérience de navigation Vous pouvez paramétrer vos préférences et modifier vos choix en cliquant sur le lien de gestion des cookies en bas de page. Paramétrer mes choix
SELECT u.*, g.* FROM oktoV3_core_users AS u INNER JOIN
oktoV3_core_users_groups AS g ON g.group_id=u.group_id WHERE
u.id=1
0.00026
3
UPDATE oktoV3_mod_news SET active = 1
WHERE active = 3 AND NOW() >
created_at
0.00009
4
UPDATE oktoV3_mod_news SET active = 0
WHERE active = 1 AND end_at !=
"0000-00-00 00:00:00"
AND NOW() > end_at
0.00009
5
SELECT id, title, code, img, active, ord FROM
oktoV3_core_languages WHERE 1 AND code='fr' ORDER BY ord
ASC
0.00011
6
SELECT m.*,
ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM oktoV3_mod_map AS m LEFT
JOIN oktoV3_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.00026
7
SELECT m.* FROM oktoV3_mod_map_element AS m WHERE 1 AND
m.id_map = 2 AND m.active=1 AND m.type NOT
IN("marker","markerAddress") ORDER BY m.created_at DESC
0.00010
8
SELECT m.* FROM oktoV3_mod_map_element AS m WHERE 1 AND
m.id_map = 2 AND m.active=1 AND m.type
IN("marker","markerAddress") ORDER BY m.created_at DESC
0.00011
9
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
oktoV3_mod_contact_fields f LEFT JOIN
oktoV3_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
