insert into circle select code_model as id1, (select code_model from model where code_type=200 and code_output=1 and code_model not in (select distinct(circle_ip) from circle group by circle_ip having count(*)>=11 ) limit 1) as id2 , 0 from model where code_type=200 and code_output=1 and code_model not in (select distinct(code_model) from circle group by code_model having count(*)>=11) and id1id2 limit 11дает Unknown column 'id1' in 'where clause'почему?Задача вставить в таблицу c полями id1 и id2 записи, чтобы id1id2
|