DELIMITER $$DROP PROCEDURE IF EXISTS `mistudent`.`prc_objs_in_cat`$$CREATE DEFINER=`maria`@`%` PROCEDURE `prc_objs_in_cat`(IN sessionID VARCHAR(128),IN cat_ID INT)BEGINDECLARE internaluid INT;SELECT sessions.userid from sessions where sessionid = sessionID INTO internaluid; SELECT DISTINCT obj_hdr.uid,obj_hdr.visible_name,obj_hdr.created_date,obj_hdr.modified_date,obj_hdr.comment FROM obj_hdr,cat_tags,obj_cat_link,capabilities WHERE obj_cat_link.cat_uid = cat_ID AND obj_cat_link.obj_uid = obj_hdr.uid AND capabilities.obj_uid = obj_hdr.uid AND capabilities.user_uid = internaluid AND capabilities.list = TRUE;END$$DELIMITER ;