$sql = 'INSERT INTO produit (idprod, idcat, titre, ref, descript, prix, stock, couleur, precis, plus, longueur, largeur, hauteur, diam, volume, poids, photo1, photo2, photo3, uvc, genre, $depot) VALUES (NULL, "'.$idcat.'", "'.$idsouscat.'", "'.$titre.'", "'.$ref.'", "'.$descript.'", "'.$prix.'", "'.$stock.'", "'.$couleur.'", "'.$precis.'", "'.$plus.'", "'.$longueur.'", "'.$largeur.'", "'.$hauteur.'", "'.$diam.'", "'.$volume.'", "'.$poids.'", "'.$photo1.'", "'.$photo2'", "'.$photo3.'", "'.$uvc.'", "'.$genre.'", "'.$depot.'")';

<sql>demande d 
			inner join r_lieu_instruction li on (li.lieu_instruction_id = d.lieu_instruction_id) 
            left join r_region r on (li.region_id = r.region_id) 
            left join (SELECT dmd_complement.demande_id,sum(least(dmd_complement.dt_reception_cpl,dd.dt_trans) -dmd_complement.dt_demande) as delais FROM dmd_complement left join demande dd on dd.demande_id = dmd_complement.demande_id where  dd.dt_trans >= dmd_complement.dt_demande group by dmd_complement.demande_id) as delais_comp on delais_comp.demande_id = d.demande_id
            left join s_nature_demande on (d.nature_demande_id = s_nature_demande.nature_demande_id)             
            left join (SELECT demande_id,d.dt_trans -d.dt_arrivee as duree from demande d where d.dt_trans is not null) as global_time on global_time.demande_id = d.demande_id
            left join (SELECT  [cr2]::integer  as nbJours ,demande_id from demande) as jours on jours.demande_id = d.demande_id
            inner join vehicule ve on ve.demande_id = d.demande_id
			where 
			s_nature_demande.operation_simple = false 
			and (d.dt_trans between [cr0] and [cr1])
			and d.statut in ('TR', 'AR')  
 
			group by r.libelle 
 
			order by r.libelle asc</sql>
 
<commentaire>Taux des demandes traitées dans le délai ciblé</commentaire>
<autorisation />
 
            <colonne libelle="Région" rang="0">
                <sql>r.libelle</sql>
            </colonne>
            <colonne libelle="Nombre de demandes" type = "Integer" rang="1">
                <sql>count(d.demande_id)</sql>
            </colonne>
            <colonne type="Double" libelle="Taux de dossiers traités dans le délai global renseigné (%)" rang="2">
                <sql>cast(100*avg(case when  (( cast(((global_time.duree)::text ||' days'::text) as interval)  <![CDATA[<]]>= cast(((jours.nbJours)::text ||' days'::text) as interval))) then 1 else 0 end)as numeric(5,2)) as globalTime</sql>
            </colonne>
            <colonne type="Double" libelle="Taux de dossiers traités dans le délai imputable renseigné (%)" rang="3">
                <sql>cast(100*avg(case when  ((( cast(((global_time.duree)::text ||' days'::text) as interval)   - coalesce(cast(((delais_comp.delais)::text ||' days'::text) as interval),cast('0 days' as interval))) <![CDATA[<]]>= cast(((jours.nbJours)::text ||' days'::text) as interval))) then 1 else 0 end)as numeric(5,2)) as InputableTime</sql>
            </colonne>
 
			<critere visible="true" libelle="Date de transmission Période du"
                obligatoire="true" rang="0" type="Date">
                <commentaire>1ère borne de l’intervalle de date</commentaire>
                <sql>?</sql>
                <sqlDefaut>select to_char(date_trunc('year', now()), 'DD/MM/YYYY')</sqlDefaut>
            </critere>
 
			<critere visible="true" libelle="Date de transmission Période au"
                obligatoire="true" rang="1" type="Date">
                <commentaire>dernière borne de l’intervalle de date</commentaire>
                <sql>?</sql>
                <sqlDefaut>select to_char((date_trunc('year', now()) + INTERVAL '1 year - 1 day'), 'DD/MM/YYYY')</sqlDefaut>
            </critere>
 
			<critere visible="true" libelle="Cible de nombre de jours"
                obligatoire="true" rang="2" type="Integer">
                <commentaire>Nombre de jours</commentaire>
                <sql>?</sql>
				<sqlDefaut>select 60</sqlDefaut>
            </critere>

<sql>demande d
			inner join r_lieu_instruction li on (li.lieu_instruction_id = d.lieu_instruction_id) 
            left join r_region r on (li.region_id = r.region_id)
            left join s_nature_demande on (d.nature_demande_id = s_nature_demande.nature_demande_id)
            left join (
				SELECT demande_id
					FROM classement_sans_suite
					WHERE dt_classe BETWEEN [cr0] and [cr1]
						AND dt_reouverture is null
					GROUP BY demande_id)
					as dmd_classe on dmd_classe.demande_id = d.demande_id
            left join (
				SELECT dmd_complement.demande_id,sum(least(dmd_complement.dt_reception_cpl,dd.dt_trans) -dmd_complement.dt_demande)
					as delais
					FROM dmd_complement
					left join demande dd on dd.demande_id = dmd_complement.demande_id where  dd.dt_trans >= dmd_complement.dt_demande group by dmd_complement.demande_id) as delais_comp on delais_comp.demande_id = d.demande_id
            left join (
				SELECT demande_id,d.dt_trans -d.dt_arrivee
					as duree
					from demande d
					where d.dt_trans is not null)
					as global_time on global_time.demande_id = d.demande_id
            left join (
				SELECT  [cr2]::integer as nbJours, demande_id from demande)
					as jours on jours.demande_id = d.demande_id
            inner join vehicule ve on ve.demande_id = d.demande_id
			where 
			s_nature_demande.operation_simple = true 
			and d.demande_id = dmd_classe.demande_id
			and d.statut = 'CL'  
 
			group by r.libelle 
 
			order by r.libelle asc</sql>
 
 
			<commentaire>Taux des demandes traitées dans le délai ciblé</commentaire>
			<autorisation />
 
            <colonne libelle="Région" rang="0">
                <sql>r.libelle</sql>
            </colonne>
            <colonne libelle="Nombre de demandes" type = "Integer" rang="1">
                <sql>count(d.demande_id)</sql>
            </colonne>
            <colonne type="Double" libelle="Taux de dossiers classés dans le délai global renseigné (%)" rang="2">
                <sql>cast(100*avg(case when  (( cast(((global_time.duree)::text ||' days'::text) as interval)  <![CDATA[<]]>= cast(((jours.nbJours)::text ||' days'::text) as interval))) then 1 else 0 end)as numeric(5,2)) as globalTime</sql>
            </colonne>
            <colonne type="Double" libelle="Taux de dossiers classés dans le délai imputable renseigné (%)" rang="3">
                <sql>cast(100*avg(case when  ((( cast(((global_time.duree)::text ||' days'::text) as interval)   - coalesce(cast(((delais_comp.delais)::text ||' days'::text) as interval),cast('0 days' as interval))) <![CDATA[<]]>= cast(((jours.nbJours)::text ||' days'::text) as interval))) then 1 else 0 end)as numeric(5,2)) as InputableTime</sql>
            </colonne>
 
            <critere visible="true" libelle="Classement sans suite à partir du" obligatoire="true" rang="0" type="Date">
                <sql>?</sql>
                <sqlDefaut>select to_char(date_trunc('year', now()), 'DD/MM/YYYY')</sqlDefaut>
            </critere>
 
            <critere visible="true" libelle="Classement sans suite jusqu'au" obligatoire="true" rang="1" type="Date">
                <sql>?</sql>
                <sqlDefaut>select to_char((date_trunc('year', now()) + INTERVAL '1 year - 1 day'), 'DD/MM/YYYY')</sqlDefaut>
            </critere>
 
			<critere visible="true" libelle="Cible de nombre de jours"
                obligatoire="true" rang="2" type="Integer">
                <commentaire>Nombre de jours</commentaire>
                <sql>?</sql>
				<sqlDefaut>select 30</sqlDefaut>
            </critere>

DELETE t1
FROM wp_icl_strings t1
JOIN wp_icl_strings t2
ON t1.domain_name_context_md5 = t2.domain_name_context_md5
AND t1.id > t2.id
WHERE t1.domain_name_context_md5 IS NOT NULL;

$resultat = mysqli_query($bdd,"SELECT gr, adr, NULL as alb, image, 1
as IdT, MATCH(gr) AGAINST('$mot') AS score
FROM table1
WHERE MATCH(gr) AGAINST('$mot')
UNION
SELECT gr,adr, alb, image, 2 as IdT,
MATCH (alb) AGAINST ('$mot') AS score
FROM table2
WHERE MATCH(alb) AGAINST('$mot')
order by score desc
");

album 'airbag' score= 1.5229313373565674 <<<OK
 album 'Airbag pas pertinent' score= 1.5058114528656006  <<<<pertinence 1/3
album 'Homeless airbag' score= 1.5058114528656006    <<<<<pertinence 1/2 déjà c'est bizarre !'
groupe 'airbag' score= 0.9696779847145081   <<<<<<<<<<<ce résultat est aberrant. Il devrait être en ligne 2

CREATE TABLE `referentiel_communes` (
  `code_commune_INSEE` varchar(5) DEFAULT NULL,
  `nom_commune_postal` varchar(38) DEFAULT NULL,
  `code_postal` char(5) DEFAULT NULL,
  `libelle_acheminement` varchar(32) DEFAULT NULL,
  `ligne_5` varchar(33) DEFAULT NULL,
  `latitude` varchar(50) DEFAULT NULL,
  `longitude` varchar(50) DEFAULT NULL,
  `code_commune` varchar(3) DEFAULT NULL,
  `article` varchar(3) DEFAULT NULL,
  `nom_commune` varchar(45) DEFAULT NULL,
  `nom_commune_complet` varchar(45) DEFAULT NULL,
  `code_departement` varchar(3) DEFAULT NULL,
  `nom_departement` varchar(23) DEFAULT NULL,
  `code_region` varchar(2) DEFAULT NULL,
  `nom_region` varchar(26) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

SELECT code_commune_insee, CONCAT(nom_commune_complet, ' ', GROUP_CONCAT(DISTINCT code_postal ORDER BY code_postal SEPARATOR'-')) AS codes_postaux_par_commune
FROM referentiel_communes
GROUP BY code_commune_insee, nom_commune_complet
ORDER BY nom_commune_complet;

SELECT t.name, tmp.codes_postaux_par_commune
FROM taxonomy_term_field_data t
LEFT JOIN 
(
    SELECT code_commune_insee, CONCAT(nom_commune_complet, ' ', GROUP_CONCAT(DISTINCT code_postal ORDER BY code_postal SEPARATOR'-')) AS codes_postaux_par_commune
    FROM referentiel_communes
    GROUP BY code_commune_insee, nom_commune_complet
) tmp ON tmp.codes_postaux_par_commune = t.name
WHERE t.vid = 'cities'
ORDER BY t.name

$stmt = mysqli_prepare($bdd, "SELECT adresse FROM groupes WHERE groupe LIKE ?");
mysqli_stmt_execute($stmt, [$_GET["Mot"]]);

$stmt = mysqli_prepare($bdd, "SELECT adresse FROM 'groupes index'
WHERE MATCH groupe  AGAINST(?)");

SET foreign_key_checks = 0;
DROP TABLE IF EXISTS `md_articles`;
CREATE TABLE `md_articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(128) NOT NULL,
  `subtitle` mediumtext NOT NULL,
  `content` mediumtext NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `url` varchar(160) DEFAULT NULL,
  `author_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `author_id` (`author_id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `articles_ibfk_1` FOREIGN KEY (`author_id`) REFERENCES `md_authors` (`id`),
  CONSTRAINT `articles_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `md_categories` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

SELECT c.lastname, c.firstname FROM `events` AS e
INNER JOIN teams AS t ON e.id = t.event_id 
INNER JOIN competitors AS c on t.teammate1_id = c.id
WHERE t.even_id = 23

SELECT c.lastname, c.firstname FROM `events` AS e
INNER JOIN teams AS t ON e.id = t.event_id 
INNER JOIN competitors AS c on t.teammate1_id = c.id
WHERE t.even_id = 23