In stock

Speed

Model: DVD-SPEED

Regional Code: 2 (Japan, Europe, Middle East, South Africa). Languages: English, Deutsch. Subtitles: English, Deutsch, Spanish. Audio: Dolby Surround 5.1. Picture Format: 16:9 Wide-Screen. Length: (approx) 112 minutes. Other: Interactive Menus,...

€47.10

Qty:

Manufacturer
Fox

Model
DVD-SPEED

Description:

Regional Code: 2 (Japan, Europe, Middle East, South Africa).
Languages: English, Deutsch.
Subtitles: English, Deutsch, Spanish.
Audio: Dolby Surround 5.1.
Picture Format: 16:9 Wide-Screen.
Length: (approx) 112 minutes.
Other: Interactive Menus, Chapter Selection, Subtitles (more languages).

In stock

Courage Under Fire

Regional Code: 2 (Japan, Europe, Middle East, South Africa). Languages: English,...

Model: DVD-CUFI

€45.92

Add to Basket

You have an error in your SQL syntax

[Hide]

1213 - Deadlock found when trying to get lock; try restarting transaction

update products p, (SELECT `p`.`products_id`, 0 + (select 0 +ifnull(sum(if(pp.viewed_date > now() - interval 7 day, 0, ifnull(pp.products_viewed, 0))),0) * 0.02 + ifnull(sum(ifnull(pp.products_viewed, 0)),0) * 0.01 from products_popularity pp where p.products_id = pp.products_id) + (select sum(products_viewed) * 0.001 from products_description pd where p.products_id = pd.products_id)+ (select ifnull(sum(products_quantity),0) * 2 from customers_wishlist wl where p.products_id = wl.products_id) +ifnull(sum(if(o.date_purchased > (now() - interval 7 day), 0, op.products_quantity)),0) * 1 +ifnull(sum(if(o.date_purchased > (now() - interval 7 day), 0, op.products_quantity)),0) * 0.5 AS `popularity` FROM `products` `p` LEFT JOIN `orders_products` `op` ON op.products_id = p.products_id LEFT JOIN `orders` `o` ON o.orders_id = op.orders_id and o.date_purchased >= now() - interval 30 day WHERE `p`.`products_id`=17 GROUP BY `p`.`products_id`) stat set p.products_popularity=0+ if(p.products_new_until>="2026-05-10", 5, 0)+ p.products_ordered* 0.02+ stat.popularity where p.products_id=stat.products_id

Filename: lib/common/components/Popularity.php
Line: 186