Evo resenja
Kôd:
(
select items.* from items left join owners_items on (items.id = owners_items.itemid and owners_items.ownerid = $ownerid)
where type = '$type'
and min_level<=$level
and owners_items.itemid is null
and parent = -1
)
UNION
(
select items.* from items left join owners_items on (items.id = owners_items.itemid and owners_items.ownerid = $ownerid)
where type = '$type'
and min_level<=$level
and owners_items.itemid is null
and parent in (
select items.itemid from
items left join
owners_items on (items.id = owners_items.itemid and owners_items.ownerid = $ownerid)
where owners_items.itemid is not null
)
)
Ako neko ima ideju kako ovo da se ulepsa, shoot