|
|
| | #** INJECTABLE; INJECTION at 50MG/ML | | #** INJECTABLE; INJECTION at 50MG/ML |
| | #Which drug products have a name ending in ESTROL? | | #Which drug products have a name ending in ESTROL? |
| − | #* DIETHYLSTILLBESTROL, STILBESTROL, DIENESTROL | + | #* select drugname from Productfile where drugname like '%ESTROL' |
| | + | #** DIETHYLSTILLBESTROL, STILBESTROL, DIENESTROL |
| | # Produce a table listing all of the known values for the therapeutic_potential column in the application table and how many application records there are of each. (Side note: The therapeutic_potential codes are explained in the ReviewClass_Lookup.txt file, in case you’re interested.) | | # Produce a table listing all of the known values for the therapeutic_potential column in the application table and how many application records there are of each. (Side note: The therapeutic_potential codes are explained in the ReviewClass_Lookup.txt file, in case you’re interested.) |
| | + | #* select ther_potential, count (*) from applicationfile where ther_potential like '%' group by ther_potential |
| | + | #** S* - 3 |
| | + | #** S - 3459 |
| | + | #** P - 928 |
| | + | #** P* - 26 |
| | + | #Produce a table listing all of the known values for the chemical_type column in the application table and how many application records there are of each. (Side note: The chemical_type codes are explained in the ChemTypeLookup.txt file, in case you’re interested.) |
| | + | #*select chemical_type, count (*) from applicationfile where chemical_type >=0 or chemical_type <0 group by chemical_type |
| | + | #**6;87 |
| | + | #**14;34 |
| | + | #**34;9 |
| | + | #**8;27 |
| | + | #**1;1271 |
| | + | #**2;139 |
| | + | #**3;1464 |
| | + | #**24;8 |
| | + | #**7;35 |
| | + | #**10;2 |
| | + | #**23;8 |
| | + | #**4;323 |
| | + | #**5;1046 |
| | + | #**9;1 |
| | + | # What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK? |
| | + | #* select drugname from productfile inner join applicationfile on (productfile.applno = applicationfile.applno) where sponsorapplicant = 'MERCK' group by drugname |
| | + | #**"DECADRON" "HUMORSOL" "NEO-HYDELTRASOL" "PRINIVIL" "MAXALT-MLT" "HYDROCORTONE" "PERIACTIN" "PROPECIA" "PROSCAR" "CLINORIL" "PRINZIDE" "ELSPAR" "ALDOMET" "ALDORIL D30" "EMEND" "DIUPRES-500" "NEODECADRON" "ALDOCLOR-250" "MEFOXIN IN DEXTROSE 5% IN PLASTIC CONTAINER" "ARAMINE" "TIAMATE" "BLOCADREN" "CANCIDAS" "CHIBROXIN" "CORTONE" "PEPCID" "TRUSOPT" "REDISOL" "VIOXX" "FLOROPRYL" "ALPHAREDISOL" "MEFOXIN IN SODIUM CHLORIDE 0.9% IN PLASTIC CONTAINER" "PEPCID RPD" "NOROXIN" "ZOCOR" "LERITINE" "DECADERM" "DOLOBID" "MANNITOL 25%" "DECADRON W/ XYLOCAINE" "ALDORIL D50" "TIMOLIDE 10-25" "CYCLAINE" "HYDROPRES 25" "AMINOHIPPURATE SODIUM" "MEVACOR" "MODURETIC 5-50" "ALDORIL 25" "SINGULAIR" "COLBENEMID" "DIUPRES-250" "HYDELTRA-TBA" "PRIMAXIN" "BENEMID" "MAXALT" "FOSAMAX PLUS D" "HYDRODIURIL" "HYDELTRASOL" "HYDROPRES 50" "ZOLINZA" "ALDORIL 15" "FOSAMAX" "COGENTIN" "ALDOCLOR-150" "PEPCID PRESERVATIVE FREE" |
| | | | |
Exception encountered, of type "Error"
[d5c550ab] /biodb/fall2015/index.php?diff=cur&oldid=2339&title=Emilysimso_Week_6 Error from line 434 of /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php: Call to undefined function each()
Backtrace:
#0 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(544): DiffEngine->diag()
#1 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(344): DiffEngine->compareSeq()
#2 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(227): DiffEngine->diffLocal()
#3 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(721): DiffEngine->diff()
#4 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(859): Diff->__construct()
#5 /apps/xmlpipedb/biodb/fall2015/includes/diff/DairikiDiff.php(980): MappedDiff->__construct()
#6 /apps/xmlpipedb/biodb/fall2015/includes/diff/TableDiffFormatter.php(194): WordLevelDiff->__construct()
#7 /apps/xmlpipedb/biodb/fall2015/includes/diff/DiffFormatter.php(140): TableDiffFormatter->changed()
#8 /apps/xmlpipedb/biodb/fall2015/includes/diff/DiffFormatter.php(111): DiffFormatter->block()
#9 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(888): DiffFormatter->format()
#10 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(802): DifferenceEngine->generateTextDiffBody()
#11 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(733): DifferenceEngine->generateContentDiffBody()
#12 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(662): DifferenceEngine->getDiffBody()
#13 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(632): DifferenceEngine->getDiff()
#14 /apps/xmlpipedb/biodb/fall2015/includes/diff/DifferenceEngine.php(453): DifferenceEngine->showDiff()
#15 /apps/xmlpipedb/biodb/fall2015/includes/page/Article.php(795): DifferenceEngine->showDiffPage()
#16 /apps/xmlpipedb/biodb/fall2015/includes/page/Article.php(506): Article->showDiffPage()
#17 /apps/xmlpipedb/biodb/fall2015/includes/actions/ViewAction.php(44): Article->view()
#18 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(395): ViewAction->show()
#19 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(273): MediaWiki->performAction()
#20 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(566): MediaWiki->performRequest()
#21 /apps/xmlpipedb/biodb/fall2015/includes/MediaWiki.php(414): MediaWiki->main()
#22 /apps/xmlpipedb/biodb/fall2015/index.php(44): MediaWiki->run()
#23 {main}