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: Unerlaubte Mischung von Sortierreihenfolgen (latin1_swedish_ci, IMPLICIT) und (utf8_general_ci, COERCIBLE) für 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