Forum Replies Created

Viewing 1 replies (of 1 total)
  • Thread Starter kingpinzs

    (@kingpinzs)

    Sorry no it’s not. I was talking more like this.

    SELECT
    *
    FROM
    wp_users
    RIGHT JOIN
    wp_usermeta ON wp_usermeta.user_id = wp_users.ID
    RIGHT JOIN
    wp_woo_sr_orders ON wp_woo_sr_orders.billing_email = wp_users.user_email COLLATE utf8mb4_unicode_520_ci
    RIGHT JOIN
    wp_wusp_user_pricing_mapping ON wp_wusp_user_pricing_mapping.user_id = wp_woo_sr_orders.user_id
    #GROUP BY wp_users.ID
    HAVING COUNT(wp_usermeta.user_id)=0;

    which is still not right so I am still going through all the tables

    on another note there platform is to expensive so my boss wont pay for it

Viewing 1 replies (of 1 total)