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 SQL
BEGIN
CALL 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 ;