I´m searching for sql-query that i can insert in plugin "Data Table Generator" but I didn´t find the correct thing for my needs.
I like to build a price table that is printed on single product page or in product widget, based on product price – calculatet with formulas.
For that i need an excel-conform sql query to pull product price from actual product id.
Anything like:
SELECT * FROM [‘posts’ WHERE ‘post_type’ = ‘product’]
I´m such a big sql noob. Can anyone help please?