MySQL Forums :: Transactions :: #1241 - Operand should contain 1 column(s)

hi where is my mistake in this query

#1241 - Operand should contain 1 column(s)

problem is with
first lines SELECT mobilenumber, message, datetime1
FROM readcsv
WHERE mobilenumber
IN

without this it is working fine


SELECT mobilenumber, message, datetime1
FROM readcsv
WHERE mobilenumber
IN (

SELECT node.nid AS nid, node_data_field_mobile.field_mobile_value AS node_data_field_mobile_field_mobile_value, node.type AS node_type, node.vid AS node_vid
FROM node node
INNER JOIN users_roles users_roles ON node.uid = users_roles.uid
LEFT JOIN content_type_profile node_data_field_mobile ON node.vid = node_data_field_mobile.vid
WHERE (
node.type
IN (
'profile'
)
)
AND (
users_roles.rid =5
)
)