SELECT distinct tblcolorpattern.* FROM tblcolorpattern , tblsizeclrptr where tblcolorpattern.clrId = tblsizeclrptr.clrid and tblsizeclrptr .sid = 42 and tblcolorpattern.`fabType` = 6 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 = 42 and tblcolorpattern.`fabType` = 6 and tblcolorpattern.fabGroup = 22 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 = 42 and tblcolorpattern.`fabType` = 6 and tblcolorpattern.fabGroup = 39 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 = 42 and tblcolorpattern.`fabType` = 6 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 = 42 and tblcolorpattern.`fabType` = 6 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 = 42 and tblcolorpattern.`fabType` = 6 and tblcolorpattern.fabGroup = 5 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 = 42 and tblcolorpattern.`fabType` = 6 and tblcolorpattern.fabGroup = 10 and tblcolorpattern.active = 1 AND tblsizeclrptr .active=1 ORDER BY tblcolorpattern.clrOrder