DELIMITER $$DROP PROCEDURE IF EXISTS `bibleshark2`.`sp_parallel`$$CREATE PROCEDURE `bibleshark2`.`sp_parallel`(IN translist varchar(255), IN chapter int, IN start_verse int, IN end_verse int, IN book varchar(255))CONTAINS SQLBEGINCALL split_string(@translist, "-"); SELECT site_scripture.id, site_translation.acronym, site_translation.name, site_book.name, site_verse.verse, site_verse.chapter, site_scripture.scripture FROM site_scripture, site_verse, site_translation, site_book INNER JOIN site_verse ON site_verse.id = site_scripture.verse_id INNER JOIN site_translation ON site_translation.id = site_scripture.translation_id INNER JOIN site_book ON site_book.id = site_verse.book_id WHERE site_book.id = site_verse.book_id AND site_translation.id = site_scripture.translation_id AND site_verse.id = site_scripture.verse_id AND site_translation.activated = 1 AND site_translation.acronym IN(SELECT value FROM SplitValues) AND site_verse.chapter = @chapter AND site_verse.verse BETWEEN @start_verse AND @end_verse site_book.name = @book ORDER BY site_book.name, site_verse.chapter, site_verse.verse; BEGIN END$$DELIMITER ;