Home
Organisms
Networks
Data Sets
Run Magic
Documentation
RUN MAGIC
Query Failed: No database selected
Query Was: SELECT datasets.ID, DATE_FORMAT(datasets.date,'%m-%d-%y') AS date, datasets.name, datasets.author, organisms.name AS organismName, networks.name AS networkName, ((unix_timestamp(endtime) - unix_timestamp(starttime))/60), sizeDone FROM datasets JOIN organisms ON datasets.organismID = organisms.ID JOIN networks ON datasets.networkID = networks.ID JOIN jobs ON jobs.callerID=datasets.ID WHERE jobs.page='runmagic' AND endtime IS NOT NULL GROUP BY ID ORDER BY ID