Database error: SQL Error:
SELECT
`article`.id,
IF (title LIKE '%Shinzō Abe%', 1, 0) AS One,
IF (GROUP_CONCAT( `tags`.`tag` ) LIKE '%Shinzō Abe%', 1, 0) AS Two,
IF ( title LIKE '%Shinzō%' OR title LIKE '%Abe%' , 1, 0) AS Three,
IF ( GROUP_CONCAT( `tags`.`tag` ) LIKE '%Shinzō%' OR GROUP_CONCAT( `tags`.`tag` ) LIKE '%Abe%' , 1, 0) AS Four
FROM article
LEFT JOIN `tag` AS `tags` ON `object_id` = `article`.`id`
WHERE `tags`.`object` = 'article' AND `article`.`active` = '1' AND `article`.`websiteCategory` != 0
GROUP BY `article`.`id`
HAVING ( One = 1 OR Two = 1 OR Three = 1 OR Four = 1 )
ORDER BY One DESC, Two DESC, Three DESC, Four DESC, datePublished DESC
MySQL Error: 1267 (Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like')
MySQL Error: 1267 (Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like')
Session halted.