Shop

        SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
        FROM wp_posts
        LEFT JOIN wp_term_relationships ON wp_posts.ID = wp_term_relationships.object_id
        LEFT JOIN wp_wc_product_meta_lookup wc_product_meta_lookup ON wp_posts.ID = wc_product_meta_lookup.product_id
        WHERE wp_posts.post_type = 'product' 
          AND wp_posts.post_status = 'publish'
        GROUP BY wp_posts.ID
        ORDER BY wc_product_meta_lookup.min_price ASC, wp_posts.ID ASC
        LIMIT 16