SELECT K.id as ky_id,K.name as tag_name,`parent_id`,`level`,`is_parser`,K.`status`,`kytype`,title,description,UNCOMPRESS(content_bin) as content,url,img FROM keyword K JOIN ( SELECT * FROM `parser_keyword_nature` WHERE id = "142839249" ) P ON K.id = P.keyword_id WHERE K.status in (0,1)