SELECT distinct tblcolorpattern.* FROM tblcolorpattern , tblsizeclrptr where tblcolorpattern.clrId = tblsizeclrptr.clrid and tblsizeclrptr .sid = 67 and tblcolorpattern.`fabType` = 1 and tblcolorpattern.fabGroup = 0 and tblcolorpattern.active = 1 AND tblsizeclrptr .active=1 ORDER BY tblcolorpattern.clrOrder


SELECT distinct tblcolorpattern.* FROM tblcolorpattern , tblsizeclrptr where tblcolorpattern.clrId = tblsizeclrptr.clrid and tblsizeclrptr .sid = 67 and tblcolorpattern.`fabType` = 1 and tblcolorpattern.fabGroup = 21 and tblcolorpattern.active = 1 AND tblsizeclrptr .active=1 ORDER BY tblcolorpattern.clrOrder


SELECT distinct tblcolorpattern.* FROM tblcolorpattern , tblsizeclrptr where tblcolorpattern.clrId = tblsizeclrptr.clrid and tblsizeclrptr .sid = 67 and tblcolorpattern.`fabType` = 1 and tblcolorpattern.fabGroup = 18 and tblcolorpattern.active = 1 AND tblsizeclrptr .active=1 ORDER BY tblcolorpattern.clrOrder


SELECT distinct tblcolorpattern.* FROM tblcolorpattern , tblsizeclrptr where tblcolorpattern.clrId = tblsizeclrptr.clrid and tblsizeclrptr .sid = 67 and tblcolorpattern.`fabType` = 1 and tblcolorpattern.fabGroup = 16 and tblcolorpattern.active = 1 AND tblsizeclrptr .active=1 ORDER BY tblcolorpattern.clrOrder


SELECT distinct tblcolorpattern.* FROM tblcolorpattern , tblsizeclrptr where tblcolorpattern.clrId = tblsizeclrptr.clrid and tblsizeclrptr .sid = 67 and tblcolorpattern.`fabType` = 1 and tblcolorpattern.fabGroup = 6 and tblcolorpattern.active = 1 AND tblsizeclrptr .active=1 ORDER BY tblcolorpattern.clrOrder


SELECT distinct tblcolorpattern.* FROM tblcolorpattern , tblsizeclrptr where tblcolorpattern.clrId = tblsizeclrptr.clrid and tblsizeclrptr .sid = 67 and tblcolorpattern.`fabType` = 1 and tblcolorpattern.fabGroup = 20 and tblcolorpattern.active = 1 AND tblsizeclrptr .active=1 ORDER BY tblcolorpattern.clrOrder