Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and s.sid = 20 ORDER BY c.`clrOrder`' at line 1
Query: SELECT DISTINCT(s.clrId), c.clrOrder FROM tblcolorpattern c, tblsizeclrptr s where c.clrId = s.clrid AND c.active=1 AND c.fabType= and s.sid = 20 ORDER BY c.`clrOrder`