query fail:

SELECT `id`, `name`, `url`, 
						(SELECT count(*) FROM `main`.`pred` AS `pt` WHERE `pt`.otr LIKE CONCAT('%;',`main`.`otr`.id,';%') AND `pt`.`on_off`!='0' AND country_id = '0') AS `sub_count` FROM `main`.`otr` WHERE `sub_otr` like '%;69;%'

SafeMySQL: Unknown column 'country_id' in 'where clause'. Full query: [SELECT `id`, `name`, `url`, (SELECT count(*) FROM `main`.`pred` AS `pt` WHERE `pt`.otr LIKE CONCAT('%;',`main`.`otr`.id,';%') AND `pt`.`on_off`!='0' AND country_id = '0') AS `sub_count` FROM `main`.`otr` WHERE `sub_otr` like '%;69;%']