2.2.2. Regroupement de formes pharmaceutiques et de teneurs

SELECT categories.* FROM (SELECT DISTINCT CAST(SUBSTRING(members.anchor, 10) AS UNSIGNED) AS target FROM yacs_members AS members WHERE (members.member LIKE 'article:6696') 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-11-19 09:41:28')) 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

Pour l’application de la méthode du prix le plus bas, certaines formes pharmaceutiques ou teneurs en ingrédients actifs d’un médicament peuvent être regroupées au sein d’une même dénomination commune. Le prix payable est alors établi en fonction des doses correspondantes.