drop view if exists view_comm_from_zem;
create view view_comm_from_zem as
select
id, seller_id, type,
offer,
city, district, street, add_address,
square_min, square_max,
price_calc, price_min, price_max, price_type,
name, detail, date, bal,
price_ALL_min, price_ALL_max,
promo, draw,
checked_date,
detail_delo, delo_cnt,
0 as nazn,
'N' as go2delo,
phone_num, phone_cont,
imgs,
0 as house,
'N' as ymap,
'N' as payed_delo,
'0000-00-00 00:00:00' as s_date,
street_id,
disable_stat, disable_stat_comment,
failed_fields, failed_checkers, special_offer, 0 as realty_id,
square_unit
from zem
where draw='Y' and not (nazn & ((1 << 2) | (1 << 4)));