/* orders which require an order flag under current order flag requiremnt rules and do not currently have an order flag */
SELECT *
FROM orders
WHERE                              /* order flag requirments               */
(
(orders.profit_margin <= 14.99)    /* order_flag_requirment_condition_id 1 */
OR
(orders.profit_margin >= 0.00)     /* order_flag_requirment_condition_id 2 */
OR
(orders.profit_margin <= -1.00)    /* order_flag_requirment_condition_id 3 */
)
AND
orders.order_flag_id IS NULL
AND inserted = TRUE
AND deleted_at IS NULL