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_screenshot`)  AS `s` ON `s`.`id_tm` = `i`.`id_tm` 
LEFT JOIN `tm_styles` AS `st` ON `st`.`id_tm` = `i`.`id_tm` 
LEFT JOIN `tm_categories` AS `cat` ON `cat`.`id_tm` = `i`.`id_tm` 
WHERE  `i`.`state` = 1 
AND ( i.id_tm IN ( 
  SELECT `k`.`id_tm` 
  FROM `tm_keywords` AS `k` 
  LEFT JOIN `tm_keywords_index` AS `ki` ON `k`.`id_keyword` = `ki`.`id_keyword` 
  WHERE MATCH (`ki`.`label_en`) AGAINST ('music photos') > 0 
  ) 
) 
AND (`i`.`id_tm` = '13775' 
  OR `i`.`id_tm` = '10781' 
  OR `i`.`id_tm` = '11568' 
  OR `i`.`id_tm` = '12397') 
AND `i`.`id_type` = 17 
AND `i`.`price` >= 20 
AND `i`.`price` <= 60 
AND `st`.`id_style` = 16 
AND `cat`.`id_category` = 94 
GROUP BY `i`.`id_tm` ORDER BY `i`.`id_tm` DESC