Error:

SELECT DISTINCT A.CategoryId AS Id, Category AS Value FROM tbl_gf_package_category A, tbl_gf_packages B WHERE A.CategoryId = B.CategoryId AND RetailService = 1 AND DisableCategory = 0 AND ArchivedCategory = 0 AND SL3BF = '0' ORDER BY OrderBy, Category Expression #1 of ORDER BY clause is not in SELECT list, references column 'unlockgeekz_dtbsunlckgeekz.A.OrderBy' which is not in SELECT list; this is incompatible with DISTINCT