Select para WordPress
De MochilaWiki
Revisão de 20h37min de 25 de março de 2018 por Banto Palmarino (discussão | contribs) (Criou página com '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_exce...')
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/
