Select para WordPress

De MochilaWiki

assim descobrir os status possíveis SELECT DISTINCT post_status FROM wsf_posts WHERE post_type LIKE 'shop_order'


SELECT ID, post_status, post_title, post_content, post_excerpt, guid FROM `wsf_posts` WHERE (`post_status` = 'publish' OR `post_status` = 'draft') AND `post_type` = 'product' ORDER BY `ID` ASC

SELECT ID, post_status, post_title, post_content, post_excerpt, guid FROM `wsf_posts` WHERE `post_type` = 'product' ORDER BY `ID` ASC

https://www.mattzajac.co.uk/sql-query-export-woocommerce-products/ https://www.84em.com/sql-query-to-find-all-woocommerce-products-that-do-not-have-an-image/