Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- /** Post ID **/
- p.id,
- /** Product Code **/
- /*mt.meta_value AS sku,*/
- /** Product Stock **/
- /* m.meta_value AS stock, */
- /** Item Title **/
- p.post_title AS title,
- /** Item Description **/
- p.post_content AS description /*,*/
- /** Item Price **/
- /* pt.meta_value AS price ,*/
- /** Item Weight **/
- /* wt.meta_value AS weight */
- FROM
- sf_posts p
- /*
- INNER JOIN sf_postmeta m ON (
- p.id = m.post_id
- )
- INNER JOIN sf_postmeta mt ON (
- p.id = mt.post_id
- )
- INNER JOIN sf_postmeta pt ON (
- p.id = pt.post_id
- )
- INNER JOIN sf_postmeta wt ON (
- p.id = wt.post_id
- )
- */
- WHERE
- p.post_type = 'product'
- /*AND
- m.meta_key = '_stock'
- AND
- mt.meta_key = '_sku'
- AND
- pt.meta_key = '_price'
- AND
- wt.meta_key = '_weight'
- */
Add Comment
Please, Sign In to add comment