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
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
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
This is actually a MySQL question and not related to WordPress but you can replace now() with NOW() + INTERVAL 1 DAY
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
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
Risk of sql injection for custom search form