Error:

SELECT BD.BrandId, BD.BrandName, BD.OrderBy AS BrandOrder, CT.OrderBy AS CatOrder, CT.Category, StoreConcatLink, Slug, S.Id AS ServiceStatusId, S.ServiceStatus, A.*, CONCAT(C.FirstName, ' ', C.LastName) AS CustomerName FROM tbl_gf_store_services A JOIN tbl_gf_store_services_cat B ON A.Id = B.StoreServiceId JOIN tbl_gf_category CT ON CT.CategoryId = B.CategoryId JOIN tbl_gf_category_brands BD ON BD.BrandId = B.BrandId JOIN tbl_gf_customers C ON C.CustomerId = A.CustId JOIN tbl_gf_store_services_status S ON A.Status = S.Id WHERE A.IsDisabled = 0 AND A.Price > 0 AND A.Status = 2 AND A.CustId = '6926' AND BD.BrandId IN () GROUP BY A.Id ORDER BY BD.OrderBy, CT.OrderBy ASC

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY A.Id ORDER BY BD.OrderBy, CT.OrderBy ASC' at line 19