SELECT DISTINCT a.articleTitle, a.articlePermalink
FROM articles a
    JOIN articleKeywords ak ON a.id = ak.articleId
    JOIN articleKeywords ak2 ON ak.articleId = ak2.articleId
        AND ak2.articleId = :articleId
        AND not(a.id = :articleId);

CREATE FUNCTION p1() RETURNS INTEGER DETERMINISTIC NO SQL RETURN @p1;

CREATE VIEW `view_articleRelated` AS
    SELECT DISTINCT a.articleTitle, a.articlePermalink
    FROM articles a
        JOIN articleKeywords ak ON a.idarticles = ak.articleId
        JOIN articleKeywords ak2 ON ak.articleId = ak2.articleId
            AND ak2.articleId = p1()
            AND not(a.idarticles = p1());

SELECT s.* FROM (SELECT @p1:=123 p) foo, view_articleRelated s;

SELECT
    a.idarticles as `article_id`,
    a2.articleTitle,
    a2.articlePermalink
FROM articles a
JOIN articleKeywords ak
    ON a.idarticles = ak.articleId
JOIN articleKeywords ak2
    ON ak.keyword = ak2.keyword
    AND ak.articleId <> a.idarticles
JOIN articles a2
    ON a2.idarticles = ak2.articleId
    AND a2.articleId <> a.idarticles
WHERE a.idarticles = 123
GROUP BY a2.idarticles;