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]
|