########### PREFACE ################################

CREATE OR REPLACE VIEW invoiced_trades_view AS
(
SELECT il.trade_origin,
       il.trade_id,
       il.trade_line_id
  FROM invoice_head ih,
       invoice_line il
 WHERE ih.id = il.invoice_id
   AND ih.creditnote_id IS NULL
);

select * from invoiced_trades_view where 
    ->   ( trade_id = 16123 and trade_line_id = 52350 )
    -> or ( trade_id = 16129 and trade_line_id = 52370 )
    -> or ( trade_id = 16977 and trade_line_id = 55162 )
    -> or ( trade_id = 16984 and trade_line_id = 55185 );
+--------------+----------+---------------+
| trade_origin | trade_id | trade_line_id |
+--------------+----------+---------------+
| IWBMARKET    |    16123 |         52350 |
| IWBMARKET    |    16129 |         52370 |
| IWBMARKET    |    16984 |         55185 |
| IWBMARKET    |    16977 |         55162 |
+--------------+----------+---------------+

============ FAILING QUERY ==========================

SELECT *
FROM
(
(
SELECT 'IWBMARKET-1' trade_origin,
       it.trade_origin trade_origin_it,
       th.id trade_id,
       tl.id trade_line_id,
       tl.trader_id trader_id
  FROM trade_head th
       JOIN trade_line tl ON th.id = tl.trade_id
  LEFT JOIN invoiced_trades_view it ON it.trade_origin = 'IWBMARKET'
                                   AND it.trade_id = th.id
                                   AND it.trade_line_id = tl.id
 WHERE th.is_closed = 'Y'
   AND th.is_deleted = 'N'
   AND tl.is_deleted = 'N'
   AND tl.is_billable = 'Y'
   AND it.trade_origin IS NULL
)
UNION ALL
(
SELECT 'IWBMARKET-2' trade_origin,
       it.trade_origin trade_origin_it,
       th.id trade_id,
       tl.id trade_line_id,
       tl.trader_id trader_id
  FROM trade_head th
       JOIN trade_line tl ON tl.trade_id = th.id
  LEFT JOIN invoiced_trades_view it ON it.trade_origin = 'IWBMARKET'
                                   AND it.trade_id = th.id
                                   AND it.trade_line_id = tl.id
 WHERE th.is_closed = 'Y'
   AND th.is_deleted = 'N'
   AND tl.is_deleted = 'N'
   AND tl.is_billable = 'Y'
   AND it.trade_origin IS NULL 
)
) t
where trader_id = 1488
;

SELECT *
FROM
(
(
SELECT 'IWBMARKET-1' trade_origin,
       it.trade_origin trade_origin_it,
       th.id trade_id,
       tl.id trade_line_id,
       tl.trader_id trader_id
  FROM trade_head th
       JOIN trade_line tl ON th.id = tl.trade_id
  LEFT JOIN invoiced_trades_view it ON it.trade_origin = 'IWBMARKET'
                                   AND it.trade_id = th.id
                                   AND it.trade_line_id = tl.id
 WHERE th.is_closed = 'Y'
   AND th.is_deleted = 'N'
   AND tl.is_deleted = 'N'
   AND tl.is_billable = 'Y'
)
UNION ALL
(
SELECT 'IWBMARKET-2' trade_origin,
       it.trade_origin trade_origin_it,
       th.id trade_id,
       tl.id trade_line_id,
       tl.trader_id trader_id
  FROM trade_head th
       JOIN trade_line tl ON tl.trade_id = th.id
  LEFT JOIN invoiced_trades_view it ON it.trade_origin = 'IWBMARKET'
                                   AND it.trade_id = th.id
                                   AND it.trade_line_id = tl.id
 WHERE th.is_closed = 'Y'
   AND th.is_deleted = 'N'
   AND tl.is_deleted = 'N'
   AND tl.is_billable = 'Y'
)
) t
where trader_id = 1488
;

;+--------------+-----------------+----------+---------------+-----------+
| trade_origin | trade_origin_it | trade_id | trade_line_id | trader_id |
+--------------+-----------------+----------+---------------+-----------+
| IWBMARKET-1  | IWBMARKET       |    16123 |         52350 |      1488 |
| IWBMARKET-1  | IWBMARKET       |    16129 |         52370 |      1488 |
| IWBMARKET-1  | NULL            |    16977 |         55162 |      1488 |
| IWBMARKET-1  | NULL            |    16984 |         55185 |      1488 |
| IWBMARKET-2  | IWBMARKET       |    16123 |         52350 |      1488 |
| IWBMARKET-2  | IWBMARKET       |    16129 |         52370 |      1488 |
| IWBMARKET-2  | NULL            |    16977 |         55162 |      1488 |
| IWBMARKET-2  | NULL            |    16984 |         55185 |      1488 |
+--------------+-----------------+----------+---------------+-----------+
8 rows in set (0.86 sec)

SELECT *
FROM
(
(
SELECT 'IWBMARKET-1' trade_origin,
       it.trade_origin trade_origin_it,
       th.id trade_id,
       tl.id trade_line_id,
       tl.trader_id trader_id
  FROM trade_head th
       JOIN trade_line tl ON th.id = tl.trade_id
  LEFT JOIN invoiced_trades_view it ON it.trade_origin = 'IWBMARKET'
                                   AND it.trade_id = th.id
                                   AND it.trade_line_id = tl.id
       JOIN company c ON c.id = tl.company_id
 WHERE th.is_closed = 'Y'
   AND th.is_deleted = 'N'
   AND tl.is_deleted = 'N'
   AND tl.is_billable = 'Y'
   AND it.trade_origin IS NULL
)
UNION ALL
(
SELECT 'IWBMARKET-2' trade_origin,
       it.trade_origin trade_origin_it,
       th.id trade_id,
       tl.id trade_line_id,
       tl.trader_id trader_id
  FROM trade_head th
       JOIN trade_line tl ON tl.trade_id = th.id
  LEFT JOIN invoiced_trades_view it ON it.trade_origin = 'IWBMARKET'
                                   AND it.trade_id = th.id
                                   AND it.trade_line_id = tl.id
 WHERE th.is_closed = 'Y'
   AND th.is_deleted = 'N'
   AND tl.is_deleted = 'N'
   AND tl.is_billable = 'Y'
   AND it.trade_origin IS NULL
)
) t
where trader_id = 1488
;

+--------------+-----------------+----------+---------------+-----------+
| trade_origin | trade_origin_it | trade_id | trade_line_id | trader_id |
+--------------+-----------------+----------+---------------+-----------+
| IWBMARKET-1  | NULL            |    16123 |         52350 |      1488 |
| IWBMARKET-1  | NULL            |    16129 |         52370 |      1488 |
| IWBMARKET-1  | NULL            |    16977 |         55162 |      1488 |
| IWBMARKET-1  | NULL            |    16984 |         55185 |      1488 |
| IWBMARKET-2  | NULL            |    16977 |         55162 |      1488 |
| IWBMARKET-2  | NULL            |    16984 |         55185 |      1488 |
+--------------+-----------------+----------+---------------+-----------+
6 rows in set (0.77 sec)