Query Builder "FROM * table AS a"

Code:
DELIMITER //



CREATE PROCEDURE get_reports(

IN record_start INT,

IN records_to_retrieve INT

)

BEGIN

    

    DECLARE r_start INT DEFAULT 0;

    DECLARE r_retrieve INT DEFAULT 0;

    SET r_start = record_start - 1;

    SET r_retrieve = record_start * records_to_retrieve;

    

    SELECT a.id,

            b.id AS employee_id, 

            CONCAT(b.last_name, ", ", b.first_name, " ", b.middle_name) AS full_name, 

            c.id AS machine_id, 

            c.title AS machine, 

            d.title AS hstatus,

            a.created_on,

            a.action_on,

            a.edit_on,

            a.problems_encountered,

            a.corrective_action,

            a.root_caused,

            a.remarks,

            a.item_replaced

    FROM reports AS a

    INNER JOIN employees AS b ON b.id = a.employee_id

    INNER JOIN machines AS c ON c.id = a.machine_id

    INNER JOIN hstatus AS d ON d.id = a.hstatus_id

    LIMIT r_start , r_retrieve;



END //



DELIMITER ;