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(16754,16755,16756,16757,16758,16759,16760,16761,16762,16763,16764,16765,16766,16767,16768,16769,16770,16771,16772,16773,16774,16775,16776,16777,16778,16779,16780,16781,16782,16783,16784,16785,16786,16787,16788,16789,16790,16791,16792,16793,16794,16795,16796,16797,16798,16799,16800,16801,16802,16803,16804,16805,16806,16807,16808,16809,16810,16811,16812,16813,16814,16815,16816,16817,16818,16819,16820,16821,16822,16823,16824,16825,16826) GROUP BY p.id ORDER BY in_stock DESC,p.NULL, p.id LIMIT 24