CREATE TABLE IF NOT EXISTS `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(512) NOT NULL,
  `count_completed` int(11) NOT NULL,
  `all_count` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

INSERT INTO `orders` (`id`, `name`, `count_completed`, `all_count`,  `owner_id`) VALUES
(1, 'order 1', 0, 10, 0, 3, 6),
(2, 'order 2', 5, 10, 0, 0, 3),
(3, 'order 3', 7, 10, 0, 0, 3);

CREATE TABLE IF NOT EXISTS `orders_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `is_complete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

INSERT INTO `orders_log` (`id`, `order_id`, `user_id`, `is_complete`) VALUES
(1, 2, 6, 1);

SELECT * FROM `orders` LEFT JOIN orders_log ON orders.id = orders_log.`order_id` AND orders_log.user_id != 6  WHERE count_completed < all_count AND owner_id != 6