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