Include data from custom table in WP_Query
Include data from custom table in WP_Query
sql
Order a custom post type admin screen by a second custom post type title
It seems like your mixing slug and post-type. Slug is used to identify a page/post when some entering it into the browser (very related to a permalink). A post type is used to identify what kind of post that is stored in the wordpress database. post_clauses is used if you want to change several things … Read more
How can I combine one field using wpdb and group by?
Got it working with $uvusql = $wpdb->prepare( ” SELECT p.ID, p.post_title, p.post_date, wcom.order_item_name, wcomm.meta_key, wcomm.meta_value, wcomm2.meta_key AS meta_key_qty, wcomm2.meta_value AS meta_value_qty, pm2.meta_value AS meta_value_location FROM $wpdb->posts AS p INNER JOIN $wpdb->postmeta AS pm ON p.ID = pm.post_id INNER JOIN $wpdb->woocommerce_order_items AS wcom ON p.ID = wcom.order_id INNER JOIN $wpdb->woocommerce_order_itemmeta AS wcomm ON wcom.order_item_id = wcomm.order_item_id … Read more
Restose content from revisions – sql query
Restose content from revisions – sql query
Setup private content for specific users with daily updates [closed]
Do you want this dashboard to be on the front-end or the back-end (inside /wp-admin)? For the first case you just need to create a page with a custom page template for it, put all your dashboard logic into that template, and redirect your users to the page after they login (check this answer for … Read more
Optimizing WordPress Queries – Removing Group By ID
Optimizing WordPress Queries – Removing Group By ID
Archive post by meta value + 24hours
This is actually a MySQL question and not related to WordPress but you can replace now() with NOW() + INTERVAL 1 DAY
UPDATE on SELECT results. A SQL query to swap Author with Meta Box value
I always find it way less confusing to get the results from one table and loop them rather than to try to join them like that… eg. global $wpdb; $query = “SELECT post_id FROM wp_postmeta WHERE meta_key=’fake_author’ AND meta_value=”11111″”; $results = $wpdb->get_results($query); foreach ($results as $result) { $query = “UPDATE wp_posts SET post_author=”222222″ WHERE ID='”.$result->post_id.”‘”; … Read more
Migrating to WordPress Recipe Plugin and Some SQL Issues
To answer your questions: Is this possible with an SQL command or just manually? Possibly. This would require you to map the data from your old table to the new WordPress table, since your old custom PHP script won’t be on WordPress. Merging your data from your old recipe table into WordPress won’t work since … Read more
SQL to migrate post types to taxonomy
SQL to migrate post types to taxonomy