SELECT i.id, i.state,p.product_code,specifications->'dimensions'->'width' AS width,
  specifications->'dimensions'->'height' AS height,
  o.sla, o.created_at, li.po,i.legacy_line_number AS ln, p.category
FROM mww_ondemand_api.orders o INNER JOIN mww_ondemand_api.line_items li ON o.id = li.order_id
INNER JOIN mww_ondemand_api.items i ON li.id = i.line_item_id
INNER JOIN mww_ondemand_api.products p ON p.product_code = li.product_code AND p.product_code = li.product_code
WHERE i.state IN ('received','not_valid') AND p.product_type != 'CA'