nixCraft

Firstly Hi all i'm new here and VERY new to running my own server.

I set up a slow-query log to try and help me out and came across this entry that I just don't understand:-

(SELECT permissions, permissions2, FIND_IN_SET(forumid, '21,18,-1') AS pos, forumid
FROM moderator
WHERE userid = 44 AND forumid IN (21,18,-1)
ORDER BY pos ASC
LIMIT 1)
UNION
(SELECT permissions, permissions2, 0, forumid
FROM moderator
WHERE userid = 44 AND forumid = -1
);


Would it be possible for someone to explain this in very simple terms for me??

Thanks in advance
Fazer

Above sql is used to combine the result from multiple SELECT statements into a single result set.

__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help

I was just a bit concerned, as I am new to this, and it mentioned Moderator and user 44 in the same message, Now one thing I do know is that user 44 is not a moderator....

But I think I understand it now.............hopefully lol

Thanks for your reply

it says FROM moderator - that means it's trying to pull records about that users permissions from the moderator -table- in the db, presumably, to see if that user does have any moderator priviledges. If the user doesn't, the result would just come back empty (no records found in 'moderator' matching that user etc)