SELECT b.SBROWSEPAGE, b.FPRODPERROW, b.FLISTORDER, b.SFLYPAGE,a.WGROUPID, a.WGROUPTYPEID, a.SDESCRIPTION, a.WPARENTGROUP2ID, a.WPARENTGROUP1ID, a.DSYSDATE, a.WSORTNO, a.BDISABLE, a.WCOLOR, a.WTEXTCOLOR
FROM GROUPS a join group_extra b on a.wgroupid = b.Wgroupid 
  where a.WGroupTypeId = 26 and (b.BNOUPLOAD is null or b.BNOUPLOAD = 0)

