{"id":31816,"date":"2013-08-05T19:47:23","date_gmt":"2013-08-05T18:47:23","guid":{"rendered":"https:\/\/pl.wordpress.org\/support\/topic\/jak-zmienic-to-zapytanie-sql\/"},"modified":"2016-08-05T21:57:45","modified_gmt":"2016-08-05T21:57:45","slug":"jak-zmienic-to-zapytanie-sql","status":"closed","type":"topic","link":"https:\/\/pl.wordpress.org\/support\/topic\/jak-zmienic-to-zapytanie-sql\/","title":{"rendered":"Jak zmienic to zapytanie sql"},"content":{"rendered":"<pre><code># First:\n\nDELETE FROM wp_postmeta\nWHERE post_id IN\n(\nSELECT id\nFROM wp_posts\nWHERE post_type = &#039;attachment&#039;\n)\n;\n\n# Second:\n\nDELETE FROM wp_posts WHERE post_type = &#039;attachment&#039;<\/code><\/pre>\n<p>To zapytanie usuwa wszystkie obrazki z post\u00f3w. Jak zmieni\u0107 to by usuwa\u0142o obrazki kt\u00f3re maj\u0105 wysoko\u015b\u0107 mniejsz\u0105 ni\u017c 100px ?<\/p>\n","protected":false},"template":"","class_list":["post-31816","topic","type-topic","status-closed","hentry","topic-tag-attachment","topic-tag-postmeta"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/31816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/31816\/revisions"}],"wp:attachment":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=31816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}