SELECT m.id as mid, m.owner_id as mowner_id, m.topic, m.group1, g.id as gid, g.owner_id as gowner_id, g.user_id as guser_id, gc.user_id as gcuser_id
FROM messages as m,
rubrics as r,
messages_rubrics as mr,
groups as g,
groups as gc
WHERE
(
m.id =mr.m_id AND m.owner_id =mr.m_owner_id AND
r.id = mr.r_id AND r.owner_id =mr.r_owner_id AND
r.synt_id in (1,2)
)
AND
(
(m.group1="" AND gc.owner_id='kukutz@suka' AND gc.id="self" AND g.id="self") OR
( m.group1 = g.id
AND
( ('kukutz@suka' = g.user_id AND gc.owner_id='kukutz@suka' AND gc.id="self") OR
( g.user_id = gc.owner_id AND gc.user_id = 'kukutz@suka' AND gc.id='members')
)))
AND g.owner_id = m.owner_id
AND m.date_server < '20030322191842'
ORDER BY m.date_server DESC
LIMIT 3
