500! Ошибка сервера! Мы уже работаем над решением этой проблемы. Перейти на главную (Посетите данную страницу позже) |
------------------------
Status: 500
Message: MySQL Select: Not unique table/alias: 'products' SQL:
SELECT
forester_products.id,
forester_products.position as lastid,
forester_products.kedoff_id as kedoff_id,
forester_products.name as name,
forester_products.name_tran as name_tran,
forester_products.img,
(SELECT preview FROM products WHERE products.id = kedoff_id) as img_kedoff,
forester_products.part,
forester_products.3d,
forester_products.price,
forester_products.discount,
forester_products.video,
forester_products.position as pos,
forester_products.type,
forester_products.img_type,
forester_products.url,
IF(forester_products.discount,forester_products.discount,forester_products.price) as forester_price,
(
SELECT
size.id
FROM
size
INNER JOIN
product_size
ON
size_id = size.id
WHERE
product_size.product_id = forester_products.kedoff_id
ORDER BY
size.value ASC
LIMIT 1
) as size_id,
IF(products.discount,products.discount,IF(products.price,products.price,IF(forester_products.discount,forester_products.discount,forester_products.price))) as actual_price,
(SELECT GROUP_CONCAT(value ORDER BY value ASC SEPARATOR ", ") FROM size INNER JOIN product_size ON size.id = product_size.size_id WHERE product_id = products.id AND product_size.count>0) as sizes,
new,
hit,
in_stock,
pending
,(
IF(forester_products.id LIKE "132125",10001,0)
+
IF(forester_products.name LIKE "132125",10000,0)
+
IF(forester_products.name LIKE "132125%",5000,0)
+
IF(forester_products.name LIKE "%132125%",50,0)
+
IF(forester_products.part LIKE "%132125%",100,0)
+
IF((SELECT forester_products.id FROM forester_products JOIN forester_category_bind_product ON forester_category_bind_product.product_id = forester_products.id JOIN category ON forester_category_bind_product.category_id = category.id WHERE category.name LIKE "%132125%" LIMIT 1),50,0)
) AS rating
, 1 as sort
FROM
forester_products
JOIN
forester_category_bind_product
ON
forester_category_bind_product.product_id = forester_products.id
JOIN
products
ON
products.id = forester_products.kedoff_id
JOIN
category
ON
forester_category_bind_product.category_id = category.id
JOIN
products
ON
products.id = forester_products.kedoff_id
WHERE forester_products.price != 0 AND forester_products.deactive = 0 AND (products.pending = 1 OR products.in_stock > 0) GROUP BY forester_products.id HAVING sizes!="" AND rating !=0 ORDER BY rating desc, id desc LIMIT 21, 21
URI: /search/132125_2.html
Query String:
IP: 162.158.79.121
User Agent: claudebot
Refer:
Time: 16:03:42
------------------------