SELECT CONCAT(LEFT(`name`, 1), '. ', `lastname`) AS `short_name` FROM `clients` WHERE POSITION('tt' IN `lastname`) != 0 OR POSITION('ss' IN `lastname`) != 0 OR SELECT * FROM `clients` WHERE `phone` ...
* creates a submitted request row then converts to a work order; staff may convert * standalone submitted requests via rpc_convert_maintenance_request_to_work_order. * affected: ...