1054. Query Error 1054: Unknown column 'custom_status' in 'order clause' Query: SELECT DISTINCT p.*,p.id,alsobought.orders_count,(p.count > 0 || p.count IS NULL) AS in_stock FROM shop_product p JOIN (SELECT oi1.product_id, COUNT(*) orders_count FROM shop_order_items oi1 JOIN ( SELECT order_id FROM shop_order_items WHERE product_id = 33861 ORDER BY id DESC LIMIT 2000 ) t ON oi1.order_id = t.order_id WHERE oi1.product_id != 33861 AND oi1.type = "product" GROUP BY oi1.product_id ORDER BY orders_count DESC LIMIT 50) alsobought ON p.id = alsobought.product_id WHERE p.status = 1 ORDER BY custom_status = 'oos', alsobought.orders_count DESC, p.id LIMIT 5

Запрашиваемый ресурс недоступен.

Перейти на главную →