SELECT j.*,b.bname,c.colname
                                FROM Brands b, JeffStore j, Collections c
                                WHERE
                                        
                                        j.isactive=1 AND
                                        j.bid= AND
                                        b.bid=j.bid AND
                                        c.colid=j.colid
                                ORDER BY c.colname,j.model