Fehler (89)
SELECT * FROM blog JOIN blogcategory ON blogcategory.categoryid = blog.categoryid WHERE ( tags REGEXP 'nö-card' OR hidden_tags REGEXP 'nö-card' ) AND blogcategory.internalcategory = 1 ORDER BY notapproved DESC, outdated_entry ASC, created DESC
Fehler (90)
SELECT * FROM blog JOIN blogcategory ON blogcategory.categoryid = blog.categoryid WHERE ( tags REGEXP 'nö-card' OR hidden_tags REGEXP 'nö-card' ) AND blogcategory.internalcategory = 1 AND notapproved = 0 ORDER BY notapproved DESC, outdated_entry ASC, created DESCSQL-Befehl konnte nicht ausgeführt werden! Fehler: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'regexp' SELECT * FROM blog JOIN blogcategory ON blogcategory.categoryid = blog.categoryid WHERE ( tags REGEXP 'nö-card' OR hidden_tags REGEXP 'nö-card' ) AND blogcategory.internalcategory = 1 ORDER BY notapproved DESC, outdated_entry ASC, created DESC