Help please write SQL Query for Checkbox Dynamic 11 PostsDirector777 5 years ago1TopicHello.I have a structure.Categories catid=32-Category1--Article1 state=1 -Category2 --Article2 state=0 -Category3--Article2 state=1 Etc.I need to get the ID of these articles from the parent category 32 in the Checkbox Dynamic field.Help please write free SQL Query. 1283 PostsBucklash 5 years ago0Level 1Along these lines....SELECT a.title AS text, a.id AS value FROM #__content AS a INNER JOIN #__categories AS b ON b.id = a.catid WHERE b.parent_id = 32Have to check database column names as is off top of me head