Вот:
<?
$rs=mysql_query('
SELECT i. * , i.id as iid, p. * , l. * , g.id bags_id, g.itext, c.icon, c.name clan_name, m.name magic_name, m.percent magic_percent
FROM (item i, item_prototype p, item_levels l, item_group ig, users_bags g)
LEFT JOIN (clan c) ON (abs( p.req_clan_id ) = c.id)...