/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
--- Ð—Ð°Ð¿Ñ€Ð¾Ñ Ð²Ñ‹Ð¿Ð¾Ð»ÑнетÑÑ Ð±Ð¾Ð»ÐµÐµ 1 минуты и (почему-то) неправильно Ñчитает numberOfPurchase --- Оптимизируйте Ð·Ð°Ð¿Ñ€Ð¾Ñ (без Ð¸Ð·Ð¼ÐµÐ½ÐµÐ½Ð¸Ñ Ð¸Ð½Ð´ÐµÐºÑов) --- Hint: тормозит ORDER BY numberOfPurchase SELECT DISTINCT cache.item_id, COUNT(oi.id) AS numberOfPurchase FROM cache_item_country_language cache LEFT JOIN OwnedItem oi ON oi.item_id = cache.item_id WHERE cache.language_id = 'eng' AND cache.item_type = 'book' GROUP BY cache.item_id ORDER BY numberOfPurchase DESC LIMIT 5;