Код: Выделить всё
SELECT orders.id , orders.number_id, orders.partner_id, orders.free, partners.title
FROM `partners`,`orders` WHERE `number_id`= $old_num
AND (
free ='1' AND partner_id NOT IN (SELECT partner_id FROM orders WHERE free = '1' AND number_id = $new_num)
OR free !='1' AND partner_id NOT IN (SELECT partner_id FROM orders WHERE free != '1' AND number_id = $new_num)
)
AND partners.id=orders.partner_id AND partners.active='1'
ORDER BY partners.title