Combining two select posts from mysql – to get least viewed posts

This should be the SQL you’re looking for (off the top of my head, so may need some tweaking).

"SELECT * FROM wp_posts
LEFT JOIN wp_popularpostsdata ON (wp_posts.ID =  wp_popularpostsdata.postid)
LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
WHERE posts.post_type="post" 
AND wp_term_taxonomy.term_id NOT IN (73)
GROUP BY wp_posts.ID 
ORDER BY pageviews ASC limit 10"

Related Posts:

  1. MySQL SELECT increment counter
  2. Populate dropdown from database
  3. Fill custom select field with pages/post titles
  4. Get results from wordpress data custom table
  5. Select From wpdb – Author/User Directory page
  6. SELECT rows between two datetimes when the range is dynamic [closed]
  7. Selecting NULL value from the database
  8. Tool to check the database in Production [closed]
  9. Custom wordpress SQL statement for a website
  10. Checking if Database Table exists
  11. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  12. Is it possible to define two databases for one installation?
  13. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  14. Syncing local content with development / staging sites
  15. Export WP database for import using WP-CLI on Vagrant Box
  16. Improve or optimize a very slow query
  17. What is the advantage of separating wp_users and wp_usermeta table?
  18. Showing content from another wordpress installation database in the page template loop?
  19. “MySQL server has gone away” since update to 3.8
  20. WordPress page title repeated in SOME pages
  21. Why is $wpdb->get_results failing on certain tables but not others (which have data)?
  22. How to correctly add a table to the WordPress MySQL database
  23. MySQL Syntax Error upon restoring database from backup [closed]
  24. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  25. Merge two databases: OLD SITE -> NEW SITE
  26. Is it safe to convert tables from MyISAM to InnoDB?
  27. Use one WordPress database with multiple instances of one site
  28. Who is responsible for data sanitization in WordPress development?
  29. How do I properly update the WordPress database password?
  30. wpdb_prepare with multiple or condition
  31. How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
  32. $wpdb->insert is not working
  33. WordPress Install and Database on separate hosting?
  34. Moving a site from a temporary domain to the live domain [duplicate]
  35. What is this in my tables
  36. WordPress shortcode attributes for database SELECT?
  37. I need to get an array from the wordpress database
  38. Moving minor updates between local and live sites – just database?
  39. what is the best way to store user created data?
  40. WP get stuck with a query on MySQL when the site is resumed
  41. Using GROUP CONCAT in my-sql query with wp_usermeta table
  42. How to move the WordPress site Layout from test site to Production site?
  43. Trying to change database tables storage engine to innodb gives error “invalid default value for ‘post_date'”
  44. Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  45. Retrieve data from the database to table such as comments in the admin control panel
  46. Need to store custom user information (many-many relationsips), preferably not as user meta
  47. charset problem with new custom table
  48. WordPress and user security
  49. How to share plugin created database tables between two WordPress sites
  50. How to connect to a remote database in WordPress?
  51. Migrating from PDO using SQLite to clean new install using MySQL
  52. Change WordPress URL in sql file via Terminal
  53. $wpdb->insert Giving duplicates
  54. Which data is written and stored in the database when read-only (non-posting, non-commenting) users visit the site?
  55. Where is phpMyAdmin inside WordPress?
  56. What can I do when an outside party hacks into my weblog and changes my display name?
  57. How to delete database without using any plugin?
  58. Cannot restore wordpress database from sql dump [closed]
  59. WooCommerce: remove sample & dummy data
  60. Is database deleted on clicking “reinstall” button in WordPress updates?
  61. Is my way to change WordPress server is correct?
  62. Check if a value exists in database table
  63. WordPress database products structure
  64. I cannot find the difference between these wp_capabilities values in wp_usermeta
  65. Files on Localhost, Database on Server
  66. Is there any way to monitor a MySQL db and check what has changed?
  67. DB prefix not updating
  68. Any other way of storing plugin admin data setting
  69. Will memcached improve performance with WP Super Cache already running?
  70. Error establishing a database connection – WordPress setup, everything else is working
  71. Restore of database doesn’t show content
  72. Why theme settings lost when I installed https
  73. WordPress site migration – locked out of admin area
  74. WordPress users table missing indexes
  75. unable to use my wordpress site after moving
  76. How to add download link from database on custom page template?
  77. How to get the id of recently registered user from database?
  78. How can i syn wordpress user table with a stand-alone php script?
  79. insert data from a form:: Warning Empty query mysqli::query()
  80. Db connection problem on Azure Since database moved on CLEARDB
  81. How to get specific table by current user login
  82. After Migration From dev, Only my Links to the Homepage Still Redirect to dev
  83. How can we speed up wp_get_nav_menu_items()?
  84. Mysql Queries per Visit – Crazy High
  85. Media Library doesn’t allow uploads? Upload Directory
  86. Moving Site: Is Re-downloading Files After Changing URLs necessary?
  87. using same mysql user with many databases
  88. Manage 3 Layers Of Information (CTP – Posts – Then Maybe Metadata?)
  89. Get id from database
  90. How to write to wp-users table
  91. Change taxonomy slug in database
  92. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  93. Multiple Address In WP-Option Value
  94. WordPress database error Unknown column
  95. Which is less DB intensive in the loop: custom taxonomies or meta fields?
  96. How can i change the nicename and the displayname in a bulk in the database?
  97. How to generate PDF dynamically based on values from the database in WordPress
  98. Help with vehicle performance website
  99. Distributed plugin – add support for Cyrillic
  100. wp_update_post function exclude specific field
deneme bonusudeneme bonusu veren sitelerpulibet girişOnwin Güncel Giriştürkçe altyazılı pornocanlı bahis casinocanlı bahis casino siteleriOnwin Güncel Girişholiganbetholiganbet girişholiganbet güncel giriş