连接2表订单wordpress插件

Question

我有两张桌子wp_wcfm_marketplace_orders wp_wcfm_affiliate_orders

我需要wp_wcfm_affiliate_orders.orderid wp_wcfm_marketplace_orders.order_id的呼叫数据

it代码调用数据表wp_wcfm_affiliate_orders

    public function processing() {
        global $WCFM, $wpdb, $_POST, $WCFMu, $WCFMaf;

        $length = $_POST['length'];
        $offset = $_POST['start'];

        $affiliate_id = $_POST['wcfm_affiliate']; 
        $status          = $_POST['status_type'];

        $sql  = "SELECT COUNT(ID) FROM `{$wpdb->prefix}wcfm_affiliate_orders`";
        $sql .= " WHERE 1=1";
        $sql .= " AND {$wpdb->prefix}wcfm_affiliate_orders.affiliate_id = {$affiliate_id}";
        if( $status ) $sql .= " AND {$wpdb->prefix}wcfm_affiliate_orders.commission_status = '{$status}'";
        $sql .= ' AND `is_trashed` = 0';
        $affiliate_count = $wpdb->get_var( $sql );

        // Get Product Count
        $sql  = "SELECT  * FROM  {$wpdb->prefix}wcfm_affiliate_orders  ";
        $sql .= " WHERE 1=1";
        $sql .= " AND {$wpdb->prefix}wcfm_affiliate_orders.affiliate_id = {$affiliate_id} 

        ";
        if( $status ) $sql .= " AND {$wpdb->prefix}wcfm_affiliate_orders.commission_status = '{$status}'";
        $sql .= ' AND `is_trashed` = 0';
        $sql .= " ORDER BY `ID` DESC";
        $sql .= " LIMIT {$length}";
        $sql .= " OFFSET {$offset}";


        $wcfm_affiliate_orders_array = $wpdb->get_results( $sql );
        $wcfm_affiliate_order_count  = count( $wcfm_affiliate_orders_array );

Answer 1

// Get Product $sql =“从{$wpdb->前缀} wcfm_affiliate_orders选择wcfm_affiliate_orders左联接{$wpdb->前缀}wcfm_marketplace_orders AS ya ON ya.order_id = wcfm_affiliate_orders.order_id "；$sql .=”WHERE 1=1"；$sql .=和wcfm_affiliate_orders.affiliate_id = {$affiliate_id}

    ";
    if( $status ) $sql .= " AND  wcfm_affiliate_orders.commission_status = '{$status}'";

    $sql .= " ORDER BY  wcfm_affiliate_orders.ID  DESC";
    $sql .= " LIMIT {$length}";
    $sql .= " OFFSET {$offset}";


    $wcfm_affiliate_orders_array = $wpdb->get_results( $sql );