Woocommerce SQL

Basic WooCommerce MySQL queries for Orders, Products and Categories : http://zjstech.com/basic-woocommerce-mysql-queries-for-orders-products-and-categories/

Get all products : http://stackoverflow.com/questions/26425192/get-all-products-from-english-version-woocommerce-wpml

SQL – Pull products of particular category http://wordpress.stackexchange.com/questions/155489/sql-pull-products-of-particular-category-from-a-remote-wordpress-woocommerce-d

Post imge URL:

SELECT p.guid FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.meta_value=p.ID
WHERE pm.post_id = $post_id
AND pm.meta_key = ‘_thumbnail_id’
ORDER BY p.post_date DESC

http://icodehub.in/get-featured-image-of-post-in-wordpress-using-mysql-query/

Blogbook : PHP | Javascript | Laravel | Corcel | CodeIgniter | VueJs | ReactJs | WordPress