1054. Query Error 1054: Unknown column 'p.NULL' in 'ORDER BY'
Query: SELECT p.*,p.id,p.sku_id,p.image_id,p.image_filename,p.ext,(p.count > 0 || p.count IS NULL) AS in_stock
FROM shop_product p
JOIN shop_category_products cp1
ON p.id = cp1.product_id
WHERE p.type_id IN (2)
AND p.status = 1
AND cp1.category_id = 12855
GROUP BY p.id
ORDER BY in_stock DESC,p.NULL, p.id
LIMIT 24
8 800 551-72-04