SELECT 
      SQL_CALC_FOUND_ROWS
      i.*,
      i.title_ru AS title
 FROM 
      gallery_photos AS i INNER JOIN
      gallery_categories AS c ON c.id = i.cat_id
 WHERE 
      i.visible = 1 AND
      i.cat_id = '27' AND
      c.sid = '209'
 ORDER BY 
      i.pos,
      i.id DESC
 LIMIT 
      0,
      10