Symfony Profiler

SELECT
  fp.id_feature,
  fp.id_product,
  fl.name,
  p.reference,
  p.id_product,
  fvl.value
FROM
  `pre2398_feature_product` fp
  INNER JOIN `pre2398_feature_value_lang` fvl ON fp.id_feature_value = fvl.id_feature_value
  INNER JOIN `pre2398_feature_lang` fl ON fp.id_feature = fl.id_feature
  INNER JOIN `pre2398_product` p ON fp.id_product = p.id_product
  INNER JOIN `pre2398_feature` f ON f.id_feature = fl.id_feature
WHERE
  fl.id_lang = 1
  AND fvl.id_lang = 1
  AND p.reference LIKE '5000\_%'
ORDER BY
  f.position

SELECT fp.id_feature, fp.id_product, fl.name, p.reference, p.id_product, fvl.value
			FROM `pre2398_feature_product` fp
			INNER JOIN `pre2398_feature_value_lang` fvl ON fp.id_feature_value = fvl.id_feature_value
			INNER JOIN `pre2398_feature_lang` fl ON fp.id_feature = fl.id_feature
			INNER JOIN `pre2398_product` p ON fp.id_product = p.id_product
			INNER JOIN `pre2398_feature` f ON f.id_feature = fl.id_feature
			WHERE fl.id_lang = 1 AND fvl.id_lang = 1 AND p.reference LIKE '5000\_%' ORDER BY f.position;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Erreur combinée (non-linéarité + hystérésis) (% P.E.*)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Erreur combinée (non-linéarité + hystérésis) (% P.E.*)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Erreur de répétabilité (% P.E.*)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Erreur de répétabilité (% P.E.*)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Force latérale statique admissible (% P.E.*)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Force latérale statique admissible (% P.E.*)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Retour à zéro (% P.E.*)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Retour à zéro (% P.E.*)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Température compensée (°C)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Température compensée (°C)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Température opérationnelle (°C)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Température opérationnelle (°C)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Fluage sur 30 min. (% P.E.*)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Fluage sur 30 min. (% P.E.*)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Dérive thermique de sensibilité (% P.E.*/10°C)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Dérive thermique de sensibilité (% P.E.*/10°C)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Dérive thermique du zéro (% P.E.*/10°C)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Dérive thermique du zéro (% P.E.*/10°C)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Sensibilité nominale (mV/V)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Sensibilité nominale (mV/V)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Température de référence (°C)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Température de référence (°C)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Tension d'alimentation nominale permise (VDC)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Tension d'alimentation nominale permise (VDC)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Utilisation dynamique admissible (% P.E.*)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Utilisation dynamique admissible (% P.E.*)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Température de stockage (°C)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Température de stockage (°C)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Tension d'alimentation de référence (VDC)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Tension d'alimentation de référence (VDC)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Charge de rupture (% P.E.*)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Charge de rupture (% P.E.*)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Plage du zéro initial (mV/V)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Plage du zéro initial (mV/V)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Charge maximale admissible (% P.E.*)"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Charge maximale admissible (% P.E.*)"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Résistance d'isolement (50 V) (Mohm(s))"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Résistance d'isolement (50 V) (Mohm(s))"
			;

SELECT
  cl.link_rewrite,
  cl.meta_title,
  cl.meta_description,
  cl.id_cms,
  c.active,
  ccl.link_rewrite as link2,
  ccl2.link_rewrite as link1
FROM
  `pre2398_cms` c
  INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
  INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
  INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
  INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
  INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
WHERE
  cl.id_lang = 1
  AND cl.meta_title = "Résistance d'entrée (ohm(s))"

SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 1
				AND cl.meta_title = "Résistance d'entrée (ohm(s))"
			;

SELECT
  p.id_product as id_product,
  p.id_category_default as category_default,
  p.reference as reference,
  l.link_rewrite as link_rewrite,
  l.name as name,
  l.description_short as description_short,
  l.description as description,
  l.meta_description as meta_description,
  i1.id_image as id_image1,
  il1.legend as legend1,
  GROUP_CONCAT(
    DISTINCT ia.id_image
    ORDER BY
      ia.id_image
  ) as id_imagea,
  GROUP_CONCAT(
    DISTINCT ila.legend
    ORDER BY
      ila.id_image
  ) as legenda,
  GROUP_CONCAT(DISTINCT s.name) as suppliers,
  GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers,
  GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap,
  GROUP_CONCAT(DISTINCT pattrl4.id_attribute) as attr_cap_id,
  GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec,
  GROUP_CONCAT(DISTINCT pattrl5.id_attribute) as attr_prec_id
FROM
  pre2398_product p
  LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product
  LEFT JOIN pre2398_image ia ON p.id_product = ia.id_product
  LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product
  AND i1.position = 1
  LEFT JOIN pre2398_image_lang ila ON ila.id_image = ia.id_image
  AND ila.id_lang = '1'
  LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image
  AND il1.id_lang = '1'
  LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product
  LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier
  LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product
  AND lpa4.id_attribute_group = 4
  LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute
  AND pattrl4.id_lang = '1'
  LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product
  AND lpa5.id_attribute_group = 5
  LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute
  AND pattrl5.id_lang = '1'
WHERE
  l.id_lang = '1'
  AND l.link_rewrite = 'axes-dynamometriques-sur-mesure-5000'
GROUP BY
  p.id_product
ORDER BY
  p.id_product

SELECT 
                    p.id_product as id_product,
                    p.id_category_default as category_default,
                    p.reference as reference,
                    l.link_rewrite as link_rewrite,
                    l.name as name,
                    l.description_short as description_short,
                    l.description as description,
                    l.meta_description as meta_description,
                    i1.id_image as id_image1,
                    il1.legend as legend1,
                    GROUP_CONCAT(DISTINCT ia.id_image ORDER BY ia.id_image) as id_imagea,
                    GROUP_CONCAT(DISTINCT ila.legend ORDER BY ila.id_image) as legenda,
                    GROUP_CONCAT(DISTINCT s.name) as suppliers,
                    GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers,
                    GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap,
                    GROUP_CONCAT(DISTINCT pattrl4.id_attribute) as attr_cap_id,
                    GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec,
                    GROUP_CONCAT(DISTINCT pattrl5.id_attribute) as attr_prec_id
                    FROM pre2398_product p
                LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product
                LEFT JOIN pre2398_image ia ON p.id_product = ia.id_product
                LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1
                LEFT JOIN pre2398_image_lang ila ON ila.id_image = ia.id_image AND ila.id_lang = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product
                LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier
                LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4
                LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '1'
                LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5
                LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '1'
                WHERE l.id_lang = '1' AND l.link_rewrite = 'axes-dynamometriques-sur-mesure-5000' GROUP BY p.id_product ORDER BY p.id_product;