mysql - IN condition and equal condition in a select query return incorrect data -

mysql - IN condition and equal condition in a select query return incorrect data -

this query.

select * users 'imported' = 0 , (id in (select distinct(author_id) articles) or id in (select distinct(photographer_id) articles)) limit 20

i have 2 conditions in query.

'imported' = 0

and

(id in (select distinct(author_id) articles) or id in (select distinct(photographer_id) articles))

my problem info set returned contains rows imported = 1 don't want.

can 1 help me.

use backticks identifiers not single quotes

where `imported` = 0

mysql sql