select 
  order_item_id  as orders_products_id , order_id orders_id  ,
product_id  products_id, '' products_model, p.post_title  products_name, 
  product_net_revenue  /  product_qty products_price ,
 product_net_revenue    final_price,
 tax_amount   products_tax, product_qty  products_quantity 
  
  from  wptr_wc_order_product_lookup    oi
  join wptr_posts p on p.ID = oi.product_id  
  where   oi.order_id = %s