(SELECT cv.id FROM custom_variables cv LEFT JOIN custom_variable_configs cvc ON (cv.config_id = cvc.id)
WHERE module LIKE 'ShipTo'
AND NOT EXISTS (SELECT shipto_id FROM shipto WHERE shipto_id = cv.trans_id));
(SELECT cv.id FROM custom_variables cv LEFT JOIN custom_variable_configs cvc ON (cv.config_id = cvc.id)
WHERE module LIKE 'ShipTo'
AND NOT EXISTS (SELECT shipto_id FROM shipto WHERE shipto_id = cv.trans_id));