/* query 1 */
SELECT
articles.title,
upper(articles.body) as content,
articles.article_id,
COUNT(ReplyJoin.comment_id) as replies_count
FROM
articles
LEFT OUTER JOIN
comments AS ReplyJoin
ON
ReplyJoin.article_id = articles.article_id
WHERE
(articles.body like '%SWEET%' and articles.user_id < 4) or articles.title like '%blandit%' /* <- EVIDENCE HERE */
GROUP BY
articles.article_id
HAVING
COUNT(ReplyJoin.comment_id) > 1
ORDER BY
articles.title
;
/* query 2 */
SELECT
lower(articles.title) as lower_title,
GROUP_CONCAT(comments.body SEPARATOR ' + ') AS comment_summary,
articles.article_id
FROM
articles
LEFT OUTER JOIN
comments
ON
comments.article_id = articles.article_id
WHERE
articles.article_id < 5 and LENGTH(articles.body) > 50 and comments.parent_id is not NULL /* <- EVIDENCE HERE */
GROUP BY
articles.article_id
HAVING
NOT comment_summary like '%bart%'
ORDER BY
LENGTH(articles.body) ASC
;
/* query 3 */
SELECT
users.name,
comments.body as 'content',
HEX(SUBSTRING_INDEX(comments.body, ' ', -1)) as 'secret',
COUNT(users.name) as 'stack'
FROM
comments
LEFT OUTER JOIN
users
ON
users.user_id = comments.user_id
LEFT OUTER JOIN
comments as parent_comment
ON
comments.parent_id = parent_comment.comment_id
WHERE
((comments.parent_id % 2) = 0 and users.name != 'jables') or comments.parent_id = 5 /* <- EVIDENCE HERE */
GROUP BY
secret
HAVING
secret != HEX('billy') and stack = 2
ORDER BY
secret DESC, users.name ASC
;
/* query 4 */
SELECT MIN(LENGTH(name))
FROM users
WHERE name != 'Billyjim Cricketwhisker' and (user_id % 2 = 1 or name like '%o%'); /* <- EVIDENCE HERE */
