SELECT s.skuid, s.sku, s.skudesc, m.mfr_name, p.product, p.shortdesc, s.fmid, s.fmSyncTime, s.fmStatus, s.gs1_syncDate FROM tbl_PRD_Skus s with (nolock) LEFT OUTER JOIN tblManufacturers m with (nolock) ON (s.mfrid = m.mfr_id) LEFT OUTER JOIN tbl_PRD_Products p with (nolock) ON (p.prodid = s.prodid) WHERE s.ownerid = AND s.fsl_tableCode = AND (s.sku LIKE OR s.skudesc LIKE ) AND s.mfrid = AND s.prodid = AND s.skuid = ORDER BY sku,skudesc, mfr_name FOR json path, include_null_values