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