USE `alloc`;

DROP procedure IF EXISTS `display_get_frequency`;



DELIMITER $$

USE `alloc`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `display_get_frequency`(IN p_freq Long)

BEGIN



SELECT *,`wiki_text`.`head`,`wiki_text`.`description` FROM `alloc`.`wiki_frequency` INNER JOIN `alloc`.`wiki_text` 







ON `wiki_frequency`.wiki_text_id = `wiki_text`.wiki_text_id







WHERE frequency1_low <= p_freq or frequency1_high <= p_freq 



or 



frequency2_low >= p_freq or frequency2_high >= p_freq;







END

$$



DELIMITER ;