Réalités Médicaments MAJ 2020

2.2.1. Méthode du prix le plus bas

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

Le prix payable pour un médicament de même dénomination commune, de même forme et de même teneur est celui de la marque de commerce dont le prix de vente garanti par le fabricant est le moins élevé pour un format donné.