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 IN(15993,15994,15995,15996,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020) GROUP BY p.id ORDER BY in_stock DESC,p.NULL, p.id LIMIT 24