Try the below code- SELECT p.*, t.term_id FROM wp_posts p LEFT JOIN wp_term_relationships rel ON rel.object_id = p.ID LEFT JOIN wp_term_taxonomy tax ON tax.term_taxonomy_id = rel.term_taxonomy_id LEFT JOIN wp_terms t ON t.term_id = tax.term_id WHERE tax.taxonomy = ‘category’ AND post_type = “post” AND post_status = “publish” AND t.term_id != 56 ORDER BY ID DESC LIMIT … Read more
To move a site from localhost i usually do the following: 1, Install adminer plugin on your localhost (lets you download the database file) 2, Use an FTP to upload all files 3, Change the php config files details to work on host 4, Open the mysql file saved from Adminer and then edit the … Read more
Im not sure this can be done on a separate sever hosts but if you have two websites that are on different URLs but hosted on the same server host this can be done with using the same database and using different prefix for each install. This link will show you how. share users
I cannot change anything in my wordpress database from within wordpress?
Try a plugin like Query Monitor to see if there are queries or things you can identify quickly. A DB may need a log rotated or you could have some DEBUG process turned on that is logging. Backups running on your server will also have an impact. It’s something you’ll have to look into. Same … Read more
Correct permissions for SQLite database
Extracted CSV as Array for Custom Query Loop
How much post meta data is too much?
Turns out this works. global $wpdb; $postsTable = $wpdb->posts; $results = $wpdb->get_results( ‘SELECT * FROM ‘.$postsTable.’ WHERE post_type = “page” OR post_type = “post” AND post_status = “publish”‘);
Custom user query – orderby meta_key (that may not exist)