Someone

SELECT `i`.`id_tm`,`s`.`id_screenshot` FROM `tm_index` AS `i` LEFT JOIN (   SELECT `s1`.`id_screenshot` , `s1`.`id_tm`, MAX(`s1`.`height`*`s1`.`width`) AS `surface`   FROM `tm_screenshots` AS `s1`   WHERE `s1`.`uri` REGEXP '\.(gif|jpg|jpeg|png)$'   AND `s1`.`uri` NOT LIKE '%rs%'   GROUP BY `s1`.`id_tm`) AS `s` ON `s`.`id_tm` = `i`.`id_tm` WHERE `i`.`state` = 1 AND (`i`.`id_tm` = '11425' OR `i`.`id_tm` = '11831' OR `i`.`id_tm` = '13108') GROUP BY `i`.`id_tm` ORDER BY `i`.`id_tm` DESC