Line 1: select
2: a.domain_url, a.id_domain, a.inf_cre_dt,
3: a.id_owner, a.name as domain_name,
4: a.filter_ownership, a.filter_price, a.filter_category,
5: a.filter_location,
6: b.id_agency, b.id_mgm,
7: b.name as agency_name, b.nickname as agency_nickname, b.reg_no as agency_reg_no,
8: b.conf_allow_without_ren_tag, b.conf_allow_buddy_agent,
9: b.subscription_status
10: from sys_domain a
11: left outer join age_agency b on b.id_agency = a.id_owner
12: where ( a.category = 'MC' or
13: a.category = 'AG'
14: )
15: and lower(a.domain_url) = lower(?) |