has_and_belongs_to_many :brands, {:finder_sql => %q[ SELECT * FROM brands INNER JOIN preferences p ON p.id = #{id} \
                                                       AND (p.brands_flags_0 & brands.flags_0 = brands.flags_0) \
                                                       AND (p.brands_flags_1 & brands.flags_1 = brands.flags_1) \
                                                       AND (p.brands_flags_2 & brands.flags_2 = brands.flags_2) \
                                                       AND (p.brands_flags_3 & brands.flags_3 = brands.flags_3) \
                                                       AND (p.brands_flags_4 & brands.flags_4 = brands.flags_4) \
                                                       AND (p.brands_flags_5 & brands.flags_5 = brands.flags_5) ],
                                     :insert_sql => %q[ UPDATE preferences p SET p.brands_flags_0 = p.brands_flags_0 | #{record.flags_0}, \
                                                                                 p.brands_flags_1 = p.brands_flags_1 | #{record.flags_1}, \
                                                                                 p.brands_flags_2 = p.brands_flags_2 | #{record.flags_2}, \
                                                                                 p.brands_flags_3 = p.brands_flags_3 | #{record.flags_3}, \
                                                                                 p.brands_flags_4 = p.brands_flags_4 | #{record.flags_4}, \
                                                                                 p.brands_flags_5 = p.brands_flags_5 | #{record.flags_5} \
                                                        WHERE p.id = #{id} ],
                                     :delete_sql => %q[ UPDATE preferences p SET p.brands_flags_0 = p.brands_flags_0 & ~#{record.flags_0}, \
                                                                                 p.brands_flags_1 = p.brands_flags_1 & ~#{record.flags_1}, \
                                                                                 p.brands_flags_2 = p.brands_flags_2 & ~#{record.flags_2}, \
                                                                                 p.brands_flags_3 = p.brands_flags_3 & ~#{record.flags_3}, \
                                                                                 p.brands_flags_4 = p.brands_flags_4 & ~#{record.flags_4}, \
                                                                                 p.brands_flags_5 = p.brands_flags_5 & ~#{record.flags_5} \
                                                        WHERE p.id = #{id} ],
                                      :touch => true
                                    }