gerer les doublons sur les cles primaires composees
produit1 SELECT FIELD(type_form,'separateur','textestatique') AS cpt1, forms_champs.champ 2 FROM `core`.spip_forms_champs AS `forms_champs` 3 WHERE (forms_champs.id_form = '1') 4 AND ((forms_champs.id_form, champ NOT IN (0))) 5 AND ((forms_champs.id_form, champ NOT IN (0))) 6 HAVING (cpt1 <> 0) 7 ORDER BY cpt1car la clé primaire est "PRIMARY KEY" => "id_form, champ"
Modification effectuée par JamesRezo