SQL/DB Error -- [Disk full (/tmp/#sql_574_7.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
select group_concat(DISTINCT MedicationID ORDER BY MedicationID) as MedicationID, BrandNameGeneric, BrandName as Name, BrandNameMatchExact as MatchExact, replace(replace(group_concat(DISTINCT trim(replace(replace(replace(VariationFormat, 'caplet', '{}'), 'tablet', '{}'), 'capsule', '{}')) SEPARATOR ',,,'), '{} ', ''), '{}', '') as PFormat FROM BrandName INNER JOIN BNM ON BNMBrandNameID=BrandNameID INNER JOIN Medication ON MedicationID=BNMMedicationID INNER JOIN Variation ON VariationBrandNameID=BrandNameID WHERE BrandNameHidden=0 AND BrandName NOT IN ('') AND BrandName like '%Taclonex%' GROUP BY BrandName ORDER BY BrandName like 'Taclonex%' DESC, BrandName
SQL/DB Error -- [Disk full (/tmp/#sql_574_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
select group_concat(DISTINCT MedicationID ORDER BY MedicationID) as MedicationID, BrandNameGeneric, BrandName as Name, BrandNameMatchExact as MatchExact, '' as PFormat FROM BrandName INNER JOIN BNM ON BNMBrandNameID=BrandNameID INNER JOIN Medication ON MedicationID=BNMMedicationID WHERE BrandNameHidden=0 AND BrandName NOT IN ('') AND BrandNameCat='Cancer' AND BrandName like '%Taclonex%' GROUP BY BrandName ORDER BY BrandName like 'Taclonex%' DESC, BrandName
SQL/DB Error -- [Disk full (/tmp/#sql_574_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
select group_concat(DISTINCT MedicationID ORDER BY MedicationID) as MedicationID, BrandNameGeneric, BrandName as Name, BrandNameMatchExact as MatchExact, replace(replace(group_concat(DISTINCT trim(replace(replace(replace(VariationFormat, 'caplet', '{}'), 'tablet', '{}'), 'capsule', '{}')) SEPARATOR ',,,'), '{} ', ''), '{}', '') as PFormat FROM BrandName INNER JOIN BNM ON BNMBrandNameID=BrandNameID INNER JOIN Medication ON MedicationID=BNMMedicationID INNER JOIN Variation ON VariationBrandNameID=BrandNameID WHERE BrandNameHidden=0 AND BrandName NOT IN ('') AND soundex(BrandName) = soundex('Taclonex') GROUP BY BrandName ORDER BY BrandName like 'Taclonex%' DESC, BrandName
SQL/DB Error -- [Disk full (/tmp/#sql_574_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
select group_concat(DISTINCT MedicationID ORDER BY MedicationID) as MedicationID, BrandNameGeneric, BrandName as Name, BrandNameMatchExact as MatchExact, '' as PFormat FROM BrandName INNER JOIN BNM ON BNMBrandNameID=BrandNameID INNER JOIN Medication ON MedicationID=BNMMedicationID WHERE BrandNameHidden=0 AND BrandName NOT IN ('') AND BrandNameCat='Cancer' AND soundex(BrandName) = soundex('Taclonex') GROUP BY BrandName ORDER BY BrandName like 'Taclonex%' DESC, BrandName