{"id":7513229,"date":"2016-06-24T11:56:08","date_gmt":"2016-06-24T11:56:08","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/incorrect-sql-queries\/"},"modified":"2016-09-01T15:57:02","modified_gmt":"2016-09-01T15:57:02","slug":"incorrect-sql-queries","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/incorrect-sql-queries\/","title":{"rendered":"Incorrect sql queries"},"content":{"rendered":"<p>Hi, I think you do not need the database name within all sql queries &#8211; it is producing errors:<\/p>\n<p>WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near &#8216;-wordp-3r.wp_1_datafeed WHERE price &gt; 0&#8217; at line 1]<br \/>\nSELECT COUNT(*) FROM a-wordp-3r.wp_1_datafeed WHERE price &gt; 0<\/p>\n<p>https:\/\/wordpress.org\/plugins\/awin-data-feed\/<\/p>\n","protected":false},"template":"","class_list":["post-7513229","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/7513229","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\/7513229\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=7513229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}