SELECT article.article_id, variants.name_of_variant, article.article_title, article.article_opening, article.article_content, article.article_date_added
FROM ((( article
INNER JOIN authors ON article.article_id = authors.article_id )
INNER JOIN user ON authors.user_id = user.user_id)
INNER JOIN variants ON article.variants_id = variants.variants_id)
WHERE CONCAT(user.given_name, ' ', user.last_name) LIKE '%$searching%'