WHERE worktab.id_w= id AND worktab.id_sotr=ids AND worktab.flag_end=1; или допустим просто clienttab.fio like'петя%'

Where id_cl= param1 and visit=param2 and ещё что то

DELIMITER $$

USE `hairsalon`$$

DROP PROCEDURE IF EXISTS `work_select`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `work_select`(IN id INT(11))
BEGIN
SELECT 
worktab.id_w AS id_w,
worktab.id_cl AS id_cl,
worktab.id_sotr AS id_sotr,
worktab.id_srv AS id_srv,
worktab.id_hc_old AS id_hc_old,
worktab.id_hl_old AS id_hl_old,
worktab.id_hc AS id_hc,
worktab.id_hl AS id_hl,
worktab.visit AS visit,
worktab.id_item AS id_item,
worktab.flag_end AS flag_end,
worktab.suma AS suma,
clienttab.fio AS cfio,
haircolortab.name_color AS name_color,
hairlntab.name_ln AS name_ln,
haircolortab_old.name_color AS name_color_old,
hairlntab_old.name_ln AS name_ln_old,
itemstab.name_item AS name_item,
worktab.item_count AS item_count,
servicetab.name_srv AS name_srv,
sotrtab.fio AS sfio
FROM 
`hairsalon`.`work` worktab
LEFT OUTER JOIN  `hairsalon`.`client` clienttab           ON worktab.id_cl = clienttab.id_cl
LEFT OUTER JOIN  `hairsalon`.`haircolor` haircolortab     ON worktab.id_hc = haircolortab.id_hc
LEFT OUTER JOIN  `hairsalon`.`hairln` hairlntab           ON worktab.id_hl = hairlntab.id_hl
LEFT OUTER JOIN  `hairsalon`.`haircolor` haircolortab_old ON worktab.id_hc_old = haircolortab_old.id_hc
LEFT OUTER JOIN  `hairsalon`.`hairln` hairlntab_old       ON worktab.id_hl_old = hairlntab_old.id_hl
LEFT OUTER JOIN  `hairsalon`.`items` itemstab             ON worktab.id_item = itemstab.id_item
LEFT OUTER JOIN  `hairsalon`.`service` servicetab         ON worktab.id_srv = servicetab.id_srv
LEFT OUTER JOIN  `hairsalon`.`sotr` sotrtab               ON worktab.id_sotr = sotrtab.id_sotr
WHERE worktab.id_w= id;
    END$$

DELIMITER ;