SELECT distinct tblcolorpattern.* FROM tblcolorpattern , tblsizeclrptr where tblcolorpattern.clrId = tblsizeclrptr.clrid and tblsizeclrptr .sid = 38 and tblcolorpattern.`fabType` = 2 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 = 38 and tblcolorpattern.`fabType` = 2 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 = 38 and tblcolorpattern.`fabType` = 2 and tblcolorpattern.fabGroup = 3 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 = 38 and tblcolorpattern.`fabType` = 2 and tblcolorpattern.fabGroup = 8 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 = 38 and tblcolorpattern.`fabType` = 2 and tblcolorpattern.fabGroup = 20 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 = 38 and tblcolorpattern.`fabType` = 2 and tblcolorpattern.fabGroup = 9 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 = 38 and tblcolorpattern.`fabType` = 2 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 = 38 and tblcolorpattern.`fabType` = 2 and tblcolorpattern.fabGroup = 17 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 = 38 and tblcolorpattern.`fabType` = 2 and tblcolorpattern.fabGroup = 4 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 = 38 and tblcolorpattern.`fabType` = 2 and tblcolorpattern.fabGroup = 44 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 = 38 and tblcolorpattern.`fabType` = 2 and tblcolorpattern.fabGroup = 2 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 = 38 and tblcolorpattern.`fabType` = 2 and tblcolorpattern.fabGroup = 7 and tblcolorpattern.active = 1 AND tblsizeclrptr .active=1 ORDER BY tblcolorpattern.clrOrder