Join only first 3 rows of the table, MySQL

Language: Layout:

DROP TABLE IF EXISTS `properties`;

CREATE TABLE `properties` (
  `property_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`property_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `properties` */

insert  into `properties`(`property_id`,`title`) values (1,'A'),(2,'B');

/*Table structure for table `tbl_property_image` */

DROP TABLE IF EXISTS `tbl_property_image`;

CREATE TABLE `tbl_property_image` (
  `property_image_id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) DEFAULT NULL,
  `property_image_status` tinyint(1) DEFAULT '0',
  `image` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`property_image_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

/*Data for the table `tbl_property_image` */

insert  into `tbl_property_image`(`property_image_id`,`property_id`,`property_image_status`,`image`) values (1,1,1,'ImageA1'),(2,1,1,'ImageA2'),(3,1,1,'ImageA3'),(4,1,1,'ImageA4'),(5,2,1,'ImageB1'),(6,2,1,'ImageB2'),(7,2,1,'ImageB3'),(8,2,1,'ImageB4');

SELECT p.*,i.*
FROM properties  p
JOIN(SELECT i1.property_id,i1.property_image_status,i1.image
	FROM tbl_property_image i1 
	LEFT OUTER JOIN tbl_property_image i2
	  ON (i1.property_id = i2.property_id AND i1.property_image_id < i2.property_image_id)
	  WHERE i1.property_image_status = 1
	GROUP BY i1.property_id,i1.property_image_status,i1.image
	HAVING COUNT(*) < 3
) i
ON p.property_id = i.property_id


absolute service time: 0,38 sec