CREATE OR REPLACE VIEW `op_customers` (realid,virtualid) AS SELECT DISTINCT `users`.`login` AS `realid`, `users`.`login` AS `virtualid` FROM `users` LEFT JOIN `op_denied` ON `users`.`login` = `op_denied`.`login` WHERE `op_denied`.`login` IS NULL UNION SELECT DISTINCT `contracts`.`login` AS `realid`, `contracts`.`contract` AS `virtualid` FROM `contracts` LEFT JOIN `op_denied` ON `contracts`.`login` = `op_denied`.`login` WHERE `op_denied`.`login` IS NULL AND `contracts`.`contract` !='' AND `contracts`.`contract` IS NOT NULL