If statements in a query. What for?

[scottm]

Hi,

Can someone tell me what the IFs are doing in this query?

SELECT issue.*,category.*,user.username,IF(assignedtoid=$userinfo[userid],1,IF(assignedtoid=0,1,1)) AS assignorder FROM issue,catassoc,category,user WHERE issue.flagged=0 AND issue.open=1 AND issue.catid=catassoc.catid AND catassoc.userid=$userinfo[userid] AND category.catid=catassoc.catid AND issue.assignedtoid=user.userid ORDER BY assignorder,issue.lastpost DESC

Thanks for any help.

Scott

[the_Igel]

seems that nothing, as they return 1 in any case.