How select posts not protected

[Anonymous]

Hi,

is there a way to list posts not protected (if necessary using PhpMyAdmin)?

Now I have a lot of posts and some of these could not protected, I need to find them, so I can edit and update.
Thank you.

[nur]

Hi,
protected posts are stored as serialized object in wp_swpm_membership_tbl.

you can retrieve them using:

SELECT post_list FROM  <code>wp_swpm_membership_tbl</code> WHERE id =1

once you deserialize the object, you can build query in phpmyadmin to retrieve posts not protected.

[Author]

Posts