SELECT SQL_CACHE p.sku,p.title,p.year,p.comment,p.actor,p.stars, p.category, i.quantity, i.quantity_rd, t.idx, p.release_date, p.red_rentonline, p.type, p.image
FROM products as p, list l, list_title t, inventory as i
WHERE l.idx = 110
and l.idx = t.list_idx
and t.sku = p.sku
and p.sku < 4000000
and p.sku = i.sku
ORDER BY p.stars desc
limit
0
, 48
[/tmp]
|
The real usefulness of...a book like '1,001 Movies You Must See Before You Die,' is that it provides good ideas for DVD rentals. I have, by the way, seen 943 of the 1,001 movies, and am carefully rationing the remaining titles to prolong my life. -Roger Ebert
|
We're enhancing our collection of these exceptional films. Feel free to add them to your queue or wishlist, even if they're currently checked out. A 'checked out' status means the DVDs are either lent to another customer or temporarily unavailable. Rest assured, we are continually replenishing
our inventory of unavailable DVDs, particularly those that many of you have added to your queue and wishlists.
|
|
1001 Movies You Must See Before You Die
[PREV 10]
[PREV]
1
2
3
4
5
6
7
8
9
10
[NEXT]
[NEXT 10]
[PREV 10]
[PREV]
1
2
3
4
5
6
7
8
9
10
[NEXT]
[NEXT 10]
|
