SELECT
      `IC_ARTICLE`.ICID
    FROM
      `IC_ARTICLE`
      INNER JOIN `JOUR_ISSUE` ON (`IC_ARTICLE`.ID_ISSUE = `JOUR_ISSUE`.ID_ISSUE)
    WHERE
      (`JOUR_ISSUE`.ID_ISSUE = 835249) AND AND `IC_ARTICLE`.`ID_ARTICLE_KIND` <> 13
    GROUP BY
      IC_ARTICLE.ICID
    ORDER BY
      `IC_ARTICLE`.`PG_FROM` DESC
      LIMIT 0, 27