whats wrong with this?

[Slynderdale]

function getpictureurl($userid) {
global $DB_site,$session;

if ($pictureinfo=$DB_site->query_first("SELECT user.pictureid NOT ISNULL(picturedata) AS hascustom
FROM user
LEFT JOIN userpicture ON userpicture.userid=user.userid
WHERE user.userid='$userid'")) {
if ($pictureinfo['hascustom']) {
return "userpicture.php?userid=$userid&dateline=$pictureinfo[dateline]";
} else {
return '';
}
}
}

[Slynderdale]

Database error in vBulletin 2.2.3:

Invalid SQL: SELECT user.pictureid NOT ISNULL(picturedata) AS hascustom
FROM user
LEFT JOIN userpicture ON userpicture.userid=user.userid
WHERE user.userid='1'
mysql error: You have an error in your SQL syntax near 'ISNULL(picturedata) AS hascustom
FROM ' at line 1

mysql error number: 1064

[Neo]

Try using NULL instead of ISNULL

[Admin]

A comma is missing before NOT ISNULL.