Da to deluje OK. To je otprilike isto sto sam napisao i ja gore (samo bez dodatnih uslova, koji nisu ni bitni
za ovu polemiku).
Samo je fora (zasto izbegavam IN)
Select ItemID from owners_items where ownerid =
wnerInQuestion
u teoriji moze da vrati do 0.5mil redova.
I ja kazem
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
)
sto mi se ni malo ne dopada.