insert в 3 таблицы за один запрос

CALL `create_photo`(42, 19, 'foo', 'bar', 37);

DELIMITER //
CREATE PROCEDURE `create_photo`(
    IN x INT,
    IN y INT,
    IN n VARCHAR(255),
    IN m VARCHAR(255),
    IN z INT
)
BEGIN
    DECLARE cid INT;
 
    INSERT INTO `category` (`name`, `value`) VALUES (n, x);
    SET cid = LAST_INSERT_ID();
    INSERT INTO `subcategory` (`cat_id`, `name`, `value`) VALUES (cid, m, y);
    INSERT INTO `photo` (`cat_id`, `value`) VALUES (cid, z);
END//

SELECT IF(MAX(corder) IS NULL, 0, MAX(corder) + 1) AS ord FROM $dbTable

DELIMITER //
 
DROP PROCEDURE IF EXISTS `db`.`ads` //
CREATE PROCEDURE `db`.`ads` (
      IN cat_name VARCHAR(100),
      IN cat_corder INT(11),
      IN cat_text MEDIUMTEXT,
      IN cat_img VARCHAR(100),
      IN cat_datetime DATETIME,
      IN cat_day TINYINT(4),
      IN cat_parent INT(11),
      IN cat_subparent INT(11),
      IN cat_type INT(11),
      IN cat_active TINYINT(4),
      IN cat_popular TINYINT(3),
      IN cat_color TINYINT(3),
      IN cat_agent INT(10),
 
      IN subcat_all_f TINYINT(3),
      IN subcat_f TINYINT(3),
      IN subcat_r TINYINT(3),
      IN subcat_h TINYINT(3),
      IN subcat_all_s SMALLINT(5),
      IN subcat_s SMALLINT(5),
      IN subcat_t VARCHAR(100),
      IN subcat_t_name VARCHAR(30),
      IN subcat_r VARCHAR(30),
      IN subcat_phone VARCHAR(20),
      IN subcat_price INT(10),
 
      IN photo1 VARCHAR(100),
      IN photo2 VARCHAR(100),
      IN photo3 VARCHAR(100),
      IN photo4 VARCHAR(100)
)
BEGIN
      DECLARE cid INT;
 
      INSERT INTO `db_ads_h` (`name`, `text`, `img`, `datetime`, `days`, `parent_cat`, `parent_subcat`, `type_premises`, `active`, `popular`, `color`, `agent`)
      VALUES (cat_name, cat_text, cat_img, cat_datetime, cat_day, cat_parent, cat_subparent, cat_type, cat_active, cat_popular, cat_color, cat_agency);
      SET cid = LAST_INSERT_ID();
      INSERT INTO `db_ads_params_h` (`all_f`, `field`, `room`, `height`, `area`, `premises`, `t_premises`, `t_name_premises`, `r_premises`, `phone`, `price`, `parent_ext`)
                                VALUES (subcat_all_f, subcat_f, subcat_r, subcat_h, subcat_all_s, subcat_s, subcat_t, subcat_t_name, subcat_r, subcat_phone, subcat_price, cid);
      INSERT INTO `db_ads_photo_h` (`photo1`, `photo2`, `photo3`, `photo4`, `parent_ext`) VALUES (photo1, photo2, photo3, photo4, cid);
END //

IF photo1 != NULL OR photo2 != NULL OR photo3 != NULL OR photo4 != NULL  THEN 
    INSERT INTO `house_ads_photo_h` (`photo1`, `photo2`, `photo3`, `photo4`, `parent_ext`) VALUES (photo1, photo2, photo3, photo4, cid);
END IF;

IN photos1 VARCHAR(100), 
IN photos2 VARCHAR(100),
IN photos3 VARCHAR(100),
IN photos4 VARCHAR(100)