MySQL WHERE Exists

where_exists.sql

SELECT * FROM orders AS orders_table
WHERE EXISTS
	(
	  SELECT * FROM orders_actions AS actions_table
	  WHERE actions_table.orders_id = orders_table.id
	  AND
	  (
            actions_table.action = 'order_created'
            OR actions_table.action = 'order_pending'
          )
        )
AND NOT EXISTS
	(
	  SELECT * FROM orders_actions AS actions_table
	  WHERE actions_table.orders_id = orders_table.id
	  AND
	  (
	    actions_table.action = 'order_transmit_confirmation_received'
          )
        );