SELECT t1.sa_itemgroupid,
       t2.itemid,
       t1.changeby,
       t1.createby,
       t1.changedate,
       t1.createdate,
       t1.sa_brandid,
       t3.brandname,
       t1.groupnum,
       t1.itemno,
       t2.itemname,
       t1.groupname,
       t1.tradefield,
       t1.isonsale,
       t1.sequence,
       t1.sa_customschemeid,
       t4.schemename
FROM sa_itemgroup t1
         LEFT JOIN plm_item t2 ON t1.itemno = t2.itemno
    AND t1.siteid = t2.siteid
         LEFT JOIN sa_brand t3 ON t3.sa_brandid = t1.sa_brandid
    AND t3.siteid = t1.siteid
        LEFT JOIN sa_customscheme t4 ON t1.sa_customschemeid = t4.sa_customschemeid and t1.siteid=t4.siteid
where t1.sa_itemgroupid = $sa_itemgroupid$