I have developed an SQL query that obtains all posts in my site that contain certain keywords, but I’d like to restrict the posts to a specific category id. Does anyone know how to do that given that (it appears) category_id is not one of the fields in the “posts” table? Here is my query (which I…

Just needed to extend the WHERE clause to search the topic_id against the topics table, which will have the category_id column. -- [params] -- int :category_id -- string_list :first_list_of_keywords -- null string_list :second_list_of_keywords WITH FirstFilter AS ( SELECT * FROM posts …

Getting All Posts for a Given Category ID Matching Certain Parameters

Community Building Data & reporting

JohnMcDonald (John McDonald) March 17, 2025, 5:22pm 3

Thanks, this worked.

Topic		Replies	Views
User-posted code blocks in a category Data & reporting sql-query	3	381	May 13, 2024
Created a topic in a specific category with conditions Data & reporting sql-triggered-badge	0	208	December 26, 2022
Categories and their Subcategories using OR Data & reporting sql-query , sql-tutorial	0	507	August 25, 2023
Data explorer query: find posts without replies Data & reporting sql-query	4	1017	February 15, 2021
Need help with an SQL badge query Data & reporting sql-triggered-badge	5	1455	December 3, 2019

Getting All Posts for a Given Category ID Matching Certain Parameters

Related topics