0
votes
0answers
180 views

SQL Query to select post thumbnail, post title, post content from a category

I use the db of my wordpress blog to develop a mobile application in Java. For this, I need the SQL query to display the thumbnail of a post, the title and the content in a selected category. I think ...
0
votes
1answer
47 views

Size article thumbnails and retrieve them directly from database

I've integrated the Wordpress database directly with my .NET application. What I want is to set the featured image of a post. This featured image must be maximum 800pixels wide, and automatically ...
0
votes
0answers
90 views

featured image not showing up with mysql_connect

i noticed a certain problem with the featured image issue, i had everything work nicely until i added a mysql connection to another database to retrieve certain information, the featured image stop ...
1
vote
0answers
299 views

Cleaning up bloated wp_postmeta table by removing multiple _thumbnail_id's?

On a very old site (7 yrs) with a lot of posts (30k) I've been trying to whittle down the database tables. The postmeta table is 1.5m rows, 750k of those rows are for a meta_key named ...
0
votes
1answer
2k views

Change featured image urls in database

Im storing my images on another server and Ive managed to change the urls in the database but I cant seem to change the featured image urls? I will not be adding any more images so I just want to ...
0
votes
1answer
609 views

Get post featured image id with $wpdb

I'm not a sql expert, but with some help and copying from queries I've found on the web I got this working one that gets the 20 closest places (custom post type) to a specific latitude and longitude ...
1
vote
2answers
6k views

Get Featured Image via direct sql query

I know you can use the wordpress methods for getting a featured image, however with this particular project I need to get the featured image via mysql query. Can anyone point me in the right ...
0
votes
2answers
3k views

Query to delete all featured images and remove post meta?

I'd like to run an SQL query to find all featured images from posts and delete the file itself and any references to it. Can anyone tell me how to accomplish this? Many thanks!