SELECT distinct tblcolorpattern.* FROM tblcolorpattern , tblsizeclrptr where tblcolorpattern.clrId = tblsizeclrptr.clrid and tblsizeclrptr .sid = 45 and tblcolorpattern.`fabType` = 3 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 = 45 and tblcolorpattern.`fabType` = 3 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 = 45 and tblcolorpattern.`fabType` = 3 and tblcolorpattern.fabGroup = 13 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 = 45 and tblcolorpattern.`fabType` = 3 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 = 45 and tblcolorpattern.`fabType` = 3 and tblcolorpattern.fabGroup = 14 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 = 45 and tblcolorpattern.`fabType` = 3 and tblcolorpattern.fabGroup = 10 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 = 45 and tblcolorpattern.`fabType` = 3 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 = 45 and tblcolorpattern.`fabType` = 3 and tblcolorpattern.fabGroup = 12 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 = 45 and tblcolorpattern.`fabType` = 3 and tblcolorpattern.fabGroup = 11 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 = 45 and tblcolorpattern.`fabType` = 3 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 = 45 and tblcolorpattern.`fabType` = 3 and tblcolorpattern.fabGroup = 19 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 = 45 and tblcolorpattern.`fabType` = 3 and tblcolorpattern.fabGroup = 15 and tblcolorpattern.active = 1 AND tblsizeclrptr .active=1 ORDER BY tblcolorpattern.clrOrder