SELECT `t`.`id` AS `t0_c0`,
       `t`.`invoice_id` AS `t0_c1`,
       `t`.`customer` AS `t0_c2`,
       `products`.`id` AS `t1_c0`,
       `products`.`name` AS `t1_c1`,
       `products`.`invoice_id` AS `invoice_id`,
       `statuses`.`id` AS `id`,
       `statuses`.`status_type` AS `status_type`,
       `statuses`.`entity_id` AS `entity_id`
FROM `invoices` `t`
LEFT OUTER JOIN `products` `products` ON (`products`.`invoice_id`=`t`.`id`)
LEFT OUTER JOIN `invoice_statuses` `statuses` ON (`statuses`.`entity_id`=`t`.`id`)
WHERE 4 <>
    (SELECT tmp.status_type
     FROM invoice_statuses tmp
     WHERE tmp.entity_id = `t`.`id`
     ORDER BY tmp.id DESC LIMIT 1)
  AND 0 <>
    (SELECT tmp.status_type
     FROM invoice_statuses tmp
     WHERE tmp.entity_id = `t`.`id`
     ORDER BY tmp.id DESC LIMIT 1) 
ORDER BY t.id ASC

tmp.status_type

CREATE TABLE `invoices` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`invoice_id` INT(11) UNSIGNED NOT NULL,
	`customer` VARCHAR(150) NOT NULL,
	`manager_id` INT(11) UNSIGNED NULL DEFAULT NULL,
	`stockman_id` INT(11) NULL DEFAULT NULL,
	`info` TEXT NULL,
	PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB

CREATE TABLE `products` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(255) NOT NULL,
	`invoice_id` INT(11) UNSIGNED NOT NULL,
	`quantity` INT(11) UNSIGNED NOT NULL,
	`owner_id` INT(10) UNSIGNED NULL DEFAULT NULL,
	PRIMARY KEY (`id`),
	INDEX `invoice` (`invoice_id`),
	CONSTRAINT `invoice` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB

CREATE TABLE `invoice_statuses` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`status_type` INT(10) UNSIGNED NOT NULL,
	`entity_id` INT(10) UNSIGNED NULL DEFAULT NULL,
	`timestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`),
	INDEX `Index 2` (`entity_id`),
	CONSTRAINT `FK_invoice_statuses_invoices` FOREIGN KEY (`entity_id`) REFERENCES `invoices` (`id`) ON UPDATE SET NULL ON DELETE SET NULL
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB