WordPress database error: [Unknown column 'categoryIds' in 'where clause']select * from
(select count(distinct cp.id) as nr_listings, cp.activity_radius,cp.featured,
cp.id
from p0rt4lmcy_jbusinessdirectory_companies cp
left join p0rt4lmcy_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join p0rt4lmcy_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
where 1 and cc.categoryId in (223,223)
and cp.state=1 and (cp.approved = 2 or cp.approved= -1) and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)
group by cp.id
having 1
) s
where 1 and (0 or categoryIds REGEXP '\\b223\\b' or categoryIds REGEXP '\\b223\\b' )
WordPress database error: [Unknown column 'categoryIds' in 'where clause']select * from
(select count(distinct cp.id) as nr_listings, cp.activity_radius,cp.featured,
cp.id
from p0rt4lmcy_jbusinessdirectory_companies cp
left join p0rt4lmcy_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join p0rt4lmcy_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
where 1 and cc.categoryId in (223,223)
and cp.state=1 and (cp.approved = 2 or cp.approved= -1) and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)
group by cp.id
having 1
) s
where 1 and (0 or categoryIds REGEXP '\\b223\\b' or categoryIds REGEXP '\\b223\\b' )
WordPress database error: [Unknown column 'categoryIds' in 'where clause']select * from
(select count(distinct cp.id) as nr_listings, cp.activity_radius,cp.featured,
cp.id
from p0rt4lmcy_jbusinessdirectory_companies cp
left join p0rt4lmcy_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join p0rt4lmcy_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
where 1 and cc.categoryId in (223,223)
and cp.state=1 and (cp.approved = 2 or cp.approved= -1) and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)
group by cp.id
having 1
) s
where 1 and (0 or categoryIds REGEXP '\\b223\\b' or categoryIds REGEXP '\\b223\\b' )