Réalités Médicaments MAJ 2020 ANNEXE IV

SALBUTAMOL (sulfate de), Pd. pour Inh.

SELECT categories.* FROM (SELECT DISTINCT CAST(SUBSTRING(members.anchor, 10) AS UNSIGNED) AS target FROM yacs_members AS members WHERE (members.member LIKE 'article:7065') AND (members.anchor LIKE 'category:%')) AS ids, yacs_categories AS categories WHERE (categories.id = ids.target) AND (categories.active='Y') AND ((categories.expiry_date is NULL) OR (categories.expiry_date <= '0000-00-00 00:00:00') OR (categories.expiry_date > '2024-12-30 17:28:26')) ORDER BY rank, title, edit_date DESC LIMIT 0,40
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', title, edit_date DESC LIMIT 0,40' at line 1

SELECT articles.* FROM yacs_articles AS articles WHERE (articles.anchor LIKE 'section:6') AND ((articles.active='Y') AND NOT ((articles.publish_date is NULL) OR (articles.publish_date <= '0000-00-00')) AND ((articles.expiry_date is NULL) OR (articles.expiry_date <= '0000-00-00 00:00:00') OR (articles.expiry_date > '2024-12-30 17:28:26'))) ORDER BY rank, publish_date DESC, title LIMIT 0,7
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', publish_date DESC, title LIMIT 0,7' at line 1

SELECT sections.* FROM yacs_sections AS sections WHERE (sections.anchor='' OR sections.anchor IS NULL) AND (sections.active='Y') AND (sections.index_map = 'Y') AND ((sections.activation_date is NULL) OR (sections.activation_date <= '2024-12-30 17:28:26')) AND ((sections.expiry_date is NULL) OR (sections.expiry_date <= '0000-00-00 00:00:00') OR (sections.expiry_date > '2024-12-30 17:28:26')) ORDER BY rank, title, edit_date DESC LIMIT 0,8
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', title, edit_date DESC LIMIT 0,8' at line 1

  •  pour le traitement des personnes présentant de la difficulté à utiliser un dispositif d’inhalation autre que le dispositif DiskusMC ou qui reçoivent déjà un autre médicament au moyen de ce dispositif.
En cas de disparité entre ce texte et la version officielle de ce texte, c'est la version officielle qui domine. (voir le fichier joint dans annexe IV)