CREATE OR REPLACE PROCEDURE
    Locations1stPage( IN Short_word VARCHAR(64), IN Page_size INT, OUT Total_rows INT )             
BEGIN
    SELECT SQL_CALC_FOUND_ROWS
        *
    FROM
        LocationsByWord( Short_word )
    LIMIT
        Page_size
    ;    

    SET 
        Total_rows = FOUND_ROWS()
    ;
END
