$wpdb post type and term query only works when there are no dashes or spaces in the term slug and title

In your code you are using "AND terms.name="shorelineorwaterway" where I don’t think shorelineorwaterway is your term name, it could be your terms slug. So you can modify this by "AND terms.slug = 'shorelineorwaterway' and here inside inverted commas you can use hyphen.

If you need to use term name then "AND terms.name="Your Term Name" would work.

And I’ve tested both above.

Hope I have cleared my thought.

Related Posts:

  1. How do you properly prepare a %LIKE% SQL statement?
  2. wpdb->prepare function remove single quote for %s in SQL statment
  3. How to get INSERT errors from $wpdb?
  4. WPDB delivers wrong results from complex queries
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. Cannot delete or update a parent row: a foreign key constraint fails
  7. Cannot delete or update a parent row: a foreign key constraint fails
  8. Rename a column in MySQL
  9. Cannot delete or update a parent row: a foreign key constraint fails
  10. How do I import an SQL file using the command line in MySQL?
  11. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  12. What is the definition of cardinality in SQL
  13. SQL Query Where Field DOES NOT Contain $x
  14. How to join two tables by multiple columns in SQL?
  15. mysql Foreign key constraint is incorrectly formed error
  16. Selecting data from two different tables without using joins
  17. MySQL: Invalid use of group function
  18. difference between primary key and unique key
  19. Simple Random Samples from a Sql database
  20. What does SQL clause “GROUP BY 1” mean?
  21. How can I prevent SQL injection in PHP?
  22. Generating a random & unique 8 character string using MySQL
  23. SQL select only rows with max value on a column
  24. Unknown Column In Where Clause
  25. SQL statement not working – “Operand type clash: date is incompatible with int’
  26. Repair all tables in one go
  27. #1062 – Duplicate entry for key ‘PRIMARY’
  28. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  29. Remove Primary Key in MySQL
  30. Is merge statement available in MySQL
  31. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  32. How to get the count of each distinct value in a column?
  33. Optimize WordPress Query that take 5 seconds to execute
  34. Multipart/formatted MySQL query problem
  35. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  36. Increment value (value = value+1) of $wpdb->update
  37. Inserting Post Meta From SQL
  38. wpdb Custom Meta Data with 2 conditions
  39. Extending the database
  40. wpdb prepare syntax
  41. SQL query not working in alphabetical post title/content search
  42. Proper way to work with wpdb to get user’s firstname
  43. How to check for empty and not a failure
  44. Database: Custom table: sprintf value for DateTime column
  45. Converting mysql to $wpdb
  46. WP_USE_EXT_MYSQL
  47. writing inner join in wpdb
  48. How to split the a table in database?
  49. MySQL Rank & $wpdb
  50. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  51. How do I join a $wpdb query with user meta using default value if not exist?
  52. How to translate this mySQL query to $wpdb query
  53. $wpdb select all meta for each post
  54. $wpdb to insert html form information
  55. Proper usage of $wpdb->update()?
  56. $wpdb->insert() does not Insert record in a table
  57. WordPress SQL Issue not returning correct reselts
  58. SQL command to convert all tags in lowercase?
  59. WordPress(wpdb class) and mysql stored procedures
  60. Can’t run database query
  61. How to stop $wpdb from prepending database name
  62. WordPress $wpdb get posts from category and sort by custom meta
  63. How can I add a new row in a separate database when someone registers via WordPress?
  64. Getting Error Trying to Create Table
  65. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  66. How can I write a formal sql query to get data from a custom table
  67. Understanding custom php that reads from WP MYSQL
  68. How to insert dash (-) into database using wpdb and new_to_publish hook?
  69. $wpdb->get_var multiple queries in one database check
  70. List users with the most posts in the last 30 days
  71. Insert two row in wordpress database
  72. WordPress $wpdb no result
  73. Database SQL query error
  74. Data is not constatntly loading from custom wordpress table
  75. MySQL ‘duplicate entry’ error
  76. User set date and time from frontend doesn’t get stored into database
  77. Wpdb query with dynamic table name
  78. get posts whether meta_key exists or not
  79. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  80. Lock wait timeout exceeded; try restarting transaction
  81. Delete oldest wordpress post (SQL query)
  82. How to search usermeta table
  83. How to add virtual column in wpdb get_result statement
  84. update_option returns false in AJAX, how to debug?
  85. Improving performance of SQL sub-queries in WordPress
  86. An SQL query to find orphaned image attachments and their meta
  87. CONCAT_WS in custom sql query
  88. MySQL Select within WP Page template
  89. Saving custom term value to the database in new table
  90. SQL error on restoring database
  91. optimise SQL wordpress call
  92. why is $wpdb->update() causing a DB error from within wp_set_password()
  93. Woocommerce: Grab total revenue of a product over all orders
  94. Delete posts with word count less than x number of words
  95. $wpdb->get_var returns 0
  96. Get all the related data from WordPress DB
  97. SQL command to export post_content from wp_posts using phpMyAdmin
  98. SQL get last entry of a specific gravity form
  99. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  100. Possible SQL injection. How to locate and fix?