Join only first 3 rows of the table 2, 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.property_id , p.title,SUBSTRING_INDEX(GROUP_CONCAT(i.image ORDER BY i.property_image_id DESC),',',3) images
FROM properties  p
JOIN tbl_property_image i ON p.property_id = i.property_id
WHERE i.property_image_status = 1
GROUP BY p.property_id , p.title


absolute service time: 0,38 sec