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