CREATE TABLE `dtb_order_send` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `senddate` date,
 `order_id_start` int(10) unsigned NOT NULL ,
 `order_id_end` int(10) unsigned NOT NULL ,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

INSERT INTO
	dtb_order_send
SELECT
	id,
	senddate,
	order_id_start,
	order_id_end
FROM
	(
		SELECT
			NULL as id,
			DATE(NOW()) as senddate,
			MIN(order_id) as order_id_start,
			MAX(order_id) as order_id_end,
			COUNT(*) as cnt
		FROM
			dtb_order
		WHERE
			order_id > COALESCE((
				SELECT
					order_id_end 
				FROM
					dtb_order_send
				ORDER BY
					id DESC
				LIMIT 1
				),0) AND 
			status <> 3
	) as a
WHERE
	cnt > 130

INSERT INTO
	dtb_order_send
SELECT
	id,
	senddate,
	order_id_start,
	order_id_end
FROM
	(
		SELECT
			NULL as id,
			DATE(NOW()) as senddate,
			MIN(order_id) as order_id_start,
			MAX(order_id) as order_id_end,
			COUNT(*) as cnt
		FROM
			dtb_order
		WHERE
			order_id > COALESCE((
				SELECT
					order_id_end 
				FROM
					dtb_order_send
				ORDER BY
					id DESC
				LIMIT 1
				),0) AND 
			status <> 3 AND 
			EXISTS(
				SELECT
					*
				FROM
					dtb_order_detail
				WHERE
					order_id = dtb_order.order_id AND 
					product_id IN(1,2) //←ここにAとBの商品のproduct_idを入れる
				
			)
	) as a
WHERE
	cnt > 130