CREATE TABLE `profiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `surname` varchar(255) NOT NULL,
  `reg_date` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `surname` (`surname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

_____________________________________________
id   |    name    |  surname   |   regdate
_____________________________________________
1   |  Владимир   |   Иванов   |  01.01.2014

INSERT INTO `profiles`(`name`, `surname`) VALUES ('Владимир', 'Иванов');
INSERT INTO `profiles`(`name`, `surname`) VALUES ('Иван', 'Владимирович');

INSERT INTO `profiles`(`name`, `surname`) VALUES ('Владимир', 'Иванов') ON DUPLICATE KEY UPDATE `name`='Владимир', `surname`='Иванов';

CREATE TABLE `fixtures` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ut` varchar(50) NOT NULL,
  `sport` varchar(50) NOT NULL,
  `country` varchar(25) DEFAULT NULL,
  `league` varchar(50) DEFAULT NULL,
  `template` varchar(255) DEFAULT NULL,
  `tournament` varchar(50) DEFAULT NULL,
  `status` varchar(25) NOT NULL DEFAULT 'Not started',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sport_country_league` (`sport`,`country`,`league`),
  KEY `league` (`league`),
  KEY `country` (`country`),
  KEY `tournament` (`tournament`),
  KEY `sport` (`sport`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8

INSERT ignore INTO `fixtures` ( `ut`, `sport`, `country`, `template`, `tournament`, `league`, `status`) VALUES ('2014-09-19','Football2','International1','International Friendlies','2014','International Friendlies','Not started')

SELECT `id` FROM `fixtures` WHERE `sport` = 'Football' LIMIT 1

CREATE DEFINER = 'root'@'localhost' FUNCTION `getid`(
        sport_name CHAR
    )
    RETURNS bigint(20)
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
  /* пробую так */
  RETURN (select id from `fixtures` where `sport`=CONCAT("'",sport_name,"'"));

  /* или так */
 RETURN (select id from `fixtures` where `sport`=sport_name);
END;

SELECT getid('Football');

id        sport 
1	Football
20	Box

CREATE DEFINER = 'root'@'localhost' PROCEDURE `fixture_id`(
        IN id TINYINT(2)
    )
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
	DECLARE sport_name  VARCHAR(20);

	SELECT sport INTO sport_name FROM `fixtures` WHERE `id`= id LIMIT 1; 
	SELECT sport_name;
END;

SELECT sport  FROM `fixtures` WHERE `id`= 1 LIMIT 1; /* ответ Football */
call fixture_id(1);  /* ответ Box  */

`id`= id

CREATE DEFINER = 'root'@'localhost' PROCEDURE `fixture_id`(
        _ut VARCHAR(50),
        _sport VARCHAR(50),
        _country VARCHAR(50),
        _template VARCHAR(50),
        _league  VARCHAR(50)
    )
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
	DECLARE inserted INT DEFAULT 0;
	DECLARE isset_id INT DEFAULT 0;
	
	SELECT id INTO isset_id FROM `fixtures` WHERE 
	`ut`= _ut and 
	`sport`= _sport and 
	`country`= _country and 
	`template`= _template and 
	`league`= _league 
	LIMIT 1;
	
	IF isset_id > 0 THEN
		SELECT isset_id 'id';
	ELSE
		INSERT INTO `fixtures` ( `ut`, `sport`, `country`, `template`, `tournament`, `league`, `status`) VALUES (_ut,_sport,_country,_template,'2014',_league,'Not started');
		SELECT LAST_INSERT_ID() INTO inserted;
		SELECT inserted 'id';
	END IF;
END;

SELECT LAST_INSERT_ID() INTO inserted;
		SELECT inserted 'id';

INSERT INTO `fixtures` (`ut`,`sport`,`country`,`template`,`league`,`tournament`,`status`) VALUES ('2014-09-20','Football','International','Euro 2016','Euro 2016','2014','Not started') ON DUPLICATE KEY UPDATE ID = LAST_INSERT_ID(ID);
INSERT INTO `fixture_events` (`name`,`date`,`fixture_id`,`participants`,`visible`) VALUES ('Azerbaijan - Bulgaria','2014-09-09 15:00:00','1','a:2:{i:0;s:10:"Azerbaijan";i:1;s:8:"Bulgaria";}','1') ON DUPLICATE KEY UPDATE ID = LAST_INSERT_ID(ID);
INSERT INTO `odds_groups` (`sport`,`caption`) VALUES ('Football','Win') ON DUPLICATE KEY UPDATE ID = LAST_INSERT_ID(ID);
INSERT INTO `odds_types` (`group_id`,`caption`,`enabled`) VALUES ('1','%par1','1') ON DUPLICATE KEY UPDATE ID = LAST_INSERT_ID(ID);
INSERT INTO `odds` (`partner_id`,`event_id`,`date`,`odds`,`type_id`,`enabled`,`margin`) VALUES ('1','1','2014-09-20 19:37:03','4.1','1','1','1.8') ON DUPLICATE KEY UPDATE ID = LAST_INSERT_ID(ID);
в среднем - от 00.00.250 до  00.00.400 !

CALL fixture_id('2014-09-20','Football','International','Euro 2016','Euro 2016');
CALL event_id('Azerbaijan - Bulgaria','2014-09-09 15:00:00','1','a:2:{i:0;s:10:\"Azerbaijan\";i:1;s:8:\"Bulgaria\";}');
CALL group_id('Football','Win');
CALL type_id('1','%par1');
CALL save_odds('1','1','2014-09-20 19:36:48','4.1','1','1.8');
в среднем - от 00.00.650 до  00.01.250 !

SELECT LAST_INSERT_ID() as `id`;