Error

(goDatabase.Execute) Error Executing Query: 1054

Unknown column 'b.id_mgm' in 'field list'

SQL Statement:

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(?)

Input Array:

Array
(
    [0] => kaizenrealty.my
)


Please contact your System Administrator for further information.
 
/