11 Posts
Director777
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.

Get a VIP membership
1283 Posts
Bucklash
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

Get a VIP membership