11 Posts
5 years ago
1
Topic
Hello.
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 Posts
5 years ago
0
Level 1
Along 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 = 32
Have to check database column names as is off top of me head