How to get "published" status of a node from the database interface?


I would like to list all the unpublished nodes from the database interface, how can I do it?

Many thanks!

Cheers, Baosong

Hello Baosong,

What exactly do you mean by DB interface?



something like?

Select * from node_filed_data where status = 0;

Database administration under CERN infrastructure.

#1146 - Table ‘ds990216.node_filed_data’ doesn’t exist

typo on the table name

use node_field_data instead

Fantastic! Thanks a lot!