public function getHistory() { $db = new DatabaseManager(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_CUSTOM_DATABASE); $SQL = 'SELECT B.recid, B.WorkoutName, A.Attribute, L.AttributeValue, L.TimeCreated FROM WODLog L LEFT JOIN CustomWorkouts B ON B.recid = L.ExerciseId LEFT JOIN Attributes A ON A.recid = L.AttributeId LEFT JOIN WorkoutTypes ET ON ET.recid = L.WODTypeId WHERE L.MemberId = ' . $_COOKIE['UID'] . ' AND ET.WorkoutType = "Custom" AND A.Attribute = "TimeToComplete" ORDER BY TimeCreated'; $db->setQuery($SQL); return $db->loadObjectList(); }