Re: Nested Sets vs. Nested Intervals
From: asdf <xyz91234_at_yahoo.com>
Date: 4 Dec 2005 10:12:42 -0800
Message-ID: <1133719962.641882.81630_at_g49g2000cwa.googlegroups.com>
ORDER BY listings.rating DESC LIMIT 0, 10 Received on Sun Dec 04 2005 - 19:12:42 CET
Date: 4 Dec 2005 10:12:42 -0800
Message-ID: <1133719962.641882.81630_at_g49g2000cwa.googlegroups.com>
UNTIL cnt >= 10
END REPEAT;
SELECT listings.*
FROM listings
WHERE listings.lft_index
BETWEEN node.a11/node.a21 - 0.00000001 ANDAND listings.rating >= number
(node.a11-node.a12)/(node.a21-node.a22) + 0.00000001
ORDER BY listings.rating DESC LIMIT 0, 10 Received on Sun Dec 04 2005 - 19:12:42 CET