DELIMITER //
CREATE STORED PROCEDURE search_items (string AS TEXT, offset AS INT)
BEGIN
COMMENT '
Takes input of a querystring (space delimited) and the offset in pages.
';

CALL split_string(input);

COMMENT 'Selects all fields from keywords for each word NOT in stopwords, in order of query string. ';
	
SELECT DISTINCT * FROM keywords WHERE word IN (SELECT * FROM search_terms) ORDER BY weight LIMIT 10 OFFSET (offset*10);

END //
DELIMITER ;