{"id":16927370,"date":"2023-07-27T12:11:18","date_gmt":"2023-07-27T12:11:18","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sql-8\/"},"modified":"2023-07-27T12:11:18","modified_gmt":"2023-07-27T12:11:18","slug":"sql-8","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sql-8\/","title":{"rendered":"SQL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hi again!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Maybe it&#8217;s a problem with my MySQL Server:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL Version 10.5.21 MariaDB Server<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">archive.php<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;$sql = &#8220;CREATE OR REPLACE VIEW <code>{$wpdb-&gt;prefix}redirection_logs_view<\/code> AS<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECT * FROM <code>{$wpdb-&gt;prefix}redirection_logs<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;UNION ALL<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECT * FROM <code>{$wpdb-&gt;prefix}redirection_logs_archive<\/code>&#8220;;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">#1222 &#8211; The used SELECT statements have a different number of columns<\/p>\n","protected":false},"template":"","class_list":["post-16927370","topic","type-topic","status-publish","hentry","topic-tag-union"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16927370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16927370\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=16927370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}